… 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…=/usr/local/mysql socket=/var/lib/mysql/mysql.sock user=justin innodb_buffer_pool_size=64G innodb_log_file_size=4G innodb_file_per_table innodb_stats…
Post: Percona Server for MySQL 5.5.31-30.3 now available
May 24, 2013 By Leave a Comment
…innodb_read_views_memory and innodb_descriptors_memory status variables in the Extended Show Engine InnoDB Status to improve InnoDB…MySQL account owner could perform…
Post: ZFS on Linux and MySQL
May 24, 2013 By 17 Comments
… few slave instances each of production database servers and will perform the backups. The write load is not excessive so a… scripts ready for the task. Snapshots work best with InnoDB, with MyISAM you’ll have to start the snapshot while holding a… is a very interesting solution for MySQL backup servers. All backup solutions have an impact on performance with ZFS the impact is…
Post: Choosing a MySQL HA Solution - Post-Webinar Q&A
June 7, 2013 By Leave a Comment
…MySQL world, except maybe MyISAM files on top of a clustered filesystem with an external lock manager. You might say that MySQL…want to use MySQL on top of something like that? I can’t imagine the performance being all…-tables and insert a few rows into an InnoDB table, but trying to run a simple …
Comment: Replication in MySQL 5.6: GTIDs benefits and limitations - Part 1
June 10, 2013 By 8 Comments
… easy to simply switch from regular MySQL replication to using replication using GTIDs 1. …to mix non-transactional tables (such as MYISAM) with innodb tables within the same transaction. The…CREATE TABLE …. SELECT – It is not supported to perform such type of statements http://mysqlopt.blogspot…
Post: Benchmarking Percona Server TokuDB vs InnoDB
May 7, 2013 By 32 Comments
… MISLEADING. So we see that InnoDB performance steadily declines from 24000 tps to 18000 tps, but InnoDB can’t make 5h run. After… = 8M myisam_max_sort_file_size = 10G #myisam_max_extra_sort_file_size = 10G myisam_repair_threads = 1 myisam_recover socket=/var/lib/mysql/mysql.sock…
Post: Follow these basics when migrating to Percona XtraDB Cluster for MySQL
May 1, 2013 By 10 Comments
…XtraDB Cluster (PXC) for MySQL is a hot thing right now and some …you should consider moving to InnoDB altogether. There are very few reasons to stay with MyISAM nowadays i.e. …without PK imposes an additional overhead, and because cluster performance is somewhat dependent on the slowest node – this …
Post: Virident vCache vs. FlashCache: Part 2
May 17, 2013 By 3 Comments
…mysql.sock –mysql-table-engine=innodb \ –oltp-read-only=off run The base MySQL configuration (configuration A) appears below: #####fixed innodb options innodb_file_format = barracuda innodb…
Post: Innodb Performance Optimization Basics
November 1, 2007 By 75 Comments
… here or read one of our MySQL Presentations. Application tuning for Innodb Especially when coming from MyISAM background there would be some changes… indexes). With these basic innodb performance tunings you will be better of when majority of Innodb users which take MySQL with defaults run it…
Post: MySQL 5.5 and MySQL 5.6 default variable values differences
February 21, 2013 By 8 Comments
…INNODB_PURGE_BATCH_SIZE | 20 | 300 | | PERFORMANCE_SCHEMA_MAX_THREAD_INSTANCES | 1000 | 224 | | SOCKET | /tmp/mysql_sandbox5530.sock | /tmp/mysql_sandbox5610.sock | | INNODB…
