(Mark Callaghan) Percona has done a great job improving the user_statistics code and making it available to others. The data from user_statistics can be used for real-time and long-term workload monitoring.

(Sheeri Cabral) Note: This article is about the WHERE extension to SHOW. I specifically use SHOW STATUS as an example, but WHERE is an extension to many SHOW statements.

(Vadim) Usually unused indexes are devil, they waste diskspace, cache, they make INSERT / DELETE / UPDATE operations slower and what makes them worse – it is hard to find them.

(Giuseppe Maxia) If you have tried using row based replication, you may have noticed two things: (1) it fixes many inconsistencies of statement-based replication, but (2) the binlog is unfit for humans. Inspecting it after a problem occurs won’t provide any useful information.

(Peter Zaitsev) How would you expect AUTO_INCREMENT to work with MERGE tables ? Assuming INSERT_METHOD=LAST is used I would expect it to work same as in case insertion happens to the last table… which does not seems to be the case. Alternatively I would expect AUTO_INCREMENT to be based off the ma

(Sheeri Cabral) Scenario: Someone wants to know which of the over 50 MySQL users have certain privileges.

(Vadim) We are going to show the effects of the new patches applied to Percona HighPerf release. As you see from the following graphs, there is significant difference to normal version when the data bigger than buffer pool.

In the xml parser that Ive been writing for rss/atom feeds Ive encountered what many people have found; bizarre encoding issues when displaying the data from the database on a webpage. Since this is not really well explained by the searches I did on google Ill explain it here.

(Vadim) We made new patches, improved previous and want to announce new builds for 5.0.62, 5.0.67 and 5.1.26 versions. One of biggest changes we separated releases of 5.0 into two branches.

(Giuseppe Maxia) Would it be cool to enhance MySQL creation table syntax to do this? CREATE TABLE t1 ( my_date DATE, my_month VIRTUAL INT AS (DATE_FORMAT(d,’%Y%m’)));