> > > > [1 ]
> > > > 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 sc
You don't seem to have mentioned how much memory you have.
On 29 Jan 2001, at 14:52, Leonardo Dias wrote:
> > > [1 ]
> > > 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 to
> 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 th
>
> > > [1 ]
> > > 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 relie
> > [1 ]
> > 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 co
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 y
> 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 pthread_c
ED]]On Behalf Of Leonardo Dias
> Sent: 29 January 2001 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
PROTECTED]>
Sent: Monday, January 29, 2001 10:41 PM
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. Whene
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
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 p
11 matches
Mail list logo
