… new log data. In some corner cases this could lead to assertion errors in the log parser or bad changed page data. Bug fixed… file in the middle of requested LSN range was missing. Bug fixed #1179974. Server would crash if an INNODB_CHANGED_PAGES query is… I/O error occurs after an INNODB_CHANGED_PAGES query started returning data to indicate an incomplete result set. Bug fixed #1185040…
Post: Percona Server 5.1.69-14.7 now available: A drop in replacement for MySQL
June 10, 2013 By 3 Comments
Post: Implementing SchemaSpy in your MySQL environment
June 4, 2013 By 2 Comments
… are candidates for dropping (why keep old data if you don’t need to?). I… know the relationships between tables versus observing queries only. An additional benefit is that SchemaSpy…in the schema, really handy to sort by name to see if you have any implicit constraints that you might have missed…
Post: Percona Server 5.6.11-60.3 first Release Candidate now available
June 3, 2013 By 3 Comments
… I/O error if a bitmap file in the middle of requested LSN range was missing. Bug fixed #1179974. A warning is… I/O error occurs after an INNODB_CHANGED_PAGES query started returning data to indicate an incomplete result set. Bug fixed #1185040. The INNODB_CHANGED_PAGES table couldn’t be queried if the…
Post: Experiences with the McAfee MySQL Audit Plugin
May 23, 2013 By 4 Comments
… experience in this post. Auditing user activity in MySQL has traditionally been challenging. Most data…query“:”Connect”} In conclusion, the plugin API seems to be opening new possibilities of extending MySQL’s behavior in… an important missing feature on the server, which has made using MySQL in PCI…
Post: Percona MySQL University @Portland next Monday!
June 12, 2013 By Leave a Comment
… titled, “Conquering BigData with MySQL and Shard Query” Daniel Nichter, lead of the Percona Toolkit … be used to provide access to government data. The daylong event will be held at…miss… 
So register now! Please also join the Portland MySQL Meetup group for more MySQL-focused events in…
Post: Percona Server 5.5.30-30.2 rerelease fixes non-restart issue
April 24, 2013 By Leave a Comment
…data. In some corner cases this could lead to assertion errors in the log parser or bad changed page data…query which opened that table. Bug fixed #1127008 (Sergei Glushchenko). Fix for bug #1070856 introduced a regression in…missing help texts in the MySQL client because the help tables were missing….
Post: Percona Server for MySQL 5.5.30-30.2 now available
April 10, 2013 By 10 Comments
…data. In some corner cases this could lead to assertion errors in the log parser or bad changed page data…query which opened that table. Bug fixed #1127008 (Sergei Glushchenko). Fix for bug #1070856 introduced a regression in…missing help texts in the MySQL client because the help tables were missing….
Post: Should we give a MySQL Query Cache a second chance ?
April 10, 2011 By 64 Comments
… strip comments when checking query cache for match. Protection from Multiple Misses So you have item invalidated from query cache and there are… understand how exactly MySQL Query Cache is working in many cases. This however can be improved and data about Query Cache content and operation…
Post: How to Identify Bad Queries in MySQL
January 10, 2011 By 16 Comments
… finding queries that block other queries — yet. The missing piece, part 3 — finding queries that block other queries — is best done by observing clusters in query …. In all of the above cases, the additional information in Percona Server’s query execution logs is absolutely vital. Without data to…
Post: mk-query-digest, query comments and the query cache
… including mk-query-digest. This tool, in particular, has a very nice option called –embedded-attributes which can process data embedded in query comments. … in the query comments. Also notice the query with static comments. There are 1000 hits and 1000 misses because MySQL treats identical queries …