List:General Discussion« Previous MessageNext Message »
From:BAUMEISTER Alexandre Date:June 19 2001 7:24am
Subject:Re[2]: 3.23.39+InnoDB = slower than 3.23.389InnoDB ?
View as plain text  
Bonjour Heikki,

  In fact this morning Mysql is ... crashed on this server :(((((

  It never crashed with 3.23.38 :(

  I  don't  yet  know if this is really a 3.23.39 problem or something
  else.

  If  I'm  able to restart Mysql, I will downgrade to 3.23.38 in order
  to see if it's back to the normal. And then upgrade once more to .39
  ...

  But  I  have some difficulties to restart Mysql. Here is what I have
  from the logs :
======================================================================
010619 09:11:11  mysqld started
InnoDB: Database was not shut down normally.
InnoDB: Starting recovery from log files...
InnoDB: Starting log scan based on checkpoint at
InnoDB: log sequence number 17 879096443
InnoDB: 1 uncommitted transaction(s) which must be rolled back
InnoDB: Starting rollback of uncommitted transactions
InnoDB: Rolling back trx no 0
======================================================================

  It's like that since minutes now. And not telling anything else :(

  When   I  check  disk usage and CPU, they stay low so it seems Mysql
  is not working hard and limited by the system :
======================================================================
load averages:  1.00,  1.00,  0.77                            09:19:55
55 processes:  53 sleeping, 2 on cpu
CPU states: 74.9% idle, 25.0% user, 0.0% kernel, 0.0% iowait, 0.0% swap
Memory: 1024M real, 776M free, 362M swap in use, 1402M swap free

   PID USERNAME THR PRI NICE  SIZE   RES STATE    TIME    CPU COMMAND
 16666 root       3   0    0  342M   39M cpu/3    8:43 25.00% mysqld
 16784 root       1  50    0 2200K 1400K cpu/2    0:00  0.09% top
 ...
======================================================================

  If I try to log in Mysql, it's not telling me that there is no Mysql
  server, but it's not giving me the hand back:
======================================================================
   [9:21am]# mysql
   ... don't returns
======================================================================

  With  3.23.38  I started to think I could use Mysql with InnoDB in a
  production system, but I'm a little feared now :(

  Alex.

Thread
my sql and patter matching ....bug(Urgent)VVM Ravikumar Sarma Chengalvala18 Jun
  • 3.23.39+InnoDB = slower than 3.23.389InnoDB ?BAUMEISTER Alexandre18 Jun
Re: 3.23.39+InnoDB = slower than 3.23.389InnoDB ?Heikki Tuuri18 Jun
Re[2]: 3.23.39+InnoDB = slower than 3.23.389InnoDB ?BAUMEISTER Alexandre19 Jun
Re: 3.23.39+InnoDB = slower than 3.23.389InnoDB ?Heikki Tuuri19 Jun