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 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, 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 problem to
> our website and we've been unable to answer to our costumers what is
> going on.
>
> a mysqladmin status shows the following:
>
> Uptime: 441237 Threads: 29 Questions: 23849146 Slow queries: 11390
> Opens: 90355 Flush tables: 8 Open tables: 128 Queries per second avg:
> 54.051
>
> We know that 54 queries per second should be a lot, but it's not. We've
> already had more traffic than that. A show processlist rarely shows more
> than 30 processes. The machine is a Linux SMP with 2 CPUs PIII 800MHz
> and 1G of RAM. What could possibly be wrong? Also, our setup for
> file-max is big enough to support lots of connections.
>
> We, of course, do lots of concurrent updates and selects in some (not
> all) tables.
>
> For the MySQL specialists out there, these are the variables returned by
> a show variables. Are there any values that could be changed so that the
> connection wouldn't be so slow?
>
> Are there people with the same problems out there? I'm waiting for a
> shout from the wild... :)
>
> Thanks.
>
> --
> Leonardo Dias
> Catho Online
> WebDevelopper
> http://www.catho.com.br/
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
