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

[8.0] show global status;
Variable_name,Value
Aborted_clients,0
Aborted_connects,0
Acl_cache_items_count,0
Binlog_cache_disk_use,0
Binlog_cache_use,0
Binlog_stmt_cache_disk_use,0
Binlog_stmt_cache_use,0
Bytes_received,1991
Bytes_sent,39260
Caching_sha2_password_rsa_public_key,*** masked ***
Com_admin_commands,6
Com_assign_to_keycache,0
Com_alter_db,0
Com_alter_event,0
Com_alter_function,0
Com_alter_instance,0
Com_alter_procedure,0
Com_alter_resource_group,0
Com_alter_server,0
Com_alter_table,0
Com_alter_tablespace,0
Com_alter_user,0
Com_alter_user_default_role,0
Com_analyze,0
Com_begin,0
Com_binlog,0
Com_call_procedure,0
Com_change_db,1
Com_change_master,0
Com_change_repl_filter,0
Com_change_replication_source,0
Com_check,0
Com_checksum,0
Com_clone,0
Com_commit,0
Com_create_db,1
Com_create_event,0
Com_create_function,0
Com_create_index,0
Com_create_procedure,0
Com_create_role,0
Com_create_server,0
Com_create_table,35
Com_create_resource_group,0
Com_create_trigger,0
Com_create_udf,0
Com_create_user,0
Com_create_view,0
Com_create_spatial_reference_system,0
Com_dealloc_sql,0
Com_delete,0
Com_delete_multi,0
Com_do,0
Com_drop_db,0
Com_drop_event,0
Com_drop_function,0
Com_drop_index,0
Com_drop_procedure,0
Com_drop_resource_group,0
Com_drop_role,0
Com_drop_server,0
Com_drop_spatial_reference_system,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,1
Com_get_diagnostics,0
Com_grant,0
Com_grant_roles,0
Com_ha_close,0
Com_ha_open,0
Com_ha_read,0
Com_help,0
Com_import,0
Com_insert,0
Com_insert_select,0
Com_install_component,0
Com_install_plugin,0
Com_kill,0
Com_load,0
Com_lock_instance,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_restart,0
Com_revoke,0
Com_revoke_all,0
Com_revoke_roles,0
Com_rollback,0
Com_rollback_to_savepoint,0
Com_savepoint,0
Com_select,6
Com_set_option,5
Com_set_password,0
Com_set_resource_group,0
Com_set_role,0
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_replicas,0
Com_show_slave_hosts,0
Com_show_replica_status,0
Com_show_slave_status,0
Com_show_status,3
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_replica_start,0
Com_slave_start,0
Com_replica_stop,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_component,0
Com_uninstall_plugin,0
Com_unlock_instance,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,9
Created_tmp_disk_tables,0
Created_tmp_files,5
Created_tmp_tables,8
Current_tls_ca,*** masked ***
Current_tls_capath,
Current_tls_cert,*** masked ***
Current_tls_cipher,
Current_tls_ciphersuites,
Current_tls_crl,
Current_tls_crlpath,
Current_tls_key,*** masked ***
Current_tls_version,"TLSv1.2,TLSv1.3"
Delayed_errors,0
Delayed_insert_threads,0
Delayed_writes,0
Error_log_buffered_bytes,136136
Error_log_buffered_events,763
Error_log_expired_events,0
Error_log_latest_write,1660641696643442
Flush_commands,3
Global_connection_memory,0
Handler_commit,2687
Handler_delete,8
Handler_discover,0
Handler_external_lock,11109
Handler_mrr_init,0
Handler_prepare,0
Handler_read_first,46
Handler_read_key,4111
Handler_read_last,0
Handler_read_next,5883
Handler_read_prev,0
Handler_read_rnd,0
Handler_read_rnd_next,4194
Handler_rollback,1
Handler_savepoint,0
Handler_savepoint_rollback,0
Handler_update,332
Handler_write,1832
Innodb_buffer_pool_dump_status,Dumping of buffer pool not started
Innodb_buffer_pool_load_status,Buffer pool(s) load completed at 220816 9:21:36
Innodb_buffer_pool_resize_status,
Innodb_buffer_pool_pages_data,2104
Innodb_buffer_pool_bytes_data,34471936
Innodb_buffer_pool_pages_dirty,0
Innodb_buffer_pool_bytes_dirty,0
Innodb_buffer_pool_pages_flushed,527
Innodb_buffer_pool_pages_free,391071
Innodb_buffer_pool_pages_misc,41
Innodb_buffer_pool_pages_total,393216
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,32717
Innodb_buffer_pool_reads,1954
Innodb_buffer_pool_wait_free,0
Innodb_buffer_pool_write_requests,5362
Innodb_data_fsyncs,843
Innodb_data_pending_fsyncs,0
Innodb_data_pending_reads,0
Innodb_data_pending_writes,0
Innodb_data_read,32066560
Innodb_data_reads,1975
Innodb_data_writes,1643
Innodb_data_written,9480704
Innodb_dblwr_pages_written,386
Innodb_dblwr_writes,43
Innodb_redo_log_read_only,OFF
Innodb_redo_log_uuid,1075899837
Innodb_redo_log_checkpoint_lsn,366533147299
Innodb_redo_log_current_lsn,366533147299
Innodb_redo_log_flushed_to_disk_lsn,366533147299
Innodb_redo_log_logical_size,512
Innodb_redo_log_physical_size,201326592
Innodb_redo_log_capacity_resized,6442450944
Innodb_redo_log_resize_status,OK
Innodb_log_waits,0
Innodb_log_write_requests,3574
Innodb_log_writes,1046
Innodb_os_log_fsyncs,696
Innodb_os_log_pending_fsyncs,0
Innodb_os_log_pending_writes,0
Innodb_os_log_written,653312
Innodb_page_size,16384
Innodb_pages_created,151
Innodb_pages_read,1953
Innodb_pages_written,527
Innodb_redo_log_enabled,ON
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,0
Innodb_rows_read,0
Innodb_rows_updated,0
Innodb_system_rows_deleted,8
Innodb_system_rows_inserted,682
Innodb_system_rows_read,7984
Innodb_system_rows_updated,332
Innodb_sampled_pages_read,0
Innodb_sampled_pages_skipped,0
Innodb_num_open_files,15
Innodb_truncated_status_writes,0
Innodb_undo_tablespaces_total,2
Innodb_undo_tablespaces_implicit,2
Innodb_undo_tablespaces_explicit,0
Innodb_undo_tablespaces_active,2
Key_blocks_not_flushed,0
Key_blocks_unused,6698
Key_blocks_used,0
Key_read_requests,0
Key_reads,0
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,2
Max_used_connections_time,2022-08-25 07:17:11
Mysqlx_aborted_clients,0
Mysqlx_address,::
Mysqlx_bytes_received,0
Mysqlx_bytes_received_compressed_payload,0
Mysqlx_bytes_received_uncompressed_frame,0
Mysqlx_bytes_sent,0
Mysqlx_bytes_sent_compressed_payload,0
Mysqlx_bytes_sent_uncompressed_frame,0
Mysqlx_compression_algorithm,
Mysqlx_compression_level,
Mysqlx_connection_accept_errors,0
Mysqlx_connection_errors,0
Mysqlx_connections_accepted,0
Mysqlx_connections_closed,0
Mysqlx_connections_rejected,0
Mysqlx_crud_create_view,0
Mysqlx_crud_delete,0
Mysqlx_crud_drop_view,0
Mysqlx_crud_find,0
Mysqlx_crud_insert,0
Mysqlx_crud_modify_view,0
Mysqlx_crud_update,0
Mysqlx_cursor_close,0
Mysqlx_cursor_fetch,0
Mysqlx_cursor_open,0
Mysqlx_errors_sent,0
Mysqlx_errors_unknown_message_type,0
Mysqlx_expect_close,0
Mysqlx_expect_open,0
Mysqlx_init_error,0
Mysqlx_messages_sent,0
Mysqlx_notice_global_sent,0
Mysqlx_notice_other_sent,0
Mysqlx_notice_warning_sent,0
Mysqlx_notified_by_group_replication,0
Mysqlx_port,33060
Mysqlx_prep_deallocate,0
Mysqlx_prep_execute,0
Mysqlx_prep_prepare,0
Mysqlx_rows_sent,0
Mysqlx_sessions,0
Mysqlx_sessions_accepted,0
Mysqlx_sessions_closed,0
Mysqlx_sessions_fatal_error,0
Mysqlx_sessions_killed,0
Mysqlx_sessions_rejected,0
Mysqlx_socket,/tmp/mysqlx.sock
Mysqlx_ssl_accepts,0
Mysqlx_ssl_active,
Mysqlx_ssl_cipher,
Mysqlx_ssl_cipher_list,
Mysqlx_ssl_ctx_verify_depth,0
Mysqlx_ssl_ctx_verify_mode,0
Mysqlx_ssl_finished_accepts,0
Mysqlx_ssl_server_not_after,
Mysqlx_ssl_server_not_before,
Mysqlx_ssl_verify_depth,
Mysqlx_ssl_verify_mode,
Mysqlx_ssl_version,
Mysqlx_stmt_create_collection,0
Mysqlx_stmt_create_collection_index,0
Mysqlx_stmt_disable_notices,0
Mysqlx_stmt_drop_collection,0
Mysqlx_stmt_drop_collection_index,0
Mysqlx_stmt_enable_notices,0
Mysqlx_stmt_ensure_collection,0
Mysqlx_stmt_execute_mysqlx,0
Mysqlx_stmt_execute_sql,0
Mysqlx_stmt_execute_xplugin,0
Mysqlx_stmt_get_collection_options,0
Mysqlx_stmt_kill_client,0
Mysqlx_stmt_list_clients,0
Mysqlx_stmt_list_notices,0
Mysqlx_stmt_list_objects,0
Mysqlx_stmt_modify_collection_options,0
Mysqlx_stmt_ping,0
Mysqlx_worker_threads,2
Mysqlx_worker_threads_active,0
Not_flushed_delayed_rows,0
Ongoing_anonymous_transaction_count,0
Open_files,9
Open_streams,0
Open_table_definitions,62
Open_tables,93
Opened_files,9
Opened_table_definitions,100
Opened_tables,174
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_longest_seen,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
Queries,19
Questions,12
Replica_open_temp_tables,0
Rsa_public_key,*** masked ***
Secondary_engine_execution_count,0
Select_full_join,2
Select_full_range_join,0
Select_range,0
Select_range_check,0
Select_scan,13
Slave_open_temp_tables,0
Slow_launch_threads,0
Slow_queries,0
Sort_merge_passes,0
Sort_range,0
Sort_rows,690
Sort_scan,4
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_timeout,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,8
Table_locks_waited,0
Table_open_cache_hits,5385
Table_open_cache_misses,174
Table_open_cache_overflows,0
Tc_log_max_pages_used,0
Tc_log_page_size,0
Tc_log_page_waits,0
Threads_cached,0
Threads_connected,2
Threads_created,2
Threads_running,2
Tls_library_version,OpenSSL 1.1.1f 31 Mar 2020
Uptime,770148
Uptime_since_flush_status,770148

Options: ReplyQuote


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


Sorry, you can't reply to this topic. It has been closed.

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.