Question : Suggestions to consider for your my.cnf [mysqld] section based on visible information provided. Entire block to go at […]
Category: InnoDB
75% of RAM for Innodb_buffer_pool size
Question : I have read many documentation including percona and MariaDB documentation where they recommend setting innodb_buffer_pool_size to 70-80% of […]
query optimization of a left join
Question : I have the following query written into the slow log (mysql-slow.log). I don’t have much idea how to […]
Automatic slave reconfiguration after updating master
Question : I have development mysql master and slave servers and a prod server. I need to set up regular […]
Drop Tables with Bigger size
Question : We have a mysql database with a size of 2 TB, in which we have for to five […]
phpMyAdmin trigger error
Question : The following oddly does work, but shows an error in PhpMyAdmin… (see image below) (in the definition block […]
Mysql/innodb deadlock on simple delete query
Question : Mysql/innodb 8.0.16, read committed transactions, several statements in transaction raise deadlock on deletion of non intercepting rows. Trying […]
Under what conditions is it safe to use innodb_flush_method = O_DIRECT_NO_FSYNC?
Question : There seems to be some contention about whether one should use innodb_flush_method = O_DIRECT_NO_FSYNC on XFS or EXT4, […]
What can cause a rapid drop in RDS MySQL Database free storage space?
Question : How could my MySQL database on Amazon RDS have recently gone from 10.5 GB free to “storage-full” status […]
What causes InnoDB to write 100% more pages while slowing down answering queries?
Question : I have a somewhat big database server: 4 processors, 32 cores, 288GB RAM, 2 ethernet cards bounded together, […]