Rhys Johnson wrote:
Hello
I am running an online web shop using a MySQL (v5.0.19) backend. The web
app runs really fast whilst the MySQL database is on the local machine
(2x PIII procs, 2GB mem). However I tried moving the database onto a
dedicated database machine (2x P4 Zeon 4Gb Mem Raid5) and it runs really
slow. I have ruled out networking issues, firewalls etc.
Check your my.cnf files to see what changes you have made.
Compare the 'show variables;' output on both systems.
Use 'explain' on both systems to see what differences you get (maybe
somehow an index is missing on the remote machine).
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
