MySQL Forums
Forum List  »  Performance

Re: Bad performance on MySQL 8.0 compared to 5.7
Posted by: Raphael Yeung
Date: August 25, 2022 01:22AM

[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

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: Bad performance on MySQL 8.0 compared to 5.7
25
August 25, 2022 01:22AM


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.