…on a GNU/Linux box (I have to adapt to whatever environment I’m in — obviously a…tables, running mk-duplicate-key-checker to find redundant indexes, and so on. As with settings and status, these set the stage for bigger gains to…hackmysql.com/scripts/mysqlsla perl mysqlsla -lt slow /path/to/slow.log…
Post: Recovering Innodb table Corruption
July 4, 2008 By 19 Comments
…index page where index id is 0 25556 InnoDB: (index “PRIMARY” of table “test”.”test”) InnoDB: Database page corruption on disk or a…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: Shard-Query EC2 images available
May 11, 2011 By 2 Comments
…indexes (not even primary keys). Here is the complete InnoDB schema from one shard. The schema is duplicated…to put that hosts file on your other nodes unless you want to run workers on them. Generate a cluster configuration There is a script provided to…
