… sorting the secondary key tuples by pk_column, we have converted a lot of point primary key lookups to one or more range primary key lookup. Thereby, converting Random access to one or more sequential access. There is….89G 1.53G Innodb_data_reads 120552 123872 100551 103011 77213 Innodb_pages_read 120548 123868 100551 123592 100566 Innodb_rows_read 799239…
Comment: Percona Toolkit 2.1 with New Online Schema Change Tool
April 9, 2012 By 9 Comments
Quick question… does the pt-online-schema-change tool work at tables using the MyISAM storage engine? Would it work to convert a table from MyISAM to InnoDB?
Comment: InnoDB's gap locks
April 6, 2012 By 14 Comments
… converted to READ COMMITTED. I wrote up a demo of this over on DBA StackExchange: http://dba.stackexchange.com/questions/15854/innodb…
Post: Announcement of Percona XtraDB Cluster 5.5.20 GA release
April 3, 2012 By 10 Comments
… make clustering very easy and affordable for everyone. You can convert your existing MySQL replication setup into a cluster in just….1-beta2 State of the art: Galera – synchronous replication for InnoDB Happy clustering! mbgc=’f5f5f5′;ww=’320′;mbc=’cecece’;bbc=’3F79D5…
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…
Post: Faster Point In Time Recovery with LVM2 Snaphots and Binary Logs
February 23, 2012 By Leave a Comment
…i.e. updates on CentOS. If you are using InnoDB, it is also important that your transaction logs (… LV VG Attr LSize Origin Snap% Move Log Copy% Convert lv_root VolGroup -wi-ao 5.54g lv_swap…
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… 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…
Post: Moving from MyISAM to Innodb or XtraDB. Basics
November 22, 2010 By 2 Comments
… feature differences between MyISAM and Innodb though well it is typically easily spotted by converting tables to Innodb on restored backup. Full text… would not fit to Innodb, though this is an exception. Space Innodb Tables tend to be larger. Again converting schema will show you… most important values to check are innodb_flush_log_at_trx_commit, innodb_buffer_pool_size and innodb_log_file_size. There are…
Post: Real-Life Use Case for "Barracuda" InnoDB File Format
April 23, 2008 By 11 Comments
… trying to optimize this server before by playing with various innodb parameters (including page size changes) but at the end of… we’ve decided to try to convert customer’s data to Barracuda file format using new InnoDB plugin recently released by Oracle… go further with our optimizations and I’ve tried to convert this table using COMPRESSED row format. This time conversion took…
Post: Lost innodb tables, xfs and binary grep
November 9, 2010 By 11 Comments
… their copy of the data The important tables were all InnoDB Having a backup, customer has first attempted to restore from… the task. In the case number one, I have just converted number 837492636 to it’s binary representation 0x31EB1F9C and ran… bgrep as part of percona recovery toolset, with some additional converters so we can match against various date/time columns as…
