…you have the following query executed on the InnoDB table: SELECT non_key_column FROM tbl WHERE … or more range primary key lookup. Thereby, converting Random access to one or more sequential access…MySQL 5.5, as can be seen by the numbers reported for the status counter Innodb_rows_read. While MySQL…
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…. Schema change does not block operations against table This is an General Availability release. We…of the art: Galera – synchronous replication for InnoDB Happy clustering! mbgc=’f5f5f5′;ww=’320′;mbc…
Post: Faster Point In Time Recovery with LVM2 Snaphots and Binary Logs
February 23, 2012 By Leave a Comment
…InnoDB…Convert lv_root VolGroup -wi-ao 5.54g lv_swap VolGroup -wi-ao 1.97g mysql-data sb owi-ao 20.00g mysql…
Comment: How to load large files safely into InnoDB with LOAD DATA INFILE
March 29, 2012 By 28 Comments
… article! It is just what I needed to convert a 330GB MyISAM database to InnoDB with reasonable effort. I have tested your… a charm transferring the biggest table we have (160GB , varchar columns). Also, rather then time’ing the mysql commands in the loop…
Post: How to recover deleted rows from an InnoDB Tablespace
February 20, 2012 By 3 Comments
… information related with tables and indexes (with their IDs) to the error log. mysql (employees) > CREATE TABLE innodb_table_monitor (id int) ENGINE=InnoDB; TABLE: name employees…/include/table_defs.h so it will be necessary to recompile the tool. To help us in the task of converting the…
Post: How Percona does a MySQL Performance Audit
November 24, 2008 By 17 Comments
… to determine when an in-memory temporary table will be converted to an on-disk table, which is an expensive operation. In this… might be an indication that it’s time to convert MyISAM tables to InnoDB. (But then again, it might not be.) Or maybe…’ll look at, including checking for default users in the mysql.* tables, running mk-duplicate-key-checker to find redundant indexes, and…
Post: Recovering Innodb table Corruption
July 4, 2008 By 19 Comments
…table and convert new table back to Innodb after restarting without innodb_force_recovery option. You can also rename the old table…
Post: MySQL Error control changes
February 19, 2007 By 4 Comments
…will 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
… 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 at once. In some cases full text search is used on secondary small tables which do not… in Innodb but build a “shadow” MyISAM table which is used for full text search. In certain cases you can just use MySQL…
Post: How to debug long-running transactions in MySQL
March 8, 2011 By 6 Comments
…-digest to convert this into a query log, and examine the log. In MySQL 5.1 and newer with the InnoDB plugin, it… blocking others. There are some INFORMATION_SCHEMA tables that make this simple. Just query the tables, and if something is blocked, find… 1 fi host=$(mysql -ss -e ‘SELECT p.HOST FROM information_schema.innodb_lock_waits w INNER JOIN information_schema.innodb_trx b…
