On Mon, Nov 10, 2008 at 08:23:24PM +0300, Alexey Vlasov wrote:
> DBI connect('database,...)
> failed: Can't create a new thread (errno 12); if you are not out of
> available memory, you can consult the manual for a possible OS-dependent
> bug at ...
I just thought, all this can be a result of du
On Mon, Nov 10, 2008 at 06:36:34PM +0100, Uwe Kiewel wrote:
> Alexey Vlasov schrieb:
>> open files (-n) 1024
>
> just a shot to the blue:
>
> can you count your open files with lsof?
# lsof -u mysql | wc -l
1719
I doubt that the problem is in that otherwise every second use
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
John Daisley schrieb:
> Hit 'Reply to All' instead of reply.
>
Is is okay for you the have your answers twice? If I post to a list, I
read that list. So there is no need to have the ansers at the list and
in my inbox
Uwe
-BEGIN PGP SIGNATURE
not to the list :-(
>
> - Original-Nachricht --------
> Betreff: Re: Is it a bug or my mistake in server configuration?
> Datum: Mon, 10 Nov 2008 18:36:34 +0100
> Von: Uwe Kiewel <[EMAIL PROTECTED]>
> An: Alexey Vlasov <[EMAIL PROTECTED]>
> Referenzen: <[EMAIL PRO
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Andy Shellam schrieb:
>
>> This mailing list has a stupid configuration. Pressing the answer
>> button, the message goes to the sender not to the list :-(
>>
>
> Hint - use Reply to All - it's not specific to this mailing list. :-)
>
It dosn't m
he sender not to the list :-(
>
> - Original-Nachricht ----
> Betreff: Re: Is it a bug or my mistake in server configuration?
> Datum: Mon, 10 Nov 2008 18:36:34 +0100
> Von: Uwe Kiewel <[EMAIL PROTECTED]>
> An: Alexey Vlasov <[EMAIL PROTECTED]>
> Referenzen: <
This mailing list has a stupid configuration. Pressing the answer
button, the message goes to the sender not to the list :-(
Hint - use Reply to All - it's not specific to this mailing list. :-)
Regards,
Andy
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Curtis Maurand schrieb:
>
> I've been having the same trouble in a Xen virtual machine. After about
> an hour and a half, mysql will be consuming 100% of cpu. There is
> nothing wrong with the tables. I'm assuming its a dynamic vs. fix
> amount of
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
This mailing list has a stupid configuration. Pressing the answer
button, the message goes to the sender not to the list :-(
- Original-Nachricht
Betreff: Re: Is it a bug or my mistake in server configuration?
Datum: Mon, 10 Nov
I've been having the same trouble in a Xen virtual machine. After about
an hour and a half, mysql will be consuming 100% of cpu. There is
nothing wrong with the tables. I'm assuming its a dynamic vs. fix
amount of memory available to mysql. I'm guaranteed x amount of ram,
but that might g
> On Tuesday 31 December 2002 10:21, Walter Procopio wrote:
>
> > I have installed mysql max 4.0.4 beta on a Suse (ver. 8.0) linux server
and
> > I have created a database with this schema:
>
> [skip]
>
> >
> > And I try to execute this query:
> >
> >
> > SELECTecoras.rstda, ecotes.rstes, ecora
Luca,
> the result was: ",1,2,.,n".
> but today doesn't works anymore
> now the result is ".n" where n is the last max(id) value in the result
set.
I did a similar query on this table;
mysql> DESCRIBE gehalt;
+---+--+--+-+-+---+
| Field | Type
On Tuesday 31 December 2002 10:21, Walter Procopio wrote:
> I have installed mysql max 4.0.4 beta on a Suse (ver. 8.0) linux server and
> I have created a database with this schema:
[skip]
>
> And I try to execute this query:
>
>
> SELECTecoras.rstda, ecotes.rstes, ecoras.rsart, ecoras.rsimm
* Son Nguyen
> mysql> select date_created from forums;
> +-+
> | date_created|
> +-+
> | 2002-04-04 19:27:03 |
> +-+
> 1 row in set (0.00 sec)
>
> mysql> SELECT CONCAT(HOUR(now()-date_created), 'H',
> MINUTE(now()-date_created), '
Join it to a table that has all the hours and to the query with an outer
join.
- Original Message -
From: "Almar van Pel" <[EMAIL PROTECTED]>
To: "Mysql" <[EMAIL PROTECTED]>
Sent: Saturday, February 09, 2002 11:00 AM
Subject: Is it a bug / not implemented /me ?
> Hi,
>
> This morning is
* Almar van Pel
> mysql> select uren.uur,
> -> count(messages.msg_date_time)
> -> from uren left join messages
> -> on hour(messages.msg_date_time) = uren.uur where messages.user_id =
> 'almar' group by uren.uur
> -> ;
I'm not sure it will solve your problem, but try this:
selec
* Almar van Pel
> mysql> select uren.uur,
> -> count(messages.msg_date_time)
> -> from uren left join messages
> -> on hour(messages.msg_date_time) = uren.uur where messages.user_id =
> 'almar' group by uren.uur
> -> ;
I'm not sure it will solve your problem, but try this:
selec
al Message -
From: "Rick Emery" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, March 26, 2001 12:20 PM
Subject: RE: RTFM (was: *sigh* Re: Is it a bug? )
> This list should be open to ALL questions, newbie and non-newbie. If we
> start filtering, or slammi
, Chris M. [mailto:[EMAIL PROTECTED]]
Sent: Monday, March 26, 2001 11:53 AM
To: Cal Evans; [EMAIL PROTECTED]
Subject: RE: RTFM (was: *sigh* Re: Is it a bug? )
Cal,
>>
>> I would love to see this list split into 2 lists. MySQL-Newbies and
>> MySQL-non-newbies. Non-newbies
Cal,
>>
>> I would love to see this list split into 2 lists. MySQL-Newbies and
>> MySQL-non-newbies. Non-newbies would be either an invitation-only list or
>> you have to pass a test to get in. (The test would contain questions that
>> are all in the manual, we don't care if you know, we care if
t: Friday, March 23, 2001 12:42 PM
To: [EMAIL PROTECTED]
Subject: *sigh* Re: Is it a bug?
This may well be a point which has been raised in the past, but has
there ever been any talk of splitting this list into a
"mysql-for-dummies" and a "mysql-for-people-who-read-the-manual"
Malek Fawaz wrote:
>
> Hello,
>
> when I install the MySQL RPM package (the newest on you site) as root, I am
> able to connect to the server through mysql.sock... but when I reboot the
> system the mysql.sock seems to be gone, and therefor I can not connect to
> the server. Do you have reports
This may well be a point which has been raised in the past, but has
there ever been any talk of splitting this list into a
"mysql-for-dummies" and a "mysql-for-people-who-read-the-manual" list
? I'm getting close to unsubscribing due to the enormously large noise
ratio - to be frank, questions suc
Hi.
'0' (i.e. Zero) has a special meaning for AUTO_INCREMENT, namely the
same as NULL, which will choose a automatically a new value for the
column. (Btw, are you sure, that you get the error for the row which
was '0' and not for the one which was '72' - the latter sounds more
probably to me).
B
24 matches
Mail list logo