… 1 row in set (0.00 sec) In previous versions of MySQL, you can create two indexes with the same columns (in… created-, but we will get a warning (note severity, to be exact): mysql> ALTER TABLE test ADD INDEX (col2); Query OK, 0 rows… on the query optimizer and the MySQL version, we always recommend to check manually the optimizations proposed by Percona Toolkit. The MySQL server, of…
Post: Experiences with the McAfee MySQL Audit Plugin
May 23, 2013 By 4 Comments
…VM I was working in and didn’t get significant differences between either output option, or …to be extracted due to this Percona Server version not being included in the binary. And …Connect”,”query“:”Connect”} In conclusion, the plugin API seems to be opening new possibilities of extending MySQL‘s…
Post: MySQL and the SSB - Part 2 - MyISAM vs InnoDB low concurrency
May 22, 2013 By Leave a Comment
…a “flight”. I have labeled each query as Q{FLIGHT_NUMBER}.{QUERY_NUMBER}. In general, each flight examines…from the buffer pool should be faster than getting them from the OS cache, which is …performs better, at least for this workload. Notes MySQL version used: 5.6.11, custom compiled to remove…
Post: Implementing SchemaSpy in your MySQL environment
June 4, 2013 By 2 Comments
…you don’t need to?). I get up to speed a lot …the relationships between tables versus observing queries only. An additional benefit is …10 sandbox: description=MySQL driver=com.mysql.jdbc.Driver connectionSpec=jdbc:mysql://127.0….child_A to parent table: version=”1.0″ encoding=”UTF-8″?> <…
Post: Disconnecting a replication slave is easier with MySQL 5.5+ (RESET SLAVE vs. RESET SLAVE ALL)
April 17, 2013 By 2 Comments
…MySQL provides the handy RESET SLAVE command. But as we’ll see, its behavior has changed along with the MySQL versions…mysql> stop slave; Query OK, 0 rows affected (0,01 sec) mysql > reset slave; Query OK, 0 rows affected (0,11 sec) mysql…
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… better for this use case. You will need version 0.6 or later to get these features. Be aware that playback output…
Post: Webinar: Best Practices for MySQL Scalability on May 1
April 30, 2013 By Leave a Comment
… providing a high-level look at the components of MySQL scalability: application architecture, MySQL version and configuration, choosing hardware and operating systems. For… info: MySQL scalability depends on getting many things right including the architecture, hardware, operating system, MySQL version, MySQL configuration, schema design and indexing, and query design…
Post: Virident vCache vs. FlashCache: Part 2
May 17, 2013 By 3 Comments
… tool used was sysbench 0.5 and the version of MySQL used was Percona Server 5.5.30-rel30.1…interesting item here is that vCache actually appears to get *better* over time; I’m not entirely sure why…buffer_size = 4M thread_cache_size = 1000 query_cache_size = 0 query_cache_type = 0 ft_min_word_len = 4…
Post: MySQL Slow query log in the table
May 31, 2007 By 1 Comment
… of MySQL 5.1 get MySQL slow query log logged in mysql.slow_log table instead of the file as you had in previous versions. We rarely would use this feature as it is incompatible with our slow query analyses patch and… in MySQL is well though of in regards to avoiding trouble. For example you can’t ALTER log table while query is…
Post: Troubleshooting MySQL Upgrade Performance Regressions
February 15, 2012 By Leave a Comment
… MySQL version. Once you have the queries you will most likely able to repeat the problem by running query on old and new MySQL Server version… standpoint and updating stats may cause old MySQL Version to get slower plan instead of new one getting faster. Check stats sampling settings such…
