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
I am having a very odd issue with one of my mysql 4.1.14 servers.
Randomly, the server returns "permission denied" to queries even if
identical queries succeeded within the same connection.
To test the problem, I setup a script that connects to the database, and
issues the same query 50,000 times