Re: Bad performance on MySQL 8.0 compared to 5.7
[5.7] show global status;
Variable_name,Value
Aborted_clients,0
Aborted_connects,0
Binlog_cache_disk_use,0
Binlog_cache_use,0
Binlog_stmt_cache_disk_use,0
Binlog_stmt_cache_use,0
Bytes_received,120319439
Bytes_sent,127993245
Com_admin_commands,5
Com_assign_to_keycache,0
Com_alter_db,0
Com_alter_db_upgrade,0
Com_alter_event,0
Com_alter_function,0
Com_alter_instance,0
Com_alter_procedure,0
Com_alter_server,0
Com_alter_table,0
Com_alter_tablespace,0
Com_alter_user,0
Com_analyze,0
Com_begin,0
Com_binlog,0
Com_call_procedure,0
Com_change_db,10
Com_change_master,0
Com_change_repl_filter,0
Com_check,0
Com_checksum,0
Com_commit,0
Com_create_db,10
Com_create_event,0
Com_create_function,0
Com_create_index,0
Com_create_procedure,0
Com_create_server,0
Com_create_table,10
Com_create_trigger,0
Com_create_udf,0
Com_create_user,0
Com_create_view,0
Com_dealloc_sql,0
Com_delete,0
Com_delete_multi,0
Com_do,0
Com_drop_db,11
Com_drop_event,0
Com_drop_function,0
Com_drop_index,0
Com_drop_procedure,0
Com_drop_server,0
Com_drop_table,0
Com_drop_trigger,0
Com_drop_user,0
Com_drop_view,0
Com_empty_query,0
Com_execute_sql,0
Com_explain_other,0
Com_flush,0
Com_get_diagnostics,0
Com_grant,0
Com_ha_close,0
Com_ha_open,0
Com_ha_read,0
Com_help,0
Com_insert,555490
Com_insert_select,0
Com_install_plugin,0
Com_kill,0
Com_load,0
Com_lock_tables,0
Com_optimize,0
Com_preload_keys,0
Com_prepare_sql,0
Com_purge,0
Com_purge_before_date,0
Com_release_savepoint,0
Com_rename_table,0
Com_rename_user,0
Com_repair,0
Com_replace,0
Com_replace_select,0
Com_reset,0
Com_resignal,0
Com_revoke,0
Com_revoke_all,0
Com_rollback,0
Com_rollback_to_savepoint,0
Com_savepoint,0
Com_select,454516
Com_set_option,11
Com_signal,0
Com_show_binlog_events,0
Com_show_binlogs,0
Com_show_charsets,0
Com_show_collations,0
Com_show_create_db,0
Com_show_create_event,0
Com_show_create_func,0
Com_show_create_proc,0
Com_show_create_table,0
Com_show_create_trigger,0
Com_show_databases,1
Com_show_engine_logs,0
Com_show_engine_mutex,0
Com_show_engine_status,0
Com_show_events,0
Com_show_errors,0
Com_show_fields,0
Com_show_function_code,0
Com_show_function_status,0
Com_show_grants,0
Com_show_keys,0
Com_show_master_status,0
Com_show_open_tables,0
Com_show_plugins,0
Com_show_privileges,0
Com_show_procedure_code,0
Com_show_procedure_status,0
Com_show_processlist,0
Com_show_profile,0
Com_show_profiles,0
Com_show_relaylog_events,0
Com_show_slave_hosts,0
Com_show_slave_status,0
Com_show_status,2
Com_show_storage_engines,0
Com_show_table_status,0
Com_show_tables,0
Com_show_triggers,0
Com_show_variables,1
Com_show_warnings,0
Com_show_create_user,0
Com_shutdown,0
Com_slave_start,0
Com_slave_stop,0
Com_group_replication_start,0
Com_group_replication_stop,0
Com_stmt_execute,0
Com_stmt_close,0
Com_stmt_fetch,0
Com_stmt_prepare,0
Com_stmt_reset,0
Com_stmt_send_long_data,0
Com_truncate,0
Com_uninstall_plugin,0
Com_unlock_tables,0
Com_update,0
Com_update_multi,0
Com_xa_commit,0
Com_xa_end,0
Com_xa_prepare,0
Com_xa_recover,0
Com_xa_rollback,0
Com_xa_start,0
Com_stmt_reprepare,0
Connection_errors_accept,0
Connection_errors_internal,0
Connection_errors_max_connections,0
Connection_errors_peer_address,0
Connection_errors_select,0
Connection_errors_tcpwrap,0
Connections,505
Created_tmp_disk_tables,19
Created_tmp_files,6
Created_tmp_tables,241
Delayed_errors,0
Delayed_insert_threads,0
Delayed_writes,0
Flush_commands,1
Handler_commit,1010010
Handler_delete,0
Handler_discover,0
Handler_external_lock,2020315
Handler_mrr_init,0
Handler_prepare,0
Handler_read_first,24
Handler_read_key,454550
Handler_read_last,0
Handler_read_next,9993
Handler_read_prev,0
Handler_read_rnd,733
Handler_read_rnd_next,3173
Handler_rollback,0
Handler_savepoint,0
Handler_savepoint_rollback,0
Handler_update,0
Handler_write,557300
Innodb_buffer_pool_dump_status,Dumping of buffer pool not started
Innodb_buffer_pool_load_status,Buffer pool(s) load completed at 220816 9:01:15
Innodb_buffer_pool_resize_status,
Innodb_buffer_pool_pages_data,11605
Innodb_buffer_pool_bytes_data,190136320
Innodb_buffer_pool_pages_dirty,0
Innodb_buffer_pool_bytes_dirty,0
Innodb_buffer_pool_pages_flushed,568
Innodb_buffer_pool_pages_free,381547
Innodb_buffer_pool_pages_misc,16
Innodb_buffer_pool_pages_total,393168
Innodb_buffer_pool_read_ahead_rnd,0
Innodb_buffer_pool_read_ahead,0
Innodb_buffer_pool_read_ahead_evicted,0
Innodb_buffer_pool_read_requests,4089028
Innodb_buffer_pool_reads,2145
Innodb_buffer_pool_wait_free,0
Innodb_buffer_pool_write_requests,2401866
Innodb_data_fsyncs,985
Innodb_data_pending_fsyncs,0
Innodb_data_pending_reads,0
Innodb_data_pending_writes,0
Innodb_data_read,35213824
Innodb_data_reads,2800
Innodb_data_writes,1438
Innodb_data_written,202106880
Innodb_dblwr_pages_written,526
Innodb_dblwr_writes,121
Innodb_log_waits,0
Innodb_log_write_requests,426071
Innodb_log_writes,134
Innodb_os_log_fsyncs,150
Innodb_os_log_pending_fsyncs,0
Innodb_os_log_pending_writes,0
Innodb_os_log_written,184174592
Innodb_page_size,16384
Innodb_pages_created,9461
Innodb_pages_read,2144
Innodb_pages_written,568
Innodb_row_lock_current_waits,0
Innodb_row_lock_time,0
Innodb_row_lock_time_avg,0
Innodb_row_lock_time_max,0
Innodb_row_lock_waits,0
Innodb_rows_deleted,0
Innodb_rows_inserted,555488
Innodb_rows_read,464499
Innodb_rows_updated,0
Innodb_num_open_files,647
Innodb_truncated_status_writes,0
Innodb_available_undo_logs,128
Key_blocks_not_flushed,0
Key_blocks_unused,6696
Key_blocks_used,3
Key_read_requests,62
Key_reads,5
Key_write_requests,0
Key_writes,0
Locked_connects,0
Max_execution_time_exceeded,0
Max_execution_time_set,0
Max_execution_time_set_failed,0
Max_used_connections,51
Max_used_connections_time,2022-08-16 09:01:23
Not_flushed_delayed_rows,0
Ongoing_anonymous_transaction_count,0
Open_files,10
Open_streams,0
Open_table_definitions,857
Open_tables,66
Opened_files,1127
Opened_table_definitions,877
Opened_tables,1453
Performance_schema_accounts_lost,0
Performance_schema_cond_classes_lost,0
Performance_schema_cond_instances_lost,0
Performance_schema_digest_lost,0
Performance_schema_file_classes_lost,0
Performance_schema_file_handles_lost,0
Performance_schema_file_instances_lost,0
Performance_schema_hosts_lost,0
Performance_schema_index_stat_lost,0
Performance_schema_locker_lost,0
Performance_schema_memory_classes_lost,0
Performance_schema_metadata_lock_lost,0
Performance_schema_mutex_classes_lost,0
Performance_schema_mutex_instances_lost,0
Performance_schema_nested_statement_lost,0
Performance_schema_prepared_statements_lost,0
Performance_schema_program_lost,0
Performance_schema_rwlock_classes_lost,0
Performance_schema_rwlock_instances_lost,0
Performance_schema_session_connect_attrs_lost,0
Performance_schema_socket_classes_lost,0
Performance_schema_socket_instances_lost,0
Performance_schema_stage_classes_lost,0
Performance_schema_statement_classes_lost,0
Performance_schema_table_handles_lost,0
Performance_schema_table_instances_lost,0
Performance_schema_table_lock_stat_lost,0
Performance_schema_thread_classes_lost,0
Performance_schema_thread_instances_lost,0
Performance_schema_users_lost,0
Prepared_stmt_count,0
Qcache_free_blocks,1
Qcache_free_memory,1031832
Qcache_hits,0
Qcache_inserts,0
Qcache_lowmem_prunes,0
Qcache_not_cached,452037
Qcache_queries_in_cache,0
Qcache_total_blocks,1
Queries,1010571
Questions,1010563
Rsa_public_key,*** masked ***
Select_full_join,1
Select_full_range_join,0
Select_range,0
Select_range_check,0
Select_scan,23
Slave_open_temp_tables,0
Slow_launch_threads,0
Slow_queries,0
Sort_merge_passes,0
Sort_range,0
Sort_rows,733
Sort_scan,3
Ssl_accept_renegotiates,0
Ssl_accepts,0
Ssl_callback_cache_hits,0
Ssl_cipher,
Ssl_cipher_list,
Ssl_client_connects,0
Ssl_connect_renegotiates,0
Ssl_ctx_verify_depth,0
Ssl_ctx_verify_mode,0
Ssl_default_timeout,0
Ssl_finished_accepts,0
Ssl_finished_connects,0
Ssl_server_not_after,
Ssl_server_not_before,
Ssl_session_cache_hits,0
Ssl_session_cache_misses,0
Ssl_session_cache_mode,NONE
Ssl_session_cache_overflows,0
Ssl_session_cache_size,0
Ssl_session_cache_timeouts,0
Ssl_sessions_reused,0
Ssl_used_session_cache_entries,0
Ssl_verify_depth,0
Ssl_verify_mode,0
Ssl_version,
Table_locks_immediate,143
Table_locks_waited,0
Table_open_cache_hits,1009657
Table_open_cache_misses,1453
Table_open_cache_overflows,877
Tc_log_max_pages_used,0
Tc_log_page_size,0
Tc_log_page_waits,0
Threads_cached,10
Threads_connected,2
Threads_created,393
Threads_running,1
Uptime,771400
Uptime_since_flush_status,771400