…Overhead It is simply file copy so overhead to the server is minimal. Easy to Integrate Do you want to compress backup ? Backup it to…to do to perform backup of MySQL Database (or create slave) using LVM2 on Linux. 1) Connect to MySQL…
Post: MySQL Query Cache
July 27, 2006 By 70 Comments
…to implement. Might not work with transactions – Different transactions may see different states of the database…how much of inserted queries are used: Qcache_hits/Qcache_inserts Other portion of overhead comes from…
Post: Quickly finding unused indexes (and estimating their size)
December 5, 2012 By 2 Comments
…overhead to your running server, but it’s important to leave this running for a good long while to…how big each index is if we dropped it (not big in this case with test data): mysql> select * from…
Post: Implementing efficient counters with MySQL
July 1, 2007 By 16 Comments
…overhead or may simply be bottleneck. If you can reduce your durability requirements this is best thing to…to perform certain action (ie write back to the database) when object is removed from…
Post: Faster Point In Time Recovery with LVM2 Snaphots and Binary Logs
February 23, 2012 By 3 Comments
…MySQL databases – but did you know that you can now restore directly from… show you quickly how. This … able to restore up to before…mysql-data-201202230157″ successfully removed [root@sb logs]# mount /mysql/data [root@sb logs]# /etc/init.d/mysql start Starting MySQL…the extra IO overhead i.e. …
