Question : We have a global project. We will have some servers all continents. We separate the datas because it […]
Category: InnoDB
what happens If I remove mysql-bin.index file?
Question : Because of the file storage full, we are removing mysql bin log files. Accidentally, we removed mysql-bin.index file. […]
Queries freezes in MariaDB
Question : I have a problem where queries freezes sporadically during the day. I made a script monitoring the processlist […]
Copying a database for testing in a safe way
Question : For testing purposes I have to create a copy of a production MySQL database that cannot be touched. […]
Getting duplicate primary key for auto increment column
Question : I have a MySQL Innodb table with ‘id’ as auto increment primary key column. My Scripts are doing […]
memory leaks in innodb
Question : I have MySQL server 5.6 and I use stress test to evaluate the performance of it. after the […]
how to remove 6 months old data automatically from MYSQL innodb table
Question : I have a very big table in which I am fetching data everyday and it’s size is getting […]
Sudden periods of performance degradation
Question : For the past couple of days, Ive been observing periods of huge performance degradation. CPU usage on our […]
Copying MySQL tables, InnoDB tables not recognized
Question : I have to set up a database copy on my local computer. The problem is that that I […]
Performance impact of adding a foreign key to a 1M rows table
Question : I have an ecommerce database running MariaDB + InnoDB, which has a table to store the transactions (T) […]