Re: bad "too many connections" error (os x)

2004-09-02 Thread Michael Winston
On Sep 2, 2004, at 6:04 AM, Egor Egorov wrote: Michael Winston <[EMAIL PROTECTED]> wrote: Okay, so the first thing to try is obviously enlarge the max_connections. Have you tried this? Yes. It's set to 400 (a number we will never reach unless there's some sort of logjam). max_c

Re: bad "too many connections" error (os x)

2004-09-01 Thread Michael Winston
too many connections or Host blocked because of many connection erros? If it is the later you have reached max_connect_errors and need to issue flush-hosts. -Original Message- From: Michael Winston To: [EMAIL PROTECTED] Sent: 9/1/04 11:02 AM Subject: bad "too many connections&quo

Re: bad "too many connections" error (os x)

2004-09-01 Thread Michael Winston
On Sep 1, 2004, at 9:10 AM, V. M. Brasseur wrote: Michael Winston wrote: Hi- We've been running into a pretty serious problem for the past several versions of mysql 4.0 running on OS X (both client and server). Every once in a while we wake up to find the "too many connections"

bad "too many connections" error (os x)

2004-09-01 Thread Michael Winston
Hi- We've been running into a pretty serious problem for the past several versions of mysql 4.0 running on OS X (both client and server). Every once in a while we wake up to find the "too many connections" error coming up. There really aren't too many connections (we have our max set to 99) -

Re: natural sorting

2003-10-16 Thread Michael Winston
At 2:06 PM -0500 10/16/2003, Dan Nelson wrote: In the last episode (Oct 16), Michael Winston said: Is there any way to do "natural sorting" in MySQL? That is: Chapter 1 Chapter 2 Chapter 10 instead of Chapter 1 Chapter 10 Chapter 2 If not, are there any plans for this feature

natural sorting

2003-10-16 Thread Michael Winston
Is there any way to do "natural sorting" in MySQL? That is: Chapter 1 Chapter 2 Chapter 10 instead of Chapter 1 Chapter 10 Chapter 2 ? If not, are there any plans for this feature in future releases? Would be pretty helpful... Michael -- MySQL General Mailing List For list archives: http://li

deleting semi-duplicate records

2003-10-08 Thread Michael Winston
Let's say I have the following table (t1): ++--++ | id | c1 | c2 | ++--++ | 1 | NULL | 1 | | 2 | a| 1 | | 3 | NULL | 2 | | 4 | b| 2 | | 5 | NULL | 3 | | 6 | c| 3 | | 7 | NULL | 4 | ++--++ I would like to delete all rows that c1 = NULL

newbie needs help: can I "order by" before "grouping"?

2003-08-07 Thread Michael Winston
I'm having trouble ordering my results before grouping them. I don't want to go into too much detail, so my simplified query without any grouping or ordering results in: ++---++ | jobnum | milestone | shipdate | ++---++ | 96-655 |