> > > > [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
Is this perhaps related to the 'slow thread creation' 'feature' of some
linux kernels?
http://lists.mysql.com/php/search.php?ps=10&q=fast+thread+creation+&ps=20&m=
and
> -Original Message-
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED]]On Behalf Of Leonardo Dias
> Sent: 29 Januar
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