May 21, 2012

Post: 5.0.84-build18 Percona binaries

… Percona patches is available now. Comparing to the previous release it has following new features: The build is based on MySQL-5.0.84 Fixed the issue with CLIENT_STATISTICS New patch innodb_recovery_patches.patch greatly improves recovery time Fixed bugs… the patches here http://www.percona.com/downloads/Percona-Server-5.0/LATEST/ The Percona patches live on Launchpad : https://launchpad.net/percona-patches and…

Comment: 5.0.83-build17 Percona binaries

Are you aware of CVE-2009-2446? 5.0.83 is affected, it’s fixed in 5.0.84 with this patch: http://lists.mysql.com/commits/77649

Post: What is stored InnoDB buffer pool

… is not so hard actually – we made a short patch for MySQL 5.0 which show innodb buffer pool content mysql> select * from… | 5 | unknown | | | | | 2 | 0 | 3 | 0 | 0 | 0 | 0 | 4 | 6 | unknown | | | | | 3 | 0 | 2 | 0 | 0 | 0 | 0 | 5 | 3 | inode | | | | | 4 | 0 | 4 | 0 | 0 | 0 | 0 | 6 | 17855 | index | CLUST_IND | | SYS_IBUF_TABLE_0 | | 5 | 0… | | 83 | 1 | 3491 | 140 | 15095 | 0 | 0 | 51 | 17855 | index | PRIMARY | art | author87 | | 84 | 1 | 3799 | 139 | 15144 | 0 | 0 | 51 | 17855 | index | PRIMARY | art…

Comment: Returning to InnoDB scalability

…you Vadim. I tried this patch. However, it became a hit to the bug and MySQL… 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93… [Note] /opt/mysql/bin/mysqld: ready for connections. Version: ‘5.0.22-log’ socket: ‘/tmp/mysql.sock’ port: 3306 Source distribution …

Post: Compression for InnoDB backup

… level of compression ( 1,2,3 for qpress; -1 and -5 for other tools) The raw results are available here http… of processing is too slow. What is interesting on Level 5 the compression is worse than in pigz Level… I would like to see parallel version. There is the patch for it, but it did not apply clean to lzop…

Post: MySQL extensions for hosting

…1. row *************************** User: hosting2 Total_connections: 84 Concurrent_connections: 0 Connected_time: 20 Busy_time….wp_options | 6586 | 200 | 400 | | hosting2.wp_postmeta | 5 | 2 | 6 | | hosting2.wp_posts | 542 | 4 |… new commands with our msl patch, which introduces the advanced query …

Post: Testing the Group Commit Fix

… The fix came into MariaDB 5.3 and Mark Callaghan tested it recently . We ported this patch to Percona Server (it …The last test was done with a disabled sync_binlog=0 and without write-back cache: Threads Nofix Group Commit … 64 4389.14 3860.01 3888.56 128 4345.84 3829.70 3859.48 256 2877.98 2145.32 …

Post: Maatkit's mk-query-digest filters

84.10 # Merge passes 273.47G 0 4.00G 97.69k 0 10.35M 0 # Tmp tables 225.85G 0 4.00G 80.67k 00 # rec lock wai 216352062699s 0 4085510331s 362690s 0 27625029s 0 … That can’t be right! Apparently there are couple bugs in the slowlog patch