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_connect_errors
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) -
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
error coming up
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 error (os x)
Hi-
We've been running
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:
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 in future
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 =
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 |
