List:General Discussion« Previous MessageNext Message »
From:Andrés Tello Date:April 23 2012 3:59pm
Subject:Re: problems with INNODB tables
View as plain text  
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 terminate.

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,


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 are
> moving over to drupal 7 to build our sites and Drupal 7 requires INNODB
> tables.   Sometimes, when we restart MySQL using the commands
> /etc/init.d/mysql stop and /etc/init.d/mysql start our sites that were
> 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 accessable.
> 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
> Malki.cymbalista@stripped<mailto:Malki.cymbalista@stripped>
> 08-9343036

problems with INNODB tablesMalka Cymbalista23 Apr
  • Re: problems with INNODB tablesAndrés Tello23 Apr
    • RE: problems with INNODB tablesRick James23 Apr
      • RE: problems with INNODB tablesMalka Cymbalista25 Apr
        • Re: problems with INNODB tablesAndrés Tello25 Apr
        • RE: problems with INNODB tablesRick James2 May