UBB.Developers Forums Community Development Programming MySQL and Server Configuration Making a Large test database?

I have a server that i want to benchmark MySQL and the server itself with a large database, atleast 500MB maybe.
it's a Dual athlon system with a hardware ide raid card, and i like pushing hardware as fast as possible - it's just fun, hehe.
anyway.
is there a way i can create a threads db that large?
or even just if theres software out there to test the performance?
i haven't worked with raid much, so i wanna see the differnce between things like raid 0+1, 3, and 5 running stuff like mysql and webservers.
or heck, just any fun stress tests or good data I/O benchmarks

Sounds like a very nice server

e-week used a program named "nile" to benchmark some tests it ran recently:

http://www.eweek.com/article/0,3658,s=708&a=23115,00.asp

You might check that out first.

MySQL.com also has benchmarking software: http://www.mysql.com/downloads/contrib.html#SEC647