SSD Disk Performance with MySQL

view full story

http://www.linuxquestions.org – More of a "you might find this interesting" type of post. Using our standard virtualisation hardware and XenServer I created a single Virtual Machine with the following configuration and used it for some MySQL tests. A default CentOS 6.4 instance was created with the following paramaters: 12 VCPU 32Gb RAM 4Gb Swap 1 x 64Gb VHD for / (etc.) 1 x 64Gb VHD (SAS HD) for mydata 1 x 64Gb VHD (SATA SSD) for mydata Before each test mysql server was stopped and the relevant MySQL data folder was deleted. This allowed the data folder to be created with default data when the mysql daemon (HowTos)