June 19, 2013

Post: Percona Server 5.1.69-14.7 now available: A drop in replacement for MySQL

…files. Bug fixed #1184427. Incorrect schema definition for the User Statistics tables in INFORMATION_SCHEMA (CLIENT_…Bug fixed #1185304. Other bug fixes: bug fixed #1174346, bug fixed #1160951, bug fixed #1079688, bug fixed #1132412, bug fixed #1153651. Release notes for Percona Server for MySQL

Post: Percona Server 5.6.11-60.3 first Release Candidate now available

…. Bug fixed #1171699. Incorrect schema definition for the User Statistics tables in INFORMATION_SCHEMA (CLIENT_…bug fixed #1183625, bug fixed #1155475, bug fixed #1157037, bug fixed #1182065, bug fixed #1182837, bug fixed #1177780, bug fixed #1154954. Release notes for Percona Server for MySQL

Post: Percona Playback 0.6 for MySQL now available

schema change can affect the overall performance of your MySQL database server. Percona Playback for MySQL can also help evaluate new server versions, patches and hardware against existing setups to allow users to make an informed

Post: Percona Toolkit 2.1.8 released today with beta support for MySQL 5.6

… pt-online-schema-change pt-archive pt-mysql-summary pt-heartbeat pt-variable-advisor pt-config-diff pt-deadlock-logger The bug fixes… uses UTC regardless of the server or MySQL time zone. Fixed bug 1079341: pt-online-schema-change checks for foreign keys on MyISAM… can’t have foreign keys, and the tool uses the information_schema to find child tables, this could cause unnecessary load on…

Post: How Percona does a MySQL Performance Audit

… an example, take a look at this bug report (not a bug). Looking at MySQL status Now we’re starting to get into… server is not heavily loaded, I may even do some INFORMATION_SCHEMA queries to help me find the biggest tables and so… exist but have been dropped from InnoDB, for example. (The INFORMATION_SCHEMA query will surely trigger errors about this.) There are a…

Post: Announcing Percona Server for MySQL version 5.1.67-14.4

…flushing purposes, which wasn’t original intention. Bug fixed #1105709 (Laurynas Biveinis). INFORMATION_SCHEMA plugin name innodb_changed_pages serves also… MySQL 5.1.67-14.4: bug fixed #1098436 (Laurynas Biveinis), bug fixed #1096904 (Laurynas Biveinis), bug fixed #1096899 (Laurynas Biveinis), bug

Post: Announcing Percona Server for MySQL version 5.5.29-30.0

… from the Percona Software Repositories). Based on MySQL 5.5.29, including all the bug fixes in it, Percona Server 5.5… for flushing purposes, which wasn’t original intention. Bug fixed #1105709 (Laurynas Biveinis). INFORMATION_SCHEMA plugin name innodb_changed_pages serves also as…

Post: Percona Server and XtraBackup weekly news, February 5th

… decided to try a series of blog posts keeping people informed about what’s happening in Percona Server and Percona XtraBackup…. There was discussion about changing the column names in the INFORMATION_SCHEMA.QUERY_RESPONSE_TIME table, because their meaning is vague and… increment the counters at all. Mark Callaghan found a bug in INFORMATION_SCHEMA.INNODB_SYS_TABLES in the 5.1 server code. Percona…

Post: MySQL Binaries Percona build10

…slow_query_log_file | /var/lib/mysql/slow_query.log | for compatibility with MySQL 5.1 and | userstat_…Information schema table of InnoDB IO counts for each datafile pages | 1.0 | Percona | GPL | INFORMATION_SCHEMA.INNODB_… | 1.0 | Baron Schwartz | GPL | Bug #29126 fix | | microslow_innodb.patch | …

Post: Announcing Percona Server 5.1.65-14.0

…indexes resulting in an unbootable server. Bug fixed #999147 (Laurynas Biveinis). Fixed the upstream MySQL bug #66301. Concurrent INSERT … ON …TABLE_STATS or INNODB_INDEX_STATS. Bug fixed #896439 (Stewart Smith). Removed the INFORMATION_SCHEMA table INNODB_PATCHES (actually XTRADB_ENHANCEMENTS)…