0
votes
1answer
78 views

Mysql general query log tool to play back queries in time?

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 ...
0
votes
1answer
141 views

Benchmarking MySQL on win7

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 ...
36
votes
7answers
28k views

What is the best Linux filesystem for MySQL (InnoDB)?

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 ...