I don't know if any of you people have ever had this trouble, but it's
been a messy one here.
Whenever a website of ours get lots of traffic, MySQL gets too slow to
connect. Whenever it connects, the queries are fast. Since lots of our
scripts relies on database connections, it has become a big
increase the number of connections allowed, that might be it
On Mon, 29 Jan 2001, Leonardo Dias wrote:
I don't know if any of you people have ever had this trouble, but it's
been a messy one here.
Whenever a website of ours get lots of traffic, MySQL gets too slow to
connect. Whenever it
15:41
To: [EMAIL PROTECTED]
Subject: Very slow to connect
I don't know if any of you people have ever had this trouble, but it's
been a messy one here.
Whenever a website of ours get lots of traffic, MySQL gets too slow to
connect. Whenever it connects, the queries are fast. Since lots
I bet your webserver and database server are seperate machine.
Make sure the hostname of web and db are in the /etc/hosts on both machine,
it's very slow to use DNS to resolve everything
That doesn't matter. We use IP to connect, not hostnames.
It might be a problem with the slow
Leonardo Dias wrote:
I bet your webserver and database server are seperate machine.
Make sure the hostname of web and db are in the /etc/hosts on both machine,
it's very slow to use DNS to resolve everything
That doesn't matter. We use IP to connect, not hostnames.
But if you use IP
[1 text/plain; us-ascii (7bit)]
I don't know if any of you people have ever had this trouble, but it's
been a messy one here.
Whenever a website of ours get lots of traffic, MySQL gets too slow to
connect. Whenever it connects, the queries are fast. Since lots of our
scripts relies
[1 text/plain; us-ascii (7bit)]
I don't know if any of you people have ever had this trouble, but it's
been a messy one here.
Whenever a website of ours get lots of traffic, MySQL gets too slow to
connect. Whenever it connects, the queries are fast. Since lots of our
Concurrent updates and mysql aren't the best of friends, yet. (Perhaps DBD
and/or that new geminii stuff can fix some of your problems? Although
geminii will probably cost you...)
A lot of the slow queries can be solved by making better tables, sometimes
even de-normalizing them if that
You don't seem to have mentioned how much memory you have.
On 29 Jan 2001, at 14:52, Leonardo Dias wrote:
[1 text/plain; us-ascii (7bit)]
I don't know if any of you people have ever had this trouble, but
it's been a messy one here.
Whenever a website of ours get lots of traffic,
[1 text/plain; us-ascii (7bit)]
I don't know if any of you people have ever had this trouble, but
it's been a messy one here.
Whenever a website of ours get lots of traffic, MySQL gets too
slow to connect. Whenever it connects, the queries are fast. Since
lots of our
10 matches
Mail list logo