MySQL Forums
Forum List  »  Performance

Re: MySQL 5.6 disk requirements
Posted by: justin edmands
Date: February 26, 2013 01:44PM

Thanks for the reply.

my.cnf is all defaults for both mysql installs. This box is not for the MySQL environment, but I am baselining the hardware components to ensure improvements are made.

Next, my initial thoughts were the DB tests were too large for this Areca cards cache of 512MB. I figured it would just skip past it in no time. I ran the tests again with the write cache off and got the same results.


Machine Disk Info Cores Threads TPS R/W Notes Write Type
New Zimbra – MySQL 5.6.00 RAID 1 – 2 x 15K RPM 8 4 2538 35541 Physical Write Through
New Zimbra – MySQL 5.6.00 RAID 1 – 2 x 15K RPM 8 8 5670 79379 Physical Write Through
New Zimbra – MySQL 5.6.00 RAID 1 – 2 x 15K RPM 8 16 5769 80768 Physical Write Through
New Zimbra – MySQL 5.6.00 RAID 1 – 2 x 15K RPM 8 40 5786 81008 Physical Write Through
New Zimbra – MySQL 5.6.00 RAID 1 – 2 x 15K RPM 8 4 4200 58798 Physical Write Back
New Zimbra – MySQL 5.6.00 RAID 1 – 2 x 15K RPM 8 8 5647 79067 Physical Write Back
New Zimbra – MySQL 5.6.00 RAID 1 – 2 x 15K RPM 8 16 5754 80560 Physical Write Back
New Zimbra – MySQL 5.6.00 RAID 1 – 2 x 15K RPM 8 40 5755 80572 Physical Write Back
New Zimbra – MySQL 5.6.00 RAID 10 – 8 x 15K 8 4 4086 57208 Physical Write Through
New Zimbra – MySQL 5.6.00 RAID 10 – 8 x 15K 8 8 5604 78461 Physical Write Through
New Zimbra – MySQL 5.6.00 RAID 10 – 8 x 15K 8 16 5589 78461 Physical Write Through
New Zimbra – MySQL 5.6.00 RAID 10 – 8 x 15K 8 40 5550 78251 Physical Write Through
New Zimbra – MySQL 5.6.00 RAID 10 – 8 x 15K 8 4 4201 58800 Physical Write Back
New Zimbra – MySQL 5.6.00 RAID 10 – 8 x 15K 8 8 5698 79781 Physical Write Back
New Zimbra – MySQL 5.6.00 RAID 10 – 8 x 15K 8 16 5797 81159 Physical Write Back
New Zimbra – MySQL 5.6.00 RAID 10 – 8 x 15K 8 40 5704 79858 Physical Write Back



Edited 1 time(s). Last edit at 02/26/2013 01:49PM by justin edmands.

Options: ReplyQuote


Subject
Views
Written By
Posted
2554
February 25, 2013 11:49AM
906
February 26, 2013 09:17AM
Re: MySQL 5.6 disk requirements
1221
February 26, 2013 01:44PM
796
February 27, 2013 11:17PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.