author: vadim tkachenko

High Performance MySQL: Optimization, Backups, and Replication

... Antipatterns (Karwin), 256 SQL dumps, 637 SQL interface prepared statements, 295 SQL slave thread, 450 SQL statements, 638 SQL utilities, 667. Index | 789.

High Performance MySQL: Optimization, Backups, and Replication

... message , from , to , subject , etc. status ENUM ( ' unsent ' , ' claimed ... so in theory it looks rather efficient . The problem is that between the two ... many rows were updated , so you know whether there were unsent rows to claim ...

High Performance MySQL: Optimization, Backups, Replication, and More

... SSH , the secure protocol upon which SCP is based . Here's the command we execute on server1 : server1 $ gzip -c ... fast compression , you can instead use an LZO - based archiver . The compressed data might be about 20 % larger , but the ...

This website uses cookies and collects data for optimal performance. Your continued use signifies agreement to our Privacy Policy.