I recompiled my sql with "nocona" instead of k8 and the problem persists.
Now, I found this:
http://bugs.mysql.com/bug.php?id=17329
which definitely sounds similar to my problems.
I'm gonna give a shot to disabling delayed_key_write.
On 6/6/07, Quentin Gouedard <[EMAIL
Hello,
So I have this somewhat busy mysql box (300qps - 1100 qps) holding a bunch
(20) of myISAM tables.
The Box is Core2Duo 2.4 / 4GB RAM / Gentoo64 / MySQL 5.0.38
There are a number of scripts accessing those tables, both located on the
same machine and on others.
Every day, 1 to 3 tables get c
tatic \
--enable-shared \
--enable-thread-safe-client \
--with-extra-charsets=none
Scott
On Wed, 2007-05-30 at 18:29 +0200, Quentin Gouedard wrote:
> Oh and by the way mysql works just fine on that machine. You can run
> queries without any problems.
> Only it keeps spawning new
e end. I'm
guessing this could have to do with the process owner being root.
Some similar problems are reported here though:
http://forums.gentoo.org//viewtopic-t-544730-highlight-mysql.html
On 5/30/07, Quentin Gouedard <[EMAIL PROTECTED]> wrote:
Merci Geoffroy,
starting from the
rigine-
De: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] De la part de Quentin
Gouedard
Envoyé: mercredi 30 mai 2007 09:02
À: Scott Tanner
Cc: mysql@lists.mysql.com
Objet: Re: mysql creating lots of processes (not threads, linux processes)
Nope, I'm using 5.0.38 on Gentoo, built via em
er?
Scott
On Tue, 2007-05-29 at 22:49 +0200, Quentin Gouedard wrote:
> No, I have just collectd+mrtg, but i don't even use them to monitor
mysql.
> I launch mysql via /etc/init.d/mysql start , and the script is the exact
> same as on the other servers. Even just after star
AIL PROTECTED]> wrote:
Hi,
It looks like automatic start-up called by a monitoring process (Nagios,
...). Have you such tools on your servers ?
Geoffroy
-Message d'origine-
De: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] De la part de Quentin
Gouedard
Envoyé: mardi 29 ma
Hi,
So I use mysql as the DB for a large site (up to 1 concurrent users at
peaks).
I have a front server as a reverse proxy and multiple (7) backend machines
serving the site.
Each machine has data strictly similar in nature and quantity.
On 6 of these machines, I have 1 single mysqld process
