MySQL ERROR 1206: The total number of locks exceeds the lock table size
A query on an InnoDB table with a very large number of rows may fail with ERROR 1206 (HY000): The total number of locks exceeds the lock table size.
EXPLORE THE TOPIC
MySQL.
9 articles on this topic
MySQL Replication: 'Got fatal error 1236'
In MySQL replication, the slave retrieves data from the master's binlog and replays it locally. If the slave stops with error 1236, as shown below, how can we fix it…
Installing MySQL 5.6 using the MySQL yum repository
Oracle has released a MySQL Yum repository to make installing and updating MySQL server easier. Initially it supports Red Hat/Oracle Enterprise Linux/CentOS 6 and Fedora 18 and 19…
[Bug] Invalid of GRANT command will breaks replication
MySQL 5.6 has a bug to watch for: running GRANT privileges in PhpMyAdmin may cause a slave to stop replicating (bug report: http://bugs.mysql.com/bug.php?id=68892). After using MySQL 5…
How to compress mysqldump output with gzip/bzip2
mysqldump exports MySQL data in SQL format and is commonly used for backups. Normally these backups are not compressed.
How to list stored procedures and show procedure code in MySQL
To list the stored procedures in MySQL and display their procedure code, follow these steps. Listing MySQL stored procedures: list the procedures in the system. mysql> SHO…
Find top frequently using queries on MySQL
MySQL tip: find the ten most frequently used queries over a period using tcpdump or mysqlbinlog to collect and rank them.
How to check MySQL password on Zimbra server
Zimbra uses a MySQL database to store operational data. Normally, when accessing mysql while logged in as zimbra, you do not need to enter a MySQL password. However, if you need to use MySQL…
How to update the max_connections in MySQL
The "too many connections" error during a database query occurs when the number of connections exceeds max_connections. MySQL normally allows…