Re: random "permission denied" issues

2005-10-29 Thread 156 Oud
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++; }

Re: random "permission denied" issues

2005-10-28 Thread sheeri kritzer
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

Re: random "permission denied" issues

2005-10-28 Thread Johannes B. Ullrich
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

Re: random "permission denied" issues

2005-10-28 Thread sheeri kritzer
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