Uploaded image for project: 'Percona Server'
  1. Percona Server
  2. PS-3701

LP #1690399: InnoDB performance drop in 5.7 because of the lru_manager

    XMLWordPrintable

    Details

      Description

      **Reported in Launchpad by jocelyn fournier last update 29-07-2017 04:17:31

      Hi,

      I'm investigating a performance regression in InnoDB between 5.6 & 5.7.
      I noticed a lot of time is spent in os_thread_sleep called from buf_lru_manager_sleep_if_needed().
      Is there any way to avoid this (my configuration is using innodb_buffer_pool_instances=24, so I assume it creates 24 lru_manager as well ?)

      Poor's man profiler result :
      89 pthread_cond_wait@@GLIBC_2.3.2,native_cond_wait,cond=0x1f74bc0),mutex=<optimized,out>,,at,handle_connection,pfs_spawn_thread,start_thread,clone,??
      24 nanosleep,os_thread_sleep,buf_lru_manager_sleep_if_needed,out>),start_thread,clone,??
      23 pthread_cond_wait@@GLIBC_2.3.2,wait,reset_sig_count=<optimized,srv_worker_thread,start_thread,clone,??
      23 pthread_cond_wait@@GLIBC_2.3.2,inline_mysql_cond_wait,pop_jobs_item,slave_worker_exec_job_group,handle_slave_worker,pfs_spawn_thread,start_thread,clone,??
      1 test_quick_select,mysql_update,Sql_cmd_update::try_single_table_update,Sql_cmd_update::execute,mysql_execute_command,mysql_parse,Query_log_event::do_apply_event,slave_worker_exec_job_group,handle_slave_worker,pfs_spawn_thread,start_thread,clone,??
      1 ,sigwaitinfo,timer_notify_thread_func,start_thread,clone,
      [...]

      Thanks!
      Jocelyn

        Smart Checklist

          Attachments

            Activity

              People

              • Assignee:
                Unassigned
                Reporter:
                lpjirasync lpjirasync (Inactive)
              • Votes:
                0 Vote for this issue
                Watchers:
                1 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: