… to rearrange their database or even restore from backup. You …even weeks depending on your storage engine and set of indexes, …error approach even for production – found some bad queries fixed them by adding indexes and got…database size. Say it takes 30 minutes to alter 10GB table so it will take 5…
Post: Recovery beyond data restore
August 2, 2008 By 11 Comments
…1TB of database size replicating to 50 servers in 5 different…soft crash. Unless you got into one of … by user or application error or security breach. What… slave from the master, another slave or restore from backup….partial replication, replication to different storage engine, add some tables beyond…
Post: Beware the Innodb Table Monitor
November 29, 2011 By 2 Comments
…database you choose), like this: CREATE TABLE innodb_table_monitor (a INT) ENGINE… to the mysql error log, which looks something like… explain it, I got an email explaining …be any adverse effects from running the monitor, …5.1 in: storage/innodb_plugin/dict/dict0load.c: line 226, and again in: storage…
Post: Cache Performance Comparison
August 9, 2006 By 73 Comments
…5.0. For memcached access memcache extension from…database access will normally be larger. Results I got from…from table (Unix Socket) 7400 Note: The test measures peak performance so I did not do much of error… on shared storage). Query Cache… NULL, PRIMARY KEY (`k`) ) ENGINE=MyISAM DEFAULT CHARSET=…
