June 20, 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: 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: Innodb Table Locks

July 31, 2012 By 4 Comments

… you may spotted important difference between MyISAM and Innodb when it comes to Table Level Locks. For MyISAM tables running UPDATE query on… unlocking it straight after. Not so for Innodb. Unless table is being locked explicitly Innodb “converts” table lock to “no lock” hence eliminating…

Filed Under: Insight for DBAs, MySQL

Post: Using CHAR keys for joins, how much is the overhead ?

June 18, 2007 By 18 Comments

… about Innodb ? Innodb executed the same query in 2.9 seconds which was a bit disappointing for me as I expected MyISAM to… more. The next test I decided to do is to convert Innodb table to latin1 character set. I was expected this to… can range from few percent to couple of times for Innodb tables MyISAM Tables may suffer significantly if key compression is not…

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

… but the info in a MyISAM table Advance the Innodb tablespace id by creating fake Innodb tables Once the Innodb tablespace id is minus one of a customer table alter the table definition from MyISAM to Innodb Discard… completed. The customer was able to download the tables in MyISAM format and then he just convert them back to InnoDB.

Filed Under: MySQL

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: 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: 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: ,
« Older Posts