May 21, 2012

Post: Impact of logging on MySQL’s performance

…+4 striped disks). Software It was used MySQL 5.0.75-percona-b11 on CentOS release 4.7 MySQL setting There were two cases considered CPU… take more than a second to execute; logging every query; MySQL was run with default settings except following: [mysqld] user=root… queries are logged. In general logging all queries can hurt MySQL and you should consider the load while using it, especially…

Post: What is stored InnoDB buffer pool

MySQL 5.0 which show innodb buffer pool content mysql