Hi all.
I have application php wrote on mysql versin 4.1
This database contains 5 Milion of records and now i have implemented new server only database (xeon dual core 2.66).

I would want configurate mysql 5 for best performance with dual core , and create test stress for valutation. I have see script mysql_stress_test.pl (http://dev.mysql.com/doc/mysqltest/e...-test-pl.html).

Furthermore, I would like to run application php on mysql 5 without rewrite query sql.