… executed on the InnoDB table: SELECT non_key…converted a lot of point primary key lookups to one or more range primary key lookup. Thereby, converting Random access to…to MySQL 5.5 MRR clearly changes the access pattern to sequential, and hence InnoDB is able to do many read_aheads. Another thing to…
Post: Announcement of Percona XtraDB Cluster 5.5.20 GA release
April 3, 2012 By 10 Comments
… and affordable for everyone. You can convert your existing MySQL replication setup into a cluster in…operations against table This is an General Availability release. We did our best to eliminate bugs…of the art: Galera – synchronous replication for InnoDB Happy clustering! mbgc=’f5f5f5′;ww=’320′;mbc…
Comment: How to load large files safely into InnoDB with LOAD DATA INFILE
March 29, 2012 By 28 Comments
… helpful article! It is just what I needed to convert a 330GB MyISAM database to InnoDB with reasonable effort. I have tested your Perl… a charm transferring the biggest table we have (160GB , varchar columns). Also, rather then time’ing the mysql commands in the loop (second shell), I added –show-warnings to the command line, because otherwise…
Post: Moving from MyISAM to Innodb or XtraDB. Basics
November 22, 2010 By 2 Comments
…some feature differences between MyISAM and Innodb though well it is typically easily spotted by converting tables to Innodb on restored backup. Full text … Innodb. First Depending on MySQL version they may be somewhere from suboptimal to absolutely disastrous, you do not want to try to run Innodb …
Post: Pitfalls of converting to InnoDB
February 25, 2007 By 16 Comments
… recommend to our clients to convert their current database from MyISAM tables to InnoDB. The transfer by itself in most cases is …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: Performance gotcha of MySQL memory tables
February 1, 2008 By 5 Comments
… with MEMORY tables you might know about comes from the fact it is the only MySQL storage engine which defaults to HASH index… per second while converting table to MyISAM I get about 600 deletes per second and about 4000 deletes per second for Innodb (with log… be surprised to see MyISAM being significantly slower than Innodb – in this case the table is small and fully fits in Innodb Buffer Pool…
Post: How Percona does a MySQL Performance Audit
November 24, 2008 By 17 Comments
…tables, I’ll paste in mysql> show global variables like ‘%table_size%’; +———————+———–+ | Variable_name | Value | +———————+———–+ | max_heap_table_size | 268435456 | | tmp_table… indication that it’s time to convert MyISAM tables to InnoDB. (But then again, it …
Post: A recovery trivia or how to recover from a lost ibdata1 file
June 3, 2011 By 7 Comments
… to Innodb ” mysql -u root -e “alter table recover.$CURRENT_TABLENAME engine=Innodb;” sleep 1 echo “discarding tablespace ” mysql -u root -e “alter table recover…schema, the recovery completed. The customer was able to download the tables in MyISAM format and then he just convert them back to InnoDB….
Post: MySQL Error control changes
February 19, 2007 By 4 Comments
… not query all tables are accessible not catching such errors. If MySQL is started with Innodb tables disabled accesses to Innodb tables will simply result … MySQL substitutes storage engines so if Innodb is disabled MyISAM is used, so I’ve seen people thinking they have converted things to Innodb…
Post: What to do with MySQL Full Text Search while migrating to Innodb ?
September 10, 2009 By 12 Comments
It is rather typical for systems to start as MyISAM but as system growths to move to Innodb. The reason of the move could… for Innodb tables. So what can you do ? Leave Tables as MyISAM The beauty of MySQL storage engines is you do not have to convert all tables… Innodb but build a “shadow” MyISAM table which is used for full text search. In certain cases you can just use MySQL triggers to…
