Re: tmp table created using remote database - slow query

2006-08-16 Thread Chris
Rhys Johnson wrote: Thanks for the reply Chris I seem to have the remote database working just as fast as the local one after comparing the my.cnf settings. Query times have dropped from 3.6s to 0.4s. However, now when I log in from a shell prompt remotely into mysql it takes about 10s for my pa

Re: tmp table created using remote database - slow query

2006-08-15 Thread Chris
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

tmp table created using remote database - slow query

2006-08-15 Thread Rhys Johnson
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