stress test

[scuba]

Hi,

can anyone suggest the best way to stress test a mysql database which is supposed to support about 2 million users?

Thanks,
Steve

[[deleted]]

2 million concurrent users?
I'd like to see the specs of that server.

What's more, I'd like to see a website that gets 2 million concurrent requests.

Anyway, the MySQL docs are not that optimistic, they say 1000 users is about the limit.

http://www.mysql.com/doc/T/o/Too_many_connections.html

[smarlowe]

what's your write/read ratio? If you're gonna be doing a fair bit of writing, you should switch from mysql to postgresql or a bigger database like db2 or oracle. that heavy of a load should probably be split as well, with the web server and database server on seperate hardware.

Use perl or php scripts to send requests to the web server with either fsock, fopen("http://..."); , wget, or ab.

[scuba]

it's basically a self replicating site deal. I have all the pages on another server, so that's not a problem.

Basically a user will enter in a small amount of form data. Maybe 14 fields worth of basic info. So the main purpose of this database is to read the information and plug it into the web pages.

I'm using php scripts to open the database and pull the appropriate data but for the webpages, I use fopen.

Thanks for everyone's help, and any suggestions are always open.

Steve