MySQL Forums :: Performance :: "Sending Data" is taking time post migration from 5.1 to 5.6


Advanced Search

"Sending Data" is taking time post migration from 5.1 to 5.6
Posted by: Aldrin Davis ()
Date: March 10, 2017 02:41AM

We have a screen using MySQL 5.1 community version [ with MYISAM Storage Engine] hosted on a Solaris 10 OS. We had recently upgraded to MySQL 5.6 community version [ with Innodb Storage Engine] hosted on Solaris 10 OS. Migration was done directly from 5.1 to 5.6. But started seeing performance issue in Update statements on a temporary table. The Query profile shows maximum time spent on “Sending Data”

Settings in 5.6
innodb_file_per_table= ON
innodb_flush_method=O_DIRECT
innodb_log_file_size=512M
innodb_buffer_pool_size=16G
innodb_log_buffer_size=8M
innodb_flush_log_at_trx_commit=1
Innodb_thread_concurrency=8
innodb_additional_mem_pool_size=512M

In 5.1 the same query just takes 0.08sec.

My Queries
• Is it OK to have MySQL 5.6 on Solaris 10 OS? Are there any known problems in having this set up?
• Are there any known issues with Temporary Tables in MySQL 5.6?
• How can we identify what is causing the problem in Sending Data? Can we pull out any reports like AWR reports in Oracle to see if there are any IO waits?
• What is the recommended way to identify IO bottlenecks in MySQL 5.6 community version

Options: ReplyQuote


Subject Views Written By Posted
"Sending Data" is taking time post migration from 5.1 to 5.6 107 Aldrin Davis 03/10/2017 02:41AM
Re: "Sending Data" is taking time post migration from 5.1 to 5.6 38 Peter Brawley 03/10/2017 12:47PM
Re: "Sending Data" is taking time post migration from 5.1 to 5.6 34 SAIKIRAN CHEVITI 03/14/2017 06:40AM
Re: "Sending Data" is taking time post migration from 5.1 to 5.6 38 Peter Brawley 03/14/2017 09:42AM
Re: "Sending Data" is taking time post migration from 5.1 to 5.6 37 SAIKIRAN CHEVITI 03/15/2017 08:50AM
Re: "Sending Data" is taking time post migration from 5.1 to 5.6 39 Peter Brawley 03/15/2017 12:43PM
Re: "Sending Data" is taking time post migration from 5.1 to 5.6 23 SAIKIRAN CHEVITI 03/16/2017 02:32AM
Re: "Sending Data" is taking time post migration from 5.1 to 5.6 37 Peter Brawley 03/16/2017 05:52AM
Re: "Sending Data" is taking time post migration from 5.1 to 5.6 19 SAI KIRAN 03/17/2017 12:08AM


Sorry, only registered users may post in this forum.

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.