-
-
Save amenk/7d6a94536b28b4564a611e6adbdc1a3c to your computer and use it in GitHub Desktop.
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| Type Name Status | |
| InnoDB \n=====================================\n2019-10-19 09:17:45 0x7f9355056700 INNODB MONITOR OUTPUT\n=====================================\nPer second averages calculated from the last 6 seconds\n-----------------\nBACKGROUND THREAD\n-----------------\nsrv_master_thread loops: 64351 srv_active, 0 srv_shutdown, 104946 srv_idle\nsrv_master_thread log flush and writes: 169294\n----------\nSEMAPHORES\n----------\nOS WAIT ARRAY INFO: reservation count 17371386\nOS WAIT ARRAY INFO: signal count 24970924\nRW-shared spins 0, rounds 29882220, OS waits 15486375\nRW-excl spins 0, rounds 55919076, OS waits 1733285\nRW-sx spins 83090, rounds 1079779, OS waits 10773\nSpin rounds per wait: 29882220.00 RW-shared, 55919076.00 RW-excl, 13.00 RW-sx\n------------\nTRANSACTIONS\n------------\nTrx id counter 29026924\nPurge done for trx's n:o < 29026924 undo n:o < 0 state: running\nHistory list length 1\nLIST OF TRANSACTIONS FOR EACH SESSION:\n---TRANSACTION 421745748775656, not started\n0 lock struct(s), heap size 1136, 0 row lock(s)\n---TRANSACTION 421745748758792, not started\n0 lock struct(s), heap size 1136, 0 row lock(s)\n---TRANSACTION 421745748784088, ACTIVE 0 sec\nmysql tables in use 2, locked 0\n0 lock struct(s), heap size 1136, 0 row lock(s)\nMySQL thread id 126037, OS thread handle 140271083210496, query id 35749872 localhost shop_production Sending data\nSELECT `main_table`.`value`, count(main_table.value) AS `count` FROM (SELECT DISTINCT `main_table`.`entity_id`, `main_table`.`value` FROM `catalog_product_index_eav` AS `main_table`\n INNER JOIN `search_tmp_5daab895210638_77883478` AS `entities` ON main_table.entity_id = entities.entity_id\n INNER JOIN `cataloginventory_stock_status` AS `stock_index` ON main_table.source_id = stock_index.product_id WHERE (main_table.attribute_id = 156) AND (main_table.store_id = '1' ) AND (stock_index.stock_status = 1)) AS `main_table` GROUP BY `value`\nTrx read view will not see trx with id >= 29026924, sees < 29026924\n---TRANSACTION 421745748792520, not started\n0 lock struct(s), heap size 1136, 0 row lock(s)\n---TRANSACTION 421745748779872, not started\n0 lock struct(s), heap size 1136, 0 row lock(s)\n---TRANSACTION 421745748771440, not started\n0 lock struct(s), heap size 1136, 0 row lock(s)\n---TRANSACTION 421745748767224, not started\n0 lock struct(s), heap size 1136, 0 row lock(s)\n---TRANSACTION 421745748763008, not started\n0 lock struct(s), heap size 1136, 0 row lock(s)\n---TRANSACTION 421745748754576, not started\n0 lock struct(s), heap size 1136, 0 row lock(s)\n--------\nFILE I/O\n--------\nI/O thread 0 state: waiting for completed aio requests (insert buffer thread)\nI/O thread 1 state: waiting for completed aio requests (log thread)\nI/O thread 2 state: waiting for completed aio requests (read thread)\nI/O thread 3 state: waiting for completed aio requests (read thread)\nI/O thread 4 state: waiting for completed aio requests (read thread)\nI/O thread 5 state: waiting for completed aio requests (read thread)\nI/O thread 6 state: waiting for completed aio requests (write thread)\nI/O thread 7 state: waiting for completed aio requests (write thread)\nI/O thread 8 state: waiting for completed aio requests (write thread)\nI/O thread 9 state: waiting for completed aio requests (write thread)\nPending normal aio reads: [0, 0, 0, 0] , aio writes: [0, 0, 0, 0] ,\n ibuf aio reads:, log i/o's:, sync i/o's:\nPending flushes (fsync) log: 0; buffer pool: 0\n803017 OS file reads, 1333713 OS file writes, 373070 OS fsyncs\n0.17 reads/s, 16384 avg bytes/read, 5.33 writes/s, 2.50 fsyncs/s\n-------------------------------------\nINSERT BUFFER AND ADAPTIVE HASH INDEX\n-------------------------------------\nIbuf: size 1, free list len 3663, seg size 3665, 6046 merges\nmerged operations:\n insert 31823, delete mark 513185, delete 132412\ndiscarded operations:\n insert 0, delete mark 0, delete 0\nHash table size 138401, node heap has 411 buffer(s)\nHash table size 138401, node heap has 275 buffer(s)\nHash table size 138401, node heap has 116 buffer(s)\nHash table size 138401, node heap has 197 buffer(s)\nHash table size 138401, node heap has 1688 buffer(s)\nHash table size 138401, node heap has 283 buffer(s)\nHash table size 138401, node heap has 1746 buffer(s)\nHash table size 138401, node heap has 507 buffer(s)\n531017.00 hash searches/s, 301590.40 non-hash searches/s\n---\nLOG\n---\nLog sequence number 26270126674\nLog flushed up to 26270126674\nPages flushed up to 26270126296\nLast checkpoint at 26270126287\n0 pending log flushes, 0 pending chkp writes\n446623 log i/o's done, 1.83 log i/o's/second\n----------------------\nBUFFER POOL AND MEMORY\n----------------------\nTotal large memory allocated 582746112\nDictionary memory allocated 1757664\nBuffer pool size 32768\nFree buffers 1953\nDatabase pages 25592\nOld database pages 9427\nModified db pages 6\nPercent of dirty pages(LRU & free pages): 0.022\nMax dirty pages percent: 75.000\nPending reads 0\nPending writes: LRU 0, flush list 0, single page 0\nPages made young 1630125, not young 84590722\n14.83 youngs/s, 20.00 non-youngs/s\nPages read 802411, created 21701, written 819462\n0.17 reads/s, 0.00 creates/s, 3.00 writes/s\nBuffer pool hit rate 999 / 1000, young-making rate 0 / 1000 not 0 / 1000\nPages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s\nLRU len: 25592, unzip_LRU len: 0\nI/O sum[379]:cur[0], unzip sum[0]:cur[0]\n--------------\nROW OPERATIONS\n--------------\n0 queries inside InnoDB, 0 queries in queue\n1 read views open inside InnoDB\nProcess ID=3572812, Main thread ID=140270772037376, state: sleeping\nNumber of rows inserted 1595865, updated 205979, deleted 971791, read 41954160087\n0.67 inserts/s, 0.00 updates/s, 0.00 deletes/s, 791984.84 reads/s\nNumber of system rows inserted 0, updated 0, deleted 0, read 58350\n0.00 inserts/s, 0.00 updates/s, 0.00 deletes/s, 0.00 reads/s\n----------------------------\nEND OF INNODB MONITOR OUTPUT\n============================\n |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| Variable_name Value | |
| Aborted_clients 756 | |
| Aborted_connects 0 | |
| Access_denied_errors 0 | |
| Acl_column_grants 0 | |
| Acl_database_grants 8 | |
| 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 7 | |
| Aria_pagecache_blocks_not_flushed 0 | |
| Aria_pagecache_blocks_unused 15706 | |
| Aria_pagecache_blocks_used 191 | |
| Aria_pagecache_read_requests 487325 | |
| Aria_pagecache_reads 17729 | |
| Aria_pagecache_write_requests 36415 | |
| Aria_pagecache_writes 36173 | |
| Aria_transaction_log_syncs 21 | |
| 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 65026021613 | |
| Bytes_sent 73665762728 | |
| Column_compressions 0 | |
| Column_decompressions 0 | |
| Com_admin_commands 376 | |
| 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_begin 386242 | |
| Com_binlog 0 | |
| Com_call_procedure 0 | |
| Com_change_db 21863 | |
| Com_change_master 0 | |
| Com_check 0 | |
| Com_checksum 0 | |
| Com_commit 386219 | |
| 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 1 | |
| Com_create_temporary_table 199200 | |
| Com_create_trigger 0 | |
| Com_create_udf 0 | |
| Com_create_user 0 | |
| Com_create_view 0 | |
| Com_dealloc_sql 0 | |
| Com_delete 47985 | |
| Com_delete_multi 3559 | |
| 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 1 | |
| Com_drop_temporary_table 188 | |
| 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 221455 | |
| Com_insert_select 100216 | |
| Com_install_plugin 0 | |
| Com_kill 0 | |
| Com_load 0 | |
| Com_lock_tables 12 | |
| Com_multi 0 | |
| Com_optimize 0 | |
| Com_preload_keys 0 | |
| Com_prepare_sql 0 | |
| Com_purge 0 | |
| Com_purge_before_date 0 | |
| Com_release_savepoint 36 | |
| Com_rename_table 0 | |
| Com_rename_user 0 | |
| Com_repair 0 | |
| Com_replace 40 | |
| Com_replace_select 0 | |
| Com_reset 0 | |
| Com_resignal 0 | |
| Com_revoke 0 | |
| Com_revoke_all 0 | |
| Com_revoke_role 0 | |
| Com_rollback 1 | |
| Com_rollback_to_savepoint 3736 | |
| Com_savepoint 36 | |
| Com_select 31036268 | |
| Com_set_option 254542 | |
| Com_show_authors 0 | |
| Com_show_binlog_events 0 | |
| Com_show_binlogs 1 | |
| Com_show_charsets 0 | |
| Com_show_collations 0 | |
| Com_show_contributors 0 | |
| Com_show_create_db 28 | |
| 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 7068 | |
| Com_show_create_trigger 0 | |
| Com_show_create_user 0 | |
| Com_show_databases 601 | |
| Com_show_engine_logs 0 | |
| Com_show_engine_mutex 0 | |
| Com_show_engine_status 2 | |
| Com_show_errors 0 | |
| Com_show_events 0 | |
| Com_show_explain 0 | |
| Com_show_fields 9130 | |
| Com_show_function_status 0 | |
| Com_show_generic 0 | |
| Com_show_grants 1 | |
| Com_show_keys 784 | |
| Com_show_master_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 33809 | |
| Com_show_profile 0 | |
| Com_show_profiles 0 | |
| Com_show_relaylog_events 0 | |
| Com_show_slave_hosts 0 | |
| Com_show_slave_status 1 | |
| Com_show_status 3 | |
| Com_show_storage_engines 0 | |
| Com_show_table_status 9690 | |
| Com_show_tables 86 | |
| Com_show_triggers 0 | |
| Com_show_variables 17305 | |
| Com_show_warnings 204 | |
| Com_shutdown 0 | |
| Com_signal 0 | |
| Com_start_all_slaves 0 | |
| Com_start_slave 0 | |
| Com_stmt_close 1146979 | |
| Com_stmt_execute 1146980 | |
| Com_stmt_fetch 0 | |
| Com_stmt_prepare 1146980 | |
| 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 4 | |
| Com_uninstall_plugin 0 | |
| Com_unlock_tables 34 | |
| Com_update 310606 | |
| Com_update_multi 271398 | |
| 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 126019 | |
| Cpu_time 0.000000 | |
| Created_tmp_disk_tables 19109 | |
| Created_tmp_files 6513 | |
| Created_tmp_tables 13806735 | |
| Delayed_errors 0 | |
| Delayed_insert_threads 0 | |
| Delayed_writes 0 | |
| Delete_scan 3603 | |
| Empty_queries 8123034 | |
| 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 9 | |
| Feature_gis 28 | |
| Feature_invisible_columns 0 | |
| Feature_json 0 | |
| Feature_locale 6 | |
| Feature_subquery 107381 | |
| Feature_system_versioning 0 | |
| Feature_timezone 51271 | |
| Feature_trigger 0 | |
| Feature_window_functions 0 | |
| Feature_xml 0 | |
| Flush_commands 1 | |
| Handler_commit 8612813 | |
| Handler_delete 793027 | |
| Handler_discover 728 | |
| Handler_external_lock 0 | |
| Handler_icp_attempts 130357832 | |
| Handler_icp_match 38015150 | |
| Handler_mrr_init 0 | |
| Handler_mrr_key_refills 0 | |
| Handler_mrr_rowid_refills 0 | |
| Handler_prepare 0 | |
| Handler_read_first 17939 | |
| Handler_read_key 58348782733 | |
| Handler_read_last 36 | |
| Handler_read_next 23122934912 | |
| Handler_read_prev 131 | |
| Handler_read_retry 0 | |
| Handler_read_rnd 1364993379 | |
| Handler_read_rnd_deleted 63052 | |
| Handler_read_rnd_next 54369542789 | |
| Handler_rollback 24 | |
| Handler_savepoint 36 | |
| Handler_savepoint_rollback 3736 | |
| Handler_tmp_delete 0 | |
| Handler_tmp_update 15124347740 | |
| Handler_tmp_write 29371819685 | |
| Handler_update 442802 | |
| Handler_write 2593004809 | |
| Innodb_buffer_pool_dump_status | |
| Innodb_buffer_pool_load_status Buffer pool(s) load completed at 191017 10:12:20 | |
| Innodb_buffer_pool_resize_status | |
| Innodb_buffer_pool_load_incomplete OFF | |
| Innodb_buffer_pool_pages_data 25590 | |
| Innodb_buffer_pool_bytes_data 419266560 | |
| Innodb_buffer_pool_pages_dirty 0 | |
| Innodb_buffer_pool_bytes_dirty 0 | |
| Innodb_buffer_pool_pages_flushed 819415 | |
| Innodb_buffer_pool_pages_free 1085 | |
| Innodb_buffer_pool_pages_misc 6093 | |
| Innodb_buffer_pool_pages_total 32768 | |
| Innodb_buffer_pool_read_ahead_rnd 0 | |
| Innodb_buffer_pool_read_ahead 113893 | |
| Innodb_buffer_pool_read_ahead_evicted 1810 | |
| Innodb_buffer_pool_read_requests 110543528190 | |
| Innodb_buffer_pool_reads 684606 | |
| Innodb_buffer_pool_wait_free 0 | |
| Innodb_buffer_pool_write_requests 25533075 | |
| Innodb_data_fsyncs 373022 | |
| Innodb_data_pending_fsyncs 0 | |
| Innodb_data_pending_reads 0 | |
| Innodb_data_pending_writes 0 | |
| Innodb_data_read 13146753536 | |
| Innodb_data_reads 803015 | |
| Innodb_data_writes 1333625 | |
| Innodb_data_written 28046700032 | |
| Innodb_dblwr_pages_written 812682 | |
| Innodb_dblwr_writes 64089 | |
| Innodb_log_waits 0 | |
| Innodb_log_write_requests 2082908 | |
| Innodb_log_writes 386702 | |
| Innodb_os_log_fsyncs 182196 | |
| Innodb_os_log_pending_fsyncs 0 | |
| Innodb_os_log_pending_writes 0 | |
| Innodb_os_log_written 1275779584 | |
| Innodb_page_size 16384 | |
| Innodb_pages_created 21701 | |
| Innodb_pages_read 802409 | |
| Innodb_pages0_read 595 | |
| Innodb_pages_written 819415 | |
| Innodb_row_lock_current_waits 0 | |
| Innodb_row_lock_time 1715 | |
| Innodb_row_lock_time_avg 45 | |
| Innodb_row_lock_time_max 687 | |
| Innodb_row_lock_waits 38 | |
| Innodb_rows_deleted 971791 | |
| Innodb_rows_inserted 1595856 | |
| Innodb_rows_read 41940317810 | |
| Innodb_rows_updated 205979 | |
| Innodb_system_rows_deleted 0 | |
| Innodb_system_rows_inserted 0 | |
| Innodb_system_rows_read 58350 | |
| Innodb_system_rows_updated 0 | |
| Innodb_num_open_files 598 | |
| 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 OFF | |
| Innodb_have_lzo OFF | |
| Innodb_have_lzma ON | |
| Innodb_have_bzip2 OFF | |
| Innodb_have_snappy OFF | |
| Innodb_have_punch_hole ON | |
| Innodb_defragment_compression_failures 0 | |
| Innodb_defragment_failures 0 | |
| Innodb_defragment_count 0 | |
| Innodb_instant_alter_column 0 | |
| Innodb_onlineddl_rowlog_rows 0 | |
| Innodb_onlineddl_rowlog_pct_used 0 | |
| Innodb_onlineddl_pct_progress 0 | |
| Innodb_secondary_index_triggered_cluster_reads 738730290 | |
| 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 107163 | |
| Key_blocks_used 18 | |
| Key_blocks_warm 0 | |
| Key_read_requests 416 | |
| Key_reads 110 | |
| 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 14 | |
| Memory_used 441770416 | |
| Memory_used_initial 407167552 | |
| Not_flushed_delayed_rows 0 | |
| Open_files 5 | |
| Open_streams 0 | |
| Open_table_definitions 400 | |
| Open_tables 600 | |
| Opened_files 120609 | |
| Opened_plugin_libraries 54 | |
| Opened_table_definitions 422140 | |
| Opened_tables 220291 | |
| Opened_views 7602 | |
| 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 0 | |
| Qcache_free_blocks 920 | |
| Qcache_free_memory 70990920 | |
| Qcache_hits 23537179 | |
| Qcache_inserts 2101049 | |
| Qcache_lowmem_prunes 1680614 | |
| Qcache_not_cached 5389858 | |
| Qcache_queries_in_cache 25589 | |
| Qcache_total_blocks 53862 | |
| Queries 35741560 | |
| Questions 33447601 | |
| Rows_read 37479133666 | |
| Rows_sent 1551077941 | |
| Rows_tmp_read 45823084983 | |
| 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 43911 | |
| Select_full_range_join 410 | |
| Select_range 825162 | |
| Select_range_check 0 | |
| Select_scan 7143924 | |
| 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 8 | |
| Sort_merge_passes 3254 | |
| Sort_priority_queue_sorts 19831 | |
| Sort_range 254287 | |
| Sort_rows 1365710575 | |
| Sort_scan 4684780 | |
| 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 5585 | |
| Syncs 126 | |
| Table_locks_immediate 334 | |
| Table_locks_waited 0 | |
| Table_open_cache_active_instances 1 | |
| Table_open_cache_hits 17251794 | |
| Table_open_cache_misses 29011 | |
| Table_open_cache_overflows 20663 | |
| 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 4 | |
| Threads_connected 10 | |
| Threads_created 14 | |
| Threads_running 10 | |
| Transactions_gtid_foreign_engine 0 | |
| Transactions_multi_engine 0 | |
| Update_scan 383 | |
| Uptime 169501 | |
| Uptime_since_flush_status 169501 | |
| 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 |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| 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 9223372036853727232 | |
| 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 250 | |
| basedir /usr/ | |
| big_tables OFF | |
| bind_address | |
| 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 latin1 | |
| character_set_connection latin1 | |
| character_set_database latin1 | |
| character_set_filesystem binary | |
| character_set_results latin1 | |
| character_set_server latin1 | |
| character_set_system utf8 | |
| character_sets_dir /usr/share/mysql/charsets/ | |
| check_constraint_checks ON | |
| collation_connection latin1_swedish_ci | |
| collation_database latin1_swedish_ci | |
| collation_server latin1_swedish_ci | |
| column_compression_threshold 100 | |
| column_compression_zlib_level 6 | |
| column_compression_zlib_strategy DEFAULT_STRATEGY | |
| 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:%s | |
| 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 example.log | |
| group_concat_max_len 320000 | |
| 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 YES | |
| have_profiling YES | |
| have_query_cache YES | |
| have_rtree_keys YES | |
| have_ssl DISABLED | |
| have_symlink DISABLED | |
| histogram_size 0 | |
| histogram_type SINGLE_PREC_HB | |
| host_cache_size 653 | |
| hostname example.example.de | |
| 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 536870912 | |
| 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:autoextend | |
| 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 2 | |
| 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_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 ON | |
| 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_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 600 | |
| 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:autoextend | |
| 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.18 | |
| 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 | |
| lc_time_names en_US | |
| license GPL | |
| local_infile OFF | |
| 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.err | |
| 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,filesort_on_disk,filesort_priority_queue,full_join,full_scan,query_cache,query_cache_miss,tmp_table,tmp_table_on_disk | |
| 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 104857600 | |
| max_binlog_cache_size 18446744073709547520 | |
| max_binlog_size 1073741824 | |
| max_binlog_stmt_cache_size 18446744073709547520 | |
| max_connect_errors 100 | |
| max_connections 1000 | |
| max_delayed_threads 20 | |
| max_digest_length 1024 | |
| max_error_count 64 | |
| max_heap_table_size 2147483648 | |
| max_insert_delayed_threads 20 | |
| max_join_size 18446744073709551615 | |
| max_length_for_sort_data 1024 | |
| max_long_data_size 104857600 | |
| max_prepared_stmt_count 16382 | |
| max_recursive_iterations 4294967295 | |
| max_relay_log_size 1073741824 | |
| max_seeks_for_key 4294967295 | |
| max_session_mem_used 9223372036854775807 | |
| 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 9223372036853727232 | |
| myisam_mmap_size 18446744073709551615 | |
| myisam_recover_options BACKUP | |
| 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 16364 | |
| optimizer_prune_level 1 | |
| optimizer_search_depth 0 | |
| optimizer_selectivity_sampling_limit 100 | |
| optimizer_switch 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=off,table_elimination=on,extended_keys=on,exists_to_in=on,orderby_uses_equalities=on,condition_pushdown_for_derived=on,split_materialized=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 /var/lib/mysql/example.pid | |
| plugin_dir /usr/lib64/mysql/plugin/ | |
| 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 2048 | |
| query_cache_size 134217728 | |
| 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,character_set_client,character_set_connection,character_set_results,time_zone | |
| session_track_transaction_info OFF | |
| skip_external_locking ON | |
| skip_name_resolve ON | |
| 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 example-slow.log | |
| socket /var/lib/mysql/mysql.sock | |
| 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 NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION | |
| sql_notes ON | |
| sql_quote_show_create ON | |
| sql_safe_updates OFF | |
| sql_select_limit 18446744073709551615 | |
| 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 2 | |
| sync_frm ON | |
| sync_master_info 10000 | |
| sync_relay_log 10000 | |
| sync_relay_log_info 10000 | |
| system_time_zone CEST | |
| system_versioning_alter_history ERROR | |
| system_versioning_asof DEFAULT | |
| table_definition_cache 400 | |
| table_open_cache 600 | |
| table_open_cache_instances 8 | |
| tcp_keepalive_interval 0 | |
| tcp_keepalive_probes 0 | |
| tcp_keepalive_time 0 | |
| thread_cache_size 256 | |
| thread_concurrency 10 | |
| thread_handling one-thread-per-connection | |
| 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 8 | |
| thread_pool_stall_limit 500 | |
| thread_stack 299008 | |
| time_format %H:%i:%s | |
| time_zone SYSTEM | |
| timed_mutexes OFF | |
| tmp_disk_table_size 18446744073709551615 | |
| tmp_memory_table_size 2147483648 | |
| tmp_table_size 2147483648 | |
| 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.18-MariaDB | |
| version_comment MariaDB Server | |
| version_compile_machine x86_64 | |
| version_compile_os Linux | |
| version_malloc_library system | |
| version_source_revision 604f80e77c054758aa449064cdc29dfa13a71922 | |
| version_ssl_library OpenSSL 1.0.2k-fips 26 Jan 2017 | |
| 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_cluster | |
| 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 example.example.de | |
| 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-0000-0000-000000000000:-1 | |
| wsrep_sync_wait 0 |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment