17
votes
1answer
2k views

How do you do load testing and capacity planning for databases?

This is a canonical question about capacity planning for databases. Related: Can you help me with my capacity planning? How do you do Load Testing and Capacity Planning for Web ...
1
vote
1answer
456 views

Oracle DB emulator

Don't now if its a right place to ask, so if not please give me a hint. I need some software that do can emulate how Oracle DB works with disks (NOT ORACLE WORKLOAD TOOL). I've already took a look at ...
0
votes
2answers
422 views

Benchmark different kind of SQL database :What's the best test to do?

I have an application that i can configure to get data from different kind of SQL database server, for example Postgres, MSSQL, MySQL, Firebird ... I must install this application and the database ...
36
votes
7answers
29k 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 ...