MySQL Forums
Forum List  »  Performance

Re: MySQL 5.6 update doubled IOs
Posted by: Christian Meisinger
Date: March 26, 2013 08:29AM

The Disk IOs graph shows MySQL 5.5 and 5.6.
http://www.livingliquid.com/at/images/mysql/mysql56-data_root-week.png
Before 11 o'clock it's version 5.5, after 11 it's version 5.6.

Here is a monthly overview: Disk IOs monthly: http://www.livingliquid.com/at/images/mysql/mysql55_mysql56-data_root-month.png
Between week 10 and 11 i've update from 5.5 to 5.6.

Right now the VM has 4 CPUs, 12G RAM and ext4 for all partitions (/, mysql-data, mysql-logs).

Database size:
~ 30G MyISAM tables
~ 4G InnoDB tables

my.cnf: http://www.livingliquid.com/at/images/mysql/mysql56_my.cnf

More graphs:
- Bin/Relay log: http://www.livingliquid.com/at/images/mysql/mysql55_mysql56-bin_relay_log-month.png
- InnoDB buffer pool: http://www.livingliquid.com/at/images/mysql/mysql55_mysql56-innodb_bpool-month.png
- InnoDB IO pending: http://www.livingliquid.com/at/images/mysql/mysql55_mysql56-innodb_io_pend-month.png
- InnoDB IOs: http://www.livingliquid.com/at/images/mysql/mysql55_mysql56-innodb_io-month.png
- InnoDB log: http://www.livingliquid.com/at/images/mysql/mysql55_mysql56-innodb_log-month.png
- InnoDB row ops: http://www.livingliquid.com/at/images/mysql/mysql55_mysql56-innodb_rows-month.png
- Memory usage: http://www.livingliquid.com/at/images/mysql/mysql55_mysql56-memory-month.png
- Query types: http://www.livingliquid.com/at/images/mysql/mysql55_mysql56-queries-month.png


Our DEVs told me they altered 3 tables from MyISAM to InnoDB after the upgrade. About 1G in total.
I understand that InnoDB IOs increased but IOs for "MyISAM" should have decreased and ultimately total IOs should at least stay the same?

I tried to increase innodb_buffer_pool_size and innodb_log_buffer_size. No change.


About my "5.6 seems to be a little bit slower" statement: i was told 5.6 will be faster.
I think this is true on a bigger MySQL server with much more load and threads?
On smaller installations like ours it's slower. I've no graph here.
I logged a few statements from production servers and run them again comparing 5.5 with 5.6 on a dev-machine.
About -15% for version 5.6.


Thanks a lot for your feedback :)



Edited 1 time(s). Last edit at 03/26/2013 08:38AM by Christian Meisinger.

Options: ReplyQuote


Subject
Views
Written By
Posted
1254
March 20, 2013 08:52AM
Re: MySQL 5.6 update doubled IOs
1355
March 26, 2013 08:29AM
1160
March 27, 2013 11:44PM
1191
March 28, 2013 07:49PM
1115
April 02, 2013 12:20AM
1165
April 02, 2013 09:57PM
1138
April 10, 2013 08:31AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.