May 25, 2012

Post: 5.0.75-build11 percona binaries

… know Sun / MySQL made release of community 5.0.75 only as source code release. We made binaries with our patchset. Patches are mostly equal to build 10 http://www.mysqlperformanceblog.com/2008/12/11/mysql-binaries-percona-build10/, only….net/percona-patches/+bug/308849 You can download binaries (RPMS x86_64) and sources with patches here http://www.percona.com/mysql/5.0.75-b11/

Post: 5.0.75-build12 Percona binaries

After several important fixes to our patches we made binaries for build12. Fixes include: Control of InnoDB … with Insert buffer. http://www.percona.com/docs/wiki/patches:innodb_io_patches * innodb_flush_neighbor_pages (default 1) – When the dirty…. You can download binaries (RPMS x86_64) and sources with patches here http://www.percona.com/mysql/5.0.75-b12/

Post: Impact of logging on MySQL’s performance

… 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… know how much from performance degradation caused by the microslow patch itself. Let’s do the same tests but logging to…

Post: What is stored InnoDB buffer pool

…so hard actually – we made a short patch for MySQL 5.0 which show innodb buffer pool content mysql> select * from information_schema.INNODB_… 0 | 0 | 75 | 17855 | index | GEN_CLUST_INDEX | art | a87 | | 74 | 17 | 2670 | 130 | 15114 | 0 | 0 | 76 | 17855 | index | GEN_CLUST_INDEX | art | a87 | | 75

Comment: Returning to InnoDB scalability

… you Vadim. I tried this patch. However, it became a hit to the bug and MySQL stopped. It reports on …20:56:56 [Note] /opt/mysql/bin/mysqld: ready for connections. Version: ‘5.0.22-log’ socket: ‘/tmp/mysql.sock’ port: 3306 Source …65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 …