… is just what I needed to convert a 330GB MyISAM database to InnoDB with reasonable effort. I have tested your Perl script, and it seems it doesn’t handle binary data correctly, you need to… it works for me like a charm transferring the biggest table we have (160GB , varchar columns). Also, rather then time’ing…
Comment: How to load large files safely into InnoDB with LOAD DATA INFILE
March 29, 2012 By 28 Comments
Post: A recovery trivia or how to recover from a lost ibdata1 file
June 3, 2011 By 7 Comments
…Innodb tables Once the Innodb tablespace id is minus one of a customer table alter the table definition from MyISAM to Innodb Discard the tablespace Replace the table…to download the tables in MyISAM format and then he just convert them back to InnoDB…
Post: Pitfalls of converting to InnoDB
February 25, 2007 By 16 Comments
… to our clients to convert their current database from MyISAM tables to InnoDB. The transfer by itself in most cases is almost…tables” $DBNAME); do echo “Converting table $t” mysql -u$DBUSER -p$DBPWD -e “alter table $t type=InnoDB” $DBNAME; done There is the standard script mysql_convert_table…
Post: Recovering Innodb table Corruption
July 4, 2008 By 19 Comments
… your data in MyISAM table so all you have to do is to drop old table and convert new table back to Innodb after restarting without innodb_force_recovery option… to find exact number doing “binary search” Note even if you do not use MyISAM table but fetch data to the script instead make sure to…
Post: Using MyISAM in production
June 17, 2006 By 35 Comments
… thousands tables) Innodb was better choice mainly because of thouse other behaviors … well table locks… application. As load increases you might convert certain tables to MyISAM and other storage engines for …to complete. This is often not accounted for and people think – “OK. I write my script…
Post: How Percona does a MySQL Performance Audit
November 24, 2008 By 17 Comments
… of the two is used to determine when an in-memory temporary table will be converted to an on-disk table, which is an expensive… status, which might be an indication that it’s time to convert MyISAM tables to InnoDB. (But then again, it might not be.) Or maybe the… run the following: wget http://hackmysql.com/scripts/mysqlsla perl mysqlsla -lt slow /path/to/slow.log By default, this outputs the…
Post: Implementing efficient counters with MySQL
July 1, 2007 By 16 Comments
… implemented the most trivial way – they convert read load to write load. When you would simply …to deal with is log flushes. If you have innodb_flush_log_at_trx_commit=0 or 2 or if you use MyISAM tables…MyISAM or HEAP tables for this purpose, how do you deal with Table Locks in this case – the script…
Comment: Pitfalls of converting to InnoDB
February 26, 2007 By 16 Comments
Here is a quick shell script to convert all tables in a database to InnoDB. No dependancies other than a command line prompt on a … table $T type=innodb” test; done Replace “test” with the target database. This pattern is also great for optimizing or analyzing your MyISAM tables…
Post: Living with backups
November 6, 2008 By 28 Comments
…to wait much longer until disk operations are scheduled and executed which converts…MyISAM tables which have dedicated buffers only to store indexes, while the actual data is always read from disk. The active portions of tables…
