maria-discuss team mailing list archive
-
maria-discuss team
-
Mailing list archive
-
Message #06282
Re: MariaDB server horribly slow on start
-
To:
Ali <mp.x@xxxxx>
-
From:
Cédric Counotte <cedric.counotte@xxxxxxxxxx>
-
Date:
Wed, 27 Jul 2022 12:32:22 +0000
-
Accept-language:
en-US, fr-FR
-
Arc-authentication-results:
i=1; mx.microsoft.com 1; spf=pass smtp.mailfrom=1check.com; dmarc=pass action=none header.from=1check.com; dkim=pass header.d=1check.com; arc=none
-
Arc-message-signature:
i=1; a=rsa-sha256; c=relaxed/relaxed; d=microsoft.com; s=arcselector9901; h=From:Date:Subject:Message-ID:Content-Type:MIME-Version:X-MS-Exchange-AntiSpam-MessageData-ChunkCount:X-MS-Exchange-AntiSpam-MessageData-0:X-MS-Exchange-AntiSpam-MessageData-1; bh=0UxIflsyTfhlHJeyTarMLuKcN/pCI/Q5RKo4/tyP8nU=; b=RYEpBCtjKgBe17NFnuRzD/fkkOqvyb0sEThft8AoUYH+ndim23CjU/DTy2/ZBAkeWcL+2KLVDWJhNZOprDP/wyRqoMQ5eFw0hu3tuPCbULJU+i+Mpu0WV6z5JMDb/gWFpleK/owXyGE+W0CbPrM/Q1/T/ERb/NpFdcLa58Lxc67cifydfHd5YOZpGlpP7HzSAP95KkxY4+GcIyrwsIpaWbDvjK6nIFoTeTox8m1thLYvj5tZbVKAjKvuqIyQqlEOfDMccM3SwTGELy0ODxixor60XOalKVxVVheIiXVU5aqRc4HXbC0XbhpcLlonXAIxlyHunJ84ABd12AFIQdQsjg==
-
Arc-seal:
i=1; a=rsa-sha256; s=arcselector9901; d=microsoft.com; cv=none; b=FAAMvflpcYIQderMe9Z1tZFfamHmXJtViW3wyzyT21xtbN7sftyukXKpUflQ1u+a+TiiKkkjli1cVMrXHnhrSFjwWaGOGFrGtnNtI6o6GQC84FmgeSjt3CT+EBt2DPmM+kH9E8QGkNGjgVOtLhG7Qf2fzGX98jwcXSHmZIYNd4FopOqIbTLTL8odTnBmsekWKCuDwNyiPIZx4WgEcw0Hwz0mL02q0ZsuvtWLwh6U3bwoa/QaApPTZbS2xnmvSFnEaRbEhqZy002pJMucwnW6QVTgq9V4f2YCRiBs0aAtmZN+qSPVwMc5ycMWwa1WvR0SHVBxVEwwKbAHf8GhjWydmw==
-
Authentication-results:
dkim=none (message not signed) header.d=none;dmarc=none action=none header.from=1check.com;
-
Cc:
Mailing-List mariadb <maria-discuss@xxxxxxxxxxxxxxxxxxx>, Pierre LAFON <pierre.lafon@xxxxxxxxxx>
-
In-reply-to:
<578d9424-b037-19f6-9753-01abfd40c1ce@bk.ru>
-
Thread-index:
Adihm/U8OcwjLBOASdqVrFuHw0ZWfgAA2yMAAAGY8HAAAKBwgAAACDYQAADYM4AAAFTbwAAAgIiAAACe0LAAAKvYAAAAHSWA
-
Thread-topic:
[Maria-discuss] MariaDB server horribly slow on start
Attached both.
Later today (at nighttime in Europe) I will be testing server restarts so it might be a good time to change any settings that could cause this.
Thanks for your time.
De : Ali <mp.x@xxxxx>
Envoyé : mercredi 27 juillet 2022 14:28
À : Cédric Counotte <cedric.counotte@xxxxxxxxxx>
Cc : Mailing-List mariadb <maria-discuss@xxxxxxxxxxxxxxxxxxx>
Objet : Re: [Maria-discuss] MariaDB server horribly slow on start
Hi,
Can you attach the logs of global status and global variables
On 7/27/22 15:12, Cédric Counotte wrote:
AH! Thanks for the input about PMM, I'm actually using netdata as you can see on screenshot.
And yes, it's better to have one than nothing, it helped me numerous times spot improvements and limits that could be changed to improve things.
I did an upgrade from 10.4 -> 10.5 -> 10.6 while it kept saying SST are not supported, but it worked 😉 Not sure I'm glad it worked now that I might have to revert back to 10.4 (and Ubuntu 20.04!).
-----Message d'origine-----
De : Gordan Bobic <gordan.bobic@xxxxxxxxx><mailto:gordan.bobic@xxxxxxxxx>
Envoyé : mercredi 27 juillet 2022 13:51
À : Cédric Counotte <cedric.counotte@xxxxxxxxxx><mailto:cedric.counotte@xxxxxxxxxx>
Cc : William Edwards <wedwards@xxxxxxxxxxxxxx><mailto:wedwards@xxxxxxxxxxxxxx>; Mailing-List mariadb <maria-discuss@xxxxxxxxxxxxxxxxxxx><mailto:maria-discuss@xxxxxxxxxxxxxxxxxxx>
Objet : Re: [Maria-discuss] MariaDB server horribly slow on start
On Wed, Jul 27, 2022 at 2:38 PM Cédric Counotte <cedric.counotte@xxxxxxxxxx<mailto:cedric.counotte@xxxxxxxxxx>> wrote:
>
> No idea what is PMM ?
https://www.percona.com/software/database-tools/percona-monitoring-and-management
I prefer v1, but in Percona's build of PMM v1 there are several bugs / missing features that are going to cause you problems with newer kernels and MariaDB 10.5+.
I have patches to fix it, but my build of it is not yet publicly available. But v2 is still far better than no PMM.
> Do you have a bug tracking this behavior, so that maybe I can follow it or apply work-around ?
I cannot say I have looked. I'm generally happy to leave testing to others until I have an overwhelming reason to upgrade to a version with a lot of changes. And 10.5 was a rather big feature release.
> I’m not quite keen on downgrading (which I’ll do using the spare servers I have and a little replication in between), but if it turns out to provide a more reliable alternative I’m eager to do it then!
Replication from newer version to older version is also not officially supported. It usually works, though.
_______________________________________________
Mailing list: https://launchpad.net/~maria-discuss
Post to : maria-discuss@xxxxxxxxxxxxxxxxxxx<mailto:maria-discuss@xxxxxxxxxxxxxxxxxxx>
Unsubscribe : https://launchpad.net/~maria-discuss
More help : https://help.launchpad.net/ListHelp
+--------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------+
| Variable_name | Value |
+--------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------+
| Aborted_clients | 2 |
| Aborted_connects | 2 |
| Aborted_connects_preauth | 0 |
| Access_denied_errors | 0 |
| Acl_column_grants | 0 |
| Acl_database_grants | 3 |
| 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 | 1 |
| Acl_users | 14 |
| Aria_pagecache_blocks_not_flushed | 0 |
| Aria_pagecache_blocks_unused | 15647 |
| Aria_pagecache_blocks_used | 928 |
| Aria_pagecache_read_requests | 5801164 |
| Aria_pagecache_reads | 52750 |
| Aria_pagecache_write_requests | 208927 |
| Aria_pagecache_writes | 122438 |
| Aria_transaction_log_syncs | 450 |
| Binlog_commits | 312168 |
| Binlog_group_commits | 299553 |
| Binlog_group_commit_trigger_count | 0 |
| Binlog_group_commit_trigger_lock_wait | 0 |
| Binlog_group_commit_trigger_timeout | 0 |
| Binlog_snapshot_file | mysql-bin.017023 |
| Binlog_snapshot_position | 602179686 |
| Binlog_bytes_written | 0 |
| Binlog_cache_disk_use | 26212 |
| Binlog_cache_use | 311884 |
| Binlog_stmt_cache_disk_use | 0 |
| Binlog_stmt_cache_use | 0 |
| Busy_time | 0.000000 |
| Bytes_received | 186 |
| Bytes_sent | 118 |
| 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 | 0 |
| Com_binlog | 0 |
| Com_call_procedure | 0 |
| Com_change_db | 0 |
| Com_change_master | 0 |
| Com_check | 0 |
| Com_checksum | 0 |
| Com_commit | 0 |
| 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 | 0 |
| Com_delete_multi | 0 |
| Com_do | 0 |
| Com_drop_db | 0 |
| Com_drop_event | 0 |
| Com_drop_function | 0 |
| Com_drop_index | 0 |
| Com_drop_procedure | 0 |
| Com_drop_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 | 0 |
| Com_insert_select | 0 |
| Com_install_plugin | 0 |
| Com_kill | 0 |
| Com_load | 0 |
| Com_lock_tables | 0 |
| Com_optimize | 0 |
| Com_preload_keys | 0 |
| Com_prepare_sql | 0 |
| Com_purge | 0 |
| Com_purge_before_date | 0 |
| Com_release_savepoint | 0 |
| Com_rename_table | 0 |
| Com_rename_user | 0 |
| Com_repair | 0 |
| Com_replace | 0 |
| Com_replace_select | 0 |
| Com_reset | 0 |
| Com_resignal | 0 |
| Com_revoke | 0 |
| Com_revoke_all | 0 |
| Com_revoke_role | 0 |
| Com_rollback | 0 |
| Com_rollback_to_savepoint | 0 |
| Com_savepoint | 0 |
| Com_select | 0 |
| Com_set_option | 0 |
| 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 | 0 |
| 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 | 0 |
| 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 | 0 |
| 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 | 0 |
| Com_stmt_execute | 0 |
| Com_stmt_fetch | 0 |
| Com_stmt_prepare | 0 |
| 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 | 0 |
| Com_update_multi | 0 |
| Com_xa_commit | 0 |
| Com_xa_end | 0 |
| Com_xa_prepare | 0 |
| Com_xa_recover | 0 |
| Com_xa_rollback | 0 |
| Com_xa_start | 0 |
| 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 | 486837 |
| Cpu_time | 0.000000 |
| Created_tmp_disk_tables | 0 |
| Created_tmp_files | 5596 |
| Created_tmp_tables | 0 |
| Delayed_errors | 0 |
| Delayed_insert_threads | 0 |
| Delayed_writes | 0 |
| Delete_scan | 0 |
| Empty_queries | 0 |
| Executed_events | 0 |
| Executed_triggers | 0 |
| Feature_application_time_periods | 0 |
| Feature_check_constraint | 4 |
| Feature_custom_aggregate_functions | 0 |
| Feature_delay_key_write | 3 |
| Feature_dynamic_columns | 0 |
| Feature_fulltext | 0 |
| Feature_gis | 0 |
| Feature_insert_returning | 0 |
| Feature_invisible_columns | 0 |
| Feature_json | 0 |
| Feature_locale | 0 |
| Feature_subquery | 0 |
| Feature_system_versioning | 0 |
| Feature_timezone | 0 |
| Feature_trigger | 0 |
| Feature_window_functions | 0 |
| Feature_xml | 0 |
| Handler_commit | 0 |
| Handler_delete | 0 |
| Handler_discover | 0 |
| Handler_external_lock | 0 |
| Handler_icp_attempts | 0 |
| Handler_icp_match | 0 |
| Handler_mrr_init | 0 |
| Handler_mrr_key_refills | 0 |
| Handler_mrr_rowid_refills | 0 |
| Handler_prepare | 0 |
| Handler_read_first | 0 |
| Handler_read_key | 0 |
| Handler_read_last | 0 |
| Handler_read_next | 0 |
| Handler_read_prev | 0 |
| Handler_read_retry | 0 |
| Handler_read_rnd | 0 |
| Handler_read_rnd_deleted | 0 |
| Handler_read_rnd_next | 0 |
| Handler_rollback | 0 |
| Handler_savepoint | 0 |
| Handler_savepoint_rollback | 0 |
| Handler_tmp_delete | 0 |
| Handler_tmp_update | 0 |
| Handler_tmp_write | 0 |
| Handler_update | 0 |
| Handler_write | 0 |
| Innodb_adaptive_hash_hash_searches | 853314710 |
| Innodb_adaptive_hash_non_hash_searches | 248258123 |
| Innodb_background_log_sync | 8652 |
| Innodb_buffer_pool_dump_status | |
| Innodb_buffer_pool_load_status | Buffer pool(s) load completed at 220727 12:04:13 |
| Innodb_buffer_pool_resize_status | |
| Innodb_buffer_pool_load_incomplete | OFF |
| Innodb_buffer_pool_pages_data | 2136635 |
| Innodb_buffer_pool_bytes_data | 35006627840 |
| Innodb_buffer_pool_pages_dirty | 40695 |
| Innodb_buffer_pool_bytes_dirty | 666746880 |
| Innodb_buffer_pool_pages_flushed | 965393 |
| Innodb_buffer_pool_pages_free | 4016362 |
| Innodb_buffer_pool_pages_made_not_young | 252223713 |
| Innodb_buffer_pool_pages_made_young | 697890 |
| Innodb_buffer_pool_pages_misc | 77019 |
| Innodb_buffer_pool_pages_old | 788731 |
| Innodb_buffer_pool_pages_total | 6230016 |
| Innodb_buffer_pool_pages_lru_flushed | 0 |
| Innodb_buffer_pool_pages_lru_freed | 0 |
| Innodb_buffer_pool_read_ahead_rnd | 0 |
| Innodb_buffer_pool_read_ahead | 77 |
| Innodb_buffer_pool_read_ahead_evicted | 0 |
| Innodb_buffer_pool_read_requests | 3513357629 |
| Innodb_buffer_pool_reads | 2017997 |
| Innodb_buffer_pool_wait_free | 0 |
| Innodb_buffer_pool_write_requests | 368907959 |
| Innodb_checkpoint_age | 679305269 |
| Innodb_checkpoint_max_age | 869021431 |
| Innodb_data_fsyncs | 59212 |
| Innodb_data_pending_fsyncs | 0 |
| Innodb_data_pending_reads | 0 |
| Innodb_data_pending_writes | 0 |
| Innodb_data_read | 33064960000 |
| Innodb_data_reads | 2135659 |
| Innodb_data_writes | 1578886 |
| Innodb_data_written | 15817238704 |
| Innodb_dblwr_pages_written | 354480 |
| Innodb_dblwr_writes | 3375 |
| Innodb_deadlocks | 0 |
| Innodb_history_list_length | 1454 |
| Innodb_ibuf_discarded_delete_marks | 0 |
| Innodb_ibuf_discarded_deletes | 0 |
| Innodb_ibuf_discarded_inserts | 0 |
| Innodb_ibuf_free_list | 57 |
| Innodb_ibuf_merged_delete_marks | 0 |
| Innodb_ibuf_merged_deletes | 0 |
| Innodb_ibuf_merged_inserts | 0 |
| Innodb_ibuf_merges | 0 |
| Innodb_ibuf_segment_size | 68 |
| Innodb_ibuf_size | 10 |
| Innodb_log_waits | 0 |
| Innodb_log_write_requests | 8265399 |
| Innodb_log_writes | 610118 |
| Innodb_lsn_current | 7666247416907 |
| Innodb_lsn_flushed | 7666247415020 |
| Innodb_lsn_last_checkpoint | 7665568111638 |
| Innodb_master_thread_active_loops | 0 |
| Innodb_master_thread_idle_loops | 8652 |
| Innodb_max_trx_id | 2161439615 |
| Innodb_mem_adaptive_hash | 2893901312 |
| Innodb_mem_dictionary | 850974968 |
| Innodb_os_log_fsyncs | 11270 |
| Innodb_os_log_pending_fsyncs | 0 |
| Innodb_os_log_pending_writes | 0 |
| Innodb_os_log_written | 20578182656 |
| Innodb_page_size | 16384 |
| Innodb_pages_created | 601801 |
| Innodb_pages_read | 2012365 |
| Innodb_pages_written | 965393 |
| Innodb_row_lock_current_waits | 0 |
| Innodb_row_lock_time | 4 |
| Innodb_row_lock_time_avg | 0 |
| Innodb_row_lock_time_max | 4 |
| Innodb_row_lock_waits | 9 |
| Innodb_rows_deleted | 45020 |
| Innodb_rows_inserted | 122784 |
| Innodb_rows_read | 1553525237 |
| Innodb_rows_updated | 40916845 |
| Innodb_system_rows_deleted | 3 |
| Innodb_system_rows_inserted | 3 |
| Innodb_system_rows_read | 1761845 |
| Innodb_system_rows_updated | 0 |
| Innodb_num_open_files | 13869 |
| 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 | ON |
| 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 | 237313220 |
| 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 | 214312 |
| 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 | 426 |
| Memory_used | 81776 |
| Memory_used_initial | 327534728 |
| Not_flushed_delayed_rows | 0 |
| Open_files | 26 |
| Open_streams | 4 |
| Open_table_definitions | 11361 |
| Open_tables | 13869 |
| Opened_files | 958604 |
| Opened_plugin_libraries | 0 |
| Opened_table_definitions | 0 |
| Opened_tables | 0 |
| 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 | 11432 |
| Qcache_free_memory | 27114056 |
| Qcache_hits | 11289632 |
| Qcache_inserts | 431080 |
| Qcache_lowmem_prunes | 231261 |
| Qcache_not_cached | 13591 |
| Qcache_queries_in_cache | 30944 |
| Qcache_total_blocks | 106377 |
| Queries | 13217440 |
| Questions | 1 |
| Resultset_metadata_skipped | 0 |
| Rows_read | 0 |
| Rows_sent | 0 |
| Rows_tmp_read | 0 |
| 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 | 0 |
| Select_range_check | 0 |
| Select_scan | 0 |
| 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 | 0 |
| Sort_range | 0 |
| Sort_rows | 0 |
| Sort_scan | 0 |
| 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 | 46108 |
| Subquery_cache_miss | 5690 |
| Syncs | 4469 |
| Table_locks_immediate | 84614 |
| Table_locks_waited | 0 |
| Table_open_cache_active_instances | 1 |
| Table_open_cache_hits | 0 |
| Table_open_cache_misses | 0 |
| 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 | 78 |
| Threads_connected | 6 |
| Threads_created | 439 |
| Threads_running | 1 |
| Transactions_gtid_foreign_engine | 0 |
| Transactions_multi_engine | 0 |
| Update_scan | 0 |
| Uptime | 8992 |
| Uptime_since_flush_status | 8992 |
| wsrep_local_state_uuid | 8c731ceb-88e3-11ec-b86d-9f8b135a1881 |
| wsrep_protocol_version | 10 |
| wsrep_last_committed | 731824218 |
| wsrep_replicated | 25873 |
| wsrep_replicated_bytes | 9109712096 |
| wsrep_repl_keys | 33229814 |
| wsrep_repl_keys_bytes | 266461464 |
| wsrep_repl_data_bytes | 2626255284 |
| wsrep_repl_other_bytes | 0 |
| wsrep_received | 289789 |
| wsrep_received_bytes | 23020160592 |
| wsrep_local_commits | 25872 |
| wsrep_local_cert_failures | 0 |
| wsrep_local_replays | 2 |
| wsrep_local_send_queue | 0 |
| wsrep_local_send_queue_max | 3 |
| wsrep_local_send_queue_min | 0 |
| wsrep_local_send_queue_avg | 0.00648349 |
| wsrep_local_recv_queue | 0 |
| wsrep_local_recv_queue_max | 1976 |
| wsrep_local_recv_queue_min | 0 |
| wsrep_local_recv_queue_avg | 23.8942 |
| wsrep_local_cached_downto | 731823205 |
| wsrep_flow_control_paused_ns | 343410763369 |
| wsrep_flow_control_paused | 0.0381903 |
| wsrep_flow_control_sent | 499 |
| wsrep_flow_control_recv | 499 |
| wsrep_flow_control_active | false |
| wsrep_flow_control_requested | false |
| wsrep_cert_deps_distance | 69.655 |
| wsrep_apply_oooe | 0.117613 |
| wsrep_apply_oool | 0.0185018 |
| wsrep_apply_window | 1.9187 |
| wsrep_apply_waits | 9966 |
| wsrep_commit_oooe | 0 |
| wsrep_commit_oool | 0 |
| wsrep_commit_window | 1.54973 |
| wsrep_local_state | 4 |
| wsrep_local_state_comment | Synced |
| wsrep_cert_index_size | 114 |
| wsrep_causal_reads | 1 |
| wsrep_cert_interval | 244663 |
| wsrep_open_transactions | 0 |
| wsrep_open_connections | 0 |
| wsrep_incoming_addresses | AUTO,AUTO |
| wsrep_cluster_weight | 2 |
| wsrep_desync_count | 0 |
| wsrep_evs_delayed | |
| wsrep_evs_evict_list | |
| wsrep_evs_repl_latency | 0.000146217/0.000381316/0.00114065/9.93354e-05/2466 |
| wsrep_evs_state | OPERATIONAL |
| wsrep_gcomm_uuid | 3cd0d067-0d8d-11ed-bd64-5b7d525ef4fc |
| wsrep_gmcast_segment | 0 |
| wsrep_applier_thread_count | 12 |
| wsrep_cluster_capabilities | |
| wsrep_cluster_conf_id | 8 |
| wsrep_cluster_size | 2 |
| wsrep_cluster_state_uuid | 8c731ceb-88e3-11ec-b86d-9f8b135a1881 |
| wsrep_cluster_status | Primary |
| wsrep_connected | ON |
| wsrep_local_bf_aborts | 3 |
| wsrep_local_index | 1 |
| wsrep_provider_capabilities | :MULTI_MASTER:CERTIFICATION:PARALLEL_APPLYING:TRX_REPLAY:ISOLATION:PAUSE:CAUSAL_READS:INCREMENTAL_WRITESET:UNORDERED:PREORDERED:STREAMING:NBO: |
| wsrep_provider_name | Galera |
| wsrep_provider_vendor | Codership Oy <info@xxxxxxxxxxxxx> |
| wsrep_provider_version | 26.4.11(r67341d07) |
| wsrep_ready | ON |
| wsrep_rollbacker_thread_count | 1 |
| wsrep_thread_count | 13 |
+--------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------+
ubuntu@ovh4:~$
*************************** 1. row ***************************
Variable_name: alter_algorithm
Value: DEFAULT
*************************** 2. row ***************************
Variable_name: analyze_sample_percentage
Value: 0.000000
*************************** 3. row ***************************
Variable_name: aria_block_size
Value: 8192
*************************** 4. row ***************************
Variable_name: aria_checkpoint_interval
Value: 30
*************************** 5. row ***************************
Variable_name: aria_checkpoint_log_activity
Value: 1048576
*************************** 6. row ***************************
Variable_name: aria_encrypt_tables
Value: OFF
*************************** 7. row ***************************
Variable_name: aria_force_start_after_recovery_failures
Value: 0
*************************** 8. row ***************************
Variable_name: aria_group_commit
Value: none
*************************** 9. row ***************************
Variable_name: aria_group_commit_interval
Value: 0
*************************** 10. row ***************************
Variable_name: aria_log_file_size
Value: 1073741824
*************************** 11. row ***************************
Variable_name: aria_log_purge_type
Value: immediate
*************************** 12. row ***************************
Variable_name: aria_max_sort_file_size
Value: 9223372036853727232
*************************** 13. row ***************************
Variable_name: aria_page_checksum
Value: ON
*************************** 14. row ***************************
Variable_name: aria_pagecache_age_threshold
Value: 300
*************************** 15. row ***************************
Variable_name: aria_pagecache_buffer_size
Value: 134217728
*************************** 16. row ***************************
Variable_name: aria_pagecache_division_limit
Value: 100
*************************** 17. row ***************************
Variable_name: aria_pagecache_file_hash_size
Value: 512
*************************** 18. row ***************************
Variable_name: aria_recover_options
Value: BACKUP,QUICK
*************************** 19. row ***************************
Variable_name: aria_repair_threads
Value: 1
*************************** 20. row ***************************
Variable_name: aria_sort_buffer_size
Value: 268434432
*************************** 21. row ***************************
Variable_name: aria_stats_method
Value: nulls_unequal
*************************** 22. row ***************************
Variable_name: aria_sync_log_dir
Value: NEWFILE
*************************** 23. row ***************************
Variable_name: aria_used_for_temp_tables
Value: ON
*************************** 24. row ***************************
Variable_name: auto_increment_increment
Value: 2
*************************** 25. row ***************************
Variable_name: auto_increment_offset
Value: 2
*************************** 26. row ***************************
Variable_name: autocommit
Value: ON
*************************** 27. row ***************************
Variable_name: automatic_sp_privileges
Value: ON
*************************** 28. row ***************************
Variable_name: back_log
Value: 2048
*************************** 29. row ***************************
Variable_name: basedir
Value: /usr
*************************** 30. row ***************************
Variable_name: big_tables
Value: OFF
*************************** 31. row ***************************
Variable_name: bind_address
Value: 0.0.0.0
*************************** 32. row ***************************
Variable_name: binlog_annotate_row_events
Value: ON
*************************** 33. row ***************************
Variable_name: binlog_cache_size
Value: 32768
*************************** 34. row ***************************
Variable_name: binlog_checksum
Value: CRC32
*************************** 35. row ***************************
Variable_name: binlog_commit_wait_count
Value: 0
*************************** 36. row ***************************
Variable_name: binlog_commit_wait_usec
Value: 100000
*************************** 37. row ***************************
Variable_name: binlog_direct_non_transactional_updates
Value: OFF
*************************** 38. row ***************************
Variable_name: binlog_expire_logs_seconds
Value: 86400
*************************** 39. row ***************************
Variable_name: binlog_file_cache_size
Value: 16384
*************************** 40. row ***************************
Variable_name: binlog_format
Value: ROW
*************************** 41. row ***************************
Variable_name: binlog_optimize_thread_scheduling
Value: ON
*************************** 42. row ***************************
Variable_name: binlog_row_image
Value: FULL
*************************** 43. row ***************************
Variable_name: binlog_row_metadata
Value: NO_LOG
*************************** 44. row ***************************
Variable_name: binlog_stmt_cache_size
Value: 32768
*************************** 45. row ***************************
Variable_name: bulk_insert_buffer_size
Value: 67108864
*************************** 46. row ***************************
Variable_name: character_set_client
Value: utf8mb4
*************************** 47. row ***************************
Variable_name: character_set_connection
Value: utf8mb4
*************************** 48. row ***************************
Variable_name: character_set_database
Value: utf8mb4
*************************** 49. row ***************************
Variable_name: character_set_filesystem
Value: binary
*************************** 50. row ***************************
Variable_name: character_set_results
Value: utf8mb4
*************************** 51. row ***************************
Variable_name: character_set_server
Value: utf8mb4
*************************** 52. row ***************************
Variable_name: character_set_system
Value: utf8mb3
*************************** 53. row ***************************
Variable_name: character_sets_dir
Value: /usr/share/mysql/charsets/
*************************** 54. row ***************************
Variable_name: check_constraint_checks
Value: ON
*************************** 55. row ***************************
Variable_name: collation_connection
Value: utf8mb4_general_ci
*************************** 56. row ***************************
Variable_name: collation_database
Value: utf8mb4_general_ci
*************************** 57. row ***************************
Variable_name: collation_server
Value: utf8mb4_general_ci
*************************** 58. row ***************************
Variable_name: column_compression_threshold
Value: 100
*************************** 59. row ***************************
Variable_name: column_compression_zlib_level
Value: 6
*************************** 60. row ***************************
Variable_name: column_compression_zlib_strategy
Value: DEFAULT_STRATEGY
*************************** 61. row ***************************
Variable_name: column_compression_zlib_wrap
Value: OFF
*************************** 62. row ***************************
Variable_name: completion_type
Value: NO_CHAIN
*************************** 63. row ***************************
Variable_name: concurrent_insert
Value: ALWAYS
*************************** 64. row ***************************
Variable_name: connect_timeout
Value: 10
*************************** 65. row ***************************
Variable_name: core_file
Value: OFF
*************************** 66. row ***************************
Variable_name: datadir
Value: /var/lib/mysql/
*************************** 67. row ***************************
Variable_name: date_format
Value: %Y-%m-%d
*************************** 68. row ***************************
Variable_name: datetime_format
Value: %Y-%m-%d %H:%i:%s
*************************** 69. row ***************************
Variable_name: deadlock_search_depth_long
Value: 15
*************************** 70. row ***************************
Variable_name: deadlock_search_depth_short
Value: 4
*************************** 71. row ***************************
Variable_name: deadlock_timeout_long
Value: 50000000
*************************** 72. row ***************************
Variable_name: deadlock_timeout_short
Value: 10000
*************************** 73. row ***************************
Variable_name: debug_no_thread_alarm
Value: OFF
*************************** 74. row ***************************
Variable_name: default_master_connection
Value:
*************************** 75. row ***************************
Variable_name: default_password_lifetime
Value: 0
*************************** 76. row ***************************
Variable_name: default_regex_flags
Value:
*************************** 77. row ***************************
Variable_name: default_storage_engine
Value: InnoDB
*************************** 78. row ***************************
Variable_name: default_tmp_storage_engine
Value:
*************************** 79. row ***************************
Variable_name: default_week_format
Value: 0
*************************** 80. row ***************************
Variable_name: delay_key_write
Value: ON
*************************** 81. row ***************************
Variable_name: delayed_insert_limit
Value: 100
*************************** 82. row ***************************
Variable_name: delayed_insert_timeout
Value: 300
*************************** 83. row ***************************
Variable_name: delayed_queue_size
Value: 1000
*************************** 84. row ***************************
Variable_name: disconnect_on_expired_password
Value: OFF
*************************** 85. row ***************************
Variable_name: div_precision_increment
Value: 4
*************************** 86. row ***************************
Variable_name: encrypt_binlog
Value: OFF
*************************** 87. row ***************************
Variable_name: encrypt_tmp_disk_tables
Value: OFF
*************************** 88. row ***************************
Variable_name: encrypt_tmp_files
Value: OFF
*************************** 89. row ***************************
Variable_name: enforce_storage_engine
Value:
*************************** 90. row ***************************
Variable_name: eq_range_index_dive_limit
Value: 0
*************************** 91. row ***************************
Variable_name: error_count
Value: 0
*************************** 92. row ***************************
Variable_name: event_scheduler
Value: OFF
*************************** 93. row ***************************
Variable_name: expensive_subquery_limit
Value: 100
*************************** 94. row ***************************
Variable_name: expire_logs_days
Value: 1.000000
*************************** 95. row ***************************
Variable_name: explicit_defaults_for_timestamp
Value: OFF
*************************** 96. row ***************************
Variable_name: external_user
Value:
*************************** 97. row ***************************
Variable_name: extra_max_connections
Value: 1
*************************** 98. row ***************************
Variable_name: extra_port
Value: 0
*************************** 99. row ***************************
Variable_name: flush
Value: OFF
*************************** 100. row ***************************
Variable_name: flush_time
Value: 0
*************************** 101. row ***************************
Variable_name: foreign_key_checks
Value: ON
*************************** 102. row ***************************
Variable_name: ft_boolean_syntax
Value: + -><()~*:""&|
*************************** 103. row ***************************
Variable_name: ft_max_word_len
Value: 84
*************************** 104. row ***************************
Variable_name: ft_min_word_len
Value: 4
*************************** 105. row ***************************
Variable_name: ft_query_expansion_limit
Value: 20
*************************** 106. row ***************************
Variable_name: ft_stopword_file
Value: (built-in)
*************************** 107. row ***************************
Variable_name: general_log
Value: OFF
*************************** 108. row ***************************
Variable_name: general_log_file
Value: ovh4.log
*************************** 109. row ***************************
Variable_name: group_concat_max_len
Value: 1048576
*************************** 110. row ***************************
Variable_name: gtid_binlog_pos
Value: 100-1-187777938,300-1-512127
*************************** 111. row ***************************
Variable_name: gtid_binlog_state
Value: 100-1-187777938,300-3-522464027,300-1-512127
*************************** 112. row ***************************
Variable_name: gtid_cleanup_batch_size
Value: 64
*************************** 113. row ***************************
Variable_name: gtid_current_pos
Value: 200-1-957
*************************** 114. row ***************************
Variable_name: gtid_domain_id
Value: 1004
*************************** 115. row ***************************
Variable_name: gtid_ignore_duplicates
Value: OFF
*************************** 116. row ***************************
Variable_name: gtid_pos_auto_engines
Value:
*************************** 117. row ***************************
Variable_name: gtid_seq_no
Value: 0
*************************** 118. row ***************************
Variable_name: gtid_slave_pos
Value: 200-1-957
*************************** 119. row ***************************
Variable_name: gtid_strict_mode
Value: OFF
*************************** 120. row ***************************
Variable_name: have_compress
Value: YES
*************************** 121. row ***************************
Variable_name: have_crypt
Value: YES
*************************** 122. row ***************************
Variable_name: have_dynamic_loading
Value: YES
*************************** 123. row ***************************
Variable_name: have_geometry
Value: YES
*************************** 124. row ***************************
Variable_name: have_openssl
Value: YES
*************************** 125. row ***************************
Variable_name: have_profiling
Value: YES
*************************** 126. row ***************************
Variable_name: have_query_cache
Value: YES
*************************** 127. row ***************************
Variable_name: have_rtree_keys
Value: YES
*************************** 128. row ***************************
Variable_name: have_ssl
Value: DISABLED
*************************** 129. row ***************************
Variable_name: have_symlink
Value: YES
*************************** 130. row ***************************
Variable_name: histogram_size
Value: 0
*************************** 131. row ***************************
Variable_name: histogram_type
Value: SINGLE_PREC_HB
*************************** 132. row ***************************
Variable_name: host_cache_size
Value: 279
*************************** 133. row ***************************
Variable_name: hostname
Value: ovh4.1check.com
*************************** 134. row ***************************
Variable_name: identity
Value: 0
*************************** 135. row ***************************
Variable_name: idle_readonly_transaction_timeout
Value: 0
*************************** 136. row ***************************
Variable_name: idle_transaction_timeout
Value: 0
*************************** 137. row ***************************
Variable_name: idle_write_transaction_timeout
Value: 0
*************************** 138. row ***************************
Variable_name: ignore_builtin_innodb
Value: OFF
*************************** 139. row ***************************
Variable_name: ignore_db_dirs
Value: lost+found
*************************** 140. row ***************************
Variable_name: in_predicate_conversion_threshold
Value: 1000
*************************** 141. row ***************************
Variable_name: in_transaction
Value: 0
*************************** 142. row ***************************
Variable_name: init_connect
Value: SET NAMES utf8mb4
*************************** 143. row ***************************
Variable_name: init_file
Value:
*************************** 144. row ***************************
Variable_name: init_slave
Value:
*************************** 145. row ***************************
Variable_name: innodb_adaptive_flushing
Value: ON
*************************** 146. row ***************************
Variable_name: innodb_adaptive_flushing_lwm
Value: 10.000000
*************************** 147. row ***************************
Variable_name: innodb_adaptive_hash_index
Value: ON
*************************** 148. row ***************************
Variable_name: innodb_adaptive_hash_index_parts
Value: 8
*************************** 149. row ***************************
Variable_name: innodb_autoextend_increment
Value: 64
*************************** 150. row ***************************
Variable_name: innodb_autoinc_lock_mode
Value: 2
*************************** 151. row ***************************
Variable_name: innodb_buf_dump_status_frequency
Value: 0
*************************** 152. row ***************************
Variable_name: innodb_buffer_pool_chunk_size
Value: 134217728
*************************** 153. row ***************************
Variable_name: innodb_buffer_pool_dump_at_shutdown
Value: ON
*************************** 154. row ***************************
Variable_name: innodb_buffer_pool_dump_now
Value: OFF
*************************** 155. row ***************************
Variable_name: innodb_buffer_pool_dump_pct
Value: 25
*************************** 156. row ***************************
Variable_name: innodb_buffer_pool_filename
Value: ib_buffer_pool
*************************** 157. row ***************************
Variable_name: innodb_buffer_pool_load_abort
Value: OFF
*************************** 158. row ***************************
Variable_name: innodb_buffer_pool_load_at_startup
Value: ON
*************************** 159. row ***************************
Variable_name: innodb_buffer_pool_load_now
Value: OFF
*************************** 160. row ***************************
Variable_name: innodb_buffer_pool_size
Value: 103079215104
*************************** 161. row ***************************
Variable_name: innodb_change_buffer_max_size
Value: 25
*************************** 162. row ***************************
Variable_name: innodb_change_buffering
Value: none
*************************** 163. row ***************************
Variable_name: innodb_checksum_algorithm
Value: crc32
*************************** 164. row ***************************
Variable_name: innodb_cmp_per_index_enabled
Value: OFF
*************************** 165. row ***************************
Variable_name: innodb_compression_algorithm
Value: zlib
*************************** 166. row ***************************
Variable_name: innodb_compression_default
Value: OFF
*************************** 167. row ***************************
Variable_name: innodb_compression_failure_threshold_pct
Value: 5
*************************** 168. row ***************************
Variable_name: innodb_compression_level
Value: 6
*************************** 169. row ***************************
Variable_name: innodb_compression_pad_pct_max
Value: 50
*************************** 170. row ***************************
Variable_name: innodb_data_file_path
Value: ibdata1:12M:autoextend
*************************** 171. row ***************************
Variable_name: innodb_data_home_dir
Value:
*************************** 172. row ***************************
Variable_name: innodb_deadlock_detect
Value: ON
*************************** 173. row ***************************
Variable_name: innodb_deadlock_report
Value: full
*************************** 174. row ***************************
Variable_name: innodb_default_encryption_key_id
Value: 1
*************************** 175. row ***************************
Variable_name: innodb_default_row_format
Value: dynamic
*************************** 176. row ***************************
Variable_name: innodb_defragment
Value: OFF
*************************** 177. row ***************************
Variable_name: innodb_defragment_fill_factor
Value: 0.900000
*************************** 178. row ***************************
Variable_name: innodb_defragment_fill_factor_n_recs
Value: 20
*************************** 179. row ***************************
Variable_name: innodb_defragment_frequency
Value: 40
*************************** 180. row ***************************
Variable_name: innodb_defragment_n_pages
Value: 7
*************************** 181. row ***************************
Variable_name: innodb_defragment_stats_accuracy
Value: 0
*************************** 182. row ***************************
Variable_name: innodb_disable_sort_file_cache
Value: OFF
*************************** 183. row ***************************
Variable_name: innodb_disallow_writes
Value: OFF
*************************** 184. row ***************************
Variable_name: innodb_doublewrite
Value: ON
*************************** 185. row ***************************
Variable_name: innodb_encrypt_log
Value: OFF
*************************** 186. row ***************************
Variable_name: innodb_encrypt_tables
Value: OFF
*************************** 187. row ***************************
Variable_name: innodb_encrypt_temporary_tables
Value: OFF
*************************** 188. row ***************************
Variable_name: innodb_encryption_rotate_key_age
Value: 1
*************************** 189. row ***************************
Variable_name: innodb_encryption_rotation_iops
Value: 100
*************************** 190. row ***************************
Variable_name: innodb_encryption_threads
Value: 0
*************************** 191. row ***************************
Variable_name: innodb_fast_shutdown
Value: 1
*************************** 192. row ***************************
Variable_name: innodb_fatal_semaphore_wait_threshold
Value: 600
*************************** 193. row ***************************
Variable_name: innodb_file_per_table
Value: ON
*************************** 194. row ***************************
Variable_name: innodb_fill_factor
Value: 100
*************************** 195. row ***************************
Variable_name: innodb_flush_log_at_timeout
Value: 1
*************************** 196. row ***************************
Variable_name: innodb_flush_log_at_trx_commit
Value: 2
*************************** 197. row ***************************
Variable_name: innodb_flush_method
Value: O_DIRECT
*************************** 198. row ***************************
Variable_name: innodb_flush_neighbors
Value: 0
*************************** 199. row ***************************
Variable_name: innodb_flush_sync
Value: ON
*************************** 200. row ***************************
Variable_name: innodb_flushing_avg_loops
Value: 30
*************************** 201. row ***************************
Variable_name: innodb_force_primary_key
Value: OFF
*************************** 202. row ***************************
Variable_name: innodb_force_recovery
Value: 0
*************************** 203. row ***************************
Variable_name: innodb_ft_aux_table
Value:
*************************** 204. row ***************************
Variable_name: innodb_ft_cache_size
Value: 8000000
*************************** 205. row ***************************
Variable_name: innodb_ft_enable_diag_print
Value: OFF
*************************** 206. row ***************************
Variable_name: innodb_ft_enable_stopword
Value: ON
*************************** 207. row ***************************
Variable_name: innodb_ft_max_token_size
Value: 84
*************************** 208. row ***************************
Variable_name: innodb_ft_min_token_size
Value: 3
*************************** 209. row ***************************
Variable_name: innodb_ft_num_word_optimize
Value: 2000
*************************** 210. row ***************************
Variable_name: innodb_ft_result_cache_limit
Value: 2000000000
*************************** 211. row ***************************
Variable_name: innodb_ft_server_stopword_table
Value:
*************************** 212. row ***************************
Variable_name: innodb_ft_sort_pll_degree
Value: 2
*************************** 213. row ***************************
Variable_name: innodb_ft_total_cache_size
Value: 640000000
*************************** 214. row ***************************
Variable_name: innodb_ft_user_stopword_table
Value:
*************************** 215. row ***************************
Variable_name: innodb_immediate_scrub_data_uncompressed
Value: OFF
*************************** 216. row ***************************
Variable_name: innodb_instant_alter_column_allowed
Value: add_last
*************************** 217. row ***************************
Variable_name: innodb_io_capacity
Value: 200
*************************** 218. row ***************************
Variable_name: innodb_io_capacity_max
Value: 2000
*************************** 219. row ***************************
Variable_name: innodb_lock_wait_timeout
Value: 50
*************************** 220. row ***************************
Variable_name: innodb_log_buffer_size
Value: 268435456
*************************** 221. row ***************************
Variable_name: innodb_log_file_size
Value: 1073741824
*************************** 222. row ***************************
Variable_name: innodb_log_group_home_dir
Value: ./
*************************** 223. row ***************************
Variable_name: innodb_log_write_ahead_size
Value: 8192
*************************** 224. row ***************************
Variable_name: innodb_lru_flush_size
Value: 32
*************************** 225. row ***************************
Variable_name: innodb_lru_scan_depth
Value: 1536
*************************** 226. row ***************************
Variable_name: innodb_max_dirty_pages_pct
Value: 90.000000
*************************** 227. row ***************************
Variable_name: innodb_max_dirty_pages_pct_lwm
Value: 0.000000
*************************** 228. row ***************************
Variable_name: innodb_max_purge_lag
Value: 0
*************************** 229. row ***************************
Variable_name: innodb_max_purge_lag_delay
Value: 0
*************************** 230. row ***************************
Variable_name: innodb_max_purge_lag_wait
Value: 4294967295
*************************** 231. row ***************************
Variable_name: innodb_max_undo_log_size
Value: 10485760
*************************** 232. row ***************************
Variable_name: innodb_monitor_disable
Value:
*************************** 233. row ***************************
Variable_name: innodb_monitor_enable
Value:
*************************** 234. row ***************************
Variable_name: innodb_monitor_reset
Value:
*************************** 235. row ***************************
Variable_name: innodb_monitor_reset_all
Value:
*************************** 236. row ***************************
Variable_name: innodb_numa_interleave
Value: OFF
*************************** 237. row ***************************
Variable_name: innodb_old_blocks_pct
Value: 37
*************************** 238. row ***************************
Variable_name: innodb_old_blocks_time
Value: 1000
*************************** 239. row ***************************
Variable_name: innodb_online_alter_log_max_size
Value: 134217728
*************************** 240. row ***************************
Variable_name: innodb_open_files
Value: 13869
*************************** 241. row ***************************
Variable_name: innodb_optimize_fulltext_only
Value: OFF
*************************** 242. row ***************************
Variable_name: innodb_page_size
Value: 16384
*************************** 243. row ***************************
Variable_name: innodb_prefix_index_cluster_optimization
Value: OFF
*************************** 244. row ***************************
Variable_name: innodb_print_all_deadlocks
Value: OFF
*************************** 245. row ***************************
Variable_name: innodb_purge_batch_size
Value: 300
*************************** 246. row ***************************
Variable_name: innodb_purge_rseg_truncate_frequency
Value: 128
*************************** 247. row ***************************
Variable_name: innodb_purge_threads
Value: 4
*************************** 248. row ***************************
Variable_name: innodb_random_read_ahead
Value: OFF
*************************** 249. row ***************************
Variable_name: innodb_read_ahead_threshold
Value: 56
*************************** 250. row ***************************
Variable_name: innodb_read_io_threads
Value: 9
*************************** 251. row ***************************
Variable_name: innodb_read_only
Value: OFF
*************************** 252. row ***************************
Variable_name: innodb_read_only_compressed
Value: OFF
*************************** 253. row ***************************
Variable_name: innodb_rollback_on_timeout
Value: OFF
*************************** 254. row ***************************
Variable_name: innodb_sort_buffer_size
Value: 1048576
*************************** 255. row ***************************
Variable_name: innodb_spin_wait_delay
Value: 4
*************************** 256. row ***************************
Variable_name: innodb_stats_auto_recalc
Value: ON
*************************** 257. row ***************************
Variable_name: innodb_stats_include_delete_marked
Value: OFF
*************************** 258. row ***************************
Variable_name: innodb_stats_method
Value: nulls_equal
*************************** 259. row ***************************
Variable_name: innodb_stats_modified_counter
Value: 0
*************************** 260. row ***************************
Variable_name: innodb_stats_on_metadata
Value: OFF
*************************** 261. row ***************************
Variable_name: innodb_stats_persistent
Value: ON
*************************** 262. row ***************************
Variable_name: innodb_stats_persistent_sample_pages
Value: 20
*************************** 263. row ***************************
Variable_name: innodb_stats_traditional
Value: ON
*************************** 264. row ***************************
Variable_name: innodb_stats_transient_sample_pages
Value: 8
*************************** 265. row ***************************
Variable_name: innodb_status_output
Value: OFF
*************************** 266. row ***************************
Variable_name: innodb_status_output_locks
Value: OFF
*************************** 267. row ***************************
Variable_name: innodb_strict_mode
Value: ON
*************************** 268. row ***************************
Variable_name: innodb_sync_spin_loops
Value: 30
*************************** 269. row ***************************
Variable_name: innodb_table_locks
Value: ON
*************************** 270. row ***************************
Variable_name: innodb_temp_data_file_path
Value: ibtmp1:12M:autoextend
*************************** 271. row ***************************
Variable_name: innodb_tmpdir
Value: /var/lib/mysql
*************************** 272. row ***************************
Variable_name: innodb_undo_directory
Value: ./
*************************** 273. row ***************************
Variable_name: innodb_undo_log_truncate
Value: OFF
*************************** 274. row ***************************
Variable_name: innodb_undo_tablespaces
Value: 0
*************************** 275. row ***************************
Variable_name: innodb_use_atomic_writes
Value: ON
*************************** 276. row ***************************
Variable_name: innodb_use_native_aio
Value: OFF
*************************** 277. row ***************************
Variable_name: innodb_version
Value: 10.6.7
*************************** 278. row ***************************
Variable_name: innodb_write_io_threads
Value: 9
*************************** 279. row ***************************
Variable_name: insert_id
Value: 0
*************************** 280. row ***************************
Variable_name: interactive_timeout
Value: 28800
*************************** 281. row ***************************
Variable_name: join_buffer_size
Value: 262144
*************************** 282. row ***************************
Variable_name: join_buffer_space_limit
Value: 2097152
*************************** 283. row ***************************
Variable_name: join_cache_level
Value: 2
*************************** 284. row ***************************
Variable_name: keep_files_on_create
Value: OFF
*************************** 285. row ***************************
Variable_name: key_buffer_size
Value: 268435456
*************************** 286. row ***************************
Variable_name: key_cache_age_threshold
Value: 300
*************************** 287. row ***************************
Variable_name: key_cache_block_size
Value: 1024
*************************** 288. row ***************************
Variable_name: key_cache_division_limit
Value: 100
*************************** 289. row ***************************
Variable_name: key_cache_file_hash_size
Value: 512
*************************** 290. row ***************************
Variable_name: key_cache_segments
Value: 4
*************************** 291. row ***************************
Variable_name: large_files_support
Value: ON
*************************** 292. row ***************************
Variable_name: large_page_size
Value: 0
*************************** 293. row ***************************
Variable_name: large_pages
Value: OFF
*************************** 294. row ***************************
Variable_name: last_gtid
Value:
*************************** 295. row ***************************
Variable_name: last_insert_id
Value: 0
*************************** 296. row ***************************
Variable_name: lc_messages
Value: en_US
*************************** 297. row ***************************
Variable_name: lc_messages_dir
Value: /usr/share/mysql
*************************** 298. row ***************************
Variable_name: lc_time_names
Value: en_US
*************************** 299. row ***************************
Variable_name: license
Value: GPL
*************************** 300. row ***************************
Variable_name: local_infile
Value: ON
*************************** 301. row ***************************
Variable_name: lock_wait_timeout
Value: 86400
*************************** 302. row ***************************
Variable_name: locked_in_memory
Value: OFF
*************************** 303. row ***************************
Variable_name: log_bin
Value: ON
*************************** 304. row ***************************
Variable_name: log_bin_basename
Value: /var/lib/mysql/mysql-bin
*************************** 305. row ***************************
Variable_name: log_bin_compress
Value: OFF
*************************** 306. row ***************************
Variable_name: log_bin_compress_min_len
Value: 256
*************************** 307. row ***************************
Variable_name: log_bin_index
Value: /var/lib/mysql/mysql-bin.index
*************************** 308. row ***************************
Variable_name: log_bin_trust_function_creators
Value: OFF
*************************** 309. row ***************************
Variable_name: log_disabled_statements
Value: sp
*************************** 310. row ***************************
Variable_name: log_error
Value: /var/log/mysql/error.log
*************************** 311. row ***************************
Variable_name: log_output
Value: FILE
*************************** 312. row ***************************
Variable_name: log_queries_not_using_indexes
Value: OFF
*************************** 313. row ***************************
Variable_name: log_slave_updates
Value: ON
*************************** 314. row ***************************
Variable_name: log_slow_admin_statements
Value: ON
*************************** 315. row ***************************
Variable_name: log_slow_disabled_statements
Value: sp
*************************** 316. row ***************************
Variable_name: log_slow_filter
Value: admin,filesort,filesort_on_disk,filesort_priority_queue,full_join,full_scan,query_cache,query_cache_miss,tmp_table,tmp_table_on_disk
*************************** 317. row ***************************
Variable_name: log_slow_rate_limit
Value: 1
*************************** 318. row ***************************
Variable_name: log_slow_slave_statements
Value: ON
*************************** 319. row ***************************
Variable_name: log_slow_verbosity
Value:
*************************** 320. row ***************************
Variable_name: log_tc_size
Value: 24576
*************************** 321. row ***************************
Variable_name: log_warnings
Value: 2
*************************** 322. row ***************************
Variable_name: long_query_time
Value: 0.500000
*************************** 323. row ***************************
Variable_name: low_priority_updates
Value: OFF
*************************** 324. row ***************************
Variable_name: lower_case_file_system
Value: OFF
*************************** 325. row ***************************
Variable_name: lower_case_table_names
Value: 0
*************************** 326. row ***************************
Variable_name: master_verify_checksum
Value: OFF
*************************** 327. row ***************************
Variable_name: max_allowed_packet
Value: 16777216
*************************** 328. row ***************************
Variable_name: max_binlog_cache_size
Value: 18446744073709547520
*************************** 329. row ***************************
Variable_name: max_binlog_size
Value: 1073741824
*************************** 330. row ***************************
Variable_name: max_binlog_stmt_cache_size
Value: 18446744073709547520
*************************** 331. row ***************************
Variable_name: max_connect_errors
Value: 100
*************************** 332. row ***************************
Variable_name: max_connections
Value: 5000
*************************** 333. row ***************************
Variable_name: max_delayed_threads
Value: 20
*************************** 334. row ***************************
Variable_name: max_digest_length
Value: 1024
*************************** 335. row ***************************
Variable_name: max_error_count
Value: 64
*************************** 336. row ***************************
Variable_name: max_heap_table_size
Value: 52428800
*************************** 337. row ***************************
Variable_name: max_insert_delayed_threads
Value: 20
*************************** 338. row ***************************
Variable_name: max_join_size
Value: 18446744073709551615
*************************** 339. row ***************************
Variable_name: max_length_for_sort_data
Value: 1024
*************************** 340. row ***************************
Variable_name: max_password_errors
Value: 4294967295
*************************** 341. row ***************************
Variable_name: max_prepared_stmt_count
Value: 16382
*************************** 342. row ***************************
Variable_name: max_recursive_iterations
Value: 1000
*************************** 343. row ***************************
Variable_name: max_relay_log_size
Value: 1073741824
*************************** 344. row ***************************
Variable_name: max_rowid_filter_size
Value: 131072
*************************** 345. row ***************************
Variable_name: max_seeks_for_key
Value: 4294967295
*************************** 346. row ***************************
Variable_name: max_session_mem_used
Value: 9223372036854775807
*************************** 347. row ***************************
Variable_name: max_sort_length
Value: 1024
*************************** 348. row ***************************
Variable_name: max_sp_recursion_depth
Value: 0
*************************** 349. row ***************************
Variable_name: max_statement_time
Value: 0.000000
*************************** 350. row ***************************
Variable_name: max_tmp_tables
Value: 32
*************************** 351. row ***************************
Variable_name: max_user_connections
Value: 0
*************************** 352. row ***************************
Variable_name: max_write_lock_count
Value: 4294967295
*************************** 353. row ***************************
Variable_name: metadata_locks_cache_size
Value: 1024
*************************** 354. row ***************************
Variable_name: metadata_locks_hash_instances
Value: 8
*************************** 355. row ***************************
Variable_name: min_examined_row_limit
Value: 0
*************************** 356. row ***************************
Variable_name: mrr_buffer_size
Value: 262144
*************************** 357. row ***************************
Variable_name: myisam_block_size
Value: 1024
*************************** 358. row ***************************
Variable_name: myisam_data_pointer_size
Value: 6
*************************** 359. row ***************************
Variable_name: myisam_max_sort_file_size
Value: 9223372036853727232
*************************** 360. row ***************************
Variable_name: myisam_mmap_size
Value: 18446744073709551615
*************************** 361. row ***************************
Variable_name: myisam_recover_options
Value: BACKUP,QUICK
*************************** 362. row ***************************
Variable_name: myisam_repair_threads
Value: 1
*************************** 363. row ***************************
Variable_name: myisam_sort_buffer_size
Value: 134216704
*************************** 364. row ***************************
Variable_name: myisam_stats_method
Value: NULLS_UNEQUAL
*************************** 365. row ***************************
Variable_name: myisam_use_mmap
Value: OFF
*************************** 366. row ***************************
Variable_name: mysql56_temporal_format
Value: ON
*************************** 367. row ***************************
Variable_name: net_buffer_length
Value: 16384
*************************** 368. row ***************************
Variable_name: net_read_timeout
Value: 30
*************************** 369. row ***************************
Variable_name: net_retry_count
Value: 10
*************************** 370. row ***************************
Variable_name: net_write_timeout
Value: 60
*************************** 371. row ***************************
Variable_name: old
Value: OFF
*************************** 372. row ***************************
Variable_name: old_alter_table
Value: DEFAULT
*************************** 373. row ***************************
Variable_name: old_mode
Value: UTF8_IS_UTF8MB3
*************************** 374. row ***************************
Variable_name: old_passwords
Value: OFF
*************************** 375. row ***************************
Variable_name: open_files_limit
Value: 32768
*************************** 376. row ***************************
Variable_name: optimizer_max_sel_arg_weight
Value: 32000
*************************** 377. row ***************************
Variable_name: optimizer_prune_level
Value: 1
*************************** 378. row ***************************
Variable_name: optimizer_search_depth
Value: 0
*************************** 379. row ***************************
Variable_name: optimizer_selectivity_sampling_limit
Value: 100
*************************** 380. row ***************************
Variable_name: optimizer_switch
Value: index_merge=on,index_merge_union=on,index_merge_sort_union=on,index_merge_intersection=on,index_merge_sort_intersection=off,engine_condition_pushdown=off,index_condition_pushdown=on,derived_merge=on,derived_with_keys=on,firstmatch=on,loosescan=on,materialization=on,in_to_exists=on,semijoin=on,partial_match_rowid_merge=on,partial_match_table_scan=on,subquery_cache=on,mrr=off,mrr_cost_based=off,mrr_sort_keys=off,outer_join_with_cache=on,semijoin_with_cache=on,join_cache_incremental=on,join_cache_hashed=on,join_cache_bka=on,optimize_join_buffer_size=on,table_elimination=on,extended_keys=on,exists_to_in=on,orderby_uses_equalities=on,condition_pushdown_for_derived=on,split_materialized=on,condition_pushdown_for_subquery=on,rowid_filter=on,condition_pushdown_from_having=on,not_null_range_scan=off
*************************** 381. row ***************************
Variable_name: optimizer_trace
Value: enabled=off
*************************** 382. row ***************************
Variable_name: optimizer_trace_max_mem_size
Value: 1048576
*************************** 383. row ***************************
Variable_name: optimizer_use_condition_selectivity
Value: 4
*************************** 384. row ***************************
Variable_name: performance_schema
Value: OFF
*************************** 385. row ***************************
Variable_name: performance_schema_accounts_size
Value: -1
*************************** 386. row ***************************
Variable_name: performance_schema_digests_size
Value: -1
*************************** 387. row ***************************
Variable_name: performance_schema_events_stages_history_long_size
Value: -1
*************************** 388. row ***************************
Variable_name: performance_schema_events_stages_history_size
Value: -1
*************************** 389. row ***************************
Variable_name: performance_schema_events_statements_history_long_size
Value: -1
*************************** 390. row ***************************
Variable_name: performance_schema_events_statements_history_size
Value: -1
*************************** 391. row ***************************
Variable_name: performance_schema_events_transactions_history_long_size
Value: -1
*************************** 392. row ***************************
Variable_name: performance_schema_events_transactions_history_size
Value: -1
*************************** 393. row ***************************
Variable_name: performance_schema_events_waits_history_long_size
Value: -1
*************************** 394. row ***************************
Variable_name: performance_schema_events_waits_history_size
Value: -1
*************************** 395. row ***************************
Variable_name: performance_schema_hosts_size
Value: -1
*************************** 396. row ***************************
Variable_name: performance_schema_max_cond_classes
Value: 90
*************************** 397. row ***************************
Variable_name: performance_schema_max_cond_instances
Value: -1
*************************** 398. row ***************************
Variable_name: performance_schema_max_digest_length
Value: 1024
*************************** 399. row ***************************
Variable_name: performance_schema_max_file_classes
Value: 80
*************************** 400. row ***************************
Variable_name: performance_schema_max_file_handles
Value: 32768
*************************** 401. row ***************************
Variable_name: performance_schema_max_file_instances
Value: -1
*************************** 402. row ***************************
Variable_name: performance_schema_max_index_stat
Value: -1
*************************** 403. row ***************************
Variable_name: performance_schema_max_memory_classes
Value: 320
*************************** 404. row ***************************
Variable_name: performance_schema_max_metadata_locks
Value: -1
*************************** 405. row ***************************
Variable_name: performance_schema_max_mutex_classes
Value: 210
*************************** 406. row ***************************
Variable_name: performance_schema_max_mutex_instances
Value: -1
*************************** 407. row ***************************
Variable_name: performance_schema_max_prepared_statements_instances
Value: -1
*************************** 408. row ***************************
Variable_name: performance_schema_max_program_instances
Value: -1
*************************** 409. row ***************************
Variable_name: performance_schema_max_rwlock_classes
Value: 50
*************************** 410. row ***************************
Variable_name: performance_schema_max_rwlock_instances
Value: -1
*************************** 411. row ***************************
Variable_name: performance_schema_max_socket_classes
Value: 10
*************************** 412. row ***************************
Variable_name: performance_schema_max_socket_instances
Value: -1
*************************** 413. row ***************************
Variable_name: performance_schema_max_sql_text_length
Value: 1024
*************************** 414. row ***************************
Variable_name: performance_schema_max_stage_classes
Value: 160
*************************** 415. row ***************************
Variable_name: performance_schema_max_statement_classes
Value: 222
*************************** 416. row ***************************
Variable_name: performance_schema_max_statement_stack
Value: 10
*************************** 417. row ***************************
Variable_name: performance_schema_max_table_handles
Value: -1
*************************** 418. row ***************************
Variable_name: performance_schema_max_table_instances
Value: -1
*************************** 419. row ***************************
Variable_name: performance_schema_max_table_lock_stat
Value: -1
*************************** 420. row ***************************
Variable_name: performance_schema_max_thread_classes
Value: 50
*************************** 421. row ***************************
Variable_name: performance_schema_max_thread_instances
Value: -1
*************************** 422. row ***************************
Variable_name: performance_schema_session_connect_attrs_size
Value: -1
*************************** 423. row ***************************
Variable_name: performance_schema_setup_actors_size
Value: -1
*************************** 424. row ***************************
Variable_name: performance_schema_setup_objects_size
Value: -1
*************************** 425. row ***************************
Variable_name: performance_schema_users_size
Value: -1
*************************** 426. row ***************************
Variable_name: pid_file
Value: /run/mysqld/mysqld.pid
*************************** 427. row ***************************
Variable_name: plugin_dir
Value: /usr/lib/mysql/plugin/
*************************** 428. row ***************************
Variable_name: plugin_maturity
Value: gamma
*************************** 429. row ***************************
Variable_name: port
Value: 3306
*************************** 430. row ***************************
Variable_name: preload_buffer_size
Value: 32768
*************************** 431. row ***************************
Variable_name: profiling
Value: OFF
*************************** 432. row ***************************
Variable_name: profiling_history_size
Value: 15
*************************** 433. row ***************************
Variable_name: progress_report_time
Value: 5
*************************** 434. row ***************************
Variable_name: protocol_version
Value: 10
*************************** 435. row ***************************
Variable_name: proxy_protocol_networks
Value:
*************************** 436. row ***************************
Variable_name: proxy_user
Value:
*************************** 437. row ***************************
Variable_name: pseudo_slave_mode
Value: OFF
*************************** 438. row ***************************
Variable_name: pseudo_thread_id
Value: 492409
*************************** 439. row ***************************
Variable_name: query_alloc_block_size
Value: 16384
*************************** 440. row ***************************
Variable_name: query_cache_limit
Value: 1048576
*************************** 441. row ***************************
Variable_name: query_cache_min_res_unit
Value: 4096
*************************** 442. row ***************************
Variable_name: query_cache_size
Value: 268435456
*************************** 443. row ***************************
Variable_name: query_cache_strip_comments
Value: OFF
*************************** 444. row ***************************
Variable_name: query_cache_type
Value: ON
*************************** 445. row ***************************
Variable_name: query_cache_wlock_invalidate
Value: OFF
*************************** 446. row ***************************
Variable_name: query_prealloc_size
Value: 24576
*************************** 447. row ***************************
Variable_name: rand_seed1
Value: 1042595001
*************************** 448. row ***************************
Variable_name: rand_seed2
Value: 170431089
*************************** 449. row ***************************
Variable_name: range_alloc_block_size
Value: 4096
*************************** 450. row ***************************
Variable_name: read_binlog_speed_limit
Value: 0
*************************** 451. row ***************************
Variable_name: read_buffer_size
Value: 131072
*************************** 452. row ***************************
Variable_name: read_only
Value: OFF
*************************** 453. row ***************************
Variable_name: read_rnd_buffer_size
Value: 262144
*************************** 454. row ***************************
Variable_name: relay_log
Value:
*************************** 455. row ***************************
Variable_name: relay_log_basename
Value:
*************************** 456. row ***************************
Variable_name: relay_log_index
Value:
*************************** 457. row ***************************
Variable_name: relay_log_info_file
Value: relay-log.info
*************************** 458. row ***************************
Variable_name: relay_log_purge
Value: ON
*************************** 459. row ***************************
Variable_name: relay_log_recovery
Value: OFF
*************************** 460. row ***************************
Variable_name: relay_log_space_limit
Value: 0
*************************** 461. row ***************************
Variable_name: replicate_annotate_row_events
Value: ON
*************************** 462. row ***************************
Variable_name: replicate_do_db
Value:
*************************** 463. row ***************************
Variable_name: replicate_do_table
Value:
*************************** 464. row ***************************
Variable_name: replicate_events_marked_for_skip
Value: REPLICATE
*************************** 465. row ***************************
Variable_name: replicate_ignore_db
Value:
*************************** 466. row ***************************
Variable_name: replicate_ignore_table
Value:
*************************** 467. row ***************************
Variable_name: replicate_wild_do_table
Value:
*************************** 468. row ***************************
Variable_name: replicate_wild_ignore_table
Value:
*************************** 469. row ***************************
Variable_name: report_host
Value:
*************************** 470. row ***************************
Variable_name: report_password
Value:
*************************** 471. row ***************************
Variable_name: report_port
Value: 3306
*************************** 472. row ***************************
Variable_name: report_user
Value:
*************************** 473. row ***************************
Variable_name: require_secure_transport
Value: OFF
*************************** 474. row ***************************
Variable_name: rowid_merge_buff_size
Value: 8388608
*************************** 475. row ***************************
Variable_name: rpl_semi_sync_master_enabled
Value: OFF
*************************** 476. row ***************************
Variable_name: rpl_semi_sync_master_timeout
Value: 10000
*************************** 477. row ***************************
Variable_name: rpl_semi_sync_master_trace_level
Value: 32
*************************** 478. row ***************************
Variable_name: rpl_semi_sync_master_wait_no_slave
Value: ON
*************************** 479. row ***************************
Variable_name: rpl_semi_sync_master_wait_point
Value: AFTER_COMMIT
*************************** 480. row ***************************
Variable_name: rpl_semi_sync_slave_delay_master
Value: OFF
*************************** 481. row ***************************
Variable_name: rpl_semi_sync_slave_enabled
Value: OFF
*************************** 482. row ***************************
Variable_name: rpl_semi_sync_slave_kill_conn_timeout
Value: 5
*************************** 483. row ***************************
Variable_name: rpl_semi_sync_slave_trace_level
Value: 32
*************************** 484. row ***************************
Variable_name: secure_auth
Value: ON
*************************** 485. row ***************************
Variable_name: secure_file_priv
Value:
*************************** 486. row ***************************
Variable_name: secure_timestamp
Value: NO
*************************** 487. row ***************************
Variable_name: server_id
Value: 3
*************************** 488. row ***************************
Variable_name: session_track_schema
Value: ON
*************************** 489. row ***************************
Variable_name: session_track_state_change
Value: OFF
*************************** 490. row ***************************
Variable_name: session_track_system_variables
Value: autocommit,character_set_client,character_set_connection,character_set_results,time_zone
*************************** 491. row ***************************
Variable_name: session_track_transaction_info
Value: OFF
*************************** 492. row ***************************
Variable_name: skip_external_locking
Value: ON
*************************** 493. row ***************************
Variable_name: skip_name_resolve
Value: ON
*************************** 494. row ***************************
Variable_name: skip_networking
Value: OFF
*************************** 495. row ***************************
Variable_name: skip_parallel_replication
Value: OFF
*************************** 496. row ***************************
Variable_name: skip_replication
Value: OFF
*************************** 497. row ***************************
Variable_name: skip_show_database
Value: OFF
*************************** 498. row ***************************
Variable_name: slave_compressed_protocol
Value: OFF
*************************** 499. row ***************************
Variable_name: slave_ddl_exec_mode
Value: IDEMPOTENT
*************************** 500. row ***************************
Variable_name: slave_domain_parallel_threads
Value: 0
*************************** 501. row ***************************
Variable_name: slave_exec_mode
Value: STRICT
*************************** 502. row ***************************
Variable_name: slave_load_tmpdir
Value: /tmp
*************************** 503. row ***************************
Variable_name: slave_max_allowed_packet
Value: 1073741824
*************************** 504. row ***************************
Variable_name: slave_net_timeout
Value: 60
*************************** 505. row ***************************
Variable_name: slave_parallel_max_queued
Value: 131072
*************************** 506. row ***************************
Variable_name: slave_parallel_mode
Value: conservative
*************************** 507. row ***************************
Variable_name: slave_parallel_threads
Value: 0
*************************** 508. row ***************************
Variable_name: slave_parallel_workers
Value: 0
*************************** 509. row ***************************
Variable_name: slave_run_triggers_for_rbr
Value: NO
*************************** 510. row ***************************
Variable_name: slave_skip_errors
Value: 1032,1047,1062
*************************** 511. row ***************************
Variable_name: slave_sql_verify_checksum
Value: ON
*************************** 512. row ***************************
Variable_name: slave_transaction_retries
Value: 10
*************************** 513. row ***************************
Variable_name: slave_transaction_retry_errors
Value: 1158,1159,1160,1161,1205,1213,1429,2013,12701,1213,1205
*************************** 514. row ***************************
Variable_name: slave_transaction_retry_interval
Value: 0
*************************** 515. row ***************************
Variable_name: slave_type_conversions
Value:
*************************** 516. row ***************************
Variable_name: slow_launch_time
Value: 1
*************************** 517. row ***************************
Variable_name: slow_query_log
Value: ON
*************************** 518. row ***************************
Variable_name: slow_query_log_file
Value: /var/log/mysql/mysql-slow.log
*************************** 519. row ***************************
Variable_name: socket
Value: /run/mysqld/mysqld.sock
*************************** 520. row ***************************
Variable_name: sort_buffer_size
Value: 2097152
*************************** 521. row ***************************
Variable_name: sql_auto_is_null
Value: OFF
*************************** 522. row ***************************
Variable_name: sql_big_selects
Value: ON
*************************** 523. row ***************************
Variable_name: sql_buffer_result
Value: OFF
*************************** 524. row ***************************
Variable_name: sql_if_exists
Value: OFF
*************************** 525. row ***************************
Variable_name: sql_log_bin
Value: ON
*************************** 526. row ***************************
Variable_name: sql_log_off
Value: OFF
*************************** 527. row ***************************
Variable_name: sql_mode
Value: STRICT_TRANS_TABLES,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION
*************************** 528. row ***************************
Variable_name: sql_notes
Value: ON
*************************** 529. row ***************************
Variable_name: sql_quote_show_create
Value: ON
*************************** 530. row ***************************
Variable_name: sql_safe_updates
Value: OFF
*************************** 531. row ***************************
Variable_name: sql_select_limit
Value: 18446744073709551615
*************************** 532. row ***************************
Variable_name: sql_slave_skip_counter
Value: 0
*************************** 533. row ***************************
Variable_name: sql_warnings
Value: OFF
*************************** 534. row ***************************
Variable_name: ssl_ca
Value:
*************************** 535. row ***************************
Variable_name: ssl_capath
Value:
*************************** 536. row ***************************
Variable_name: ssl_cert
Value:
*************************** 537. row ***************************
Variable_name: ssl_cipher
Value:
*************************** 538. row ***************************
Variable_name: ssl_crl
Value:
*************************** 539. row ***************************
Variable_name: ssl_crlpath
Value:
*************************** 540. row ***************************
Variable_name: ssl_key
Value:
*************************** 541. row ***************************
Variable_name: standard_compliant_cte
Value: ON
*************************** 542. row ***************************
Variable_name: storage_engine
Value: InnoDB
*************************** 543. row ***************************
Variable_name: stored_program_cache
Value: 256
*************************** 544. row ***************************
Variable_name: strict_password_validation
Value: ON
*************************** 545. row ***************************
Variable_name: sync_binlog
Value: 0
*************************** 546. row ***************************
Variable_name: sync_frm
Value: ON
*************************** 547. row ***************************
Variable_name: sync_master_info
Value: 10000
*************************** 548. row ***************************
Variable_name: sync_relay_log
Value: 10000
*************************** 549. row ***************************
Variable_name: sync_relay_log_info
Value: 10000
*************************** 550. row ***************************
Variable_name: system_time_zone
Value: CEST
*************************** 551. row ***************************
Variable_name: system_versioning_alter_history
Value: ERROR
*************************** 552. row ***************************
Variable_name: system_versioning_asof
Value: DEFAULT
*************************** 553. row ***************************
Variable_name: table_definition_cache
Value: 400
*************************** 554. row ***************************
Variable_name: table_open_cache
Value: 13869
*************************** 555. row ***************************
Variable_name: table_open_cache_instances
Value: 1
*************************** 556. row ***************************
Variable_name: tcp_keepalive_interval
Value: 0
*************************** 557. row ***************************
Variable_name: tcp_keepalive_probes
Value: 0
*************************** 558. row ***************************
Variable_name: tcp_keepalive_time
Value: 0
*************************** 559. row ***************************
Variable_name: tcp_nodelay
Value: ON
*************************** 560. row ***************************
Variable_name: thread_cache_size
Value: 256
*************************** 561. row ***************************
Variable_name: thread_handling
Value: one-thread-per-connection
*************************** 562. row ***************************
Variable_name: thread_pool_dedicated_listener
Value: OFF
*************************** 563. row ***************************
Variable_name: thread_pool_exact_stats
Value: OFF
*************************** 564. row ***************************
Variable_name: thread_pool_idle_timeout
Value: 60
*************************** 565. row ***************************
Variable_name: thread_pool_max_threads
Value: 65536
*************************** 566. row ***************************
Variable_name: thread_pool_oversubscribe
Value: 3
*************************** 567. row ***************************
Variable_name: thread_pool_prio_kickup_timer
Value: 1000
*************************** 568. row ***************************
Variable_name: thread_pool_priority
Value: auto
*************************** 569. row ***************************
Variable_name: thread_pool_size
Value: 12
*************************** 570. row ***************************
Variable_name: thread_pool_stall_limit
Value: 500
*************************** 571. row ***************************
Variable_name: thread_stack
Value: 299008
*************************** 572. row ***************************
Variable_name: time_format
Value: %H:%i:%s
*************************** 573. row ***************************
Variable_name: time_zone
Value: SYSTEM
*************************** 574. row ***************************
Variable_name: timestamp
Value: 1658925038.915376
*************************** 575. row ***************************
Variable_name: tls_version
Value: TLSv1.1,TLSv1.2,TLSv1.3
*************************** 576. row ***************************
Variable_name: tmp_disk_table_size
Value: 18446744073709551615
*************************** 577. row ***************************
Variable_name: tmp_memory_table_size
Value: 16777216
*************************** 578. row ***************************
Variable_name: tmp_table_size
Value: 16777216
*************************** 579. row ***************************
Variable_name: tmpdir
Value: /tmp
*************************** 580. row ***************************
Variable_name: transaction_alloc_block_size
Value: 8192
*************************** 581. row ***************************
Variable_name: transaction_prealloc_size
Value: 4096
*************************** 582. row ***************************
Variable_name: tx_isolation
Value: REPEATABLE-READ
*************************** 583. row ***************************
Variable_name: tx_read_only
Value: OFF
*************************** 584. row ***************************
Variable_name: unique_checks
Value: ON
*************************** 585. row ***************************
Variable_name: updatable_views_with_limit
Value: YES
*************************** 586. row ***************************
Variable_name: use_stat_tables
Value: PREFERABLY_FOR_QUERIES
*************************** 587. row ***************************
Variable_name: userstat
Value: OFF
*************************** 588. row ***************************
Variable_name: version
Value: 10.6.7-MariaDB-2ubuntu1.1-log
*************************** 589. row ***************************
Variable_name: version_comment
Value: Ubuntu 22.04
*************************** 590. row ***************************
Variable_name: version_compile_machine
Value: x86_64
*************************** 591. row ***************************
Variable_name: version_compile_os
Value: debian-linux-gnu
*************************** 592. row ***************************
Variable_name: version_malloc_library
Value: system
*************************** 593. row ***************************
Variable_name: version_source_revision
Value:
*************************** 594. row ***************************
Variable_name: version_ssl_library
Value: OpenSSL 3.0.2 15 Mar 2022
*************************** 595. row ***************************
Variable_name: wait_timeout
Value: 28800
*************************** 596. row ***************************
Variable_name: warning_count
Value: 0
*************************** 597. row ***************************
Variable_name: wsrep_osu_method
Value: TOI
*************************** 598. row ***************************
Variable_name: wsrep_sr_store
Value: table
*************************** 599. row ***************************
Variable_name: wsrep_auto_increment_control
Value: ON
*************************** 600. row ***************************
Variable_name: wsrep_causal_reads
Value: OFF
*************************** 601. row ***************************
Variable_name: wsrep_certification_rules
Value: strict
*************************** 602. row ***************************
Variable_name: wsrep_certify_nonpk
Value: ON
*************************** 603. row ***************************
Variable_name: wsrep_cluster_address
Value: gcomm://192.168.0.2,192.168.0.3,192.168.0.4,192.168.0.5
*************************** 604. row ***************************
Variable_name: wsrep_cluster_name
Value: MariaDB Galera Cluster
*************************** 605. row ***************************
Variable_name: wsrep_convert_lock_to_trx
Value: OFF
*************************** 606. row ***************************
Variable_name: wsrep_data_home_dir
Value: /var/lib/mysql/
*************************** 607. row ***************************
Variable_name: wsrep_dbug_option
Value:
*************************** 608. row ***************************
Variable_name: wsrep_debug
Value: NONE
*************************** 609. row ***************************
Variable_name: wsrep_desync
Value: OFF
*************************** 610. row ***************************
Variable_name: wsrep_dirty_reads
Value: OFF
*************************** 611. row ***************************
Variable_name: wsrep_drupal_282555_workaround
Value: OFF
*************************** 612. row ***************************
Variable_name: wsrep_forced_binlog_format
Value: NONE
*************************** 613. row ***************************
Variable_name: wsrep_gtid_domain_id
Value: 300
*************************** 614. row ***************************
Variable_name: wsrep_gtid_mode
Value: ON
*************************** 615. row ***************************
Variable_name: wsrep_gtid_seq_no
Value: 0
*************************** 616. row ***************************
Variable_name: wsrep_ignore_apply_errors
Value: 7
*************************** 617. row ***************************
Variable_name: wsrep_load_data_splitting
Value: OFF
*************************** 618. row ***************************
Variable_name: wsrep_log_conflicts
Value: OFF
*************************** 619. row ***************************
Variable_name: wsrep_max_ws_rows
Value: 0
*************************** 620. row ***************************
Variable_name: wsrep_max_ws_size
Value: 2147483647
*************************** 621. row ***************************
Variable_name: wsrep_mode
Value:
*************************** 622. row ***************************
Variable_name: wsrep_mysql_replication_bundle
Value: 0
*************************** 623. row ***************************
Variable_name: wsrep_node_address
Value: 192.168.0.4
*************************** 624. row ***************************
Variable_name: wsrep_node_incoming_address
Value: AUTO
*************************** 625. row ***************************
Variable_name: wsrep_node_name
Value: ovh4.1check.com
*************************** 626. row ***************************
Variable_name: wsrep_notify_cmd
Value:
*************************** 627. row ***************************
Variable_name: wsrep_on
Value: ON
*************************** 628. row ***************************
Variable_name: wsrep_patch_version
Value: wsrep_26.22
*************************** 629. row ***************************
Variable_name: wsrep_provider
Value: /usr/lib/galera/libgalera_smm.so
*************************** 630. row ***************************
Variable_name: wsrep_provider_options
Value: base_dir = /var/lib/mysql/; base_host = 192.168.0.4; base_port = 4567; cert.log_conflicts = no; cert.optimistic_pa = yes; debug = no; evs.auto_evict = 0; evs.causal_keepalive_period = PT1S; evs.debug_log_mask = 0x1; evs.delay_margin = PT1S; evs.delayed_keep_period = PT30S; evs.inactive_check_period = PT0.5S; evs.inactive_timeout = PT15S; evs.info_log_mask = 0; evs.install_timeout = PT7.5S; evs.join_retrans_period = PT1S; evs.keepalive_period = PT1S; evs.max_install_timeouts = 3; evs.send_window = 4; evs.stats_report_period = PT1M; evs.suspect_timeout = PT5S; evs.use_aggregate = true; evs.user_send_window = 2; evs.version = 1; evs.view_forget_timeout = P1D; gcache.dir = /var/lib/mysql/; gcache.keep_pages_size = 0; gcache.keep_plaintext_size = 128M; gcache.mem_size = 0; gcache.name = galera.cache; gcache.page_size = 128M; gcache.recover = yes; gcache.size = 128M; gcomm.thread_prio = ; gcs.fc_debug = 0; gcs.fc_factor = 1.0; gcs.fc_limit = 16; gcs.fc_master_slave = no; gcs.fc_single_primary = no; gcs.max_packet_size = 64500; gcs.max_throttle = 0.25; gcs.recv_q_hard_limit = 9223372036854775807; gcs.recv_q_soft_limit = 0.25; gcs.sync_donor = no; gmcast.listen_addr = tcp://0.0.0.0:4567; gmcast.mcast_addr = ; gmcast.mcast_ttl = 1; gmcast.peer_timeout = PT3S; gmcast.segment = 0; gmcast.time_wait = PT5S; gmcast.version = 0; ist.recv_addr = 192.168.0.4; pc.announce_timeout = PT3S; pc.checksum = false; pc.ignore_quorum = false; pc.ignore_sb = false; pc.linger = PT20S; pc.npvo = false; pc.recovery = true; pc.version = 0; pc.wait_prim = true; pc.wait_prim_timeout = PT30S; pc.weight = 1; protonet.backend = asio; protonet.version = 0; repl.causal_read_timeout = PT30S; repl.commit_order = 3; repl.key_format = FLAT8; repl.max_ws_size = 2147483647; repl.proto_max = 10; socket.checksum = 2; socket.recv_buf_size = auto; socket.send_buf_size = auto;
*************************** 631. row ***************************
Variable_name: wsrep_recover
Value: OFF
*************************** 632. row ***************************
Variable_name: wsrep_reject_queries
Value: NONE
*************************** 633. row ***************************
Variable_name: wsrep_replicate_myisam
Value: OFF
*************************** 634. row ***************************
Variable_name: wsrep_restart_slave
Value: OFF
*************************** 635. row ***************************
Variable_name: wsrep_retry_autocommit
Value: 1
*************************** 636. row ***************************
Variable_name: wsrep_slave_fk_checks
Value: ON
*************************** 637. row ***************************
Variable_name: wsrep_slave_uk_checks
Value: OFF
*************************** 638. row ***************************
Variable_name: wsrep_slave_threads
Value: 12
*************************** 639. row ***************************
Variable_name: wsrep_sst_auth
Value: ********
*************************** 640. row ***************************
Variable_name: wsrep_sst_donor
Value:
*************************** 641. row ***************************
Variable_name: wsrep_sst_donor_rejects_queries
Value: OFF
*************************** 642. row ***************************
Variable_name: wsrep_sst_method
Value: mariabackup
*************************** 643. row ***************************
Variable_name: wsrep_sst_receive_address
Value: AUTO
*************************** 644. row ***************************
Variable_name: wsrep_start_position
Value: 8c731ceb-88e3-11ec-b86d-9f8b135a1881:731512032,300-1-197474
*************************** 645. row ***************************
Variable_name: wsrep_strict_ddl
Value: OFF
*************************** 646. row ***************************
Variable_name: wsrep_sync_wait
Value: 0
*************************** 647. row ***************************
Variable_name: wsrep_trx_fragment_size
Value: 0
*************************** 648. row ***************************
Variable_name: wsrep_trx_fragment_unit
Value: bytes
ubuntu@ovh4:~$
References
-
MariaDB server horribly slow on start
From: Cédric Counotte, 2022-07-27
-
Re: MariaDB server horribly slow on start
From: William Edwards, 2022-07-27
-
Re: MariaDB server horribly slow on start
From: Cédric Counotte, 2022-07-27
-
Re: MariaDB server horribly slow on start
From: Gordan Bobic, 2022-07-27
-
Re: MariaDB server horribly slow on start
From: Cédric Counotte, 2022-07-27
-
Re: MariaDB server horribly slow on start
From: Gordan Bobic, 2022-07-27
-
Re: MariaDB server horribly slow on start
From: Cédric Counotte, 2022-07-27
-
Re: MariaDB server horribly slow on start
From: Gordan Bobic, 2022-07-27
-
Re: MariaDB server horribly slow on start
From: Cédric Counotte, 2022-07-27
-
Re: MariaDB server horribly slow on start
From: Ali, 2022-07-27
