June 20, 2013

Post: Fighting MySQL Replication Lag

time. I would keep the maximum query length at about 1/5th ofMySQL 5.1 with row level replication you will not have selection process … in 5.0 for many reasons (locking, long query time, waste of execution on slave). …significantly during their run time and make it impossible for slave to run the …

Post: Improved InnoDB fast index creation

for query cache lockMySQL manual: “… you can generally speed the overall process oftime mysql -uroot test < dump_unoptimized.sql real 2m52.785s user 0m3.179s sys 0m0.069s $ time mysql