Question : I have an InnoDB table whose primary key column is defined as follows: id INT NOT NULL AUTO_INCREMENT […]
Category: InnoDB
Set up a MySQL slave using mysqldump to get the initial data
Question : I have a master database which already has some data in it. The tables in the master database […]
MySQL Enterprise Backup error: Log scan was only able to reach xxxx
Question : I use MySQL Enterprise Backup to make incremental backups, but when I apply a restore (copy-back), I can’t […]
Which MySQL storage engine is the most similar to ARCHIVE when that is not available?
Question : I have a table that contains a log of events that is written to often and read very […]
Which one to use? InnoDB Replication or MySQL Cluster?
Question : I am building a url shortener and I use InnoDB as the storage engine for link data. I […]
Why is it slower to access records at the end of the database?
Question : I have a mysql innodb database running with some 200k records, and I’m having some unexpected slowdown when […]
Is Mysql creating any temp table , when running Mysql delete query?
Question : Server details We have one Galera cluster Mariadb with 3 nodes . On primary node database size is […]
Percona pt-deadlock-logger strange results
Question : Running the deadlock detector from Percona Toolkit, I get something like the following (MySQL 5.7 / AWS RDS, […]
UPDATE query periodically is slower by factor of 5000x
Question : I run a site (Magento) which have a problem with a specific UPDATE query. Under heavy load, this […]
How to use Limit in query on my index column without scan all rows?
Question : Here is my table : In my table Clustering_key (Primary key and auto incremental) ID (Index Column) Data […]