List:General Discussion« Previous MessageNext Message »
From:BAUMEISTER Alexandre Date:June 18 2001 3:24pm
Subject:3.23.39+InnoDB = slower than 3.23.389InnoDB ?
View as plain text  
Bonjour,

  Environment: Solaris 2.8 on SPARC 64bit, Mysql-3.23.39+InnoDB.

  Mysql  3.23.38 with InnoDB support have been running for a while now
  on  one  of  my  servers  (for a month in fact, since the release of
  3.23.38).

  It  worked  perfectly well and was able to handle the job (intensive
  insert/update of a few tables. intensive = about 800 inserts/updates
  per second nearly all day long).

  Last  week-end  I  upgraded  to  3.23.39.  And  today Mysql seems to
  have some difficulties with the load :(

  Today I have symptoms like :
    *  Mysql  is  verly (VERY) long to answer queries like "mysqladmin
    stat" or "mysqladmin proc"
    * When I do a "mysqladmin proc" I can see that a few thread are in
    UPDATE  state  since about 20 or even more seconds. This has never
    been the case with 3.23.38 :(

  Any idea ? Any reason ?

  Regards,
  Alex.
-----------------------------------------------------------------------
Alexandre BAUMEISTER                        Standard : +333-83-36-58-67
Email : alex@stripped                Fax:       +333-83-36-69-44

FINANCE NET - 1,rue St Dizier 54000 NANCY - FRANCE (www.finance-net.fr)
-----------------------------------------------------------------------

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