June 18, 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. Temporary tables – CREATE and DROP… storage engines – It is not possible to mix non-transactional tables (such as MYISAM) with innodb tables within the same transaction. The…/slave db. 3. CREATE TABLE …. SELECT – It is not supported to perform such type of statements http://mysqlopt.blogspot.co.uk…

Filed Under: MySQL Tagged With: , ,

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

June 7, 2013 By Leave a Comment

… switching infrastructure). In essence, you’re looking for two of everything. Q: Is it possible to replicate only some tables from master to… not responsive? A: The easiest way to do this is to simply connect to it and attempt to run a simple query. I’d… able to get the server up with –skip-grant-tables and insert a few rows into an InnoDB table, but trying to run…

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

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

May 1, 2013 By 10 Comments

… wish to keep running under PXC, wsrep_replicate_myisam allows you to do so. However, if you can, you should consider moving to InnoDB altogether. There are very few reasons to stay with… sure to not forget turning the feature back on when you switch to the new cluster especially if you are planning to write on…

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

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

March 29, 2013 By 10 Comments

… a link to the full documentation for setting up the plugin: http://dev.mysql.com/doc/refman/5.6/en/innodb-memcached…, here are the relative differences: InnoDB store operation was 280% higher (~1.73 ms/op) InnoDB fetch operation was 20% higher (~.06… client libraries and benchmark methodology. My goal here was to compare a transparent switch (in terms of code) and experiment with the…

Filed Under: MySQL Tagged With: , , , ,

Post: Virident vCache vs. FlashCache: Part 1

May 16, 2013 By 3 Comments

… and also to conduct some benchmarks for the use case where the MySQL working set is significantly larger than the InnoDB buffer pool (thus leading to a lot of buffer pool disk reads) but still small enough to fit into…-and-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: Webinar: MyISAM to InnoDB migration

November 8, 2010 By 4 Comments

… for a free Percona webinar about migrating your MyISAM databases to InnoDB. Save the date: Dec 1, 2010 at 9:00 AM… from MyISAM to InnoDB in the upcoming MySQL 5.5 release, we expect that a lot of users will be wanting to learn more about the benefits of switching to InnoDB, as well as topics such as: What…

Filed Under: Events and Announcements, MySQL Tagged With:

Post: Heikki Tuuri answers to Innodb questions, Part II

November 4, 2007 By 13 Comments

… MySQL because it seems to offer the neccessary performance. Are we just kidding ourselves, and should we switch to Oracle? HT: You are…, to prevent double buffering. Configure as much memory as possible to InnoDB‘s buffer pool. For this, you need to find a way to tell Linux to keep a small OS…

Filed Under: Insight for Developers Tagged With:

Post: A recovery trivia or how to recover from a lost ibdata1 file

June 3, 2011 By 8 Comments

… fake Innodb tables Once the Innodb tablespace id is minus one of a customer table alter the table definition from MyISAM to Innodb Discard….$CURRENT_TABLENAME;” sleep 1 echo “switching to Innodb ” mysql -u root -e “alter table recover.$CURRENT_TABLENAME engine=Innodb;” sleep 1 echo “discarding tablespace…

Filed Under: MySQL

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

March 4, 2013 By 7 Comments

… to be people who believe that switching to InnoDB FTS is simply a matter of upgrading to 5.6 and running ALTER TABLE foo ENGINE=InnoDB…’s middle initial. To test this hypothesis, I reset innodb_ft_min_token_size to 1, dropped/rebuilt the InnoDB index, and tried again… default), I think you’re going to be forced to set innodb_ft_min_token_size to 1. Otherwise you’ll run into the…

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

Post: Should you move from MyISAM to Innodb ?

January 12, 2009 By 59 Comments

… when it is feasible to move to Innodb and when staying on MyISAM is preferred ? I generally prefer to see Innodb as the main storage… to pick one storage engine (typically Innodb) and when use other tables when it really gives substantial gains. I would not switch table to… Archive) for logging. Innodb Needs Tuning As a final note about MyISAM to Innodb migration I should mention about Innodb tuning. Innodb needs tuning. Really…

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