What is your MySql configuration file? What query is slow? Have you tested your query with mysql tool from a command line? What is your schema? What is the result of "describe select ..."
I suggest you to look at dns because, if i'm not wrong, MySql tries to resolve ips and this can slow down connection time. (There is a option to skip this).
Santino Cusimano
At 11:21 -0500 28-03-2005, Andre Matos wrote:
What kind of detail do you need? I checked the DNS, and it is seems to working fine.
Andre
On 3/27/05 10:02 AM, "Santino" <[EMAIL PROTECTED]> wrote:
It could be a DNS problem, but you must give us more details.
Santino
At 10:47 -0500 26-03-2005, Andre Matos wrote:Hi List,
I have 4 web based systems developed using PHP4 and MySQL accessed for 10
users. The Web Server and Database Server were running ok on a Mac OS X 10.3
G4 dual. However, since we move to a new server, the access becomes very
slow. This was not expected since we move to a 64 bits high performance
machine.
Now, we are using MySQL version 4.1.9 with Apache 2.0.52 and PHP 4.3.10, all
compiled and running on a Linux Fedora X86_64.
My first thought was the systems, but since I have not changed 3 of the 4
systems, I start to look to the database. I monitored the MySQL using "MySQL
Administrator", but I couldn't identify any problem. It looks ok, but not
completely sure if really is.
The system administrator told me that could be the PHP session, but again, he also was not complete sure about this.
It is a big problem since I need to check in 3 places: MySQL, Apache, or PHP.
Does anyone had this kind of problem or has any suggestion or direction to help me to identify and solve this issue?
Any help will be appreciated!!!
Thanks.
Andre
-- Andre Matos [EMAIL PROTECTED]
-- Andre Matos [EMAIL PROTECTED]
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
-- Andre Matos [EMAIL PROTECTED]
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
