MySQL Forums
Forum List  »  Performance

"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




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.