June 18, 2013

Comment: TMP_TABLE_SIZE and MAX_HEAP_TABLE_SIZE

April 4, 2013 By 17 Comments

… everyone I am using wordpress and drupal, and i converted databases from MyISAM to InnoDB, mysql tunning script gives below results for temp…

Filed Under: Insight for DBAs Tagged With: ,

Post: Pitfalls of converting to InnoDB

February 25, 2007 By 16 Comments

We often recommend to our clients to convert their current database from MyISAM tables to InnoDB. The transfer by itself in most cases… the idea. Also there is script we are using for converting databases with many tables, maybe it will be useful for… “Converting table $t” mysql -u$DBUSER -p$DBPWD -e “alter table $t type=InnoDB” $DBNAME; done There is the standard script mysql_convert…

Filed Under: Insight for DBAs Tagged With: ,

Post: MyISAM Scalability and Innodb, Falcon Benchmarks

October 12, 2007 By 10 Comments

… was converting table t1 into InnoDB, and results: Threads Queries/sec 1 296 2 341 4 544 8 493 16 498 InnoDB both… when single query executed being 1/3rd of MyISAM and 1/6th of Innodb. On other hand it scales quite nicely as…. Here is comparison of MyISAM Innodb and Falcon results in the graphical form: I’ve created bug, for MyISAM key cache contention issue…

Filed Under: Uncategorized Tagged With: , , , ,

Post: Moving from MyISAM to Innodb or XtraDB. Basics

November 22, 2010 By 2 Comments

… are some feature differences between MyISAM and Innodb though well it is typically easily spotted by converting tables to Innodb on restored backup. Full… stored in MyISAM but would not fit to Innodb, though this is an exception. Space Innodb Tables tend to be larger. Again converting schema…

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

… CREATE TABLE 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 DEFAULT… the MyISAM full-text parser code, convert it to a plugin, and use it for InnoDB FT indexes where you’re expecting MyISAM-style…

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

Post: Recovering Innodb table Corruption

July 4, 2008 By 22 Comments

… Innodb tablespace got corrupted. In such cases Innodb will typically print something like this: InnoDB: Database page corruption on disk or a failed InnoDB: file read of page 7. InnoDB… MyISAM table so all you have to do is to drop old table and convert new table back to Innodb after restarting without innodb…

Filed Under: Insight for DBAs Tagged With:

Post: What to do with MySQL Full Text Search while migrating to Innodb ?

September 10, 2009 By 12 Comments

… rather typical for systems to start as MyISAM but as system growths to move to Innodb. The reason of the move could… do ? Leave Tables as MyISAM The beauty of MySQL storage engines is you do not have to convert all tables at once… the evils. Use “Shadow” MyISAM Table You can keep main data in Innodb but build a “shadow” MyISAM table which is used for…

Filed Under: Insight for Developers Tagged With: ,

Post: Quick tip: how to convert tables to InnoDB

July 30, 2008 By 5 Comments

… a bazillion tables to convert from MyISAM to InnoDB, but they are mixed in with other tables that are already InnoDB, or are another storage engine that you don’t want to touch. mk-find –engine MyISAM –exec “ALTER TABLE %D.%N ENGINE=INNODB” –print Here’s a bonus tip, while…

Filed Under: Insight for DBAs Tagged With:

Post: Using MyISAM in production

June 17, 2006 By 36 Comments

… application (storing billions of rows in tens of thousands tables) Innodb was better choice mainly because of thouse other behaviors … well… performance for small application. As load increases you might convert certain tables to MyISAM and other storage engines for performance reasons…. of…

Filed Under: Insight for DBAs Tagged With: ,

Post: InnoDB in self-compiled MySQL 5.1

September 13, 2007 By 9 Comments

… of InnoDB from previous version: mysql testdatabase < dump.sql I bet you will not notice all your tables now is MyISAM. Why… | YES | CSV storage engine | NO | NO | NO | | MRG_MYISAM | YES | Collection of identical MyISAM tables | NO | NO | NO | | MEMORY | YES | Hash based… want to see is BIG Warning or even Error that InnoDB table can’t be created instead of calm converting to MyISAM

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