Hi,
I've got the exact same problem than Johannes with MySQL 4.1.14.
Like him, i've set a little script
[EMAIL PROTECTED]($host,$user$password);
while ($i<5) {
$x=mysql_query($query);
if ( $x) {
print "$i worked!";
} else {
print "$i ERROR! ".mysql_error()."";
}
$i++;
}
I'm not sure if this will help you, but it might:
http://jeremy.zawodny.com/blog/archives/000173.html
(brief excerpt)
"So the moral of the story is this: If you have a busy server that's
getting a lot of quick connections, set your thread cache high enough
that the Threads_created value in SHOW S
sheeri kritzer wrote:
> What is max_connections set to (my.cnf?)? How many connections are
> there at a time? (show processlist) That would result in a "too many
> connections" error, but it's worth a shot.
Max connections: 2000
typically 10-20 used (hardly ever >100).
> What is the thread cache
What is max_connections set to (my.cnf?)? How many connections are
there at a time? (show processlist) That would result in a "too many
connections" error, but it's worth a shot.
What is the thread cache set to?
-Sheeri
On 10/28/05, Johannes B. Ullrich <[EMAIL PROTECTED]> wrote:
>
> I am having