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 password to be accepted. Hence the web
app still runs slow.
I can log in remotely using mysql administrator and other client
programs and it logs in as normal. It is just really slow from a shell.
The only settings I changed were
key_buffer
max_allowed_packet
no_auto_rehash
Not sure how changing these values has caused my logins to be so slow
Always CC the list, you'll get better and faster responses.
That sounds like a dns issue.
If you log in again now is it fast?
If you use the ip address instead of the domain name is it fast?
This might help you:
http://www.debuntu.org/2006/07/21/75-how-to-optimize-mysql-response-time/
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]