Re: Anyone using LVM for backing up?

2009-06-22 Thread Thomas A. McGonagle
Hi Tim, We use LVM snapshots all the time. They are essentially instantaneous with our 90GB innodb database files. A command to generate the snapshot could be: sudo /usr/sbin/lvcreate --snapshot --name mysqlsqlbackup --size 15G / dev/system/data01 Please let me know if you have any

Re: Available parallelism in MySQL community edition 5.1.34?

2009-06-10 Thread Thomas A. McGonagle
Hi Mike, The way we do it is installing each mysql instance from a precompiled binary. So if you had an 8 core box, and you wanted to use each of the 8 cores, you could install a mysql binary installation and then make 7 copies of it. We use an internal naming convention like the