Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- MariaDB [(none)]> SELECT COUNT(*) FROM information_schema.tables;
- +----------+
- | COUNT(*) |
- +----------+
- | 242 |
- +----------+
- 1 row in set (0.001 sec)
- MariaDB [(none)]> SHOW GLOBAL STATUS;
- +--------------------------------------------------------------+--------------------------------------------------+
- | Variable_name | Value |
- +--------------------------------------------------------------+--------------------------------------------------+
- | Aborted_clients | 1544 |
- | Aborted_connects | 23054 |
- | Access_denied_errors | 20414 |
- | Acl_column_grants | 0 |
- | Acl_database_grants | 0 |
- | Acl_function_grants | 0 |
- | Acl_procedure_grants | 0 |
- | Acl_package_spec_grants | 0 |
- | Acl_package_body_grants | 0 |
- | Acl_proxy_users | 1 |
- | Acl_role_grants | 0 |
- | Acl_roles | 0 |
- | Acl_table_grants | 0 |
- | Acl_users | 2 |
- | Aria_pagecache_blocks_not_flushed | 0 |
- | Aria_pagecache_blocks_unused | 15706 |
- | Aria_pagecache_blocks_used | 5799 |
- | Aria_pagecache_read_requests | 4510272 |
- | Aria_pagecache_reads | 2037 |
- | Aria_pagecache_write_requests | 34681 |
- | Aria_pagecache_writes | 34670 |
- | Aria_transaction_log_syncs | 10 |
- | Binlog_commits | 0 |
- | Binlog_group_commits | 0 |
- | Binlog_group_commit_trigger_count | 0 |
- | Binlog_group_commit_trigger_lock_wait | 0 |
- | Binlog_group_commit_trigger_timeout | 0 |
- | Binlog_snapshot_file | |
- | Binlog_snapshot_position | 0 |
- | Binlog_bytes_written | 0 |
- | Binlog_cache_disk_use | 0 |
- | Binlog_cache_use | 0 |
- | Binlog_stmt_cache_disk_use | 0 |
- | Binlog_stmt_cache_use | 0 |
- | Busy_time | 0.000000 |
- | Bytes_received | 22356458278 |
- | Bytes_sent | 28914464696 |
- | Column_compressions | 0 |
- | Column_decompressions | 0 |
- | Com_admin_commands | 20154175 |
- | 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 | 119 |
- | Com_alter_tablespace | 0 |
- | Com_alter_user | 0 |
- | Com_analyze | 0 |
- | Com_assign_to_keycache | 0 |
- | Com_begin | 10283119 |
- | Com_binlog | 0 |
- | Com_call_procedure | 87598921 |
- | Com_change_db | 10338170 |
- | Com_change_master | 0 |
- | Com_check | 0 |
- | Com_checksum | 0 |
- | Com_commit | 10283080 |
- | Com_compound_sql | 0 |
- | Com_create_db | 4 |
- | Com_create_event | 0 |
- | Com_create_function | 0 |
- | Com_create_index | 0 |
- | Com_create_package | 0 |
- | Com_create_package_body | 0 |
- | Com_create_procedure | 157 |
- | Com_create_role | 0 |
- | Com_create_sequence | 0 |
- | Com_create_server | 0 |
- | Com_create_table | 8717492 |
- | Com_create_temporary_table | 7 |
- | Com_create_trigger | 0 |
- | Com_create_udf | 0 |
- | Com_create_user | 0 |
- | Com_create_view | 0 |
- | Com_dealloc_sql | 8719570 |
- | Com_delete | 73 |
- | 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 | 128 |
- | Com_drop_package | 0 |
- | Com_drop_package_body | 0 |
- | Com_drop_role | 0 |
- | Com_drop_server | 0 |
- | Com_drop_sequence | 0 |
- | Com_drop_table | 33 |
- | Com_drop_temporary_table | 5 |
- | Com_drop_trigger | 0 |
- | Com_drop_user | 0 |
- | Com_drop_view | 0 |
- | Com_empty_query | 0 |
- | Com_execute_immediate | 0 |
- | Com_execute_sql | 431161903 |
- | Com_flush | 754 |
- | Com_get_diagnostics | 37 |
- | Com_grant | 1 |
- | Com_grant_role | 0 |
- | Com_ha_close | 0 |
- | Com_ha_open | 0 |
- | Com_ha_read | 0 |
- | Com_help | 0 |
- | Com_insert | 458128982 |
- | Com_insert_select | 0 |
- | Com_install_plugin | 0 |
- | Com_kill | 12 |
- | Com_load | 0 |
- | Com_lock_tables | 0 |
- | Com_multi | 0 |
- | Com_optimize | 0 |
- | Com_preload_keys | 0 |
- | Com_prepare_sql | 431162363 |
- | 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 | 37 |
- | Com_rollback_to_savepoint | 0 |
- | Com_savepoint | 0 |
- | Com_select | 1005533116 |
- | Com_set_option | 9765214 |
- | Com_show_authors | 0 |
- | Com_show_binlog_events | 0 |
- | Com_show_binlogs | 0 |
- | Com_show_charsets | 158 |
- | Com_show_collations | 2622 |
- | Com_show_contributors | 0 |
- | Com_show_create_db | 77 |
- | 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 | 1167 |
- | Com_show_create_table | 1369 |
- | Com_show_create_trigger | 0 |
- | Com_show_create_user | 0 |
- | Com_show_databases | 227 |
- | Com_show_engine_logs | 0 |
- | Com_show_engine_mutex | 0 |
- | Com_show_engine_status | 0 |
- | Com_show_errors | 0 |
- | Com_show_events | 88 |
- | Com_show_explain | 0 |
- | Com_show_fields | 173 |
- | Com_show_function_status | 403 |
- | Com_show_generic | 0 |
- | Com_show_grants | 6 |
- | Com_show_keys | 298 |
- | Com_show_master_status | 0 |
- | Com_show_open_tables | 56 |
- | Com_show_package_status | 0 |
- | Com_show_package_body_status | 0 |
- | Com_show_plugins | 0 |
- | Com_show_privileges | 0 |
- | Com_show_procedure_status | 403 |
- | 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 | 155 |
- | Com_show_storage_engines | 74 |
- | Com_show_table_status | 485 |
- | Com_show_tables | 5 |
- | Com_show_triggers | 403 |
- | Com_show_variables | 125 |
- | Com_show_warnings | 250 |
- | Com_shutdown | 0 |
- | Com_signal | 0 |
- | Com_start_all_slaves | 0 |
- | Com_start_slave | 0 |
- | Com_stmt_close | 431159809 |
- | Com_stmt_execute | 431161903 |
- | Com_stmt_fetch | 0 |
- | Com_stmt_prepare | 431162363 |
- | 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 | 12 |
- | Com_uninstall_plugin | 0 |
- | Com_unlock_tables | 0 |
- | Com_update | 3610136 |
- | 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 | 350 |
- | Connection_errors_max_connections | 350 |
- | Connection_errors_peer_address | 38 |
- | Connection_errors_select | 0 |
- | Connection_errors_tcpwrap | 0 |
- | Connections | 27660 |
- | Cpu_time | 0.000000 |
- | Created_tmp_disk_tables | 3082 |
- | Created_tmp_files | 173 |
- | Created_tmp_tables | 35517 |
- | Delayed_errors | 0 |
- | Delayed_insert_threads | 0 |
- | Delayed_writes | 0 |
- | Delete_scan | 60 |
- | Empty_queries | 985447468 |
- | Executed_events | 0 |
- | Executed_triggers | 0 |
- | Feature_check_constraint | 0 |
- | Feature_custom_aggregate_functions | 0 |
- | Feature_delay_key_write | 0 |
- | Feature_dynamic_columns | 0 |
- | Feature_fulltext | 0 |
- | Feature_gis | 0 |
- | Feature_invisible_columns | 0 |
- | Feature_json | 5405 |
- | Feature_locale | 0 |
- | Feature_subquery | 845416541 |
- | Feature_system_versioning | 0 |
- | Feature_timezone | 0 |
- | Feature_trigger | 0 |
- | Feature_window_functions | 0 |
- | Feature_xml | 0 |
- | Flush_commands | 1 |
- | Handler_commit | 1841154493 |
- | Handler_delete | 141427267 |
- | Handler_discover | 1 |
- | Handler_external_lock | 0 |
- | Handler_icp_attempts | 25591786 |
- | Handler_icp_match | 25591786 |
- | Handler_mrr_init | 0 |
- | Handler_mrr_key_refills | 0 |
- | Handler_mrr_rowid_refills | 0 |
- | Handler_prepare | 0 |
- | Handler_read_first | 13594 |
- | Handler_read_key | 531830319 |
- | Handler_read_last | 48 |
- | Handler_read_next | 112640012110 |
- | Handler_read_prev | 99388429 |
- | Handler_read_retry | 0 |
- | Handler_read_rnd | 60310 |
- | Handler_read_rnd_deleted | 35 |
- | Handler_read_rnd_next | 66886254717 |
- | Handler_rollback | 244 |
- | Handler_savepoint | 0 |
- | Handler_savepoint_rollback | 0 |
- | Handler_tmp_delete | 0 |
- | Handler_tmp_update | 13584036 |
- | Handler_tmp_write | 230627974 |
- | Handler_update | 3610195 |
- | Handler_write | 471069056 |
- | Innodb_buffer_pool_dump_status | |
- | Innodb_buffer_pool_load_status | Buffer pool(s) load completed at 210513 8:11:25 |
- | Innodb_buffer_pool_resize_status | |
- | Innodb_buffer_pool_load_incomplete | OFF |
- | Innodb_buffer_pool_pages_data | 6742 |
- | Innodb_buffer_pool_bytes_data | 110460928 |
- | Innodb_buffer_pool_pages_dirty | 874 |
- | Innodb_buffer_pool_bytes_dirty | 14319616 |
- | Innodb_buffer_pool_pages_flushed | 875771033 |
- | Innodb_buffer_pool_pages_free | 1024 |
- | Innodb_buffer_pool_pages_misc | 426 |
- | Innodb_buffer_pool_pages_total | 8192 |
- | Innodb_buffer_pool_read_ahead_rnd | 0 |
- | Innodb_buffer_pool_read_ahead | 627338386 |
- | Innodb_buffer_pool_read_ahead_evicted | 30033951 |
- | Innodb_buffer_pool_read_requests | 203404044043 |
- | Innodb_buffer_pool_reads | 752484373 |
- | Innodb_buffer_pool_wait_free | 231263853 |
- | Innodb_buffer_pool_write_requests | 5512728906 |
- | Innodb_data_fsyncs | 478034442 |
- | Innodb_data_pending_fsyncs | 1 |
- | Innodb_data_pending_reads | 0 |
- | Innodb_data_pending_writes | 0 |
- | Innodb_data_read | 22638349257216 |
- | Innodb_data_reads | 1381529859 |
- | Innodb_data_writes | 1331704590 |
- | Innodb_data_written | 29461385919488 |
- | Innodb_dblwr_pages_written | 882752261 |
- | Innodb_dblwr_writes | 17883976 |
- | Innodb_log_waits | 0 |
- | Innodb_log_write_requests | 388547537 |
- | Innodb_log_writes | 421825406 |
- | Innodb_os_log_fsyncs | 423427699 |
- | Innodb_os_log_pending_fsyncs | 1 |
- | Innodb_os_log_pending_writes | 0 |
- | Innodb_os_log_written | 534575420416 |
- | Innodb_page_size | 16384 |
- | Innodb_pages_created | 2662630 |
- | Innodb_pages_read | 1381741293 |
- | Innodb_pages0_read | 5 |
- | Innodb_pages_written | 882756743 |
- | Innodb_row_lock_current_waits | 0 |
- | Innodb_row_lock_time | 2396264 |
- | Innodb_row_lock_time_avg | 39937 |
- | Innodb_row_lock_time_max | 51962 |
- | Innodb_row_lock_waits | 60 |
- | Innodb_rows_deleted | 141427138 |
- | Innodb_rows_inserted | 471068900 |
- | Innodb_rows_read | 179674631902 |
- | Innodb_rows_updated | 3610140 |
- | Innodb_system_rows_deleted | 0 |
- | Innodb_system_rows_inserted | 0 |
- | Innodb_system_rows_read | 0 |
- | Innodb_system_rows_updated | 0 |
- | Innodb_num_open_files | 91 |
- | 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 | 3 |
- | Innodb_onlineddl_rowlog_rows | 0 |
- | Innodb_onlineddl_rowlog_pct_used | 0 |
- | Innodb_onlineddl_pct_progress | 0 |
- | Innodb_secondary_index_triggered_cluster_reads | 6201432999 |
- | 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_scrub_background_page_reorganizations | 0 |
- | Innodb_scrub_background_page_splits | 0 |
- | Innodb_scrub_background_page_split_failures_underflow | 0 |
- | Innodb_scrub_background_page_split_failures_out_of_filespace | 0 |
- | Innodb_scrub_background_page_split_failures_missing_index | 0 |
- | Innodb_scrub_background_page_split_failures_unknown | 0 |
- | Innodb_scrub_log | 0 |
- | Innodb_encryption_num_key_requests | 0 |
- | Key_blocks_not_flushed | 0 |
- | Key_blocks_unused | 107159 |
- | Key_blocks_used | 4 |
- | Key_blocks_warm | 0 |
- | Key_read_requests | 20060 |
- | Key_reads | 4 |
- | Key_write_requests | 650 |
- | Key_writes | 568 |
- | 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 | 152 |
- | Memory_used | 326396176 |
- | Memory_used_initial | 289576080 |
- | Not_flushed_delayed_rows | 0 |
- | Open_files | 62 |
- | Open_streams | 0 |
- | Open_table_definitions | 115 |
- | Open_tables | 819 |
- | Opened_files | 13179 |
- | Opened_plugin_libraries | 0 |
- | Opened_table_definitions | 452 |
- | Opened_tables | 1128 |
- | 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_locker_lost | 0 |
- | Performance_schema_mutex_classes_lost | 0 |
- | Performance_schema_mutex_instances_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_thread_classes_lost | 0 |
- | Performance_schema_thread_instances_lost | 0 |
- | Performance_schema_users_lost | 0 |
- | Prepared_stmt_count | 12 |
- | Qcache_free_blocks | 54 |
- | Qcache_free_memory | 16244336 |
- | Qcache_hits | 9769383 |
- | Qcache_inserts | 5245 |
- | Qcache_lowmem_prunes | 0 |
- | Qcache_not_cached | 97904933 |
- | Qcache_queries_in_cache | 186 |
- | Qcache_total_blocks | 453 |
- | Queries | 6366821426 |
- | Questions | 60257674 |
- | Rows_read | 179669877982 |
- | Rows_sent | 247478226 |
- | Rows_tmp_read | 19954513 |
- | 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 | 98 |
- | Select_full_range_join | 0 |
- | Select_range | 3067 |
- | Select_range_check | 0 |
- | Select_scan | 882528505 |
- | 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 | 2059 |
- | Sort_merge_passes | 4220 |
- | Sort_priority_queue_sorts | 231 |
- | Sort_range | 328 |
- | Sort_rows | 24739133 |
- | Sort_scan | 1188 |
- | Ssl_accept_renegotiates | 0 |
- | Ssl_accepts | 0 |
- | Ssl_callback_cache_hits | 0 |
- | Ssl_cipher | |
- | Ssl_cipher_list | |
- | Ssl_client_connects | 0 |
- | Ssl_connect_renegotiates | 0 |
- | Ssl_ctx_verify_depth | 0 |
- | Ssl_ctx_verify_mode | 0 |
- | Ssl_default_timeout | 0 |
- | Ssl_finished_accepts | 0 |
- | Ssl_finished_connects | 0 |
- | Ssl_server_not_after | |
- | Ssl_server_not_before | |
- | Ssl_session_cache_hits | 0 |
- | Ssl_session_cache_misses | 0 |
- | Ssl_session_cache_mode | NONE |
- | Ssl_session_cache_overflows | 0 |
- | Ssl_session_cache_size | 0 |
- | Ssl_session_cache_timeouts | 0 |
- | Ssl_sessions_reused | 0 |
- | Ssl_used_session_cache_entries | 0 |
- | Ssl_verify_depth | 0 |
- | Ssl_verify_mode | 0 |
- | Ssl_version | |
- | Subquery_cache_hit | 0 |
- | Subquery_cache_miss | 0 |
- | Syncs | 858 |
- | Table_locks_immediate | 11156 |
- | Table_locks_waited | 0 |
- | Table_open_cache_active_instances | 1 |
- | Table_open_cache_hits | 2253353494 |
- | Table_open_cache_misses | 1118 |
- | Table_open_cache_overflows | 0 |
- | Tc_log_max_pages_used | 0 |
- | Tc_log_page_size | 4096 |
- | Tc_log_page_waits | 0 |
- | Threadpool_idle_threads | 0 |
- | Threadpool_threads | 0 |
- | Threads_cached | 0 |
- | Threads_connected | 16 |
- | Threads_created | 4578 |
- | Threads_running | 8 |
- | Transactions_gtid_foreign_engine | 0 |
- | Transactions_multi_engine | 0 |
- | Update_scan | 53954 |
- | Uptime | 16245918 |
- | Uptime_since_flush_status | 16245918 |
- | wsrep_applier_thread_count | 0 |
- | wsrep_cluster_conf_id | 18446744073709551615 |
- | wsrep_cluster_size | 0 |
- | wsrep_cluster_state_uuid | |
- | wsrep_cluster_status | Disconnected |
- | wsrep_connected | OFF |
- | wsrep_local_bf_aborts | 0 |
- | wsrep_local_index | 18446744073709551615 |
- | wsrep_provider_name | |
- | wsrep_provider_vendor | |
- | wsrep_provider_version | |
- | wsrep_ready | OFF |
- | wsrep_rollbacker_thread_count | 0 |
- | wsrep_thread_count | 0 |
- +--------------------------------------------------------------+--------------------------------------------------+
- 536 rows in set (0.003 sec)
- MariaDB [(none)]> SHOW GLOBAL VARIABLES;
- +--------------------------------------------------------+----------------
- | Variable_name | Value
- +--------------------------------------------------------+----------------
- | alter_algorithm | DEFAULT
- | aria_block_size | 8192
- | aria_checkpoint_interval | 30
- | aria_checkpoint_log_activity | 1048576
- | aria_encrypt_tables | OFF
- | aria_force_start_after_recovery_failures | 0
- | aria_group_commit | none
- | aria_group_commit_interval | 0
- | aria_log_file_size | 1073741824
- | aria_log_purge_type | immediate
- | aria_max_sort_file_size | 922337203685372
- | aria_page_checksum | ON
- | aria_pagecache_age_threshold | 300
- | aria_pagecache_buffer_size | 134217728
- | aria_pagecache_division_limit | 100
- | aria_pagecache_file_hash_size | 512
- | aria_recover_options | BACKUP,QUICK
- | aria_repair_threads | 1
- | aria_sort_buffer_size | 268434432
- | aria_stats_method | nulls_unequal
- | aria_sync_log_dir | NEWFILE
- | aria_used_for_temp_tables | ON
- | auto_increment_increment | 1
- | auto_increment_offset | 1
- | autocommit | ON
- | automatic_sp_privileges | ON
- | back_log | 80
- | basedir | /usr
- | big_tables | OFF
- | bind_address | 0.0.0.0
- | binlog_annotate_row_events | ON
- | binlog_cache_size | 32768
- | binlog_checksum | CRC32
- | binlog_commit_wait_count | 0
- | binlog_commit_wait_usec | 100000
- | binlog_direct_non_transactional_updates | OFF
- | binlog_file_cache_size | 16384
- | binlog_format | MIXED
- | binlog_optimize_thread_scheduling | ON
- | binlog_row_image | FULL
- | binlog_stmt_cache_size | 32768
- | bulk_insert_buffer_size | 8388608
- | character_set_client | utf8mb4
- | character_set_connection | utf8mb4
- | character_set_database | utf8mb4
- | character_set_filesystem | binary
- | character_set_results | utf8mb4
- | character_set_server | utf8mb4
- | character_set_system | utf8
- | character_sets_dir | /usr/share/mysq
- | check_constraint_checks | ON
- | collation_connection | utf8mb4_general
- | collation_database | utf8mb4_general
- | collation_server | utf8mb4_general
- | column_compression_threshold | 100
- | column_compression_zlib_level | 6
- | column_compression_zlib_strategy | DEFAULT_STRATEG
- | column_compression_zlib_wrap | OFF
- | completion_type | NO_CHAIN
- | concurrent_insert | AUTO
- | connect_timeout | 10
- | core_file | OFF
- | datadir | /var/lib/mysql/
- | date_format | %Y-%m-%d
- | datetime_format | %Y-%m-%d %H:%i:
- | deadlock_search_depth_long | 15
- | deadlock_search_depth_short | 4
- | deadlock_timeout_long | 50000000
- | deadlock_timeout_short | 10000
- | debug_no_thread_alarm | OFF
- | default_regex_flags |
- | default_storage_engine | InnoDB
- | default_tmp_storage_engine |
- | default_week_format | 0
- | delay_key_write | ON
- | delayed_insert_limit | 100
- | delayed_insert_timeout | 300
- | delayed_queue_size | 1000
- | div_precision_increment | 4
- | encrypt_binlog | OFF
- | encrypt_tmp_disk_tables | OFF
- | encrypt_tmp_files | OFF
- | enforce_storage_engine |
- | eq_range_index_dive_limit | 0
- | event_scheduler | OFF
- | expensive_subquery_limit | 100
- | expire_logs_days | 10
- | explicit_defaults_for_timestamp | OFF
- | extra_max_connections | 1
- | extra_port | 0
- | flush | OFF
- | flush_time | 0
- | foreign_key_checks | ON
- | ft_boolean_syntax | + -><()~*:""&|
- | ft_max_word_len | 84
- | ft_min_word_len | 4
- | ft_query_expansion_limit | 20
- | ft_stopword_file | (built-in)
- | general_log | OFF
- | general_log_file | templarivm.log
- | group_concat_max_len | 1048576
- | gtid_binlog_pos |
- | gtid_binlog_state |
- | gtid_current_pos |
- | gtid_domain_id | 0
- | gtid_ignore_duplicates | OFF
- | gtid_pos_auto_engines |
- | gtid_slave_pos |
- | gtid_strict_mode | OFF
- | have_compress | YES
- | have_crypt | YES
- | have_dynamic_loading | YES
- | have_geometry | YES
- | have_openssl | NO
- | have_profiling | YES
- | have_query_cache | YES
- | have_rtree_keys | YES
- | have_ssl | DISABLED
- | have_symlink | YES
- | histogram_size | 0
- | histogram_type | SINGLE_PREC_HB
- | host_cache_size | 279
- | hostname | templarivm
- | idle_readonly_transaction_timeout | 0
- | idle_transaction_timeout | 0
- | idle_write_transaction_timeout | 0
- | ignore_builtin_innodb | OFF
- | ignore_db_dirs |
- | in_predicate_conversion_threshold | 1000
- | init_connect |
- | init_file |
- | init_slave |
- | innodb_adaptive_flushing | ON
- | innodb_adaptive_flushing_lwm | 10.000000
- | innodb_adaptive_hash_index | ON
- | innodb_adaptive_hash_index_parts | 8
- | innodb_adaptive_max_sleep_delay | 150000
- | innodb_autoextend_increment | 64
- | innodb_autoinc_lock_mode | 1
- | innodb_background_scrub_data_check_interval | 3600
- | innodb_background_scrub_data_compressed | OFF
- | innodb_background_scrub_data_interval | 604800
- | innodb_background_scrub_data_uncompressed | OFF
- | innodb_buf_dump_status_frequency | 0
- | innodb_buffer_pool_chunk_size | 134217728
- | innodb_buffer_pool_dump_at_shutdown | ON
- | innodb_buffer_pool_dump_now | OFF
- | innodb_buffer_pool_dump_pct | 25
- | innodb_buffer_pool_filename | ib_buffer_pool
- | innodb_buffer_pool_instances | 1
- | innodb_buffer_pool_load_abort | OFF
- | innodb_buffer_pool_load_at_startup | ON
- | innodb_buffer_pool_load_now | OFF
- | innodb_buffer_pool_size | 134217728
- | innodb_change_buffer_max_size | 25
- | innodb_change_buffering | all
- | innodb_checksum_algorithm | crc32
- | innodb_checksums | ON
- | innodb_cmp_per_index_enabled | OFF
- | innodb_commit_concurrency | 0
- | innodb_compression_algorithm | zlib
- | innodb_compression_default | OFF
- | innodb_compression_failure_threshold_pct | 5
- | innodb_compression_level | 6
- | innodb_compression_pad_pct_max | 50
- | innodb_concurrency_tickets | 5000
- | innodb_data_file_path | ibdata1:12M:aut
- | innodb_data_home_dir |
- | innodb_deadlock_detect | ON
- | innodb_default_encryption_key_id | 1
- | innodb_default_row_format | dynamic
- | innodb_defragment | OFF
- | innodb_defragment_fill_factor | 0.900000
- | innodb_defragment_fill_factor_n_recs | 20
- | innodb_defragment_frequency | 40
- | innodb_defragment_n_pages | 7
- | innodb_defragment_stats_accuracy | 0
- | innodb_disable_sort_file_cache | OFF
- | innodb_disallow_writes | OFF
- | innodb_doublewrite | ON
- | innodb_encrypt_log | OFF
- | innodb_encrypt_tables | OFF
- | innodb_encrypt_temporary_tables | OFF
- | innodb_encryption_rotate_key_age | 1
- | innodb_encryption_rotation_iops | 100
- | innodb_encryption_threads | 0
- | innodb_fast_shutdown | 1
- | innodb_fatal_semaphore_wait_threshold | 600
- | innodb_file_format |
- | innodb_file_per_table | ON
- | innodb_fill_factor | 100
- | innodb_flush_log_at_timeout | 1
- | innodb_flush_log_at_trx_commit | 1
- | innodb_flush_method | fsync
- | innodb_flush_neighbors | 1
- | innodb_flush_sync | ON
- | innodb_flushing_avg_loops | 30
- | innodb_force_load_corrupted | OFF
- | innodb_force_primary_key | OFF
- | innodb_force_recovery | 0
- | innodb_ft_aux_table |
- | innodb_ft_cache_size | 8000000
- | innodb_ft_enable_diag_print | OFF
- | innodb_ft_enable_stopword | ON
- | innodb_ft_max_token_size | 84
- | innodb_ft_min_token_size | 3
- | innodb_ft_num_word_optimize | 2000
- | innodb_ft_result_cache_limit | 2000000000
- | innodb_ft_server_stopword_table |
- | innodb_ft_sort_pll_degree | 2
- | innodb_ft_total_cache_size | 640000000
- | innodb_ft_user_stopword_table |
- | innodb_idle_flush_pct | 100
- | innodb_immediate_scrub_data_uncompressed | OFF
- | innodb_instant_alter_column_allowed | add_last
- | innodb_io_capacity | 200
- | innodb_io_capacity_max | 2000
- | innodb_large_prefix |
- | innodb_lock_schedule_algorithm | fcfs
- | innodb_lock_wait_timeout | 50
- | innodb_locks_unsafe_for_binlog | OFF
- | innodb_log_buffer_size | 16777216
- | innodb_log_checksums | ON
- | innodb_log_compressed_pages | ON
- | innodb_log_file_size | 50331648
- | innodb_log_files_in_group | 2
- | innodb_log_group_home_dir | ./
- | innodb_log_optimize_ddl | OFF
- | innodb_log_write_ahead_size | 8192
- | innodb_lru_scan_depth | 1024
- | innodb_max_dirty_pages_pct | 75.000000
- | innodb_max_dirty_pages_pct_lwm | 0.000000
- | innodb_max_purge_lag | 0
- | innodb_max_purge_lag_delay | 0
- | innodb_max_purge_lag_wait | 4294967295
- | innodb_max_undo_log_size | 10485760
- | innodb_monitor_disable |
- | innodb_monitor_enable |
- | innodb_monitor_reset |
- | innodb_monitor_reset_all |
- | innodb_old_blocks_pct | 37
- | innodb_old_blocks_time | 1000
- | innodb_online_alter_log_max_size | 134217728
- | innodb_open_files | 2000
- | innodb_optimize_fulltext_only | OFF
- | innodb_page_cleaners | 1
- | innodb_page_size | 16384
- | innodb_prefix_index_cluster_optimization | OFF
- | innodb_print_all_deadlocks | OFF
- | innodb_purge_batch_size | 300
- | innodb_purge_rseg_truncate_frequency | 128
- | innodb_purge_threads | 4
- | innodb_random_read_ahead | OFF
- | innodb_read_ahead_threshold | 56
- | innodb_read_io_threads | 4
- | innodb_read_only | OFF
- | innodb_replication_delay | 0
- | innodb_rollback_on_timeout | OFF
- | innodb_rollback_segments | 128
- | innodb_scrub_log | OFF
- | innodb_scrub_log_speed | 256
- | innodb_sort_buffer_size | 1048576
- | innodb_spin_wait_delay | 4
- | innodb_stats_auto_recalc | ON
- | innodb_stats_include_delete_marked | OFF
- | innodb_stats_method | nulls_equal
- | innodb_stats_modified_counter | 0
- | innodb_stats_on_metadata | OFF
- | innodb_stats_persistent | ON
- | innodb_stats_persistent_sample_pages | 20
- | innodb_stats_sample_pages | 8
- | innodb_stats_traditional | ON
- | innodb_stats_transient_sample_pages | 8
- | innodb_status_output | OFF
- | innodb_status_output_locks | OFF
- | innodb_strict_mode | ON
- | innodb_sync_array_size | 1
- | innodb_sync_spin_loops | 30
- | innodb_table_locks | ON
- | innodb_temp_data_file_path | ibtmp1:12M:auto
- | innodb_thread_concurrency | 0
- | innodb_thread_sleep_delay | 10000
- | innodb_tmpdir |
- | innodb_undo_directory | ./
- | innodb_undo_log_truncate | OFF
- | innodb_undo_logs | 128
- | innodb_undo_tablespaces | 0
- | innodb_use_atomic_writes | ON
- | innodb_use_native_aio | ON
- | innodb_version | 10.3.27
- | innodb_write_io_threads | 4
- | interactive_timeout | 28800
- | join_buffer_size | 262144
- | join_buffer_space_limit | 2097152
- | join_cache_level | 2
- | keep_files_on_create | OFF
- | key_buffer_size | 134217728
- | key_cache_age_threshold | 300
- | key_cache_block_size | 1024
- | key_cache_division_limit | 100
- | key_cache_file_hash_size | 512
- | key_cache_segments | 0
- | large_files_support | ON
- | large_page_size | 0
- | large_pages | OFF
- | lc_messages | en_US
- | lc_messages_dir | /usr/share/mysq
- | lc_time_names | en_US
- | license | GPL
- | local_infile | ON
- | lock_wait_timeout | 86400
- | locked_in_memory | OFF
- | log_bin | OFF
- | log_bin_basename |
- | log_bin_compress | OFF
- | log_bin_compress_min_len | 256
- | log_bin_index |
- | log_bin_trust_function_creators | OFF
- | log_disabled_statements | sp
- | log_error | /var/log/mysql/
- | log_output | FILE
- | log_queries_not_using_indexes | OFF
- | log_slave_updates | OFF
- | log_slow_admin_statements | ON
- | log_slow_disabled_statements | sp
- | log_slow_filter | admin,filesort,
- | log_slow_rate_limit | 1
- | log_slow_slave_statements | ON
- | log_slow_verbosity |
- | log_tc_size | 24576
- | log_warnings | 2
- | long_query_time | 10.000000
- | low_priority_updates | OFF
- | lower_case_file_system | OFF
- | lower_case_table_names | 0
- | master_verify_checksum | OFF
- | max_allowed_packet | 16777216
- | max_binlog_cache_size | 184467440737095
- | max_binlog_size | 1073741824
- | max_binlog_stmt_cache_size | 184467440737095
- | max_connect_errors | 100
- | max_connections | 151
- | max_delayed_threads | 20
- | max_digest_length | 1024
- | max_error_count | 64
- | max_heap_table_size | 16777216
- | max_insert_delayed_threads | 20
- | max_join_size | 184467440737095
- | max_length_for_sort_data | 1024
- | max_long_data_size | 16777216
- | max_prepared_stmt_count | 16382
- | max_recursive_iterations | 4294967295
- | max_relay_log_size | 1073741824
- | max_seeks_for_key | 4294967295
- | max_session_mem_used | 922337203685477
- | max_sort_length | 1024
- | max_sp_recursion_depth | 0
- | max_statement_time | 0.000000
- | max_tmp_tables | 32
- | max_user_connections | 0
- | max_write_lock_count | 4294967295
- | metadata_locks_cache_size | 1024
- | metadata_locks_hash_instances | 8
- | min_examined_row_limit | 0
- | mrr_buffer_size | 262144
- | multi_range_count | 256
- | myisam_block_size | 1024
- | myisam_data_pointer_size | 6
- | myisam_max_sort_file_size | 922337203685372
- | myisam_mmap_size | 184467440737095
- | myisam_recover_options | BACKUP,QUICK
- | myisam_repair_threads | 1
- | myisam_sort_buffer_size | 134216704
- | myisam_stats_method | NULLS_UNEQUAL
- | myisam_use_mmap | OFF
- | mysql56_temporal_format | ON
- | net_buffer_length | 16384
- | net_read_timeout | 30
- | net_retry_count | 10
- | net_write_timeout | 60
- | old | OFF
- | old_alter_table | DEFAULT
- | old_mode |
- | old_passwords | OFF
- | open_files_limit | 16384
- | optimizer_prune_level | 1
- | optimizer_search_depth | 62
- | optimizer_selectivity_sampling_limit | 100
- | optimizer_switch | index_merge=on,
- | optimizer_use_condition_selectivity | 1
- | performance_schema | OFF
- | performance_schema_accounts_size | -1
- | performance_schema_digests_size | -1
- | performance_schema_events_stages_history_long_size | -1
- | performance_schema_events_stages_history_size | -1
- | performance_schema_events_statements_history_long_size | -1
- | performance_schema_events_statements_history_size | -1
- | performance_schema_events_waits_history_long_size | -1
- | performance_schema_events_waits_history_size | -1
- | performance_schema_hosts_size | -1
- | performance_schema_max_cond_classes | 80
- | performance_schema_max_cond_instances | -1
- | performance_schema_max_digest_length | 1024
- | performance_schema_max_file_classes | 50
- | performance_schema_max_file_handles | 32768
- | performance_schema_max_file_instances | -1
- | performance_schema_max_mutex_classes | 200
- | performance_schema_max_mutex_instances | -1
- | performance_schema_max_rwlock_classes | 40
- | performance_schema_max_rwlock_instances | -1
- | performance_schema_max_socket_classes | 10
- | performance_schema_max_socket_instances | -1
- | performance_schema_max_stage_classes | 160
- | performance_schema_max_statement_classes | 200
- | performance_schema_max_table_handles | -1
- | performance_schema_max_table_instances | -1
- | performance_schema_max_thread_classes | 50
- | performance_schema_max_thread_instances | -1
- | performance_schema_session_connect_attrs_size | -1
- | performance_schema_setup_actors_size | 100
- | performance_schema_setup_objects_size | 100
- | performance_schema_users_size | -1
- | pid_file | /run/mysqld/mys
- | plugin_dir | /usr/lib/x86_64
- | plugin_maturity | gamma
- | port | 3306
- | preload_buffer_size | 32768
- | profiling | OFF
- | profiling_history_size | 15
- | progress_report_time | 5
- | protocol_version | 10
- | proxy_protocol_networks |
- | query_alloc_block_size | 16384
- | query_cache_limit | 1048576
- | query_cache_min_res_unit | 4096
- | query_cache_size | 16777216
- | query_cache_strip_comments | OFF
- | query_cache_type | ON
- | query_cache_wlock_invalidate | OFF
- | query_prealloc_size | 24576
- | range_alloc_block_size | 4096
- | read_binlog_speed_limit | 0
- | read_buffer_size | 131072
- | read_only | OFF
- | read_rnd_buffer_size | 262144
- | relay_log |
- | relay_log_basename |
- | relay_log_index |
- | relay_log_info_file | relay-log.info
- | relay_log_purge | ON
- | relay_log_recovery | OFF
- | relay_log_space_limit | 0
- | replicate_annotate_row_events | ON
- | replicate_do_db |
- | replicate_do_table |
- | replicate_events_marked_for_skip | REPLICATE
- | replicate_ignore_db |
- | replicate_ignore_table |
- | replicate_wild_do_table |
- | replicate_wild_ignore_table |
- | report_host |
- | report_password |
- | report_port | 3306
- | report_user |
- | rowid_merge_buff_size | 8388608
- | rpl_semi_sync_master_enabled | OFF
- | rpl_semi_sync_master_timeout | 10000
- | rpl_semi_sync_master_trace_level | 32
- | rpl_semi_sync_master_wait_no_slave | ON
- | rpl_semi_sync_master_wait_point | AFTER_COMMIT
- | rpl_semi_sync_slave_delay_master | OFF
- | rpl_semi_sync_slave_enabled | OFF
- | rpl_semi_sync_slave_kill_conn_timeout | 5
- | rpl_semi_sync_slave_trace_level | 32
- | secure_auth | ON
- | secure_file_priv |
- | secure_timestamp | NO
- | server_id | 1
- | session_track_schema | ON
- | session_track_state_change | OFF
- | session_track_system_variables | autocommit,char
- | session_track_transaction_info | OFF
- | skip_external_locking | ON
- | skip_name_resolve | OFF
- | skip_networking | OFF
- | skip_show_database | OFF
- | slave_compressed_protocol | OFF
- | slave_ddl_exec_mode | IDEMPOTENT
- | slave_domain_parallel_threads | 0
- | slave_exec_mode | STRICT
- | slave_load_tmpdir | /tmp
- | slave_max_allowed_packet | 1073741824
- | slave_net_timeout | 60
- | slave_parallel_max_queued | 131072
- | slave_parallel_mode | conservative
- | slave_parallel_threads | 0
- | slave_parallel_workers | 0
- | slave_run_triggers_for_rbr | NO
- | slave_skip_errors | OFF
- | slave_sql_verify_checksum | ON
- | slave_transaction_retries | 10
- | slave_transaction_retry_errors | 1213,1205
- | slave_transaction_retry_interval | 0
- | slave_type_conversions |
- | slow_launch_time | 2
- | slow_query_log | OFF
- | slow_query_log_file | templarivm-slow
- | socket | /run/mysqld/mys
- | sort_buffer_size | 2097152
- | sql_auto_is_null | OFF
- | sql_big_selects | ON
- | sql_buffer_result | OFF
- | sql_log_bin | ON
- | sql_log_off | OFF
- | sql_mode | STRICT_TRANS_TA
- | sql_notes | ON
- | sql_quote_show_create | ON
- | sql_safe_updates | OFF
- | sql_select_limit | 184467440737095
- | sql_slave_skip_counter | 0
- | sql_warnings | OFF
- | ssl_ca |
- | ssl_capath |
- | ssl_cert |
- | ssl_cipher |
- | ssl_crl |
- | ssl_crlpath |
- | ssl_key |
- | standard_compliant_cte | ON
- | storage_engine | InnoDB
- | stored_program_cache | 256
- | strict_password_validation | ON
- | sync_binlog | 0
- | sync_frm | ON
- | sync_master_info | 10000
- | sync_relay_log | 10000
- | sync_relay_log_info | 10000
- | system_time_zone | UTC
- | system_versioning_alter_history | ERROR
- | system_versioning_asof | DEFAULT
- | table_definition_cache | 400
- | table_open_cache | 2000
- | table_open_cache_instances | 4
- | tcp_keepalive_interval | 0
- | tcp_keepalive_probes | 0
- | tcp_keepalive_time | 0
- | thread_cache_size | 151
- | thread_concurrency | 10
- | thread_handling | one-thread-per-
- | thread_pool_idle_timeout | 60
- | thread_pool_max_threads | 65536
- | thread_pool_oversubscribe | 3
- | thread_pool_prio_kickup_timer | 1000
- | thread_pool_priority | auto
- | thread_pool_size | 4
- | thread_pool_stall_limit | 500
- | thread_stack | 299008
- | time_format | %H:%i:%s
- | time_zone | SYSTEM
- | timed_mutexes | OFF
- | tmp_disk_table_size | 184467440737095
- | tmp_memory_table_size | 16777216
- | tmp_table_size | 16777216
- | tmpdir | /tmp
- | transaction_alloc_block_size | 8192
- | transaction_prealloc_size | 4096
- | tx_isolation | REPEATABLE-READ
- | tx_read_only | OFF
- | unique_checks | ON
- | updatable_views_with_limit | YES
- | use_stat_tables | NEVER
- | userstat | OFF
- | version | 10.3.27-MariaDB
- | version_comment | Debian 10
- | version_compile_machine | x86_64
- | version_compile_os | debian-linux-gn
- | version_malloc_library | system
- | version_source_revision | dba846ce2a4c573
- | version_ssl_library | YaSSL 2.4.4
- | wait_timeout | 28800
- | wsrep_osu_method | TOI
- | wsrep_auto_increment_control | ON
- | wsrep_causal_reads | OFF
- | wsrep_certification_rules | strict
- | wsrep_certify_nonpk | ON
- | wsrep_cluster_address |
- | wsrep_cluster_name | my_wsrep_cluste
- | wsrep_convert_lock_to_trx | OFF
- | wsrep_data_home_dir | /var/lib/mysql/
- | wsrep_dbug_option |
- | wsrep_debug | OFF
- | wsrep_desync | OFF
- | wsrep_dirty_reads | OFF
- | wsrep_drupal_282555_workaround | OFF
- | wsrep_forced_binlog_format | NONE
- | wsrep_gtid_domain_id | 0
- | wsrep_gtid_mode | OFF
- | wsrep_load_data_splitting | ON
- | wsrep_log_conflicts | OFF
- | wsrep_max_ws_rows | 0
- | wsrep_max_ws_size | 2147483647
- | wsrep_mysql_replication_bundle | 0
- | wsrep_node_address |
- | wsrep_node_incoming_address | AUTO
- | wsrep_node_name | templarivm
- | wsrep_notify_cmd |
- | wsrep_on | OFF
- | wsrep_patch_version | wsrep_25.24
- | wsrep_provider | none
- | wsrep_provider_options |
- | wsrep_recover | OFF
- | wsrep_reject_queries | NONE
- | wsrep_replicate_myisam | OFF
- | wsrep_restart_slave | OFF
- | wsrep_retry_autocommit | 1
- | wsrep_slave_fk_checks | ON
- | wsrep_slave_uk_checks | OFF
- | wsrep_slave_threads | 1
- | wsrep_sst_auth |
- | wsrep_sst_donor |
- | wsrep_sst_donor_rejects_queries | OFF
- | wsrep_sst_method | rsync
- | wsrep_sst_receive_address | AUTO
- | wsrep_start_position | 00000000-0000-0
- | wsrep_sync_wait | 0
- +--------------------------------------------------------+----------------
- MariaDB [(none)]> SHOW FULL PROCESSLIST;
- +-------+-------------+----------------------------------------+----------
- | Id | User | Host | db
- +-------+-------------+----------------------------------------+----------
- | 1 | system user | | NULL
- | 2 | system user | | NULL
- | 3 | system user | | NULL
- | 4 | system user | | NULL
- | 5 | system user | | NULL
- | 27532 | root | <MASKED_IP>:32992 | <MY_DB>
- | 27531 | root | <MASKED_IP>:32994 | <MY_DB>
- | 27533 | root | <MASKED_IP>:32996 | <MY_DB>
- | 27534 | root | <MASKED_IP>:33004 | <MY_DB>
- | 27535 | root | <MASKED_IP>:33006 | <MY_DB>
- | 27536 | root | <MASKED_IP>:33156 | <MY_DB>
- | 27537 | root | <MASKED_IP>:33226 | <MY_DB>
- | 27538 | root | <MASKED_IP>:33230 | <MY_DB>
- | 27539 | root | <MASKED_IP>:33228 | <MY_DB>
- | 27541 | root | <MASKED_IP>:33272 | <MY_DB>
- | 27542 | root | <MASKED_IP>:33274 | <MY_DB>
- | 27543 | root | <MASKED_IP>:33276 | <MY_DB>
- | 27657 | root | 89-97-178-146.ip18.fastwebnet.it:59872 | NULL
- | 27659 | root | 135.125.216.137:32812 | <MY_DB>
- | 27660 | root | localhost | NULL
- | 27661 | root | 89-97-178-146.ip18.fastwebnet.it:56006 | NULL
- | 27663 | root | localhost | NULL
- +-------+-------------+----------------------------------------+----------
- ~$ ulimit -a
- core file size (blocks, -c) 0
- data seg size (kbytes, -d) unlimited
- scheduling priority (-e) 0
- file size (blocks, -f) unlimited
- pending signals (-i) 58656
- max locked memory (kbytes, -l) 65536
- max memory size (kbytes, -m) unlimited
- open files (-n) 1024
- pipe size (512 bytes, -p) 8
- POSIX message queues (bytes, -q) 819200
- real-time priority (-r) 0
- stack size (kbytes, -s) 8192
- cpu time (seconds, -t) unlimited
- max user processes (-u) 58656
- virtual memory (kbytes, -v) unlimited
- file locks (-x) unlimited
Advertisement
Add Comment
Please, Sign In to add comment