Benchmarking MySQL on win7
Posted
by
Patrick
on Server Fault
See other posts from Server Fault
or by Patrick
Published on 2011-06-23T23:15:34Z
Indexed on
2011/06/24
0:24 UTC
Read the original article
Hit count: 652
I've setup a nginx server running php 5.3.6 and mysql 5.5.1.3.
My computer is an AMD quadcore 9650, 4gb ram, 500gb 7200rpm HD.
I ran the PHP MySQL Benchmark Tool v. 0.1, and got the following results:
Testing a(n) MYISAM table using 100000 rows.
Successfully created database speedtestdb
Sucessfully created table speedtesttable
Table Type Verified: MYISAM ..
Done. 100000 inserts in 19.73628 seconds or 5067 inserts per second.
Done. 100000 row reads in 0.2801 seconds or 357015 row reads per second.
Done. 100000 updates in 4.03876 seconds or 24760 updates per second.
I'm wondering where this stands as far as performance goes, and what are some steps I can take if any to improve on this. I'm not trying to make anything fantastic, just getting a feel for how to best optimize a web server in this configuration.
© Server Fault or respective owner