May 25, 2012

Post: MySQL performance on EC2/EBS versus RDS

MySQL database. When you do, the limitations on the core counts and effective CPU…_running SHOW STATUS counter, without much loss of generality…. are likely to be affected by the shared nature …performance and ability to mount them on other machines. This is really nice for making replicas and backups

Post: Living with backups

mysql | ssh backup@storage-host /root/backup-tools/write_backup.sh This will read /mnt/snapshot/mysqlwithout one-liners) On Linux there is also a utility called ionice. It allows to affectperformance problems to happen on the working instance of MySQL