Benchmarking MySQL on win7
- by Patrick
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.
