Compare text

Find the difference between two text files

Real-time diff

Unified diff

Collapse lines

Highlight change

Syntax highlighting

Tools

Diffchecker Desktop The most secure way to run Diffchecker. Get the Diffchecker Desktop app: your diffs never leave your computer!Get Desktop

SHOW GLOBAL STATUS - left production, right development

Created 4 years agoDiff never expires

Lines
Total
Removed

Words
Total
Removed

To continue using this feature, upgrade to Diffchecker Pro View Pricing

228 lines

Lines
Total
Added

Words
Total
Added

To continue using this feature, upgrade to Diffchecker Pro View Pricing

MariaDB [phs_p]> SHOW GLOBAL STATUS;

MariaDB [phs]> SHOW GLOBAL STATUS;

+--------------------------------------------------------+--------------------------------------------------+

| Variable_name | Value |

+--------------------------------------------------------+--------------------------------------------------+

| Aborted_clients | 6 |

| Aborted_clients | 1 |

| Aborted_connects | 1 |

| Aborted_connects | 0 |

| Aborted_connects_preauth | 0 |

| Access_denied_errors | 1 |

| Access_denied_errors | 0 |

| Acl_column_grants | 0 |

| Acl_database_grants | 45 |

| Acl_database_grants | 0 |

| Acl_function_grants | 0 |

| Acl_procedure_grants | 0 |

| Acl_package_spec_grants | 0 |

| Acl_package_body_grants | 0 |

| Acl_proxy_users | 1 |

| Acl_proxy_users | 2 |

| Acl_role_grants | 0 |

| Acl_roles | 0 |

| Acl_table_grants | 3 |

| Acl_table_grants | 1 |

| Acl_users | 50 |

| Acl_users | 3 |

| Aria_pagecache_blocks_not_flushed | 0 |

| Aria_pagecache_blocks_unused | 15573 |

| Aria_pagecache_blocks_unused | 15637 |

| Aria_pagecache_blocks_used | 2087 |

| Aria_pagecache_blocks_used | 12 |

| Aria_pagecache_read_requests | 7626383 |

| Aria_pagecache_read_requests | 1391 |

| Aria_pagecache_reads | 206705 |

| Aria_pagecache_reads | 51 |

| Aria_pagecache_write_requests | 431744 |

| Aria_pagecache_write_requests | 78 |

| Aria_pagecache_writes | 431744 |

| Aria_pagecache_writes | 78 |

| Aria_transaction_log_syncs | 303 |

| Aria_transaction_log_syncs | 0 |

| Binlog_commits | 0 |

| Binlog_group_commits | 0 |

| Binlog_group_commit_trigger_count | 0 |

| Binlog_group_commit_trigger_lock_wait | 0 |

| Binlog_group_commit_trigger_timeout | 0 |

| Binlog_snapshot_file | |

| Binlog_snapshot_position | 0 |

| Binlog_bytes_written | 0 |

| Binlog_cache_disk_use | 0 |

| Binlog_cache_use | 0 |

| Binlog_stmt_cache_disk_use | 0 |

| Binlog_stmt_cache_use | 0 |

| Busy_time | 0.000000 |

| Bytes_received | 2133580365 |

| Bytes_received | 335567 |

| Bytes_sent | 142893269070 |

| Bytes_sent | 2411072 |

| Column_compressions | 0 |

| Column_decompressions | 0 |

| Com_admin_commands | 1 |

| Com_admin_commands | 0 |

| Com_alter_db | 0 |

| Com_alter_db_upgrade | 0 |

| Com_alter_event | 0 |

| Com_alter_function | 0 |

| Com_alter_procedure | 0 |

| Com_alter_server | 0 |

| Com_alter_sequence | 0 |

| Com_alter_table | 452 |

| Com_alter_table | 0 |

| Com_alter_tablespace | 0 |

| Com_alter_user | 0 |

| Com_analyze | 0 |

| Com_assign_to_keycache | 0 |

| Com_backup | 0 |

| Com_backup_lock | 0 |

| Com_begin | 1299234 |

| Com_begin | 535 |

| Com_binlog | 0 |

| Com_call_procedure | 0 |

| Com_change_db | 483611 |

| Com_change_db | 221 |

| Com_change_master | 0 |

| Com_check | 0 |

| Com_checksum | 0 |

| Com_commit | 1299026 |

| Com_commit | 535 |

| Com_compound_sql | 0 |

| Com_create_db | 0 |

| Com_create_event | 0 |

| Com_create_function | 0 |

| Com_create_index | 0 |

| Com_create_package | 0 |

| Com_create_package_body | 0 |

| Com_create_procedure | 0 |

| Com_create_role | 0 |

| Com_create_sequence | 0 |

| Com_create_server | 0 |

| Com_create_table | 0 |

| Com_create_temporary_table | 0 |

| Com_create_trigger | 0 |

| Com_create_udf | 0 |

| Com_create_user | 0 |

| Com_create_view | 0 |

| Com_dealloc_sql | 0 |

| Com_delete | 9208 |

| Com_delete | 1 |

| 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_package | 0 |

| Com_drop_package_body | 0 |

| Com_drop_role | 0 |

| Com_drop_server | 0 |

| Com_drop_sequence | 0 |

| Com_drop_table | 0 |

| Com_drop_temporary_table | 0 |

| Com_drop_trigger | 0 |

| Com_drop_user | 0 |

| Com_drop_view | 0 |

| Com_empty_query | 0 |

| Com_execute_immediate | 0 |

| Com_execute_sql | 0 |

| Com_flush | 0 |

| Com_get_diagnostics | 0 |

| Com_grant | 0 |

| Com_grant_role | 0 |

| Com_ha_close | 0 |

| Com_ha_open | 0 |

| Com_ha_read | 0 |

| Com_help | 0 |

| Com_insert | 44279 |

| Com_insert | 2 |

| Com_insert_select | 69 |

| Com_insert_select | 0 |

| Com_install_plugin | 0 |

| Com_kill | 0 |

| Com_load | 0 |

| Com_lock_tables | 0 |

| Com_multi | 0 |

| Com_optimize | 0 |

| Com_preload_keys | 0 |

| Com_prepare_sql | 0 |

| Com_purge | 0 |

| Com_purge_before_date | 0 |

| Com_release_savepoint | 183 |

| 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_revoke_role | 0 |

| Com_rollback | 25 |

| Com_rollback | 0 |

| Com_rollback_to_savepoint | 8003 |

| Com_rollback_to_savepoint | 0 |

| Com_savepoint | 37063 |

| Com_savepoint | 4 |

| Com_select | 9486355 |

| Com_select | 1327 |

| Com_set_option | 992073 |

| Com_set_option | 442 |

| Com_show_authors | 0 |

| Com_show_binlog_events | 0 |

| Com_show_binlogs | 0 |

| Com_show_charsets | 0 |

| Com_show_collations | 0 |

| Com_show_contributors | 0 |

| Com_show_create_db | 0 |

| Com_show_create_event | 0 |

| Com_show_create_func | 183 |

| Com_show_create_func | 0 |

| Com_show_create_package | 0 |

| Com_show_create_package_body | 0 |

| Com_show_create_proc | 0 |

| Com_show_create_table | 8003 |

| Com_show_create_table | 0 |

| Com_show_create_trigger | 0 |

| Com_show_create_user | 0 |

| Com_show_databases | 3 |

| Com_show_databases | 1 |

| Com_show_engine_logs | 0 |

| Com_show_engine_mutex | 0 |

| Com_show_engine_status | 7 |

| Com_show_engine_status | 0 |

| Com_show_errors | 0 |

| Com_show_events | 183 |

| Com_show_events | 0 |

| Com_show_explain | 0 |

| Com_show_fields | 8050 |

| Com_show_fields | 47 |

| Com_show_function_status | 183 |

| Com_show_function_status | 0 |

| Com_show_generic | 0 |

| Com_show_grants | 0 |

| Com_show_keys | 0 |

| Com_show_binlog_status | 0 |

| Com_show_open_tables | 0 |

| Com_show_package_status | 26 |

| Com_show_package_status | 0 |

| Com_show_package_body_status | 26 |

| Com_show_package_body_status | 0 |

| Com_show_plugins | 0 |

| Com_show_privileges | 0 |

| Com_show_procedure_status | 26 |

| 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 | 2 |

| Com_show_slave_status | 0 |

| Com_show_status | 5 |

| Com_show_status | 1 |

| Com_show_storage_engines | 1 |

| Com_show_storage_engines | 0 |

| Com_show_table_status | 51 |

| Com_show_table_status | 0 |

| Com_show_tables | 184 |

| Com_show_tables | 1 |

| Com_show_triggers | 0 |

| Com_show_variables | 3 |

| Com_show_variables | 0 |

| Com_show_warnings | 0 |

| Com_shutdown | 0 |

| Com_signal | 0 |

| Com_start_all_slaves | 0 |

| Com_start_slave | 0 |

| Com_stmt_close | 10507781 |

| Com_stmt_close | 1773 |

| Com_stmt_execute | 10507787 |

| Com_stmt_execute | 1773 |

| Com_stmt_fetch | 0 |

| Com_stmt_prepare | 10507787 |

| Com_stmt_prepare | 1773 |

| Com_stmt_reprepare | 1 |

| Com_stmt_reprepare | 0 |

| Com_stmt_reset | 0 |

| Com_stmt_send_long_data | 0 |

| Com_stop_all_slaves | 0 |

| Com_stop_slave | 0 |

| Com_truncate | 0 |

| Com_uninstall_plugin | 0 |

| Com_unlock_tables | 183 |

| Com_unlock_tables | 0 |

| Com_update | 61400 |

| Com_update | 2 |

| Com_update_multi | 23 |

| 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 |

| Compression | OFF |

| 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 | 476218 |

| Connections | 224 |

| Cpu_time | 0.000000 |

| Created_tmp_disk_tables | 208300 |

| Created_tmp_disk_tables | 39 |

| Created_tmp_files | 1333 |

| Created_tmp_files | 5 |

| Created_tmp_tables | 249989 |

| Created_tmp_tables | 46 |

| Delayed_errors | 0 |

| Delayed_insert_threads | 0 |

| Delayed_writes | 0

Saved diffs

Original text

Open file

MariaDB [phs_p]> SHOW GLOBAL STATUS;
+--------------------------------------------------------+--------------------------------------------------+
| Variable_name                                          | Value                                            |
+--------------------------------------------------------+--------------------------------------------------+
| Aborted_clients                                        | 6                                                |
| Aborted_connects                                       | 1                                                |
| Aborted_connects_preauth                               | 0                                                |
| Access_denied_errors                                   | 1                                                |
| Acl_column_grants                                      | 0                                                |
| Acl_database_grants                                    | 45                                               |
| Acl_function_grants                                    | 0                                                |
| Acl_procedure_grants                                   | 0                                                |
| Acl_package_spec_grants                                | 0                                                |
| Acl_package_body_grants                                | 0                                                |
| Acl_proxy_users                                        | 1                                                |
| Acl_role_grants                                        | 0                                                |
| Acl_roles                                              | 0                                                |
| Acl_table_grants                                       | 3                                                |
| Acl_users                                              | 50                                               |
| Aria_pagecache_blocks_not_flushed                      | 0                                                |
| Aria_pagecache_blocks_unused                           | 15573                                            |
| Aria_pagecache_blocks_used                             | 2087                                             |
| Aria_pagecache_read_requests                           | 7626383                                          |
| Aria_pagecache_reads                                   | 206705                                           |
| Aria_pagecache_write_requests                          | 431744                                           |
| Aria_pagecache_writes                                  | 431744                                           |
| Aria_transaction_log_syncs                             | 303                                              |
| Binlog_commits                                         | 0                                                |
| Binlog_group_commits                                   | 0                                                |
| Binlog_group_commit_trigger_count                      | 0                                                |
| Binlog_group_commit_trigger_lock_wait                  | 0                                                |
| Binlog_group_commit_trigger_timeout                    | 0                                                |
| Binlog_snapshot_file                                   |                                                  |
| Binlog_snapshot_position                               | 0                                                |
| Binlog_bytes_written                                   | 0                                                |
| Binlog_cache_disk_use                                  | 0                                                |
| Binlog_cache_use                                       | 0                                                |
| Binlog_stmt_cache_disk_use                             | 0                                                |
| Binlog_stmt_cache_use                                  | 0                                                |
| Busy_time                                              | 0.000000                                         |
| Bytes_received                                         | 2133580365                                       |
| Bytes_sent                                             | 142893269070                                     |
| Column_compressions                                    | 0                                                |
| Column_decompressions                                  | 0                                                |
| Com_admin_commands                                     | 1                                                |
| Com_alter_db                                           | 0                                                |
| Com_alter_db_upgrade                                   | 0                                                |
| Com_alter_event                                        | 0                                                |
| Com_alter_function                                     | 0                                                |
| Com_alter_procedure                                    | 0                                                |
| Com_alter_server                                       | 0                                                |
| Com_alter_sequence                                     | 0                                                |
| Com_alter_table                                        | 452                                              |
| Com_alter_tablespace                                   | 0                                                |
| Com_alter_user                                         | 0                                                |
| Com_analyze                                            | 0                                                |
| Com_assign_to_keycache                                 | 0                                                |
| Com_backup                                             | 0                                                |
| Com_backup_lock                                        | 0                                                |
| Com_begin                                              | 1299234                                          |
| Com_binlog                                             | 0                                                |
| Com_call_procedure                                     | 0                                                |
| Com_change_db                                          | 483611                                           |
| Com_change_master                                      | 0                                                |
| Com_check                                              | 0                                                |
| Com_checksum                                           | 0                                                |
| Com_commit                                             | 1299026                                          |
| Com_compound_sql                                       | 0                                                |
| Com_create_db                                          | 0                                                |
| Com_create_event                                       | 0                                                |
| Com_create_function                                    | 0                                                |
| Com_create_index                                       | 0                                                |
| Com_create_package                                     | 0                                                |
| Com_create_package_body                                | 0                                                |
| Com_create_procedure                                   | 0                                                |
| Com_create_role                                        | 0                                                |
| Com_create_sequence                                    | 0                                                |
| Com_create_server                                      | 0                                                |
| Com_create_table                                       | 0                                                |
| Com_create_temporary_table                             | 0                                                |
| Com_create_trigger                                     | 0                                                |
| Com_create_udf                                         | 0                                                |
| Com_create_user                                        | 0                                                |
| Com_create_view                                        | 0                                                |
| Com_dealloc_sql                                        | 0                                                |
| Com_delete                                             | 9208                                             |
| 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_package                                       | 0                                                |
| Com_drop_package_body                                  | 0                                                |
| Com_drop_role                                          | 0                                                |
| Com_drop_server                                        | 0                                                |
| Com_drop_sequence                                      | 0                                                |
| Com_drop_table                                         | 0                                                |
| Com_drop_temporary_table                               | 0                                                |
| Com_drop_trigger                                       | 0                                                |
| Com_drop_user                                          | 0                                                |
| Com_drop_view                                          | 0                                                |
| Com_empty_query                                        | 0                                                |
| Com_execute_immediate                                  | 0                                                |
| Com_execute_sql                                        | 0                                                |
| Com_flush                                              | 0                                                |
| Com_get_diagnostics                                    | 0                                                |
| Com_grant                                              | 0                                                |
| Com_grant_role                                         | 0                                                |
| Com_ha_close                                           | 0                                                |
| Com_ha_open                                            | 0                                                |
| Com_ha_read                                            | 0                                                |
| Com_help                                               | 0                                                |
| Com_insert                                             | 44279                                            |
| Com_insert_select                                      | 69                                               |
| Com_install_plugin                                     | 0                                                |
| Com_kill                                               | 0                                                |
| Com_load                                               | 0                                                |
| Com_lock_tables                                        | 0                                                |
| Com_multi                                              | 0                                                |
| Com_optimize                                           | 0                                                |
| Com_preload_keys                                       | 0                                                |
| Com_prepare_sql                                        | 0                                                |
| Com_purge                                              | 0                                                |
| Com_purge_before_date                                  | 0                                                |
| Com_release_savepoint                                  | 183                                              |
| 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_revoke_role                                        | 0                                                |
| Com_rollback                                           | 25                                               |
| Com_rollback_to_savepoint                              | 8003                                             |
| Com_savepoint                                          | 37063                                            |
| Com_select                                             | 9486355                                          |
| Com_set_option                                         | 992073                                           |
| Com_show_authors                                       | 0                                                |
| Com_show_binlog_events                                 | 0                                                |
| Com_show_binlogs                                       | 0                                                |
| Com_show_charsets                                      | 0                                                |
| Com_show_collations                                    | 0                                                |
| Com_show_contributors                                  | 0                                                |
| Com_show_create_db                                     | 0                                                |
| Com_show_create_event                                  | 0                                                |
| Com_show_create_func                                   | 183                                              |
| Com_show_create_package                                | 0                                                |
| Com_show_create_package_body                           | 0                                                |
| Com_show_create_proc                                   | 0                                                |
| Com_show_create_table                                  | 8003                                             |
| Com_show_create_trigger                                | 0                                                |
| Com_show_create_user                                   | 0                                                |
| Com_show_databases                                     | 3                                                |
| Com_show_engine_logs                                   | 0                                                |
| Com_show_engine_mutex                                  | 0                                                |
| Com_show_engine_status                                 | 7                                                |
| Com_show_errors                                        | 0                                                |
| Com_show_events                                        | 183                                              |
| Com_show_explain                                       | 0                                                |
| Com_show_fields                                        | 8050                                             |
| Com_show_function_status                               | 183                                              |
| Com_show_generic                                       | 0                                                |
| Com_show_grants                                        | 0                                                |
| Com_show_keys                                          | 0                                                |
| Com_show_binlog_status                                 | 0                                                |
| Com_show_open_tables                                   | 0                                                |
| Com_show_package_status                                | 26                                               |
| Com_show_package_body_status                           | 26                                               |
| Com_show_plugins                                       | 0                                                |
| Com_show_privileges                                    | 0                                                |
| Com_show_procedure_status                              | 26                                               |
| 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                                  | 2                                                |
| Com_show_status                                        | 5                                                |
| Com_show_storage_engines                               | 1                                                |
| Com_show_table_status                                  | 51                                               |
| Com_show_tables                                        | 184                                              |
| Com_show_triggers                                      | 0                                                |
| Com_show_variables                                     | 3                                                |
| Com_show_warnings                                      | 0                                                |
| Com_shutdown                                           | 0                                                |
| Com_signal                                             | 0                                                |
| Com_start_all_slaves                                   | 0                                                |
| Com_start_slave                                        | 0                                                |
| Com_stmt_close                                         | 10507781                                         |
| Com_stmt_execute                                       | 10507787                                         |
| Com_stmt_fetch                                         | 0                                                |
| Com_stmt_prepare                                       | 10507787                                         |
| Com_stmt_reprepare                                     | 1                                                |
| Com_stmt_reset                                         | 0                                                |
| Com_stmt_send_long_data                                | 0                                                |
| Com_stop_all_slaves                                    | 0                                                |
| Com_stop_slave                                         | 0                                                |
| Com_truncate                                           | 0                                                |
| Com_uninstall_plugin                                   | 0                                                |
| Com_unlock_tables                                      | 183                                              |
| Com_update                                             | 61400                                            |
| Com_update_multi                                       | 23                                               |
| Com_xa_commit                                          | 0                                                |
| Com_xa_end                                             | 0                                                |
| Com_xa_prepare                                         | 0                                                |
| Com_xa_recover                                         | 0                                                |
| Com_xa_rollback                                        | 0                                                |
| Com_xa_start                                           | 0                                                |
| Compression                                            | OFF                                              |
| 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                                            | 476218                                           |
| Cpu_time                                               | 0.000000                                         |
| Created_tmp_disk_tables                                | 208300                                           |
| Created_tmp_files                                      | 1333                                             |
| Created_tmp_tables                                     | 249989                                           |
| Delayed_errors                                         | 0                                                |
| Delayed_insert_threads                                 | 0                                                |
| Delayed_writes                                         | 0                                                |
| Delete_scan                                            | 23                                               |
| Empty_queries                                          | 1749695                                          |
| Executed_events                                        | 0                                                |
| Executed_triggers                                      | 0                                                |
| Feature_application_time_periods                       | 0                                                |
| Feature_check_constraint                               | 30                                               |
| Feature_custom_aggregate_functions                     | 0                                                |
| Feature_delay_key_write                                | 0                                                |
| Feature_dynamic_columns                                | 0                                                |
| Feature_fulltext                                       | 0                                                |
| Feature_gis                                            | 0                                                |
| Feature_insert_returning                               | 0                                                |
| Feature_invisible_columns                              | 0                                                |
| Feature_json                                           | 32701                                            |
| Feature_locale                                         | 0                                                |
| Feature_subquery                                       | 472956                                           |
| Feature_system_versioning                              | 0                                                |
| Feature_timezone                                       | 0                                                |
| Feature_trigger                                        | 1                                                |
| Feature_window_functions                               | 0                                                |
| Feature_xml                                            | 0                                                |
| Handler_commit                                         | 10687287                                         |
| Handler_delete                                         | 8437                                             |
| Handler_discover                                       | 80                                               |
| Handler_external_lock                                  | 0                                                |
| Handler_icp_attempts                                   | 213359715                                        |
| Handler_icp_match                                      | 188437332                                        |
| Handler_mrr_init                                       | 0                                                |
| Handler_mrr_key_refills                                | 0                                                |
| Handler_mrr_rowid_refills                              | 0                                                |
| Handler_prepare                                        | 0                                                |
| Handler_read_first                                     | 1281610                                          |
| Handler_read_key                                       | 985622040                                        |
| Handler_read_last                                      | 8710                                             |
| Handler_read_next                                      | 520312811                                        |
| Handler_read_prev                                      | 238730623                                        |
| Handler_read_retry                                     | 0                                                |
| Handler_read_rnd                                       | 35678110                                         |
| Handler_read_rnd_deleted                               | 13271                                            |
| Handler_read_rnd_next                                  | 9054207967                                       |
| Handler_rollback                                       | 211                                              |
| Handler_savepoint                                      | 27699                                            |
| Handler_savepoint_rollback                             | 8003                                             |
| Handler_tmp_delete                                     | 0                                                |
| Handler_tmp_update                                     | 3775072                                          |
| Handler_tmp_write                                      | 2220654031                                       |
| Handler_update                                         | 67715                                            |
| Handler_write                                          | 1610794                                          |
| Innodb_adaptive_hash_hash_searches                     | 0                                                |
| Innodb_adaptive_hash_non_hash_searches                 | 1519962576                                       |
| Innodb_background_log_sync                             | 254802                                           |
| Innodb_buffer_pool_dump_status                         |                                                  |
| Innodb_buffer_pool_load_status                         | Buffer pool(s) load completed at 210902 22:44:54 |
| Innodb_buffer_pool_resize_status                       |                                                  |
| Innodb_buffer_pool_load_incomplete                     | OFF                                              |
| Innodb_buffer_pool_pages_data                          | 295907                                           |
| Innodb_buffer_pool_bytes_data                          | 4848140288                                       |
| Innodb_buffer_pool_pages_dirty                         | 23030                                            |
| Innodb_buffer_pool_bytes_dirty                         | 377323520                                        |
| Innodb_buffer_pool_pages_flushed                       | 0                                                |
| Innodb_buffer_pool_pages_free                          | 736413                                           |
| Innodb_buffer_pool_pages_made_not_young                | 547383                                           |
| Innodb_buffer_pool_pages_made_young                    | 6142725                                          |
| Innodb_buffer_pool_pages_misc                          | 0                                                |
| Innodb_buffer_pool_pages_old                           | 109211                                           |
| Innodb_buffer_pool_pages_total                         | 1032320                                          |
| Innodb_buffer_pool_pages_lru_flushed                   | 0                                                |
| Innodb_buffer_pool_read_ahead_rnd                      | 0                                                |
| Innodb_buffer_pool_read_ahead                          | 89                                               |
| Innodb_buffer_pool_read_ahead_evicted                  | 0                                                |
| Innodb_buffer_pool_read_requests                       | 11134537004                                      |
| Innodb_buffer_pool_reads                               | 286497                                           |
| Innodb_buffer_pool_wait_free                           | 0                                                |
| Innodb_buffer_pool_write_requests                      | 1218485                                          |
| Innodb_checkpoint_age                                  | 480992075                                        |
| Innodb_checkpoint_max_age                              | 3478214063                                       |
| Innodb_data_fsyncs                                     | 80497                                            |
| Innodb_data_pending_fsyncs                             | 0                                                |
| Innodb_data_pending_reads                              | 0                                                |
| Innodb_data_pending_writes                             | 0                                                |
| Innodb_data_read                                       | 4695441408                                       |
| Innodb_data_reads                                      | 288579                                           |
| Innodb_data_writes                                     | 80768                                            |
| Innodb_data_written                                    | 0                                                |
| Innodb_dblwr_pages_written                             | 0                                                |
| Innodb_dblwr_writes                                    | 0                                                |
| Innodb_deadlocks                                       | 0                                                |
| Innodb_history_list_length                             | 0                                                |
| Innodb_ibuf_discarded_delete_marks                     | 0                                                |
| Innodb_ibuf_discarded_deletes                          | 0                                                |
| Innodb_ibuf_discarded_inserts                          | 0                                                |
| Innodb_ibuf_free_list                                  | 3017                                             |
| Innodb_ibuf_merged_delete_marks                        | 593                                              |
| Innodb_ibuf_merged_deletes                             | 167                                              |
| Innodb_ibuf_merged_inserts                             | 3924                                             |
| Innodb_ibuf_merges                                     | 1108                                             |
| Innodb_ibuf_segment_size                               | 3030                                             |
| Innodb_ibuf_size                                       | 12                                               |
| Innodb_log_waits                                       | 0                                                |
| Innodb_log_write_requests                              | 26833                                            |
| Innodb_log_writes                                      | 80459                                            |
| Innodb_lsn_current                                     | 141418798854                                     |
| Innodb_lsn_flushed                                     | 141418798854                                     |
| Innodb_lsn_last_checkpoint                             | 140937806779                                     |
| Innodb_master_thread_active_loops                      | 19287                                            |
| Innodb_master_thread_idle_loops                        | 235581                                           |
| Innodb_max_trx_id                                      | 110964485                                        |
| Innodb_mem_adaptive_hash                               | 0                                                |
| Innodb_mem_dictionary                                  | 110281776                                        |
| Innodb_os_log_fsyncs                                   | 80459                                            |
| Innodb_os_log_pending_fsyncs                           | 0                                                |
| Innodb_os_log_pending_writes                           | 0                                                |
| Innodb_os_log_written                                  | 592457728                                        |
| Innodb_page_size                                       | 16384                                            |
| Innodb_pages_created                                   | 9322                                             |
| Innodb_pages_read                                      | 286584                                           |
| Innodb_pages_written                                   | 0                                                |
| Innodb_row_lock_current_waits                          | 0                                                |
| Innodb_row_lock_time                                   | 17724                                            |
| Innodb_row_lock_time_avg                               | 285                                              |
| Innodb_row_lock_time_max                               | 1603                                             |
| Innodb_row_lock_waits                                  | 62                                               |
| Innodb_rows_deleted                                    | 8437                                             |
| Innodb_rows_inserted                                   | 44235                                            |
| Innodb_rows_read                                       | 10469594967                                      |
| Innodb_rows_updated                                    | 64497                                            |
| Innodb_system_rows_deleted                             | 0                                                |
| Innodb_system_rows_inserted                            | 0                                                |
| Innodb_system_rows_read                                | 0                                                |
| Innodb_system_rows_updated                             | 0                                                |
| Innodb_num_open_files                                  | 400                                              |
| Innodb_truncated_status_writes                         | 0                                                |
| Innodb_available_undo_logs                             | 128                                              |
| Innodb_undo_truncations                                | 0                                                |
| Innodb_page_compression_saved                          | 0                                                |
| Innodb_num_index_pages_written                         | 0                                                |
| Innodb_num_non_index_pages_written                     | 0                                                |
| Innodb_num_pages_page_compressed                       | 0                                                |
| Innodb_num_page_compressed_trim_op                     | 0                                                |
| Innodb_num_pages_page_decompressed                     | 0                                                |
| Innodb_num_pages_page_compression_error                | 0                                                |
| Innodb_num_pages_encrypted                             | 0                                                |
| Innodb_num_pages_decrypted                             | 0                                                |
| Innodb_have_lz4                                        | ON                                               |
| Innodb_have_lzo                                        | OFF                                              |
| Innodb_have_lzma                                       | OFF                                              |
| Innodb_have_bzip2                                      | OFF                                              |
| Innodb_have_snappy                                     | OFF                                              |
| Innodb_have_punch_hole                                 | ON                                               |
| Innodb_defragment_compression_failures                 | 0                                                |
| Innodb_defragment_failures                             | 0                                                |
| Innodb_defragment_count                                | 0                                                |
| Innodb_instant_alter_column                            | 0                                                |
| Innodb_onlineddl_rowlog_rows                           | 0                                                |
| Innodb_onlineddl_rowlog_pct_used                       | 0                                                |
| Innodb_onlineddl_pct_progress                          | 0                                                |
| Innodb_secondary_index_triggered_cluster_reads         | 492103516                                        |
| Innodb_secondary_index_triggered_cluster_reads_avoided | 0                                                |
| Innodb_encryption_rotation_pages_read_from_cache       | 0                                                |
| Innodb_encryption_rotation_pages_read_from_disk        | 0                                                |
| Innodb_encryption_rotation_pages_modified              | 0                                                |
| Innodb_encryption_rotation_pages_flushed               | 0                                                |
| Innodb_encryption_rotation_estimated_iops              | 0                                                |
| Innodb_encryption_key_rotation_list_length             | 0                                                |
| Innodb_encryption_n_merge_blocks_encrypted             | 0                                                |
| Innodb_encryption_n_merge_blocks_decrypted             | 0                                                |
| Innodb_encryption_n_rowlog_blocks_encrypted            | 0                                                |
| Innodb_encryption_n_rowlog_blocks_decrypted            | 0                                                |
| Innodb_encryption_n_temp_blocks_encrypted              | 0                                                |
| Innodb_encryption_n_temp_blocks_decrypted              | 0                                                |
| Innodb_encryption_num_key_requests                     | 0                                                |
| Key_blocks_not_flushed                                 | 0                                                |
| Key_blocks_unused                                      | 107163                                           |
| Key_blocks_used                                        | 0                                                |
| Key_blocks_warm                                        | 0                                                |
| Key_read_requests                                      | 0                                                |
| Key_reads                                              | 0                                                |
| Key_write_requests                                     | 0                                                |
| Key_writes                                             | 0                                                |
| Last_query_cost                                        | 0.000000                                         |
| Master_gtid_wait_count                                 | 0                                                |
| Master_gtid_wait_time                                  | 0                                                |
| Master_gtid_wait_timeouts                              | 0                                                |
| Max_statement_time_exceeded                            | 0                                                |
| Max_used_connections                                   | 220                                              |
| Memory_used                                            | 118531640                                        |
| Memory_used_initial                                    | 33657784                                         |
| Not_flushed_delayed_rows                               | 0                                                |
| Open_files                                             | 166                                              |
| Open_streams                                           | 4                                                |
| Open_table_definitions                                 | 2003                                             |
| Open_tables                                            | 2000                                             |
| Opened_files                                           | 838171                                           |
| Opened_plugin_libraries                                | 0                                                |
| Opened_table_definitions                               | 2665                                             |
| Opened_tables                                          | 3234                                             |
| Opened_views                                           | 3793                                             |
| 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                 | 414                                              |
| 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                                     | 0                                                |
| Qcache_free_memory                                     | 0                                                |
| Qcache_hits                                            | 0                                                |
| Qcache_inserts                                         | 0                                                |
| Qcache_lowmem_prunes                                   | 0                                                |
| Qcache_not_cached                                      | 0                                                |
| Qcache_queries_in_cache                                | 0                                                |
| Qcache_total_blocks                                    | 0                                                |
| Queries                                                | 35229881                                         |
| Questions                                              | 14214314                                         |
| Rows_read                                              | 10266242428                                      |
| Rows_sent                                              | 521831079                                        |
| Rows_tmp_read                                          | 16262631                                         |
| Rpl_semi_sync_master_clients                           | 0                                                |
| Rpl_semi_sync_master_get_ack                           | 0                                                |
| Rpl_semi_sync_master_net_avg_wait_time                 | 0                                                |
| Rpl_semi_sync_master_net_wait_time                     | 0                                                |
| Rpl_semi_sync_master_net_waits                         | 0                                                |
| Rpl_semi_sync_master_no_times                          | 0                                                |
| Rpl_semi_sync_master_no_tx                             | 0                                                |
| Rpl_semi_sync_master_request_ack                       | 0                                                |
| Rpl_semi_sync_master_status                            | OFF                                              |
| Rpl_semi_sync_master_timefunc_failures                 | 0                                                |
| Rpl_semi_sync_master_tx_avg_wait_time                  | 0                                                |
| Rpl_semi_sync_master_tx_wait_time                      | 0                                                |
| Rpl_semi_sync_master_tx_waits                          | 0                                                |
| Rpl_semi_sync_master_wait_pos_backtraverse             | 0                                                |
| Rpl_semi_sync_master_wait_sessions                     | 0                                                |
| Rpl_semi_sync_master_yes_tx                            | 0                                                |
| Rpl_semi_sync_slave_send_ack                           | 0                                                |
| Rpl_semi_sync_slave_status                             | OFF                                              |
| Rpl_status                                             | AUTH_MASTER                                      |
| Rpl_transactions_multi_engine                          | 0                                                |
| Select_full_join                                       | 1498                                             |
| Select_full_range_join                                 | 324                                              |
| Select_range                                           | 431886                                           |
| Select_range_check                                     | 0                                                |
| Select_scan                                            | 371859                                           |
| Slave_connections                                      | 0                                                |
| Slave_heartbeat_period                                 | 0.000                                            |
| Slave_open_temp_tables                                 | 0                                                |
| Slave_received_heartbeats                              | 0                                                |
| Slave_retried_transactions                             | 0                                                |
| Slave_running                                          | OFF                                              |
| Slave_skipped_errors                                   | 0                                                |
| Slaves_connected                                       | 0                                                |
| Slaves_running                                         | 0                                                |
| Slow_launch_threads                                    | 0                                                |
| Slow_queries                                           | 196                                              |
| Sort_merge_passes                                      | 628                                              |
| Sort_priority_queue_sorts                              | 75446                                            |
| Sort_range                                             | 206699                                           |
| Sort_rows                                              | 49860419                                         |
| Sort_scan                                              | 56477                                            |
| 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                                            |                                                  |
| Subquery_cache_hit                                     | 1159                                             |
| Subquery_cache_miss                                    | 6091                                             |
| Syncs                                                  | 1481                                             |
| Table_locks_immediate                                  | 3174                                             |
| Table_locks_waited                                     | 0                                                |
| Table_open_cache_active_instances                      | 1                                                |
| Table_open_cache_hits                                  | 24741188                                         |
| Table_open_cache_misses                                | 7027                                             |
| Table_open_cache_overflows                             | 669                                              |
| Tc_log_max_pages_used                                  | 0                                                |
| Tc_log_page_size                                       | 0                                                |
| Tc_log_page_waits                                      | 0                                                |
| Threadpool_idle_threads                                | 0                                                |
| Threadpool_threads                                     | 0                                                |
| Threads_cached                                         | 58                                               |
| Threads_connected                                      | 16                                               |
| Threads_created                                        | 991                                              |
| Threads_running                                        | 1                                                |
| Transactions_gtid_foreign_engine                       | 0                                                |
| Transactions_multi_engine                              | 0                                                |
| Update_scan                                            | 17370                                            |
| Uptime                                                 | 254961                                           |
| Uptime_since_flush_status                              | 254961                                           |
| wsrep                                                  | 0                                                |
| wsrep_applier_thread_count                             | 0                                                |
| wsrep_cluster_capabilities                             |                                                  |
| wsrep_cluster_conf_id                                  | 18446744073709551615                             |
| wsrep_cluster_size                                     | 0                                                |
| wsrep_cluster_state_uuid                               |                                                  |
| wsrep_cluster_status                                   | Disconnected                                     |
| wsrep_connected                                        | OFF                                              |
| wsrep_local_bf_aborts                                  | 0                                                |
| wsrep_local_index                                      | 18446744073709551615                             |
| wsrep_provider_capabilities                            |                                                  |
| wsrep_provider_name                                    |                                                  |
| wsrep_provider_vendor                                  |                                                  |
| wsrep_provider_version                                 |                                                  |
| wsrep_ready                                            | OFF                                              |
| wsrep_rollbacker_thread_count                          | 0                                                |
| wsrep_thread_count                                     | 0                                                |
+--------------------------------------------------------+--------------------------------------------------+

Changed text

Open file

MariaDB [phs]> SHOW GLOBAL STATUS;
+--------------------------------------------------------+--------------------------------------------------+
| Variable_name                                          | Value                                            |
+--------------------------------------------------------+--------------------------------------------------+
| Aborted_clients                                        | 1                                                |
| Aborted_connects                                       | 0                                                |
| Aborted_connects_preauth                               | 0                                                |
| Access_denied_errors                                   | 0                                                |
| Acl_column_grants                                      | 0                                                |
| Acl_database_grants                                    | 0                                                |
| Acl_function_grants                                    | 0                                                |
| Acl_procedure_grants                                   | 0                                                |
| Acl_package_spec_grants                                | 0                                                |
| Acl_package_body_grants                                | 0                                                |
| Acl_proxy_users                                        | 2                                                |
| Acl_role_grants                                        | 0                                                |
| Acl_roles                                              | 0                                                |
| Acl_table_grants                                       | 1                                                |
| Acl_users                                              | 3                                                |
| Aria_pagecache_blocks_not_flushed                      | 0                                                |
| Aria_pagecache_blocks_unused                           | 15637                                            |
| Aria_pagecache_blocks_used                             | 12                                               |
| Aria_pagecache_read_requests                           | 1391                                             |
| Aria_pagecache_reads                                   | 51                                               |
| Aria_pagecache_write_requests                          | 78                                               |
| Aria_pagecache_writes                                  | 78                                               |
| Aria_transaction_log_syncs                             | 0                                                |
| Binlog_commits                                         | 0                                                |
| Binlog_group_commits                                   | 0                                                |
| Binlog_group_commit_trigger_count                      | 0                                                |
| Binlog_group_commit_trigger_lock_wait                  | 0                                                |
| Binlog_group_commit_trigger_timeout                    | 0                                                |
| Binlog_snapshot_file                                   |                                                  |
| Binlog_snapshot_position                               | 0                                                |
| Binlog_bytes_written                                   | 0                                                |
| Binlog_cache_disk_use                                  | 0                                                |
| Binlog_cache_use                                       | 0                                                |
| Binlog_stmt_cache_disk_use                             | 0                                                |
| Binlog_stmt_cache_use                                  | 0                                                |
| Busy_time                                              | 0.000000                                         |
| Bytes_received                                         | 335567                                           |
| Bytes_sent                                             | 2411072                                          |
| Column_compressions                                    | 0                                                |
| Column_decompressions                                  | 0                                                |
| Com_admin_commands                                     | 0                                                |
| Com_alter_db                                           | 0                                                |
| Com_alter_db_upgrade                                   | 0                                                |
| Com_alter_event                                        | 0                                                |
| Com_alter_function                                     | 0                                                |
| Com_alter_procedure                                    | 0                                                |
| Com_alter_server                                       | 0                                                |
| Com_alter_sequence                                     | 0                                                |
| Com_alter_table                                        | 0                                                |
| Com_alter_tablespace                                   | 0                                                |
| Com_alter_user                                         | 0                                                |
| Com_analyze                                            | 0                                                |
| Com_assign_to_keycache                                 | 0                                                |
| Com_backup                                             | 0                                                |
| Com_backup_lock                                        | 0                                                |
| Com_begin                                              | 535                                              |
| Com_binlog                                             | 0                                                |
| Com_call_procedure                                     | 0                                                |
| Com_change_db                                          | 221                                              |
| Com_change_master                                      | 0                                                |
| Com_check                                              | 0                                                |
| Com_checksum                                           | 0                                                |
| Com_commit                                             | 535                                              |
| Com_compound_sql                                       | 0                                                |
| Com_create_db                                          | 0                                                |
| Com_create_event                                       | 0                                                |
| Com_create_function                                    | 0                                                |
| Com_create_index                                       | 0                                                |
| Com_create_package                                     | 0                                                |
| Com_create_package_body                                | 0                                                |
| Com_create_procedure                                   | 0                                                |
| Com_create_role                                        | 0                                                |
| Com_create_sequence                                    | 0                                                |
| Com_create_server                                      | 0                                                |
| Com_create_table                                       | 0                                                |
| Com_create_temporary_table                             | 0                                                |
| Com_create_trigger                                     | 0                                                |
| Com_create_udf                                         | 0                                                |
| Com_create_user                                        | 0                                                |
| Com_create_view                                        | 0                                                |
| Com_dealloc_sql                                        | 0                                                |
| Com_delete                                             | 1                                                |
| 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_package                                       | 0                                                |
| Com_drop_package_body                                  | 0                                                |
| Com_drop_role                                          | 0                                                |
| Com_drop_server                                        | 0                                                |
| Com_drop_sequence                                      | 0                                                |
| Com_drop_table                                         | 0                                                |
| Com_drop_temporary_table                               | 0                                                |
| Com_drop_trigger                                       | 0                                                |
| Com_drop_user                                          | 0                                                |
| Com_drop_view                                          | 0                                                |
| Com_empty_query                                        | 0                                                |
| Com_execute_immediate                                  | 0                                                |
| Com_execute_sql                                        | 0                                                |
| Com_flush                                              | 0                                                |
| Com_get_diagnostics                                    | 0                                                |
| Com_grant                                              | 0                                                |
| Com_grant_role                                         | 0                                                |
| Com_ha_close                                           | 0                                                |
| Com_ha_open                                            | 0                                                |
| Com_ha_read                                            | 0                                                |
| Com_help                                               | 0                                                |
| Com_insert                                             | 2                                                |
| Com_insert_select                                      | 0                                                |
| Com_install_plugin                                     | 0                                                |
| Com_kill                                               | 0                                                |
| Com_load                                               | 0                                                |
| Com_lock_tables                                        | 0                                                |
| Com_multi                                              | 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_revoke_role                                        | 0                                                |
| Com_rollback                                           | 0                                                |
| Com_rollback_to_savepoint                              | 0                                                |
| Com_savepoint                                          | 4                                                |
| Com_select                                             | 1327                                             |
| Com_set_option                                         | 442                                              |
| Com_show_authors                                       | 0                                                |
| Com_show_binlog_events                                 | 0                                                |
| Com_show_binlogs                                       | 0                                                |
| Com_show_charsets                                      | 0                                                |
| Com_show_collations                                    | 0                                                |
| Com_show_contributors                                  | 0                                                |
| Com_show_create_db                                     | 0                                                |
| Com_show_create_event                                  | 0                                                |
| Com_show_create_func                                   | 0                                                |
| Com_show_create_package                                | 0                                                |
| Com_show_create_package_body                           | 0                                                |
| Com_show_create_proc                                   | 0                                                |
| Com_show_create_table                                  | 0                                                |
| Com_show_create_trigger                                | 0                                                |
| Com_show_create_user                                   | 0                                                |
| Com_show_databases                                     | 1                                                |
| Com_show_engine_logs                                   | 0                                                |
| Com_show_engine_mutex                                  | 0                                                |
| Com_show_engine_status                                 | 0                                                |
| Com_show_errors                                        | 0                                                |
| Com_show_events                                        | 0                                                |
| Com_show_explain                                       | 0                                                |
| Com_show_fields                                        | 47                                               |
| Com_show_function_status                               | 0                                                |
| Com_show_generic                                       | 0                                                |
| Com_show_grants                                        | 0                                                |
| Com_show_keys                                          | 0                                                |
| Com_show_binlog_status                                 | 0                                                |
| Com_show_open_tables                                   | 0                                                |
| Com_show_package_status                                | 0                                                |
| Com_show_package_body_status                           | 0                                                |
| Com_show_plugins                                       | 0                                                |
| Com_show_privileges                                    | 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                                        | 1                                                |
| Com_show_storage_engines                               | 0                                                |
| Com_show_table_status                                  | 0                                                |
| Com_show_tables                                        | 1                                                |
| Com_show_triggers                                      | 0                                                |
| Com_show_variables                                     | 0                                                |
| Com_show_warnings                                      | 0                                                |
| Com_shutdown                                           | 0                                                |
| Com_signal                                             | 0                                                |
| Com_start_all_slaves                                   | 0                                                |
| Com_start_slave                                        | 0                                                |
| Com_stmt_close                                         | 1773                                             |
| Com_stmt_execute                                       | 1773                                             |
| Com_stmt_fetch                                         | 0                                                |
| Com_stmt_prepare                                       | 1773                                             |
| Com_stmt_reprepare                                     | 0                                                |
| Com_stmt_reset                                         | 0                                                |
| Com_stmt_send_long_data                                | 0                                                |
| Com_stop_all_slaves                                    | 0                                                |
| Com_stop_slave                                         | 0                                                |
| Com_truncate                                           | 0                                                |
| Com_uninstall_plugin                                   | 0                                                |
| Com_unlock_tables                                      | 0                                                |
| Com_update                                             | 2                                                |
| 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                                                |
| Compression                                            | OFF                                              |
| 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                                            | 224                                              |
| Cpu_time                                               | 0.000000                                         |
| Created_tmp_disk_tables                                | 39                                               |
| Created_tmp_files                                      | 5                                                |
| Created_tmp_tables                                     | 46                                               |
| Delayed_errors                                         | 0                                                |
| Delayed_insert_threads                                 | 0                                                |
| Delayed_writes                                         | 0                                                |
| Delete_scan                                            | 0                                                |
| Empty_queries                                          | 643                                              |
| Executed_events                                        | 0                                                |
| Executed_triggers                                      | 0                                                |
| Feature_application_time_periods                       | 0                                                |
| Feature_check_constraint                               | 3                                                |
| Feature_custom_aggregate_functions                     | 0                                                |
| Feature_delay_key_write                                | 0                                                |
| Feature_dynamic_columns                                | 0                                                |
| Feature_fulltext                                       | 0                                                |
| Feature_gis                                            | 0                                                |
| Feature_insert_returning                               | 0                                                |
| Feature_invisible_columns                              | 0                                                |
| Feature_json                                           | 5                                                |
| Feature_locale                                         | 0                                                |
| Feature_subquery                                       | 108                                              |
| Feature_system_versioning                              | 0                                                |
| Feature_timezone                                       | 0                                                |
| Feature_trigger                                        | 0                                                |
| Feature_window_functions                               | 0                                                |
| Feature_xml                                            | 0                                                |
| Handler_commit                                         | 1259                                             |
| Handler_delete                                         | 1                                                |
| Handler_discover                                       | 0                                                |
| Handler_external_lock                                  | 0                                                |
| Handler_icp_attempts                                   | 211                                              |
| Handler_icp_match                                      | 211                                              |
| Handler_mrr_init                                       | 0                                                |
| Handler_mrr_key_refills                                | 0                                                |
| Handler_mrr_rowid_refills                              | 0                                                |
| Handler_prepare                                        | 0                                                |
| Handler_read_first                                     | 538                                              |
| Handler_read_key                                       | 1415                                             |
| Handler_read_last                                      | 4                                                |
| Handler_read_next                                      | 908                                              |
| Handler_read_prev                                      | 50                                               |
| Handler_read_retry                                     | 0                                                |
| Handler_read_rnd                                       | 141                                              |
| Handler_read_rnd_deleted                               | 2                                                |
| Handler_read_rnd_next                                  | 33777                                            |
| Handler_rollback                                       | 0                                                |
| Handler_savepoint                                      | 3                                                |
| Handler_savepoint_rollback                             | 0                                                |
| Handler_tmp_delete                                     | 0                                                |
| Handler_tmp_update                                     | 0                                                |
| Handler_tmp_write                                      | 11452                                            |
| Handler_update                                         | 2                                                |
| Handler_write                                          | 2                                                |
| Innodb_adaptive_hash_hash_searches                     | 0                                                |
| Innodb_adaptive_hash_non_hash_searches                 | 4350                                             |
| Innodb_background_log_sync                             | 2254                                             |
| Innodb_buffer_pool_dump_status                         |                                                  |
| Innodb_buffer_pool_load_status                         | Buffer pool(s) load completed at 210906  0:56:42 |
| Innodb_buffer_pool_resize_status                       |                                                  |
| Innodb_buffer_pool_load_incomplete                     | OFF                                              |
| Innodb_buffer_pool_pages_data                          | 4634                                             |
| Innodb_buffer_pool_bytes_data                          | 75923456                                         |
| Innodb_buffer_pool_pages_dirty                         | 34                                               |
| Innodb_buffer_pool_bytes_dirty                         | 557056                                           |
| Innodb_buffer_pool_pages_flushed                       | 0                                                |
| Innodb_buffer_pool_pages_free                          | 11496                                            |
| Innodb_buffer_pool_pages_made_not_young                | 0                                                |
| Innodb_buffer_pool_pages_made_young                    | 0                                                |
| Innodb_buffer_pool_pages_misc                          | 0                                                |
| Innodb_buffer_pool_pages_old                           | 1730                                             |
| Innodb_buffer_pool_pages_total                         | 16130                                            |
| Innodb_buffer_pool_pages_lru_flushed                   | 0                                                |
| 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                       | 30188                                            |
| Innodb_buffer_pool_reads                               | 4501                                             |
| Innodb_buffer_pool_wait_free                           | 0                                                |
| Innodb_buffer_pool_write_requests                      | 641                                              |
| Innodb_checkpoint_age                                  | 36032                                            |
| Innodb_checkpoint_max_age                              | 80827823                                         |
| Innodb_data_fsyncs                                     | 13                                               |
| Innodb_data_pending_fsyncs                             | 0                                                |
| Innodb_data_pending_reads                              | 0                                                |
| Innodb_data_pending_writes                             | 0                                                |
| Innodb_data_read                                       | 73760768                                         |
| Innodb_data_reads                                      | 4628                                             |
| Innodb_data_writes                                     | 11                                               |
| Innodb_data_written                                    | 0                                                |
| Innodb_dblwr_pages_written                             | 0                                                |
| Innodb_dblwr_writes                                    | 0                                                |
| Innodb_deadlocks                                       | 0                                                |
| Innodb_history_list_length                             | 0                                                |
| Innodb_ibuf_discarded_delete_marks                     | 0                                                |
| Innodb_ibuf_discarded_deletes                          | 0                                                |
| Innodb_ibuf_discarded_inserts                          | 0                                                |
| Innodb_ibuf_free_list                                  | 6107                                             |
| Innodb_ibuf_merged_delete_marks                        | 1                                                |
| Innodb_ibuf_merged_deletes                             | 0                                                |
| Innodb_ibuf_merged_inserts                             | 0                                                |
| Innodb_ibuf_merges                                     | 1                                                |
| Innodb_ibuf_segment_size                               | 6152                                             |
| Innodb_ibuf_size                                       | 44                                               |
| Innodb_log_waits                                       | 0                                                |
| Innodb_log_write_requests                              | 160                                              |
| Innodb_log_writes                                      | 11                                               |
| Innodb_lsn_current                                     | 19030538776                                      |
| Innodb_lsn_flushed                                     | 19030538776                                      |
| Innodb_lsn_last_checkpoint                             | 19030502744                                      |
| Innodb_master_thread_active_loops                      | 3                                                |
| Innodb_master_thread_idle_loops                        | 2251                                             |
| Innodb_max_trx_id                                      | 52065                                            |
| Innodb_mem_adaptive_hash                               | 0                                                |
| Innodb_mem_dictionary                                  | 1882752                                          |
| Innodb_os_log_fsyncs                                   | 11                                               |
| Innodb_os_log_pending_fsyncs                           | 0                                                |
| Innodb_os_log_pending_writes                           | 0                                                |
| Innodb_os_log_written                                  | 54272                                            |
| Innodb_page_size                                       | 16384                                            |
| Innodb_pages_created                                   | 132                                              |
| Innodb_pages_read                                      | 4501                                             |
| Innodb_pages_written                                   | 0                                                |
| 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                                    | 1                                                |
| Innodb_rows_inserted                                   | 2                                                |
| Innodb_rows_read                                       | 35095                                            |
| Innodb_rows_updated                                    | 2                                                |
| Innodb_system_rows_deleted                             | 0                                                |
| Innodb_system_rows_inserted                            | 0                                                |
| Innodb_system_rows_read                                | 0                                                |
| Innodb_system_rows_updated                             | 0                                                |
| Innodb_num_open_files                                  | 117                                              |
| Innodb_truncated_status_writes                         | 0                                                |
| Innodb_available_undo_logs                             | 128                                              |
| Innodb_undo_truncations                                | 0                                                |
| Innodb_page_compression_saved                          | 0                                                |
| Innodb_num_index_pages_written                         | 0                                                |
| Innodb_num_non_index_pages_written                     | 0                                                |
| Innodb_num_pages_page_compressed                       | 0                                                |
| Innodb_num_page_compressed_trim_op                     | 0                                                |
| Innodb_num_pages_page_decompressed                     | 0                                                |
| Innodb_num_pages_page_compression_error                | 0                                                |
| Innodb_num_pages_encrypted                             | 0                                                |
| Innodb_num_pages_decrypted                             | 0                                                |
| Innodb_have_lz4                                        | ON                                               |
| Innodb_have_lzo                                        | OFF                                              |
| Innodb_have_lzma                                       | OFF                                              |
| Innodb_have_bzip2                                      | OFF                                              |
| Innodb_have_snappy                                     | OFF                                              |
| Innodb_have_punch_hole                                 | ON                                               |
| Innodb_defragment_compression_failures                 | 0                                                |
| Innodb_defragment_failures                             | 0                                                |
| Innodb_defragment_count                                | 0                                                |
| Innodb_instant_alter_column                            | 0                                                |
| Innodb_onlineddl_rowlog_rows                           | 0                                                |
| Innodb_onlineddl_rowlog_pct_used                       | 0                                                |
| Innodb_onlineddl_pct_progress                          | 0                                                |
| Innodb_secondary_index_triggered_cluster_reads         | 442                                              |
| Innodb_secondary_index_triggered_cluster_reads_avoided | 0                                                |
| Innodb_encryption_rotation_pages_read_from_cache       | 0                                                |
| Innodb_encryption_rotation_pages_read_from_disk        | 0                                                |
| Innodb_encryption_rotation_pages_modified              | 0                                                |
| Innodb_encryption_rotation_pages_flushed               | 0                                                |
| Innodb_encryption_rotation_estimated_iops              | 0                                                |
| Innodb_encryption_key_rotation_list_length             | 0                                                |
| Innodb_encryption_n_merge_blocks_encrypted             | 0                                                |
| Innodb_encryption_n_merge_blocks_decrypted             | 0                                                |
| Innodb_encryption_n_rowlog_blocks_encrypted            | 0                                                |
| Innodb_encryption_n_rowlog_blocks_decrypted            | 0                                                |
| Innodb_encryption_n_temp_blocks_encrypted              | 0                                                |
| Innodb_encryption_n_temp_blocks_decrypted              | 0                                                |
| Innodb_encryption_num_key_requests                     | 0                                                |
| Key_blocks_not_flushed                                 | 0                                                |
| Key_blocks_unused                                      | 107163                                           |
| Key_blocks_used                                        | 0                                                |
| Key_blocks_warm                                        | 0                                                |
| Key_read_requests                                      | 0                                                |
| Key_reads                                              | 0                                                |
| Key_write_requests                                     | 0                                                |
| Key_writes                                             | 0                                                |
| Last_query_cost                                        | 0.000000                                         |
| Master_gtid_wait_count                                 | 0                                                |
| Master_gtid_wait_time                                  | 0                                                |
| Master_gtid_wait_timeouts                              | 0                                                |
| Max_statement_time_exceeded                            | 0                                                |
| Max_used_connections                                   | 3                                                |
| Memory_used                                            | 105740304                                        |
| Memory_used_initial                                    | 99946040                                         |
| Not_flushed_delayed_rows                               | 0                                                |
| Open_files                                             | 40                                               |
| Open_streams                                           | 4                                                |
| Open_table_definitions                                 | 94                                               |
| Open_tables                                            | 89                                               |
| Opened_files                                           | 336                                              |
| Opened_plugin_libraries                                | 0                                                |
| Opened_table_definitions                               | 94                                               |
| Opened_tables                                          | 96                                               |
| Opened_views                                           | 0                                                |
| 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                                     | 66676768                                         |
| Qcache_hits                                            | 582                                              |
| Qcache_inserts                                         | 166                                              |
| Qcache_lowmem_prunes                                   | 0                                                |
| Qcache_not_cached                                      | 2                                                |
| Qcache_queries_in_cache                                | 151                                              |
| Qcache_total_blocks                                    | 329                                              |
| Queries                                                | 6885                                             |
| Questions                                              | 3339                                             |
| Rows_read                                              | 35101                                            |
| Rows_sent                                              | 2744                                             |
| Rows_tmp_read                                          | 338                                              |
| Rpl_semi_sync_master_clients                           | 0                                                |
| Rpl_semi_sync_master_get_ack                           | 0                                                |
| Rpl_semi_sync_master_net_avg_wait_time                 | 0                                                |
| Rpl_semi_sync_master_net_wait_time                     | 0                                                |
| Rpl_semi_sync_master_net_waits                         | 0                                                |
| Rpl_semi_sync_master_no_times                          | 0                                                |
| Rpl_semi_sync_master_no_tx                             | 0                                                |
| Rpl_semi_sync_master_request_ack                       | 0                                                |
| Rpl_semi_sync_master_status                            | OFF                                              |
| Rpl_semi_sync_master_timefunc_failures                 | 0                                                |
| Rpl_semi_sync_master_tx_avg_wait_time                  | 0                                                |
| Rpl_semi_sync_master_tx_wait_time                      | 0                                                |
| Rpl_semi_sync_master_tx_waits                          | 0                                                |
| Rpl_semi_sync_master_wait_pos_backtraverse             | 0                                                |
| Rpl_semi_sync_master_wait_sessions                     | 0                                                |
| Rpl_semi_sync_master_yes_tx                            | 0                                                |
| Rpl_semi_sync_slave_send_ack                           | 0                                                |
| Rpl_semi_sync_slave_status                             | OFF                                              |
| Rpl_status                                             | AUTH_MASTER                                      |
| Rpl_transactions_multi_engine                          | 0                                                |
| Select_full_join                                       | 0                                                |
| Select_full_range_join                                 | 0                                                |
| Select_range                                           | 25                                               |
| Select_range_check                                     | 0                                                |
| Select_scan                                            | 70                                               |
| Slave_connections                                      | 0                                                |
| Slave_heartbeat_period                                 | 0.000                                            |
| Slave_open_temp_tables                                 | 0                                                |
| Slave_received_heartbeats                              | 0                                                |
| Slave_retried_transactions                             | 0                                                |
| Slave_running                                          | OFF                                              |
| Slave_skipped_errors                                   | 0                                                |
| Slaves_connected                                       | 0                                                |
| Slaves_running                                         | 0                                                |
| Slow_launch_threads                                    | 0                                                |
| Slow_queries                                           | 0                                                |
| Sort_merge_passes                                      | 0                                                |
| Sort_priority_queue_sorts                              | 3                                                |
| Sort_range                                             | 12                                               |
| Sort_rows                                              | 186                                              |
| Sort_scan                                              | 11                                               |
| 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                                            |                                                  |
| Subquery_cache_hit                                     | 0                                                |
| Subquery_cache_miss                                    | 0                                                |
| Syncs                                                  | 15                                               |
| Table_locks_immediate                                  | 86                                               |
| Table_locks_waited                                     | 0                                                |
| Table_open_cache_active_instances                      | 1                                                |
| Table_open_cache_hits                                  | 2175                                             |
| Table_open_cache_misses                                | 3216                                             |
| Table_open_cache_overflows                             | 0                                                |
| Tc_log_max_pages_used                                  | 0                                                |
| Tc_log_page_size                                       | 0                                                |
| Tc_log_page_waits                                      | 0                                                |
| Threadpool_idle_threads                                | 0                                                |
| Threadpool_threads                                     | 0                                                |
| Threads_cached                                         | 2                                                |
| Threads_connected                                      | 1                                                |
| Threads_created                                        | 6                                                |
| Threads_running                                        | 1                                                |
| Transactions_gtid_foreign_engine                       | 0                                                |
| Transactions_multi_engine                              | 0                                                |
| Update_scan                                            | 0                                                |
| Uptime                                                 | 2255                                             |
| Uptime_since_flush_status                              | 2255                                             |
| wsrep                                                  | 0                                                |
| wsrep_applier_thread_count                             | 0                                                |
| wsrep_cluster_capabilities                             |                                                  |
| wsrep_cluster_conf_id                                  | 18446744073709551615                             |
| wsrep_cluster_size                                     | 0                                                |
| wsrep_cluster_state_uuid                               |                                                  |
| wsrep_cluster_status                                   | Disconnected                                     |
| wsrep_connected                                        | OFF                                              |
| wsrep_local_bf_aborts                                  | 0                                                |
| wsrep_local_index                                      | 18446744073709551615                             |
| wsrep_provider_capabilities                            |                                                  |
| wsrep_provider_name                                    |                                                  |
| wsrep_provider_vendor                                  |                                                  |
| wsrep_provider_version                                 |                                                  |
| wsrep_ready                                            | OFF                                              |
| wsrep_rollbacker_thread_count                          | 0                                                |
| wsrep_thread_count                                     | 0                                                |
+--------------------------------------------------------+--------------------------------------------------+