June 18, 2013

Post: The small improvements of MySQL 5.6: Duplicate Index Detection

May 31, 2013 By Leave a Comment

… complete performance schema, online DDL and several other InnoDB and query optimizer improvements. However, I plan to focus on a series… mode, it will throw an error and the second ALTER will fail, preventing the creation of the duplicate index. Does it mean that…-key-checker, but it does not detect all cases. For example: mysql> alter table test add index redundant (col2, id); Query OK, 0…

Filed Under: Insight for DBAs, MySQL, On Ground Training, Percona Toolkit, Training Tagged With: , , , , , , , , ,

Post: Choosing a MySQL HA Solution - Post-Webinar Q&A

June 7, 2013 By Leave a Comment

… simply connect to it and attempt to run a simple query. I’d suggest doing this as a user that does NOT have… prevent a problem before it occurs. For example, if you see a large number of long-running queries in the output of… and PRM simply attempt to connect and run a simple query, but it‘s always possible to build something more involved if…

Filed Under: Insight for DBAs, Insight for Developers, MySQL, MySQL Webinars Tagged With: , , ,

Comment: Sphinx search performance optimization: multi-threaded search

May 27, 2013 By 10 Comments

Thanks for the feedback, Robert. There are some types of queries where it does not help (those that do a lot of post-processing after matching the search), but in many simple cases it should help indeed.

Filed Under: MySQL Tagged With: , , ,

Post: MySQL and the SSB - Part 2 - MyISAM vs InnoDB low concurrency

May 22, 2013 By Leave a Comment

… known as a “flight”. I have labeled each query as Q{FLIGHT_NUMBER}.{QUERY_NUMBER}. In general, each flight examines different time… InnoDB. Like the queries in Flight #3 that are faster using MyISAM, Q4.3 examines very little data. It seems that InnoDB… which MyISAM imposes that are difficult to work with.  MyISAM does not maintain checksum consistency during regular operations and is not…

Filed Under: Benchmarks, MySQL Tagged With: , , , , , , ,

Post: Experiences with the McAfee MySQL Audit Plugin

May 23, 2013 By 4 Comments

… and this is what the McAffee plugin does. Installation and configuration are straightforward following the…localhost”,”cmd”:”Connect”,”query“:”Connect”} {“msg-type”:”activity”,”date”:”1369155747373″,”thread-id”:”6439″,”query-id”:”…example of what can be achieved with it. It is a very good one for me…

Filed Under: Insight for DBAs, MySQL Tagged With: ,

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

June 10, 2013 By 3 Comments

….69, this release will include all the bug fixes in it. All of Percona’s software is open-source and free… if an INNODB_CHANGED_PAGES query is issued that has an empty LSN range and thus does not need to read any… file I/O error occurs after an INNODB_CHANGED_PAGES query started returning data to indicate an incomplete result set. Bug…

Filed Under: MySQL, Percona Server, Percona Software Tagged With:

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

June 3, 2013 By 3 Comments

… query is issued that has an empty LSN range and thus does not need to read any bitmap files. Bug fixed #1184427. Query… file I/O error occurs after an INNODB_CHANGED_PAGES query started returning data to indicate an incomplete result set. Bug…. Reduced the overhead from the Handle Corrupted Tables check as it was missing branch predictor annotations. Bug fixed #1176864. Other bug…

Filed Under: MySQL, Percona Server, Percona Software Tagged With: ,

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….  Nice, eh? Usage of this tool is very straightforward and it does a lot of the work for you.  Basically if your….  Most of the time SchemaSpy “does the right thing” but sometimes you need to give it a little help in the form…

Filed Under: Insight for DBAs, Insight for Developers, MySQL Tagged With: ,

Post: Disconnecting a replication slave is easier with MySQL 5.5+ (RESET SLAVE vs. RESET SLAVE ALL)

April 17, 2013 By 2 Comments

… looks great, but does it ensure the replica is disconnected from its master? Let’s try: mysql> stop slave; Query OK, 0 rows affected (0.00 sec) mysql> reset slave; Query OK…; Query OK, 0 rows affected (0,04 sec) mysql> show slave status\G Empty set (0,00 sec) Very good! The command does…

Filed Under: Insight for DBAs, MySQL Tagged With: , ,

Post: Is your MySQL buffer pool warm? Make it sweat!

April 16, 2013 By 6 Comments

… sufficient for failover during peak traffic. The standby server does not process query traffic except for replication. The buffer pool and adaptive… standby server will not have recently accessed pages. When it starts handling queries after failover, the lower cache hit rates can lead… is necessary when running a large stream of queries. Benchmarks We benchmarked with slow query logs captured from our production systems. We…

Filed Under: Insight for DBAs, Insight for Developers, MySQL, Percona Software Tagged With: , , , , , , ,
« Older Posts