Alex,
did you change any my.cnf parameters? Version .39 should
actually be a littel bit faster than .38.
What does Unix 'top' say? What are the CPU usage %?
The biggest change performance-wise in .39 is that
you can now specify the parameter
innodb_unix_file_flush_method
in my.cnf.
You could try the following values for it:
innodb_unix_file_flush_method=O_DSYNC
or
innodb_unix_file_flush_method=littlesync
Does it work fast now?
Regards,
Heikki
-----Original Message-----
From: BAUMEISTER Alexandre <[EMAIL PROTECTED]>
To: Heikki Tuuri <[EMAIL PROTECTED]>
Cc: [EMAIL PROTECTED] <[EMAIL PROTECTED]>
Date: Monday, June 18, 2001 6:24 PM
Subject: 3.23.39+InnoDB = slower than 3.23.389InnoDB ?
>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 : [EMAIL PROTECTED] Fax: +333-83-36-69-44
>
>FINANCE NET - 1,rue St Dizier 54000 NANCY - FRANCE (www.finance-net.fr)
>-----------------------------------------------------------------------
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php