…performance is a case-by-case decision. There are other drawbacks to using temporary tables in this way, for example when using replication, a …SQL can produce an infinite variety of queries. The query optimizer analyzes queries for common patterns the MySQL designers know can be improved. But …
Post: MySQL and the SSB - Part 2 - MyISAM vs InnoDB low concurrency
May 22, 2013 By Leave a Comment
… tests a database’s ability to optimize queries for a star schema. A star schema presents … of data are examined. Conclusion In some cases MyISAM is faster than InnoDB, but usually …least for this workload. Notes MySQL version used: 5.6.11, custom compiled to remove performance_schema For the InnoDB…
Post: Choosing a MySQL HA Solution - Post-Webinar Q&A
June 7, 2013 By Leave a Comment
… my recommendation for MySQL 5.6? Is MHA ready for MySQL 5.6? A: My personal recommendation for MySQL 5.6, based…query, but it’s always possible to build something more involved if that’s what you need. Q: What MySQL…I’m not optimistic that this is a viable use case. If someone can prove me wrong, I’d…
Post: Experiences with the McAfee MySQL Audit Plugin
May 23, 2013 By 4 Comments
…using for the test (5.5.28-29.1). This is needed as the plugin needs the offset to some MySQL… why that is the case. Maybe someone more knowledgeable in MySQL internals can enlighten me …”,”cmd”:”Connect”,”query“:”Connect”} {“msg-type”:”activity”,”date”:”1369155747373″,”thread-id”:”6439″,”query-id”:”…
Post: Implementing SchemaSpy in your MySQL environment
June 4, 2013 By 2 Comments
… effectively when I know the relationships between tables versus observing queries only. An additional benefit is that SchemaSpy is command-line… case here is the properties file in use for my Percona Server 5.6.10 sandbox: description=MySQL driver=com.mysql.jdbc.Driver connectionSpec=jdbc:mysql…
Post: Percona Server 5.1.69-14.7 now available: A drop in replacement for MySQL
June 10, 2013 By 3 Comments
… new log data. In some corner cases this could lead to assertion errors …. XtraDB changed page tracking used to hold the log system mutex for the log reads needlessly…query started returning data to indicate an incomplete result set. Bug fixed #1185040. Fixed the upstream bug #69379 which caused MySQL…
Post: The small improvements of MySQL 5.6: Duplicate Index Detection
May 31, 2013 By Leave a Comment
… out there that use MySQL, for which we at Percona tend to find redundant indexes. And second, because in some cases, we may need… suffixes for secondary keys in InnoDB. As some of this redundancies could be necessary, depending on the query optimizer and the MySQL version…, but it does not detect all cases. For example: mysql> alter table test add index redundant (col2, id); Query OK, 0 rows affected (1…
Post: Is your MySQL buffer pool warm? Make it sweat!
April 16, 2013 By 6 Comments
…:3307/slow | percona-playback –mysql-host 127.0.0.1 –mysql-username playback –mysql-password PaSSwOrd –mysql-schema schema_name –query-log-stdin –dispatcher-plugin… few features to Percona Playback to make it work better for this use case. You will need version 0.6 or later to…
Post: More on MySQL transaction descriptors optimization
April 26, 2013 By Leave a Comment
… are two cases covered in the first post: single SELECT queries doing PRIMARY KEY lookups (aka QPS sysbench mode); same MySQL queries executed inside… used a smaller dataset for this benchmarks round, since reportedly Dimitri was using 8 tables with 1M rows each (about 2.1GB) for his…
Post: High-load problems? Investigate them with 'pt-query-digest'
April 23, 2013 By 2 Comments
…case last week, and I thought I’d share what I think is a little known goodie from Percona Toolkit for MySQL called pt-query-digest. One customer …used them, you know it can be a daunting task to review them in servers with thousands of connections. Enter pt-query…
