…MySQL databases – but did you know that you can now restore directly from…5…mysql-bin.000022 | 336797725 | | mysql-bin.000023 | 107 | +——————+———–+ 23 rows in set (0.00 sec) mysql> select count(*) from…
Post: Faster Point In Time Recovery with LVM2 Snaphots and Binary Logs
February 23, 2012 By 3 Comments
Post: Feature in details: Incremental state transfer after a node crash in Percona XtraDB Cluster
January 31, 2013 By 2 Comments
…restore nodes from backup. We can start all nodes from…23:01:22 mysqld_safe Starting mysqld daemon with databases from /mnt/data/mysql 130129 23…3(r143) by Codership Oy
Post: Database problems in MySQL/PHP Applications
August 11, 2006 By 13 Comments
… elseware might be faster. 3. Using multiple databases Honestly … easier to do backup and restore if you need only portion… my Why MySQL Could be slow with Large Tables article. 5. …FROM articles WHERE user_id IN(23,545,654,34) instead of: SELECT * FROM articles WHERE user_id IN (SELECT id FROM…
Comment: Database problems in MySQL/PHP Applications
August 11, 2006 By 13 Comments
… engine like Archive… > 3. Using multiple databases…> Things are different with MySQL. Good design will… data restore, more tables means longer restore times….bad is unwise. > 5. The n+1…FROM articles WHERE user_id IN(23,545,654,34) > instead of: > SELECT * FROM articles WHERE user_id IN (SELECT id FROM…
