I am trying to reproduce production activity in time for benchmarking purposes from the mysql general query log. I'd like to be able to use the date data from the log to reprduce the time intervals ...
I've setup a nginx server running php 5.3.6 and mysql 18.104.22.168. 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 ...
I tried to look for benchmark on the performances of various filesystems with MySQL InnoDB but couldn't find any. My database workload is the typical web-based OLTP, about 90% read, 10% write. Random ...