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
Hi.
One client from my shared hosting periodically informs me about an
error:
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 ...
There's nothing suspicious in the MySQL
02-12-01') and (rsdat <= '2002-12-23')
> > AND (match(ecotxt.rstxt) against('JAVA' IN BOOLEAN
MODE))
> > ORDER BY ecoras.rspst, ecoras.rstda, ecotes.rstes, ecoras.rstpg,
> > ecoras.rsart
> >
> >
> > In this query the wher
Geschäftsführer / CEO iConnect GmbH <http://iConnect.de>
Heesestr. 6, 12169 Berlin (Germany)
Tel: +49 30 7970948-0 Fax: +49 30 7970948-3
- Original Message -
From: "Luca Burlizzi" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Saturday, January 04, 2003 5:35
hello,
I have a problem in mysql 4.0.7
this piece of code worked until version 4.0.4
SELECT @ID:='';
SELECT @ID:=CONCAT(@ID,',',MAX(ID)) FROM WF_Users GROUP BY GUID;
SELECT @ID;
the result was: ",1,2,.,n".
but today doesn't works anymore
now the result is ".n" where n is the last max(id) va
es, ecoras.rstpg,
> ecoras.rsart
>
>
> In this query the where-clause matches the primary key (index) of ecoras
> table:
>
>
> ecoras.rsnum = 0
> AND ecoras.rsori = ecotxt.rsori
> AND ecoras.rscod = ecotxt.rscod
>
>
> If I do not use an index, I will obtain
x27;)
AND (match(ecotxt.rstxt) against('JAVA' IN BOOLEAN MODE))
ORDER BY ecoras.rspst, ecoras.rstda, ecotes.rstes, ecoras.rstpg,
ecoras.rsart
In this query the where-clause matches the primary key (index) of ecoras
table:
ecoras.rsnum = 0
AND ecoras.rsor
x27;)
AND (match(ecotxt.rstxt) against('JAVA' IN BOOLEAN MODE))
ORDER BY ecoras.rspst, ecoras.rstda, ecotes.rstes, ecoras.rstpg,
ecoras.rsart
In this query the where-clause matches the primary key (index) of ecoras
table:
ecoras.rsnum = 0
AND ecoras.rsor
* 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), '
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), 'M', SECOND(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 implemente
* 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
Hi,
This morning is posted a message :
---
I have a question about a query. We have a guestbook and I want to do some
statistics for the messages in it. So I've created a query that looks like
this.
select hour(msg_date_time), count(*)
from messages
where user_id = 'almar'
group by hour(msg_
* 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
Hi,
This morning is posted a message :
---
I have a question about a query. We have a guestbook and I want to do some
statistics for the messages in it. So I've created a query that looks like
this.
select hour(msg_date_time), count(*)
from messages
where user_id = 'almar'
group by hour(msg_
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
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 on that? This happens with SuSE li
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
I have been using MySQL for ecommerce work for quite some time. One
problem that just recently arose was a duplicate key error during db
restoration. The culprit lies in a table which has an
auto_incremented, not null defined integer field called "id". There
is an entry which was adjusted,
33 matches
Mail list logo