Here at the MySQL Performance Blog, we’ve been discussing the several new features that MySQL 5.6 brought: GTID-based replication, InnoDB…: mysql> ALTER TABLE test ADD INDEX (col2); Query OK, 0 rows affected (0.22 sec) Records: 0 Duplicates: 0 Warnings: 0 mysql> ALTER TABLE test…): mysql> ALTER TABLE test ADD INDEX (col2); Query OK, 0 rows affected (0.36 sec) Records: 0 Duplicates: 0 Warnings: 0 mysql> ALTER TABLE test…
Post: Experiences with the McAfee MySQL Audit Plugin
May 23, 2013 By 4 Comments
… for the test (5.5.28-29.1). This is needed as the plugin needs the offset to some MySQL data structures… and process the audit records as you wish. Performance-wise, I did basic tests on the VM I was working in and…”:”localhost”,”cmd”:”Connect”,”query“:”Connect”} In conclusion, the plugin API seems to be opening new possibilities of extending MySQL‘s behavior in…
Post: MySQL and the SSB - Part 2 - MyISAM vs InnoDB low concurrency
May 22, 2013 By Leave a Comment
… tested with a cold buffer pool. Then the query is tested again without restarting the database. The first test is described as the cold test… performs better, at least for this workload. Notes MySQL version used: 5.6.11, custom compiled to remove performance_schema For the InnoDB tests…
Post: MySQL Query Patterns, Optimized - Webinar questions followup
June 3, 2013 By 2 Comments
… SQL can produce an infinite variety of queries. The query optimizer analyzes queries for common patterns the MySQL designers know can be improved. But… in performance like this, so it pays to test all different solutions, and measure the resulting performance! Q: Bill, back to the query where…
Post: Choosing a MySQL HA Solution - Post-Webinar Q&A
June 7, 2013 By Leave a Comment
…to degrade. If you’re just setting up a test environment to get familiar with the technology, certainly … But, if you can connect and run a simple query and receive a response back in a reasonable (…ever want to use MySQL on top of something like that? I can’t imagine the performance being all that…
Post: Percona Server for MySQL 5.5.30-30.2 now available
April 10, 2013 By 10 Comments
…MySQL performance can be found in this blogpost. (Ignacio Nin) This release of Percona Server for MySQL has fixed a number of performance…query which opened that table. Bug fixed #1127008 (Sergei Glushchenko). Fix for bug #1070856 introduced a regression in Percona Server for MySQL…
Post: MySQL and Percona Server in LinkBench benchmark
May 8, 2013 By 18 Comments
…MySQL performs quite well, though we can see small performance drop in MySQL 5.6. In IO-bound cases MySQL still has performance…-definition-cache=1000 query_cache_size=0 query_cache_type=0 performance_schema=0 #56only…MyConfig.properties -l command line to run test for 10x dataset: ./bin/linkbench -D …
Post: Webinar: SQL Query Patterns, Optimized
May 20, 2013 By Leave a Comment
…queries with which developers struggle. I’ll test several SQL solutions for each type of query objective, and show how you can use MySQL… for optimal query efficiency. The discussion will cover optimizer reports, query profiling, and session status to measure performance. The query patterns will …
Post: Percona Server 5.5.30-30.2 rerelease fixes non-restart issue
April 24, 2013 By Leave a Comment
…MySQL performance can be found in this blogpost. (Ignacio Nin) This release of Percona Server for MySQL has fixed a number of performance…query which opened that table. Bug fixed #1127008 (Sergei Glushchenko). Fix for bug #1070856 introduced a regression in Percona Server for MySQL…
Post: Virident vCache vs. FlashCache: Part 2
May 17, 2013 By 3 Comments
… vs. vCache – MySQL parameter testing The first test was designed to look solely at vCache performance under some different sets of MySQL configuration parameters. For… join_buffer_size = 4M thread_cache_size = 1000 query_cache_size = 0 query_cache_type = 0 ft_min_word_len = 4 thread…
