I have a dedicated MySQL 5.1 database server with 2 Intel Xeon 2GHz quad core processors and 10 Gb of Ram.
I use the MySQL Admin tool to perform full backups of my database, with a size of 12 Gb, but the process takes almost 4 hours to complete.
While analyzing the processor usage during the backup, only one core is being used by the MySQL Admin, which is a total waste considering I have another 7 cores sitting idle.
Is there a way to speed the backup process using the MySQL Admin Tool, or do you recommend another procedure to perform faster backups?
Edited: The server runs Windows 2008 x64 Enterprise Edition