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 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.
>
>
--
-Spinlock
EmpireQuest Creator
http://www.empirequest.com
---------------------------------------------------------------------
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
