Re: Heavily-loaded MySQL: Resource temporarily unavavailable?

2007-03-02 Thread Chris Boot
Jay Pipes wrote: Other variables you may want to look at is ensuring that your table_cache (or table_open_cache if 5.1+) has enough room to deal with 600 connections * the number of average tables in a typical SQL expression executed against the server. If this variable value is really low, y

Re: Heavily-loaded MySQL: Resource temporarily unavavailable?

2007-03-02 Thread Chris Boot
Jay Pipes wrote: Chris Boot wrote: Rolando Edwards wrote: Also consider wait_timeout in my.ini This is set to 28800. I don't consider this a problem since I've hardly ever got anywhere near my connection limit. - Original Message - From: "Rolando Edwards" &l

Re: Heavily-loaded MySQL: Resource temporarily unavavailable?

2007-03-02 Thread Chris Boot
Rolando Edwards wrote: Also consider wait_timeout in my.ini This is set to 28800. I don't consider this a problem since I've hardly ever got anywhere near my connection limit. - Original Message - From: "Rolando Edwards" <[EMAIL PROTECTED]> To: "Chr

Heavily-loaded MySQL: Resource temporarily unavavailable?

2007-03-02 Thread Chris Boot
min's stats anyway). I've upped the open files limit on MySQL and Apache (PHP runs as a module). At this stage I'm completely out of ideas as to what I can do to fix my problem. Any ideas? What extra information can I provide that could help? Many thanks, Chris -- Chris Boo

Re: Selecting random rows with MySQL 3.22?

2001-03-19 Thread Chris Boot
on't like knowing something without knowing how it works. Best wishes, -- .-. Chris Boot /v\ [EMAIL PROTECTED] // \\ /( )\L I N U X ^^-^^>Phear the Penguin< - Before po

Selecting random rows with MySQL 3.22?

2001-03-19 Thread Chris Boot
RAND() LIMIT 1 How can I do this 3.22? Upgrading to 3.23 is not an option at the moment. Thanks in advance, -- .-. Chris Boot /v\ [EMAIL PROTECTED] // \\ /( )\L I N U X ^^-^^