June 19, 2013

Comment: Replication in MySQL 5.6: GTIDs benefits and limitations - Part 1

June 10, 2013 By 8 Comments

It may not be easy to simply switch from regular MySQL replication to using replication using GTIDs 1. … possible to mix non-transactional tables (such as MYISAM) with innodb tables within the same transaction. The same issue can arise…

Filed Under: MySQL Tagged With: , ,

Post: Choosing a MySQL HA Solution - Post-Webinar Q&A

June 7, 2013 By Leave a Comment

… be bonded with active-backup or LACP (depending on your switching infrastructure). In essence, you’re looking for two of everything… –skip-grant-tables and insert a few rows into an InnoDB table, but trying to run a simple mysqlslap just hung…

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

Post: MySQL 5.6 - InnoDB Memcached Plugin as a caching layer

March 29, 2013 By 10 Comments

… code for this benchmark: // Identical config/code for memcached vs InnoDB $frontendOpts = array( ‘caching’ => true, ‘lifetime’ => 3600, ‘automatic_serialization’ => true ); $memcacheOpts…, here are the relative differences: InnoDB store operation was 280% higher (~1.73 ms/op) InnoDB fetch operation was 20% higher (~.06… benchmark methodology. My goal here was to compare a transparent switch (in terms of code) and experiment with the memcache plugin…

Filed Under: MySQL Tagged With: , , , ,

Post: Virident vCache vs. FlashCache: Part 1

May 16, 2013 By 3 Comments

… where the MySQL working set is significantly larger than the InnoDB buffer pool (thus leading to a lot of buffer pool…-forget any day. FlashCache does have the nice ability to switch between FIFO and LRU for its flushing algorithm; vCache does…

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

Post: Follow these basics when migrating to Percona XtraDB Cluster for MySQL

May 1, 2013 By 10 Comments

… so. However, if you can, you should consider moving to InnoDB altogether. There are very few reasons to stay with MyISAM… to not forget turning the feature back on when you switch to the new cluster especially if you are planning to…

Filed Under: Insight for DBAs, MySQL, Percona Software, XtraDB Cluster Tagged With: , , , ,

Post: How Innodb Contention may manifest itself

July 28, 2011 By 1 Comment

… of context switches. These correspond to different contention situations which can be handled differently. First situation often corresponds to Innodb spending a… efficient than doing context switches, however sometimes there is just too much spinning and it becomes inefficient. Reducing innodb_sync_spin_loops… be wasting time with context switching because Innodb is not spinning too much, thus you can consider increasing innodb_sync_spin_loops to…

Filed Under: Insight for DBAs, MySQL

Post: Heikki Tuuri answers to Innodb questions, Part II

November 4, 2007 By 13 Comments

… neccessary performance. Are we just kidding ourselves, and should we switch to Oracle? HT: You are right, bugs that cause data… rules can be established. I have assigned Inaam as the InnoDB scalability engineer. We do not have much resources for scalability… not showed up in “show innodb status”. select * from table where id=5 show innodb status: Hash table size 10624987, used…

Filed Under: Insight for Developers Tagged With:

Post: SHOW INNODB STATUS walk through

July 17, 2006 By 40 Comments

…. innodb_sync_spin_loops can be used to ballance between wasting CPU time running spin locks and doing unneeded context switches. The… tickets to use. Innodb tries to limit thread concurrency allowing only innodb_thread_concurrency threads to run inside Innodb kernel at the same… thread is not runniing inside innodb kernel status could be “waiting in InnoDB queue” or “sleeping before joining InnoDB queue”. Latest one is…

Filed Under: Insight for DBAs Tagged With:

Post: Webinar: MyISAM to InnoDB migration

November 8, 2010 By 4 Comments

…. With the change in default storage engine from MyISAM to InnoDB in the upcoming MySQL 5.5 release, we expect that… will be wanting to learn more about the benefits of switching to InnoDB, as well as topics such as: What kind of… cost) will be involved How to decide whether you should switch, or stay on MyISAM Matt Yonkovit will cover those and…

Filed Under: Events and Announcements, MySQL Tagged With:

Post: InnoDB Full-text Search in MySQL 5.6: Part 2, The Queries!

March 4, 2013 By 7 Comments

… innodb_myisam_stopword\G *************************** 1. row *************************** Table: innodb_myisam_stopword Create Table: CREATE TABLE `innodb_myisam_stopword` ( `value` varchar(18) NOT NULL DEFAULT ” ) ENGINE=InnoDB… believe that switching to InnoDB FTS is simply a matter of upgrading to 5.6 and running ALTER TABLE foo ENGINE=InnoDB. In…

Filed Under: Insight for DBAs, Insight for Developers, MySQL Tagged With: , , , , ,
« Older Posts