Check your memory usage according to
> -----Original Message-----
> From: Andrés Tello [mailto:mr.criptos@stripped]
> Sent: Monday, April 23, 2012 9:00 AM
> To: Malka Cymbalista
> Cc: mysql@stripped; Shlomit Afgin; Ronen Hayun
> Subject: Re: problems with INNODB tables
> Weird, I use a lot Innodb, and no issue, I even kill bravely the mysql
> process with pkill -9 -f mysql
> Y suppose the way drupal is being programed.
> PHP open and closes database connections each time a webpage with db
> access is issued.
> When a php exceution ends and the apache webserver have fullfilled the
> http request, again, php memory is freed and connections closed...
> UNLESS:.. you are using a mem cached db connection, wich I doubt it
> since drupal doens't requiere one, or using persistent connections,
> again, I doubt it, because persistante database connections aren't
> recommended to innodb tables...
> Mysql server by default can handles 100 conections, if you get to thata
> limit you need to fine tune the number of connections allowed.
> show full processlist can give you a better idea of what is going on,
> connections with the sleep status, are open connections with no
> currently no transacctions...
> I never use script based stop, I always use mysqladmin -u root -p -h
> localhost shutdown which properly tells mysql to flush tables and
> I can almost bet that you are using Ubuntu... ubuntu had given me
> sometimes very hard times because of the "edgy " code they use to use,
> ext4 last version, and so on... what can you tell us about that?
> How much amount of memory you have?
> How much concurrent apache/php users you have?
> Can you provide more cuantitive data please? Hardware, php version,
> distro, kernel...
> To start, 100 process is quite a lot, something isn't fine. Each time
> On Mon, Apr 23, 2012 at 9:10 AM, Malka Cymbalista <
> malki.cymbalista@stripped> wrote:
> > We are running MySQL version 5.0.45 on a Linux machine. Over the past
> > few months we have been having several problems:
> > 1. Our mysql processes have increased the memory used from
> about .3%
> > per process to 8% per process
> > 2. We sometimes can have over 100 processes running which
> brings the
> > machine to its knees and we have to stop and start MySQL in order to
> > kill all the processes. We think that maybe the processes are not
> > finishing normally and are just hanging around.
> > 3. The machine is a web server and in the last few months we
> > moving over to drupal 7 to build our sites and Drupal 7 requires
> > tables. Sometimes, when we restart MySQL using the commands
> > /etc/init.d/mysql stop and /etc/init.d/mysql start our sites that
> > built in drupal 7 do not come up. In order for the INNODB tables to
> > work, we have to stop mysql, rename the ibdata1 file, copy it back to
> > ibdata1 and then restart mysql. Otherwise the INNODB tables are not
> > In the past all our tables were MYIASM. Our problems started as we
> > started using more and more INNODB tables. Is there anything special
> > that has to be done to configure MySQL when using INNODB tables?
> > We clearly have a problem but we have no idea where to start
> looking. Our
> > error logs don't show anything. If anyone has any suggestions, we
> will be
> > happy to hear them.
> > We are considering hiring a consultant who is an expert in MySQL. We
> > are in Israel and we are open to suggestions.
> > Thanks for any help.
> > Malki Cymbalista
> > Webmaster, Weizmann Institute of Science
> > >
> > 08-9343036