MySQL

Error: 1040, Too Many Connections (MySQL)

Error 1040 occurs when the number of connected clients has reached the value of the max_connections server variable. …

Network partitioning is when there is a network outage that causes the cluster to be split into two survivable groups. …

A node group is a set of data nodes that is in charge of several fragments of data in the MySQL Cluster.

1. Download the MySQL packages for ubuntu. 2. Upload the zip file to the Ubuntu and unzip it. (unzip was not install by …

As of MySQL 5.5, you can use these 2 INFORMATION_SCHEMA views : INNODB_LOCK_WAITS INNODB_TRX Here is an example: session …

Question: How to Check Whether Any Queries Are Waiting for a Lock Other Than an InnoDB Row Lock? You can use the …

Question: How to Monitor Number of InnoDB Deadlocks? To log all deadlock information to the mysql error log, you can …

The Problem After issuing FLUSH TABLES WITH READ LOCK, we can see it is pended for a long time with one of the following …

If you want to be able to do a point-in-time recovery, you need to start your preparation already when creating the …

Question: How to get the exact number of days left for the password to expire when the password expiry policy is …

To be able to use SSL for connecting to a MySQL server, the server will need to be reconfigured, and how clients access …