… query that took half the time. An important conclusion of my presentation today is that sometimes you find unexpected differences 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
… main reasons that I don’t like DRBD with virtual machines. First is the disk IO performance hit that comes with DRBD… example, if you see a large number of long-running queries in the output of SHOW PROCESSLIST that might be a… to use MySQL on top of something like that? I can’t imagine the performance being all that fantastic, and I could…
Post: The small improvements of MySQL 5.6: Duplicate Index Detection
May 31, 2013 By Leave a Comment
… Fulltext, Memcached integration, a more complete performance schema, online DDL and several other InnoDB and query optimizer improvements. However, I plan to… creation of the duplicate index. Does it mean that tools like pt-duplicate-key-checker will not be necessary for MySQL…-dependent, like redundant suffixes for secondary keys in InnoDB. As some of this redundancies could be necessary, depending on the query optimizer…
Post: MySQL and the SSB - Part 2 - MyISAM vs InnoDB low concurrency
May 22, 2013 By Leave a Comment
… the importance of performance at low concurrency. The SSB The SSB tests a database’s ability to optimize queries for a star… #4 There is one query in this flight, Q4.3, which is faster using MyISAM than InnoDB. Like the queries in Flight #3 that are faster using MyISAM, Q4.3 examines very little data. It seems that InnoDB performs better…
Post: Experiences with the McAfee MySQL Audit Plugin
May 23, 2013 By 4 Comments
… the McAfee MySQL Audit Plugin and would like to share my experience in this post…. plugin is its flexibility, and not its performance, which seems to be on par with …”:”localhost”,”cmd”:”Connect”,”query“:”Connect”} {“msg-type”:”activity”,”date”:”1369155747373″,”thread-id”:”6439″,”query-id”:”219309″,”…
Post: Percona MySQL University @Portland next Monday!
June 12, 2013 By Leave a Comment
…talk about Percona XtraDB Cluster, Percona Xtrabackup and Performance and Improvements and new Features in MySQL … titled, “Conquering BigData with MySQL and Shard Query” Daniel Nichter, lead of the Percona Toolkit … ideal of Percona MySQL University and would like us to bring the event to your …
Comment: Benchmarking Percona Server TokuDB vs InnoDB
May 7, 2013 By 32 Comments
The main performance win of TokuDB is indexes. If you add multiple multi-….x). It really shines on large tables and index scan like queries.
Post: More on MySQL transaction descriptors optimization
April 26, 2013 By Leave a Comment
… the difference in results still requires an explanation, I’d like to highlight one aspect of the descriptors optimization that I… = 2000 max_connections=5000 table_open_cache=5000 query_cache_type=OFF performance_schema=0 warmup To warmup server and load data and indices to the buffer pool we use following queries: select…
Post: Benchmarking Percona Server TokuDB vs InnoDB
May 7, 2013 By 32 Comments
… is closer to what I need). Tables looks like: CREATE TABLE `sbtest1` ( `hid` int(10) unsigned NOT… InnoDB and TokuDB performs if PK is (`id`,`hid`,`mid`). This also will affect select performance, so we…_size = 4M thread_cache_size = 1000 query_cache_size = 0 query_cache_type = 0 ft_min_word_len = …
Comment: MySQL Partitioning - can save you or kill you
April 30, 2013 By 45 Comments
… if the user’s ad hoc query leads to scanning the entire last two partitions, performance is not bad. (The last 2…. Seems like this is being fixed in 5.6; not sure about Percona or MariaDB. (Re #4) There are _no_ parallel queries… than the non-partition equivalent. Even single-row writes are likely to be slower in PARTITIONed tables unless you include something…
