June 19, 2013

Post: Percona Server for MySQL 5.5.31-30.3 now available

May 24, 2013 By Leave a Comment

… a memory leak if query cache was used together with InnoDB. Bug …, where an unprivileged MySQL account owner could perform brute-force password guessing …MySQL 5.6 version, which removed MyISAM internal temporary table mutex contention. Bug fixed #1179978. Release notes for Percona Server for MySQL…

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

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

May 22, 2013 By Leave a Comment

…MyISAM is faster when the data is not cached (the cold run) but is slower in the hot (cached…MyISAM for everything!. MyISAM may be good for raw performance, but there are limitations which MyISAM imposes that are difficult to work with.  MyISAM…=/usr/local/mysql socket=/var/lib/mysql/mysql.sock user=…

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

Post: ZFS on Linux and MySQL

May 24, 2013 By 17 Comments

…the task.  Snapshots work best with InnoDB, with MyISAM you’ll have to start the snapshot while… it is related to better raid controller write cache use.  Even the fairly slow gzip-1 …very interesting solution for MySQL backup servers.  All backup solutions have an impact on performance with ZFS the…

Filed Under: Hardware and Storage, Insight for DBAs, MySQL Tagged With: , , , ,

Post: Virident vCache vs. FlashCache: Part 2

May 17, 2013 By 3 Comments

…. vCache – MySQL parameter testing The first test was designed to look solely at vCache performance under some different sets of MySQL configuration parameters… FlashCache performance versus that of vCache, and I also included a “no cache” test run as well using the base HDD MySQL configuration…_size = 4M bulk_insert_buffer_size = 8M myisam_sort_buffer_size = 8M myisam_max_sort_file_size = 10G myisam_repair_threads = 1 myisam_recover

Filed Under: Benchmarks, Hardware and Storage, MySQL Tagged With: , , , , , , ,

Post: Benchmarking Percona Server TokuDB vs InnoDB

May 7, 2013 By 32 Comments

… performs if PK is (`id`,`hid`,`mid`). This also will affect select performance…_size = 4M thread_cache_size = 1000 query_cache_size = 0 query_cache_type = 0 ft_…myisam_max_sort_file_size = 10G #myisam_max_extra_sort_file_size = 10G myisam_repair_threads = 1 myisam_recover socket=/var/lib/mysql/mysql…

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

Post: Cache Performance Comparison

August 9, 2006 By 74 Comments

…MySQL Performance tuning ? Not surpising associative array cache performs the best, almost 4 times faster than APC shared memory cache – closest competitor. In real life performance…

Filed Under: Insight for Developers Tagged With:

Post: Ultimate MySQL variable and status reference list

January 8, 2011 By 4 Comments

…Performance_schema_mutex_classes_lostblogpercona.commanual Performance_schema_mutex_instances_lostblogpercona.commanual Performance_schema_rwlock_classes_lostblogpercona.commanual Performance_schema_rwlock_instances_lostblogpercona.commanual Performance…

Filed Under: Insight for DBAs, MySQL

Post: InnoDB Full-text Search in MySQL 5.6 (part 1)

February 26, 2013 By 1 Comment

… sense of how it works compared to traditional MyISAM FTS. We’ll get to performance in the third installment. For now, the….ibd -rw-rw—-. 1 mysql mysql 98304 Feb 20 16:09 FTS_00000000000000ad_DELETED_CACHE.ibd -rw-rw—-. 1 mysql mysql 98304 Feb 20 16…:17 dir_test_myisam.frm -rw-rw—-. 1 mysql mysql 155011048 Feb 19 17:17 dir_test_myisam.MYD -rw-rw—-. 1 mysql mysql 153956352 Feb…

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

Post: MySQL Crash Recovery

July 30, 2006 By 30 Comments

…care of or which may seriously affect MySQL Performance. MyISAM Corruption – If you’re writting to MyISAM tables there is very large chance of…restart MySQL server its caches (key_buffer, innodb_buffer_pool, query_cache,table_cache) are cleaned, so may be OS caches. This may reduce performance …

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

Post: MySQL File System Fragmentation Benchmarks

March 21, 2008 By 28 Comments

… of inserts going to random tables. I used default MySQL settings for MyISAM (table_cache=64) and set innodb_buffer_pool_size=8G… affects table scan performance nadly – MyISAM suffers worse than Innodb – Innodb extent allocation works (perhaps would be good option for MyISAM as well…

Filed Under: Benchmarks Tagged With: ,
« Older Posts