FreeBSD 5.4 and Poor performance using MySQL Administrator

FreeBSD 5.4 and Poor performance using MySQL Administrator

am 27.04.2006 22:49:49 von Newbie72

Thanks for the help in advance,

It has been over 5 years since I have messed with FreeBSD and I have
never messed with MySQL until now so forgive me if my issue is trivial
and I thank everyone for the help.

The hospital I work for is finally getting off of Micrisift IIS to
server the Hospital website. i built a FreeBSD server with Apache
2.0.54 and PHP5 as well as MySQl 5.x.x. Running queries on the server
locally is fast as lighting as well as is creating db's and tables. How
ever if I use MySQL query or Administrator it takes what seems like
like about a minute or more to finally connect. I believe I have ruled
out all network issues as this server also sits in our corporate dmz by
attempting to connect directly to the server via cross over cable with
a laptop.

I have been fuddling with this for about a week and it is supposed to
go into production next week. I do not know where to start so if anyone
could point me in the right direction it would be greatly appreciated.

i have looked at the MySQL documentation as well as searched all over
google.

Sincerely,

Steven Johnson