List:General Discussion« Previous MessageNext Message »
From:Rick James Date:October 8 2012 9:35pm
Subject:RE: mysql 5.5.24/27 massive slow down since upgrade to solaris 10
u9 with 147440-19
View as plain text  
Are you I/O bound?

XFS

What "elevator" strategy?

Compare settings.
Especially innodb_flush_log_at_trx_commit .

> -----Original Message-----
> From: Gael Martinez [mailto:gael.martinez@stripped]
> Sent: Sunday, October 07, 2012 5:46 PM
> To: mysql
> Subject: mysql 5.5.24/27 massive slow down since upgrade to solaris 10
> u9 with 147440-19
> 
> Hello
> 
> For nearly 3 years, we have had a master - slaves configuration working
> like a charm, the slaves would be able to sync daily ... since a recent
> upgrade from Solaris10u6 to solaris 10 u9 with the latest CPU bundle
> (kernel patch 147440-19) on one of the two slaves, the slave upgrade
> cannot keep up anymore... it is now at over 2 days behind in
> replication and the delay increases... the volume of data did not
> increase and the second slave seems in good shape (still on u6). No
> configuration change was done to the mysql configuration itself... Is
> there a well know issue/parameter to configure with the more recent
> versions of solaris ? The storage is on an Hitachi  san storage with
> 4Gig HBAs and the volume of data to replicate is about 6-8 1G binary
> log files a day... Another change is that the new machine global zone
> is using zfs for the boot disks, but the database zone itself including
> the data directory is sitting on ufs filesystems...
> Regards
> 
> --
> Gaël Martinez
Thread
mysql 5.5.24/27 massive slow down since upgrade to solaris 10 u9 with 147440-19Gael Martinez8 Oct
  • RE: mysql 5.5.24/27 massive slow down since upgrade to solaris 10u9 with 147440-19Rick James8 Oct