Hi, Nice work 
For information, you switched the two urls at the top (innoDB recovery and moving tables).
Comment: Performance improvements in Percona 5.0.83 and XtraDB
July 15, 2009 By 27 Comments
Post: MySQL 5.6 vs MySQL 5.5 and the Star Schema Benchmark
March 11, 2013 By 7 Comments
… is problematic. What usually happens is that the full table scans access the table by primary key. This forces the storage engine to touch the same page numerous times in rapid succession. This invariably moves… tinyint, D_HolidayFl tinyint, D_WeekDayFl tinyint ); DROP TABLE IF EXISTS lineorder; CREATE TABLE IF NOT EXISTS lineorder ( LO_OrderKey bigint not…
Comment: Spreading .ibd files across multiple disks; the optimization that isn't
December 26, 2010 By 23 Comments
… combined with views to move physical access to other devices while logically allowing you to access the table in the other database… we already have tables in it,. Also assume that we just added SSD –and only want to move certain tables there. Last, assume…(10), log3 int) engine=innodb; To move the_db.log to `fast_ssd`: RENAME TABLE the_db.log to `fast_ssd`.log…
Post: High-Performance Click Analysis with MySQL
December 22, 2008 By 13 Comments
… cases. Especially on huge tables, it lets you scan portions of a table instead of the whole table if you a) choose… SQL tend to get really bogged down. In contrast, moving the processing outside the database lets you parallelize trivially. If… is essentially “I admit defeat and accept table scans as a fact of life.” Table scans can be better than the alternative…
Post: When is MIN(DATE) != MIN(DATE) ?
September 4, 2012 By 5 Comments
… range for DATE/DATETIME, neither TRADITIONAL, STRICT_ALL_TABLES, or STRICT_TRANS_TABLES produces so much as a warning. Is this a…, the behavior was even stranger. I created a table with a similar structure: CREATE TABLE `foo` ( `i` int(11) NOT NULL AUTO… changing their PK, and this is what happened: Before the move: (root@localhost) [test]> select * from foo order by update_date…
Post: Performance impact of complex queries
January 17, 2007 By 11 Comments
… you load the data or build summary tables. In such cases you may still move some of the load to the server… of the load) or you may prepare summary tables on the slave and when move them to the master using mysqldump, or even careful file transfer if you’re using MyISAM tables. Chop it…
Post: MySQL Crash Recovery
July 30, 2006 By 30 Comments
… use tiny script which moves out all MyISAM tables out of MySQL database directory, checks them with MyISAMchk and moves them back to running server. This looks scary but it works great – until table is checked and… might run select 1 from _table_ limit 1 for each table or any other statement – it is table open which is important. There…
Post: Side load may massively impact your MySQL Performance
November 13, 2011 By 7 Comments
… –mysql-host=localhost –mysql-table-engine=innodb –mysql-db=test –oltp-table-name=md_cache_test_small –oltp-table-size=1100000 –mysql-user… –mysql-host=localhost –mysql-table-engine=innodb –mysql-db=test –oltp-table-name=md_cache_test_small –oltp-table-size=1100000 –mysql-user… specifies amount of milliseconds which needs to pass before table can be moved to the young sublist. In typical cases like mysqldump…
Post: Heikki Tuuri answers to Innodb questions, Part II
November 4, 2007 By 13 Comments
… on the OS version. In our tests, removing one bottleneck moves the contention to another place. Thus, no general rules can… 64 pages == 1 MB. Then a full table scan would be fast. Maybe the table has become fragmented? Or maybe you have… a bit. I also like to keep tables small enough, “sharding” to many tables before they become so large it would take…
Post: The story of one MySQL Upgrade
October 8, 2010 By 8 Comments
… guess in such cases some of the original authors have moved on and nobody is exactly sure what application does or… we ran the check using default CHECKSUM TABLE algorithm. We got number of tables reporting wrong checksums while running SELECT INTO OUTFILE… BIT_XOR algorithm eliminated those false positives. Another table remained though. We used mk-table-sync –print as a diff tool for…
