Oracle19c PDB level Failover error scenario test

First of all, don't use the default service for the client connection, that is, the connection used by the application. The source of the original text is Real Application Clusters Administration and Deployment Guide: All of these services are used for internal management. You cannot stop or disable any of these internal services to do pl ...

Posted by Jonob on Wed, 19 Jan 2022 14:20:30 +0100

[Java Spring open source project] operation, analysis and summary of neebee mall project

Project introduction **Project address:** https://github.com/newbee-ltd/newbee-mall **Project Description: * * NewBee mall project is a set of e-commerce system, including NewBee mall system and NewBee mall admin mall background management system, based on spring boot 2 X and related technology stack development. The front desk mall system in ...

Posted by suepahfly on Wed, 19 Jan 2022 12:25:01 +0100

MySQL group replication: why not recommend large transactions

Scene reproductionIntroduction to terms and functions alive_tasksend_msgsender_task_send_msgconclusionresolventWrite at the end ❝ Recently, the backup and restore function under different data volumes has been tested, so a large amount of data needs to be migrated to the MGR cluster. However, when the amount of migrated dat ...

Posted by wild_dog on Wed, 19 Jan 2022 05:05:09 +0100

Json type of MySQL

1. Introduction to Jason type The Json type is provided after MySQL 5.7, which is a type designed by MySQL combining structured storage and unstructured storage. In some situations, the Jason type is a blessing. Scenario 1: user portraits, labels describing users and other similar scenarios, such as patient health files in Internet hospital ...

Posted by Grego on Wed, 19 Jan 2022 02:06:11 +0100

MIT6.830 Lab 3 query optimization learning notes

Lab3 query optimization Exercise 1 selectivity estimation based on histogram The students who just read this chapter may be a little confused. Why did they say a lot of statistics? Because the essence of query optimization is to know in advance how to execute statements faster. Statistics can help us better estimate how much time it takes to ...

Posted by insightstyle on Tue, 18 Jan 2022 22:37:33 +0100

Spring boot uses Druid data sources

Spring boot uses Druid data sources When the program operates the database, it needs to use the database connection, and the performance of the database connection is related to the database connection pool. Druid is an open source database connection pool implementation of Alibaba. It combines the advantages of database connection pools such a ...

Posted by todd2006 on Tue, 18 Jan 2022 20:29:27 +0100

[MongoDB] install and deploy MongoDB for Ubuntu

Installing and deploying MongoDB for Ubuntu I Introduction to MongoDB MongoDB is a database based on distributed file storage. Written in C + +. It aims to provide scalable high-performance data storage solutions for Web applications. MongoDB is a product between relational database and non relational database. It is the most funct ...

Posted by iamchris on Tue, 18 Jan 2022 19:51:46 +0100

Introduction to Django Database (SQlite) tutorial

1: Create a project django-admin startproject mysite Once created, the project directory structure is as follows: Manage. Py ----- Tools inside a Django project that can call Django shells, databases, etc. settings.py -- Contains default settings for the project, including database information, debug flags, and other work variables. ur ...

Posted by lotrfan on Tue, 18 Jan 2022 18:32:23 +0100

[one week introduction to MySQL] multi table query, sub query and common functions

Multi table query, sub query, common function 1, Multi table query Multi table query: connect multiple tables through key fields with the same meaning in different tables to query the field information in different tables. Correspondence One to one: for example, the personnel information table and the personnel identity card correspon ...

Posted by theresandy on Tue, 18 Jan 2022 11:41:50 +0100

03-MySql Performance Monitoring Tool, Performance Tuning EXPLAIN Index Tuning trace Monitoring Sys schema View Call

Performance Monitoring Tools -- Connect MySQL Number of servers SHOW GLOBAL STATUS LIKE 'Connections'; -- MySQL Server online time SHOW GLOBAL STATUS LIKE 'Uptime'; -- Number of slow queries SHOW GLOBAL STATUS LIKE 'Slow_queries'; -- Select Number of rows returned by the query SHOW GLOBAL STATUS LIKE 'Innodb_rows_read'; -- implement INSERT Nu ...

Posted by sixseven on Tue, 18 Jan 2022 07:48:11 +0100