May 25, 2012

Post: How Percona does a MySQL Performance Audit

… a look at this bug report (not a bug). Looking at MySQL status Now we’re …been dropped from InnoDB, for example. (The INFORMATION_SCHEMA query will surely trigger errors about this.)…microsecond logging and additional information in the slow query log output. The stock MySQL server’s limitation…

Post: 5.0.77 / 5.0.82 -build16 Percona binaries

… new patches were added: profiling_slow.patch This patch adds information from SHOW PROFILE to query information in slow.log output. profiling_server. This… query Bug #378761: compilation fails on 5.0.77 Bug #381900: mysql-test information_schema fails on 5.0.77 with –with-debug Bug #382783…

Post: MySQL Binaries Percona build10

slow_query_log | ON | | slow_query_log_file | /var/lib/mysql/slow_query.log | for compatibility with MySQLInformation schema table of InnoDB IO counts for each datafile pages | 1.0 | Percona | GPL | INFORMATION_SCHEMA… | Bug #29126 fix | | microslow_innodb.patch | Extended statistics in slow.log | 1….

Post: Percona Server 5.1.53-12.4

…12.4 is based on MySQL 5.1.53.  New …Time Distribution. (Oleg Tsarev) Bugs Fixed Bug #643149 – Slow query log entries were…Bug #693814, Bug #693815, Bug #693816, Bug #693817, Bug #693819 – Tests in the test environment were updated to reflect past INFORMATION_SCHEMA changes. (Aleksandr Kuzminsky) Bug

Post: Percona Server 5.5.8 Beta Release

…authentication In addition to building on MySQL 5.5, here are the …. (Oleg Tsarev) Existing variable log_slow_verbosity had two new values …INFORMATION_SCHEMA table XTRADB_ENHANCEMENTS was removed. (Yasufumi Kinoshita) Several fields in the INFORMATION_SCHEMA table INNODB_INDEX_STATS were renamed. Bug

Post: Percona Server 5.1.53-11.7

… now based on MySQL 5.1.53.  New Features Added: None  Other Changes: None Bugs Fixed Bug #643149 – Slow query log entries were not being done in the usual parsing format. (Alexey Kopytov) Bug #677407 – The innodb.innodb_information_schema

Post: Percona build7 with latest patches

… for MySQL 5.0.67 build 7 which include … | Information schema table of InnoDB IO counts for each datafile pages | 1.0 | Percona | GPL | INFORMATION_SCHEMA.INNODB_IO_PATTERN….0 | Baron Schwartz | GPL | Bug #29126 fix | | microslow_innodb.patch | Extended statistics in slow.log | 1.1 | Percona | GPL |…

Comment: Learning about MySQL Table Fragmentation

I posted this to MySQL: http://bugs.mysql.com/bug.php?id=36588 Originally we had this discussion in our … also SHOW TABLE STATUS can be very slow. Same for queries to Information_Schema fetching the same information. But it seems not always so…