Advertisement
Guest User

Untitled

a guest
Sep 23rd, 2021
3,885
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 49.81 KB | None | 0 0
  1. "Variable_name" "Value"
  2. "Aborted_clients" "6"
  3. "Aborted_connects" "1441"
  4. "Aborted_connects_preauth" "959"
  5. "Access_denied_errors" "0"
  6. "Acl_column_grants" "0"
  7. "Acl_database_grants" "11"
  8. "Acl_function_grants" "0"
  9. "Acl_procedure_grants" "0"
  10. "Acl_package_spec_grants" "0"
  11. "Acl_package_body_grants" "0"
  12. "Acl_proxy_users" "2"
  13. "Acl_role_grants" "0"
  14. "Acl_roles" "0"
  15. "Acl_table_grants" "0"
  16. "Acl_users" "12"
  17. "Aria_pagecache_blocks_not_flushed" "0"
  18. "Aria_pagecache_blocks_unused" "15697"
  19. "Aria_pagecache_blocks_used" "3277"
  20. "Aria_pagecache_read_requests" "688837565"
  21. "Aria_pagecache_reads" "19022930"
  22. "Aria_pagecache_write_requests" "269719289"
  23. "Aria_pagecache_writes" "59407252"
  24. "Aria_transaction_log_syncs" "25641"
  25. "Binlog_commits" "0"
  26. "Binlog_group_commits" "0"
  27. "Binlog_group_commit_trigger_count" "0"
  28. "Binlog_group_commit_trigger_lock_wait" "0"
  29. "Binlog_group_commit_trigger_timeout" "0"
  30. "Binlog_snapshot_file"
  31. "Binlog_snapshot_position" "0"
  32. "Binlog_bytes_written" "0"
  33. "Binlog_cache_disk_use" "0"
  34. "Binlog_cache_use" "0"
  35. "Binlog_stmt_cache_disk_use" "0"
  36. "Binlog_stmt_cache_use" "0"
  37. "Busy_time" "0.000000"
  38. "Bytes_received" "84758330406"
  39. "Bytes_sent" "866276687694"
  40. "Column_compressions" "0"
  41. "Column_decompressions" "0"
  42. "Com_admin_commands" "1"
  43. "Com_alter_db" "0"
  44. "Com_alter_db_upgrade" "0"
  45. "Com_alter_event" "0"
  46. "Com_alter_function" "0"
  47. "Com_alter_procedure" "0"
  48. "Com_alter_server" "0"
  49. "Com_alter_sequence" "0"
  50. "Com_alter_table" "4"
  51. "Com_alter_tablespace" "0"
  52. "Com_alter_user" "0"
  53. "Com_analyze" "0"
  54. "Com_assign_to_keycache" "0"
  55. "Com_backup" "0"
  56. "Com_backup_lock" "0"
  57. "Com_begin" "104871"
  58. "Com_binlog" "0"
  59. "Com_call_procedure" "0"
  60. "Com_change_db" "5990870"
  61. "Com_change_master" "0"
  62. "Com_check" "0"
  63. "Com_checksum" "0"
  64. "Com_commit" "104831"
  65. "Com_compound_sql" "0"
  66. "Com_create_db" "0"
  67. "Com_create_event" "0"
  68. "Com_create_function" "0"
  69. "Com_create_index" "0"
  70. "Com_create_package" "0"
  71. "Com_create_package_body" "0"
  72. "Com_create_procedure" "0"
  73. "Com_create_role" "0"
  74. "Com_create_sequence" "0"
  75. "Com_create_server" "0"
  76. "Com_create_table" "911"
  77. "Com_create_temporary_table" "0"
  78. "Com_create_trigger" "0"
  79. "Com_create_udf" "0"
  80. "Com_create_user" "0"
  81. "Com_create_view" "0"
  82. "Com_dealloc_sql" "0"
  83. "Com_delete" "27242"
  84. "Com_delete_multi" "0"
  85. "Com_do" "0"
  86. "Com_drop_db" "0"
  87. "Com_drop_event" "0"
  88. "Com_drop_function" "0"
  89. "Com_drop_index" "0"
  90. "Com_drop_procedure" "0"
  91. "Com_drop_package" "0"
  92. "Com_drop_package_body" "0"
  93. "Com_drop_role" "0"
  94. "Com_drop_server" "0"
  95. "Com_drop_sequence" "0"
  96. "Com_drop_table" "0"
  97. "Com_drop_temporary_table" "0"
  98. "Com_drop_trigger" "0"
  99. "Com_drop_user" "0"
  100. "Com_drop_view" "0"
  101. "Com_empty_query" "0"
  102. "Com_execute_immediate" "0"
  103. "Com_execute_sql" "0"
  104. "Com_flush" "0"
  105. "Com_get_diagnostics" "0"
  106. "Com_grant" "0"
  107. "Com_grant_role" "0"
  108. "Com_ha_close" "0"
  109. "Com_ha_open" "0"
  110. "Com_ha_read" "0"
  111. "Com_help" "0"
  112. "Com_insert" "87669877"
  113. "Com_insert_select" "1957"
  114. "Com_install_plugin" "0"
  115. "Com_kill" "0"
  116. "Com_load" "0"
  117. "Com_lock_tables" "0"
  118. "Com_multi" "0"
  119. "Com_optimize" "0"
  120. "Com_preload_keys" "0"
  121. "Com_prepare_sql" "0"
  122. "Com_purge" "0"
  123. "Com_purge_before_date" "0"
  124. "Com_release_savepoint" "40"
  125. "Com_rename_table" "0"
  126. "Com_rename_user" "0"
  127. "Com_repair" "0"
  128. "Com_replace" "0"
  129. "Com_replace_select" "0"
  130. "Com_reset" "0"
  131. "Com_resignal" "0"
  132. "Com_revoke" "0"
  133. "Com_revoke_all" "0"
  134. "Com_revoke_role" "0"
  135. "Com_rollback" "0"
  136. "Com_rollback_to_savepoint" "2289"
  137. "Com_savepoint" "40"
  138. "Com_select" "282029692"
  139. "Com_set_option" "24009273"
  140. "Com_show_authors" "0"
  141. "Com_show_binlog_events" "0"
  142. "Com_show_binlogs" "0"
  143. "Com_show_charsets" "0"
  144. "Com_show_collations" "0"
  145. "Com_show_contributors" "0"
  146. "Com_show_create_db" "0"
  147. "Com_show_create_event" "0"
  148. "Com_show_create_func" "0"
  149. "Com_show_create_package" "0"
  150. "Com_show_create_package_body" "0"
  151. "Com_show_create_proc" "0"
  152. "Com_show_create_table" "2290"
  153. "Com_show_create_trigger" "0"
  154. "Com_show_create_user" "0"
  155. "Com_show_databases" "0"
  156. "Com_show_engine_logs" "0"
  157. "Com_show_engine_mutex" "0"
  158. "Com_show_engine_status" "0"
  159. "Com_show_errors" "0"
  160. "Com_show_events" "0"
  161. "Com_show_explain" "0"
  162. "Com_show_fields" "476868"
  163. "Com_show_function_status" "0"
  164. "Com_show_generic" "0"
  165. "Com_show_grants" "0"
  166. "Com_show_keys" "0"
  167. "Com_show_master_status" "0"
  168. "Com_show_open_tables" "0"
  169. "Com_show_package_status" "0"
  170. "Com_show_package_body_status" "0"
  171. "Com_show_plugins" "0"
  172. "Com_show_privileges" "0"
  173. "Com_show_procedure_status" "0"
  174. "Com_show_processlist" "6"
  175. "Com_show_profile" "0"
  176. "Com_show_profiles" "0"
  177. "Com_show_relaylog_events" "0"
  178. "Com_show_slave_hosts" "0"
  179. "Com_show_slave_status" "0"
  180. "Com_show_status" "1972"
  181. "Com_show_storage_engines" "0"
  182. "Com_show_table_status" "5"
  183. "Com_show_tables" "259161"
  184. "Com_show_triggers" "0"
  185. "Com_show_variables" "23"
  186. "Com_show_warnings" "19180"
  187. "Com_shutdown" "0"
  188. "Com_signal" "0"
  189. "Com_start_all_slaves" "0"
  190. "Com_start_slave" "0"
  191. "Com_stmt_close" "0"
  192. "Com_stmt_execute" "0"
  193. "Com_stmt_fetch" "0"
  194. "Com_stmt_prepare" "0"
  195. "Com_stmt_reprepare" "0"
  196. "Com_stmt_reset" "0"
  197. "Com_stmt_send_long_data" "0"
  198. "Com_stop_all_slaves" "0"
  199. "Com_stop_slave" "0"
  200. "Com_truncate" "40"
  201. "Com_uninstall_plugin" "0"
  202. "Com_unlock_tables" "40"
  203. "Com_update" "1452911"
  204. "Com_update_multi" "0"
  205. "Com_xa_commit" "0"
  206. "Com_xa_end" "0"
  207. "Com_xa_prepare" "0"
  208. "Com_xa_recover" "0"
  209. "Com_xa_rollback" "0"
  210. "Com_xa_start" "0"
  211. "Compression" "OFF"
  212. "Connection_errors_accept" "0"
  213. "Connection_errors_internal" "26"
  214. "Connection_errors_max_connections" "26"
  215. "Connection_errors_peer_address" "0"
  216. "Connection_errors_select" "0"
  217. "Connection_errors_tcpwrap" "0"
  218. "Connections" "11987448"
  219. "Cpu_time" "0.000000"
  220. "Created_tmp_disk_tables" "23539653"
  221. "Created_tmp_files" "45"
  222. "Created_tmp_tables" "96501765"
  223. "Delayed_errors" "0"
  224. "Delayed_insert_threads" "0"
  225. "Delayed_writes" "0"
  226. "Delete_scan" "35"
  227. "Empty_queries" "32395664"
  228. "Executed_events" "0"
  229. "Executed_triggers" "0"
  230. "Feature_application_time_periods" "0"
  231. "Feature_check_constraint" "1"
  232. "Feature_custom_aggregate_functions" "0"
  233. "Feature_delay_key_write" "0"
  234. "Feature_dynamic_columns" "0"
  235. "Feature_fulltext" "0"
  236. "Feature_gis" "0"
  237. "Feature_invisible_columns" "0"
  238. "Feature_json" "1"
  239. "Feature_locale" "0"
  240. "Feature_subquery" "4045680"
  241. "Feature_system_versioning" "0"
  242. "Feature_timezone" "8671"
  243. "Feature_trigger" "0"
  244. "Feature_window_functions" "0"
  245. "Feature_xml" "0"
  246. "Flush_commands" "1"
  247. "Handler_commit" "238555190"
  248. "Handler_delete" "503577"
  249. "Handler_discover" "0"
  250. "Handler_external_lock" "0"
  251. "Handler_icp_attempts" "20623679650"
  252. "Handler_icp_match" "20605794593"
  253. "Handler_mrr_init" "0"
  254. "Handler_mrr_key_refills" "0"
  255. "Handler_mrr_rowid_refills" "0"
  256. "Handler_prepare" "0"
  257. "Handler_read_first" "823155"
  258. "Handler_read_key" "146823076488"
  259. "Handler_read_last" "127939"
  260. "Handler_read_next" "385198074155"
  261. "Handler_read_prev" "177984"
  262. "Handler_read_retry" "0"
  263. "Handler_read_rnd" "1010688469"
  264. "Handler_read_rnd_deleted" "2707950"
  265. "Handler_read_rnd_next" "9902395915"
  266. "Handler_rollback" "999"
  267. "Handler_savepoint" "40"
  268. "Handler_savepoint_rollback" "2289"
  269. "Handler_tmp_delete" "0"
  270. "Handler_tmp_update" "1448587457"
  271. "Handler_tmp_write" "2437491504"
  272. "Handler_update" "614833861"
  273. "Handler_write" "92325018"
  274. "Innodb_buffer_pool_dump_status"
  275. "Innodb_buffer_pool_load_status" "Buffer pool(s) load completed at 210903 13:57:28"
  276. "Innodb_buffer_pool_resize_status"
  277. "Innodb_buffer_pool_load_incomplete" "OFF"
  278. "Innodb_buffer_pool_pages_data" "496385"
  279. "Innodb_buffer_pool_bytes_data" "8132771840"
  280. "Innodb_buffer_pool_pages_dirty" "0"
  281. "Innodb_buffer_pool_bytes_dirty" "0"
  282. "Innodb_buffer_pool_pages_flushed" "24639681"
  283. "Innodb_buffer_pool_pages_free" "8268"
  284. "Innodb_buffer_pool_pages_misc" "8307"
  285. "Innodb_buffer_pool_pages_total" "512960"
  286. "Innodb_buffer_pool_read_ahead_rnd" "0"
  287. "Innodb_buffer_pool_read_ahead" "48978"
  288. "Innodb_buffer_pool_read_ahead_evicted" "0"
  289. "Innodb_buffer_pool_read_requests" "1164717999783"
  290. "Innodb_buffer_pool_reads" "432072"
  291. "Innodb_buffer_pool_wait_free" "0"
  292. "Innodb_buffer_pool_write_requests" "2054047633"
  293. "Innodb_data_fsyncs" "52875899"
  294. "Innodb_data_pending_fsyncs" "0"
  295. "Innodb_data_pending_reads" "0"
  296. "Innodb_data_pending_writes" "0"
  297. "Innodb_data_read" "7969573376"
  298. "Innodb_data_reads" "486596"
  299. "Innodb_data_writes" "72893648"
  300. "Innodb_data_written" "945455674880"
  301. "Innodb_dblwr_pages_written" "24639550"
  302. "Innodb_dblwr_writes" "3843981"
  303. "Innodb_log_waits" "0"
  304. "Innodb_log_write_requests" "200700193"
  305. "Innodb_log_writes" "43856157"
  306. "Innodb_os_log_fsyncs" "44370041"
  307. "Innodb_os_log_pending_fsyncs" "0"
  308. "Innodb_os_log_pending_writes" "0"
  309. "Innodb_os_log_written" "137804939264"
  310. "Innodb_page_size" "16384"
  311. "Innodb_pages_created" "45599"
  312. "Innodb_pages_read" "486434"
  313. "Innodb_pages_written" "24639681"
  314. "Innodb_row_lock_current_waits" "0"
  315. "Innodb_row_lock_time" "4701"
  316. "Innodb_row_lock_time_avg" "391"
  317. "Innodb_row_lock_time_max" "1345"
  318. "Innodb_row_lock_waits" "12"
  319. "Innodb_rows_deleted" "503577"
  320. "Innodb_rows_inserted" "1439631"
  321. "Innodb_rows_read" "496100627628"
  322. "Innodb_rows_updated" "614833216"
  323. "Innodb_system_rows_deleted" "0"
  324. "Innodb_system_rows_inserted" "0"
  325. "Innodb_system_rows_read" "0"
  326. "Innodb_system_rows_updated" "0"
  327. "Innodb_num_open_files" "159"
  328. "Innodb_truncated_status_writes" "0"
  329. "Innodb_available_undo_logs" "128"
  330. "Innodb_undo_truncations" "0"
  331. "Innodb_page_compression_saved" "0"
  332. "Innodb_num_index_pages_written" "0"
  333. "Innodb_num_non_index_pages_written" "0"
  334. "Innodb_num_pages_page_compressed" "0"
  335. "Innodb_num_page_compressed_trim_op" "0"
  336. "Innodb_num_pages_page_decompressed" "0"
  337. "Innodb_num_pages_page_compression_error" "0"
  338. "Innodb_num_pages_encrypted" "0"
  339. "Innodb_num_pages_decrypted" "0"
  340. "Innodb_have_lz4" "OFF"
  341. "Innodb_have_lzo" "OFF"
  342. "Innodb_have_lzma" "OFF"
  343. "Innodb_have_bzip2" "OFF"
  344. "Innodb_have_snappy" "OFF"
  345. "Innodb_have_punch_hole" "OFF"
  346. "Innodb_defragment_compression_failures" "0"
  347. "Innodb_defragment_failures" "0"
  348. "Innodb_defragment_count" "0"
  349. "Innodb_instant_alter_column" "0"
  350. "Innodb_onlineddl_rowlog_rows" "0"
  351. "Innodb_onlineddl_rowlog_pct_used" "0"
  352. "Innodb_onlineddl_pct_progress" "0"
  353. "Innodb_secondary_index_triggered_cluster_reads" "262925468107"
  354. "Innodb_secondary_index_triggered_cluster_reads_avoided" "0"
  355. "Innodb_encryption_rotation_pages_read_from_cache" "0"
  356. "Innodb_encryption_rotation_pages_read_from_disk" "0"
  357. "Innodb_encryption_rotation_pages_modified" "0"
  358. "Innodb_encryption_rotation_pages_flushed" "0"
  359. "Innodb_encryption_rotation_estimated_iops" "0"
  360. "Innodb_encryption_key_rotation_list_length" "0"
  361. "Innodb_encryption_n_merge_blocks_encrypted" "0"
  362. "Innodb_encryption_n_merge_blocks_decrypted" "0"
  363. "Innodb_encryption_n_rowlog_blocks_encrypted" "0"
  364. "Innodb_encryption_n_rowlog_blocks_decrypted" "0"
  365. "Innodb_encryption_n_temp_blocks_encrypted" "0"
  366. "Innodb_encryption_n_temp_blocks_decrypted" "0"
  367. "Innodb_scrub_background_page_reorganizations" "0"
  368. "Innodb_scrub_background_page_splits" "0"
  369. "Innodb_scrub_background_page_split_failures_underflow" "0"
  370. "Innodb_scrub_background_page_split_failures_out_of_filespace" "0"
  371. "Innodb_scrub_background_page_split_failures_missing_index" "0"
  372. "Innodb_scrub_background_page_split_failures_unknown" "0"
  373. "Innodb_scrub_log" "0"
  374. "Innodb_encryption_num_key_requests" "0"
  375. "Key_blocks_not_flushed" "0"
  376. "Key_blocks_unused" "106703"
  377. "Key_blocks_used" "460"
  378. "Key_blocks_warm" "3"
  379. "Key_read_requests" "268981955"
  380. "Key_reads" "404"
  381. "Key_write_requests" "40284646"
  382. "Key_writes" "19978377"
  383. "Last_query_cost" "0.000000"
  384. "Master_gtid_wait_count" "0"
  385. "Master_gtid_wait_time" "0"
  386. "Master_gtid_wait_timeouts" "0"
  387. "Max_statement_time_exceeded" "0"
  388. "Max_used_connections" "152"
  389. "Memory_used" "321792504"
  390. "Memory_used_initial" "273400512"
  391. "Not_flushed_delayed_rows" "0"
  392. "Open_files" "92"
  393. "Open_streams" "0"
  394. "Open_table_definitions" "183"
  395. "Open_tables" "1062"
  396. "Opened_files" "94158075"
  397. "Opened_plugin_libraries" "0"
  398. "Opened_table_definitions" "229"
  399. "Opened_tables" "1109"
  400. "Opened_views" "0"
  401. "Performance_schema_accounts_lost" "0"
  402. "Performance_schema_cond_classes_lost" "0"
  403. "Performance_schema_cond_instances_lost" "0"
  404. "Performance_schema_digest_lost" "0"
  405. "Performance_schema_file_classes_lost" "0"
  406. "Performance_schema_file_handles_lost" "0"
  407. "Performance_schema_file_instances_lost" "0"
  408. "Performance_schema_hosts_lost" "0"
  409. "Performance_schema_locker_lost" "0"
  410. "Performance_schema_mutex_classes_lost" "0"
  411. "Performance_schema_mutex_instances_lost" "0"
  412. "Performance_schema_rwlock_classes_lost" "0"
  413. "Performance_schema_rwlock_instances_lost" "0"
  414. "Performance_schema_session_connect_attrs_lost" "0"
  415. "Performance_schema_socket_classes_lost" "0"
  416. "Performance_schema_socket_instances_lost" "0"
  417. "Performance_schema_stage_classes_lost" "0"
  418. "Performance_schema_statement_classes_lost" "0"
  419. "Performance_schema_table_handles_lost" "0"
  420. "Performance_schema_table_instances_lost" "0"
  421. "Performance_schema_thread_classes_lost" "0"
  422. "Performance_schema_thread_instances_lost" "0"
  423. "Performance_schema_users_lost" "0"
  424. "Prepared_stmt_count" "0"
  425. "Qcache_free_blocks" "28"
  426. "Qcache_free_memory" "78344"
  427. "Qcache_hits" "37201050"
  428. "Qcache_inserts" "146211296"
  429. "Qcache_lowmem_prunes" "125234412"
  430. "Qcache_not_cached" "78413835"
  431. "Qcache_queries_in_cache" "82"
  432. "Qcache_total_blocks" "229"
  433. "Queries" "414140315"
  434. "Questions" "414140316"
  435. "Rows_read" "495917164049"
  436. "Rows_sent" "26594334894"
  437. "Rows_tmp_read" "4486774905"
  438. "Rpl_semi_sync_master_clients" "0"
  439. "Rpl_semi_sync_master_get_ack" "0"
  440. "Rpl_semi_sync_master_net_avg_wait_time" "0"
  441. "Rpl_semi_sync_master_net_wait_time" "0"
  442. "Rpl_semi_sync_master_net_waits" "0"
  443. "Rpl_semi_sync_master_no_times" "0"
  444. "Rpl_semi_sync_master_no_tx" "0"
  445. "Rpl_semi_sync_master_request_ack" "0"
  446. "Rpl_semi_sync_master_status" "OFF"
  447. "Rpl_semi_sync_master_timefunc_failures" "0"
  448. "Rpl_semi_sync_master_tx_avg_wait_time" "0"
  449. "Rpl_semi_sync_master_tx_wait_time" "0"
  450. "Rpl_semi_sync_master_tx_waits" "0"
  451. "Rpl_semi_sync_master_wait_pos_backtraverse" "0"
  452. "Rpl_semi_sync_master_wait_sessions" "0"
  453. "Rpl_semi_sync_master_yes_tx" "0"
  454. "Rpl_semi_sync_slave_send_ack" "0"
  455. "Rpl_semi_sync_slave_status" "OFF"
  456. "Rpl_status" "AUTH_MASTER"
  457. "Rpl_transactions_multi_engine" "0"
  458. "Select_full_join" "30333225"
  459. "Select_full_range_join" "2"
  460. "Select_range" "14006873"
  461. "Select_range_check" "0"
  462. "Select_scan" "3165965"
  463. "Slave_connections" "0"
  464. "Slave_heartbeat_period" "0.000"
  465. "Slave_open_temp_tables" "0"
  466. "Slave_received_heartbeats" "0"
  467. "Slave_retried_transactions" "0"
  468. "Slave_running" "OFF"
  469. "Slave_skipped_errors" "0"
  470. "Slaves_connected" "0"
  471. "Slaves_running" "0"
  472. "Slow_launch_threads" "0"
  473. "Slow_queries" "131"
  474. "Sort_merge_passes" "20"
  475. "Sort_priority_queue_sorts" "3758219"
  476. "Sort_range" "5011121"
  477. "Sort_rows" "1503713188"
  478. "Sort_scan" "53248623"
  479. "Ssl_accept_renegotiates" "0"
  480. "Ssl_accepts" "0"
  481. "Ssl_callback_cache_hits" "0"
  482. "Ssl_cipher"
  483. "Ssl_cipher_list"
  484. "Ssl_client_connects" "0"
  485. "Ssl_connect_renegotiates" "0"
  486. "Ssl_ctx_verify_depth" "0"
  487. "Ssl_ctx_verify_mode" "0"
  488. "Ssl_default_timeout" "0"
  489. "Ssl_finished_accepts" "0"
  490. "Ssl_finished_connects" "0"
  491. "Ssl_server_not_after"
  492. "Ssl_server_not_before"
  493. "Ssl_session_cache_hits" "0"
  494. "Ssl_session_cache_misses" "0"
  495. "Ssl_session_cache_mode" "NONE"
  496. "Ssl_session_cache_overflows" "0"
  497. "Ssl_session_cache_size" "0"
  498. "Ssl_session_cache_timeouts" "0"
  499. "Ssl_sessions_reused" "0"
  500. "Ssl_used_session_cache_entries" "0"
  501. "Ssl_verify_depth" "0"
  502. "Ssl_verify_mode" "0"
  503. "Ssl_version"
  504. "Subquery_cache_hit" "0"
  505. "Subquery_cache_miss" "0"
  506. "Syncs" "51311"
  507. "Table_locks_immediate" "40740349"
  508. "Table_locks_waited" "23713"
  509. "Table_open_cache_active_instances" "1"
  510. "Table_open_cache_hits" "436428730"
  511. "Table_open_cache_misses" "1109"
  512. "Table_open_cache_overflows" "0"
  513. "Tc_log_max_pages_used" "0"
  514. "Tc_log_page_size" "0"
  515. "Tc_log_page_waits" "0"
  516. "Threadpool_idle_threads" "0"
  517. "Threadpool_threads" "0"
  518. "Threads_cached" "51"
  519. "Threads_connected" "100"
  520. "Threads_created" "153"
  521. "Threads_running" "6"
  522. "Transactions_gtid_foreign_engine" "0"
  523. "Transactions_multi_engine" "0"
  524. "Update_scan" "4615"
  525. "Uptime" "1725103"
  526. "Uptime_since_flush_status" "1725103"
  527. "wsrep" "14408211716257585"
  528. "wsrep_applier_thread_count" "0"
  529. "wsrep_cluster_capabilities"
  530. "wsrep_cluster_conf_id" "18446744073709551615"
  531. "wsrep_cluster_size" "0"
  532. "wsrep_cluster_state_uuid"
  533. "wsrep_cluster_status" "Disconnected"
  534. "wsrep_connected" "OFF"
  535. "wsrep_local_bf_aborts" "0"
  536. "wsrep_local_index" "18446744073709551615"
  537. "wsrep_provider_capabilities"
  538. "wsrep_provider_name"
  539. "wsrep_provider_vendor"
  540. "wsrep_provider_version"
  541. "wsrep_ready" "OFF"
  542. "wsrep_rollbacker_thread_count" "0"
  543. "wsrep_thread_count" "0"
  544. "alter_algorithm" "DEFAULT"
  545. "analyze_sample_percentage" "100.000000"
  546. "aria_block_size" "8192"
  547. "aria_checkpoint_interval" "30"
  548. "aria_checkpoint_log_activity" "1048576"
  549. "aria_encrypt_tables" "OFF"
  550. "aria_force_start_after_recovery_failures" "0"
  551. "aria_group_commit" "none"
  552. "aria_group_commit_interval" "0"
  553. "aria_log_file_size" "1073741824"
  554. "aria_log_purge_type" "immediate"
  555. "aria_max_sort_file_size" "9223372036853727232"
  556. "aria_page_checksum" "ON"
  557. "aria_pagecache_age_threshold" "300"
  558. "aria_pagecache_buffer_size" "134217728"
  559. "aria_pagecache_division_limit" "100"
  560. "aria_pagecache_file_hash_size" "512"
  561. "aria_recover_options" "BACKUP,QUICK"
  562. "aria_repair_threads" "1"
  563. "aria_sort_buffer_size" "268434432"
  564. "aria_stats_method" "nulls_unequal"
  565. "aria_sync_log_dir" "NEWFILE"
  566. "aria_used_for_temp_tables" "ON"
  567. "auto_increment_increment" "1"
  568. "auto_increment_offset" "1"
  569. "autocommit" "ON"
  570. "automatic_sp_privileges" "ON"
  571. "back_log" "80"
  572. "basedir" "/usr"
  573. "big_tables" "OFF"
  574. "bind_address"
  575. "binlog_annotate_row_events" "ON"
  576. "binlog_cache_size" "32768"
  577. "binlog_checksum" "CRC32"
  578. "binlog_commit_wait_count" "0"
  579. "binlog_commit_wait_usec" "100000"
  580. "binlog_direct_non_transactional_updates" "OFF"
  581. "binlog_file_cache_size" "16384"
  582. "binlog_format" "MIXED"
  583. "binlog_optimize_thread_scheduling" "ON"
  584. "binlog_row_image" "FULL"
  585. "binlog_stmt_cache_size" "32768"
  586. "bulk_insert_buffer_size" "8388608"
  587. "character_set_client" "latin1"
  588. "character_set_connection" "latin1"
  589. "character_set_database" "latin1"
  590. "character_set_filesystem" "binary"
  591. "character_set_results" "latin1"
  592. "character_set_server" "latin1"
  593. "character_set_system" "utf8"
  594. "character_sets_dir" "/usr/share/mysql/charsets/"
  595. "check_constraint_checks" "ON"
  596. "collation_connection" "latin1_swedish_ci"
  597. "collation_database" "latin1_swedish_ci"
  598. "collation_server" "latin1_swedish_ci"
  599. "column_compression_threshold" "100"
  600. "column_compression_zlib_level" "6"
  601. "column_compression_zlib_strategy" "DEFAULT_STRATEGY"
  602. "column_compression_zlib_wrap" "OFF"
  603. "completion_type" "NO_CHAIN"
  604. "concurrent_insert" "AUTO"
  605. "connect_timeout" "10"
  606. "core_file" "OFF"
  607. "datadir" "/var/lib/mysql/"
  608. "date_format" "%Y-%m-%d"
  609. "datetime_format" "%Y-%m-%d %H:%i:%s"
  610. "deadlock_search_depth_long" "15"
  611. "deadlock_search_depth_short" "4"
  612. "deadlock_timeout_long" "50000000"
  613. "deadlock_timeout_short" "10000"
  614. "debug_no_thread_alarm" "OFF"
  615. "default_password_lifetime" "0"
  616. "default_regex_flags"
  617. "default_storage_engine" "InnoDB"
  618. "default_tmp_storage_engine"
  619. "default_week_format" "0"
  620. "delay_key_write" "ON"
  621. "delayed_insert_limit" "100"
  622. "delayed_insert_timeout" "300"
  623. "delayed_queue_size" "1000"
  624. "disconnect_on_expired_password" "OFF"
  625. "div_precision_increment" "4"
  626. "encrypt_binlog" "OFF"
  627. "encrypt_tmp_disk_tables" "OFF"
  628. "encrypt_tmp_files" "OFF"
  629. "enforce_storage_engine"
  630. "eq_range_index_dive_limit" "200"
  631. "event_scheduler" "OFF"
  632. "expensive_subquery_limit" "100"
  633. "expire_logs_days" "0"
  634. "explicit_defaults_for_timestamp" "OFF"
  635. "extra_max_connections" "1"
  636. "extra_port" "0"
  637. "flush" "OFF"
  638. "flush_time" "0"
  639. "foreign_key_checks" "ON"
  640. "ft_boolean_syntax" "+ -><()~*:""""&|"
  641. "ft_max_word_len" "84"
  642. "ft_min_word_len" "4"
  643. "ft_query_expansion_limit" "20"
  644. "ft_stopword_file" "(built-in)"
  645. "general_log" "ON"
  646. "general_log_file" "web11.log"
  647. "group_concat_max_len" "1048576"
  648. "gtid_binlog_pos"
  649. "gtid_binlog_state"
  650. "gtid_cleanup_batch_size" "64"
  651. "gtid_current_pos"
  652. "gtid_domain_id" "0"
  653. "gtid_ignore_duplicates" "OFF"
  654. "gtid_pos_auto_engines"
  655. "gtid_slave_pos"
  656. "gtid_strict_mode" "OFF"
  657. "have_compress" "YES"
  658. "have_crypt" "YES"
  659. "have_dynamic_loading" "YES"
  660. "have_geometry" "YES"
  661. "have_openssl" "YES"
  662. "have_profiling" "YES"
  663. "have_query_cache" "YES"
  664. "have_rtree_keys" "YES"
  665. "have_ssl" "DISABLED"
  666. "have_symlink" "YES"
  667. "histogram_size" "254"
  668. "histogram_type" "DOUBLE_PREC_HB"
  669. "host_cache_size" "279"
  670. "hostname" "web11. martind.com"
  671. "idle_readonly_transaction_timeout" "0"
  672. "idle_transaction_timeout" "0"
  673. "idle_write_transaction_timeout" "0"
  674. "ignore_builtin_innodb" "OFF"
  675. "ignore_db_dirs"
  676. "in_predicate_conversion_threshold" "1000"
  677. "init_connect"
  678. "init_file"
  679. "init_slave"
  680. "innodb_adaptive_flushing" "ON"
  681. "innodb_adaptive_flushing_lwm" "10.000000"
  682. "innodb_adaptive_hash_index" "ON"
  683. "innodb_adaptive_hash_index_parts" "8"
  684. "innodb_adaptive_max_sleep_delay" "150000"
  685. "innodb_autoextend_increment" "64"
  686. "innodb_autoinc_lock_mode" "1"
  687. "innodb_background_scrub_data_check_interval" "3600"
  688. "innodb_background_scrub_data_compressed" "OFF"
  689. "innodb_background_scrub_data_interval" "604800"
  690. "innodb_background_scrub_data_uncompressed" "OFF"
  691. "innodb_buf_dump_status_frequency" "0"
  692. "innodb_buffer_pool_chunk_size" "134217728"
  693. "innodb_buffer_pool_dump_at_shutdown" "ON"
  694. "innodb_buffer_pool_dump_now" "OFF"
  695. "innodb_buffer_pool_dump_pct" "25"
  696. "innodb_buffer_pool_filename" "ib_buffer_pool"
  697. "innodb_buffer_pool_instances" "8"
  698. "innodb_buffer_pool_load_abort" "OFF"
  699. "innodb_buffer_pool_load_at_startup" "ON"
  700. "innodb_buffer_pool_load_now" "OFF"
  701. "innodb_buffer_pool_size" "8589934592"
  702. "innodb_change_buffer_max_size" "25"
  703. "innodb_change_buffering" "all"
  704. "innodb_checksum_algorithm" "crc32"
  705. "innodb_checksums" "ON"
  706. "innodb_cmp_per_index_enabled" "OFF"
  707. "innodb_commit_concurrency" "0"
  708. "innodb_compression_algorithm" "zlib"
  709. "innodb_compression_default" "OFF"
  710. "innodb_compression_failure_threshold_pct" "5"
  711. "innodb_compression_level" "6"
  712. "innodb_compression_pad_pct_max" "50"
  713. "innodb_concurrency_tickets" "5000"
  714. "innodb_data_file_path" "ibdata1:12M:autoextend"
  715. "innodb_data_home_dir"
  716. "innodb_deadlock_detect" "ON"
  717. "innodb_default_encryption_key_id" "1"
  718. "innodb_default_row_format" "dynamic"
  719. "innodb_defragment" "OFF"
  720. "innodb_defragment_fill_factor" "0.900000"
  721. "innodb_defragment_fill_factor_n_recs" "20"
  722. "innodb_defragment_frequency" "40"
  723. "innodb_defragment_n_pages" "7"
  724. "innodb_defragment_stats_accuracy" "0"
  725. "innodb_disable_sort_file_cache" "OFF"
  726. "innodb_disallow_writes" "OFF"
  727. "innodb_doublewrite" "ON"
  728. "innodb_encrypt_log" "OFF"
  729. "innodb_encrypt_tables" "OFF"
  730. "innodb_encrypt_temporary_tables" "OFF"
  731. "innodb_encryption_rotate_key_age" "1"
  732. "innodb_encryption_rotation_iops" "100"
  733. "innodb_encryption_threads" "0"
  734. "innodb_fast_shutdown" "1"
  735. "innodb_fatal_semaphore_wait_threshold" "600"
  736. "innodb_file_format"
  737. "innodb_file_per_table" "ON"
  738. "innodb_fill_factor" "100"
  739. "innodb_flush_log_at_timeout" "1"
  740. "innodb_flush_log_at_trx_commit" "1"
  741. "innodb_flush_method" "fsync"
  742. "innodb_flush_neighbors" "1"
  743. "innodb_flush_sync" "ON"
  744. "innodb_flushing_avg_loops" "30"
  745. "innodb_force_load_corrupted" "OFF"
  746. "innodb_force_primary_key" "OFF"
  747. "innodb_force_recovery" "0"
  748. "innodb_ft_aux_table"
  749. "innodb_ft_cache_size" "8000000"
  750. "innodb_ft_enable_diag_print" "OFF"
  751. "innodb_ft_enable_stopword" "ON"
  752. "innodb_ft_max_token_size" "84"
  753. "innodb_ft_min_token_size" "3"
  754. "innodb_ft_num_word_optimize" "2000"
  755. "innodb_ft_result_cache_limit" "2000000000"
  756. "innodb_ft_server_stopword_table"
  757. "innodb_ft_sort_pll_degree" "2"
  758. "innodb_ft_total_cache_size" "640000000"
  759. "innodb_ft_user_stopword_table"
  760. "innodb_idle_flush_pct" "100"
  761. "innodb_immediate_scrub_data_uncompressed" "OFF"
  762. "innodb_io_capacity" "200"
  763. "innodb_io_capacity_max" "2000"
  764. "innodb_large_prefix"
  765. "innodb_lock_schedule_algorithm" "fcfs"
  766. "innodb_lock_wait_timeout" "50"
  767. "innodb_locks_unsafe_for_binlog" "OFF"
  768. "innodb_log_buffer_size" "16777216"
  769. "innodb_log_checksums" "ON"
  770. "innodb_log_compressed_pages" "ON"
  771. "innodb_log_file_size" "50331648"
  772. "innodb_log_files_in_group" "2"
  773. "innodb_log_group_home_dir" "./"
  774. "innodb_log_optimize_ddl" "ON"
  775. "innodb_log_write_ahead_size" "8192"
  776. "innodb_lru_scan_depth" "1024"
  777. "innodb_max_dirty_pages_pct" "75.000000"
  778. "innodb_max_dirty_pages_pct_lwm" "0.000000"
  779. "innodb_max_purge_lag" "0"
  780. "innodb_max_purge_lag_delay" "0"
  781. "innodb_max_undo_log_size" "10485760"
  782. "innodb_monitor_disable"
  783. "innodb_monitor_enable"
  784. "innodb_monitor_reset"
  785. "innodb_monitor_reset_all"
  786. "innodb_old_blocks_pct" "37"
  787. "innodb_old_blocks_time" "1000"
  788. "innodb_online_alter_log_max_size" "134217728"
  789. "innodb_open_files" "2000"
  790. "innodb_optimize_fulltext_only" "OFF"
  791. "innodb_page_cleaners" "4"
  792. "innodb_page_size" "16384"
  793. "innodb_prefix_index_cluster_optimization" "OFF"
  794. "innodb_print_all_deadlocks" "OFF"
  795. "innodb_purge_batch_size" "300"
  796. "innodb_purge_rseg_truncate_frequency" "128"
  797. "innodb_purge_threads" "4"
  798. "innodb_random_read_ahead" "OFF"
  799. "innodb_read_ahead_threshold" "56"
  800. "innodb_read_io_threads" "4"
  801. "innodb_read_only" "OFF"
  802. "innodb_replication_delay" "0"
  803. "innodb_rollback_on_timeout" "OFF"
  804. "innodb_rollback_segments" "128"
  805. "innodb_scrub_log" "OFF"
  806. "innodb_scrub_log_speed" "256"
  807. "innodb_sort_buffer_size" "1048576"
  808. "innodb_spin_wait_delay" "4"
  809. "innodb_stats_auto_recalc" "ON"
  810. "innodb_stats_include_delete_marked" "OFF"
  811. "innodb_stats_method" "nulls_equal"
  812. "innodb_stats_modified_counter" "0"
  813. "innodb_stats_on_metadata" "OFF"
  814. "innodb_stats_persistent" "ON"
  815. "innodb_stats_persistent_sample_pages" "20"
  816. "innodb_stats_sample_pages" "8"
  817. "innodb_stats_traditional" "ON"
  818. "innodb_stats_transient_sample_pages" "8"
  819. "innodb_status_output" "OFF"
  820. "innodb_status_output_locks" "OFF"
  821. "innodb_strict_mode" "ON"
  822. "innodb_sync_array_size" "1"
  823. "innodb_sync_spin_loops" "30"
  824. "innodb_table_locks" "ON"
  825. "innodb_temp_data_file_path" "ibtmp1:12M:autoextend"
  826. "innodb_thread_concurrency" "0"
  827. "innodb_thread_sleep_delay" "10000"
  828. "innodb_tmpdir"
  829. "innodb_undo_directory" "./"
  830. "innodb_undo_log_truncate" "OFF"
  831. "innodb_undo_logs" "128"
  832. "innodb_undo_tablespaces" "0"
  833. "innodb_use_atomic_writes" "ON"
  834. "innodb_use_native_aio" "ON"
  835. "innodb_version" "10.4.12"
  836. "innodb_write_io_threads" "4"
  837. "interactive_timeout" "28800"
  838. "join_buffer_size" "262144"
  839. "join_buffer_space_limit" "2097152"
  840. "join_cache_level" "2"
  841. "keep_files_on_create" "OFF"
  842. "key_buffer_size" "134217728"
  843. "key_cache_age_threshold" "300"
  844. "key_cache_block_size" "1024"
  845. "key_cache_division_limit" "100"
  846. "key_cache_file_hash_size" "512"
  847. "key_cache_segments" "0"
  848. "large_files_support" "ON"
  849. "large_page_size" "0"
  850. "large_pages" "OFF"
  851. "lc_messages" "en_US"
  852. "lc_messages_dir"
  853. "lc_time_names" "en_US"
  854. "license" "GPL"
  855. "local_infile" "ON"
  856. "lock_wait_timeout" "86400"
  857. "locked_in_memory" "OFF"
  858. "log_bin" "OFF"
  859. "log_bin_basename"
  860. "log_bin_compress" "OFF"
  861. "log_bin_compress_min_len" "256"
  862. "log_bin_index"
  863. "log_bin_trust_function_creators" "OFF"
  864. "log_disabled_statements" "sp"
  865. "log_error" "/var/lib/mysql/web11. martind.com.err"
  866. "log_output" "TABLE"
  867. "log_queries_not_using_indexes" "OFF"
  868. "log_slave_updates" "OFF"
  869. "log_slow_admin_statements" "ON"
  870. "log_slow_disabled_statements" "sp"
  871. "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"
  872. "log_slow_rate_limit" "1"
  873. "log_slow_slave_statements" "ON"
  874. "log_slow_verbosity"
  875. "log_tc_size" "24576"
  876. "log_warnings" "2"
  877. "long_query_time" "10.000000"
  878. "low_priority_updates" "OFF"
  879. "lower_case_file_system" "OFF"
  880. "lower_case_table_names" "0"
  881. "master_verify_checksum" "OFF"
  882. "max_allowed_packet" "268435456"
  883. "max_binlog_cache_size" "18446744073709547520"
  884. "max_binlog_size" "1073741824"
  885. "max_binlog_stmt_cache_size" "18446744073709547520"
  886. "max_connect_errors" "100"
  887. "max_connections" "151"
  888. "max_delayed_threads" "20"
  889. "max_digest_length" "1024"
  890. "max_error_count" "64"
  891. "max_heap_table_size" "16777216"
  892. "max_insert_delayed_threads" "20"
  893. "max_join_size" "18446744073709551615"
  894. "max_length_for_sort_data" "1024"
  895. "max_long_data_size" "268435456"
  896. "max_password_errors" "4294967295"
  897. "max_prepared_stmt_count" "16382"
  898. "max_recursive_iterations" "4294967295"
  899. "max_relay_log_size" "1073741824"
  900. "max_rowid_filter_size" "131072"
  901. "max_seeks_for_key" "4294967295"
  902. "max_session_mem_used" "9223372036854775807"
  903. "max_sort_length" "1024"
  904. "max_sp_recursion_depth" "0"
  905. "max_statement_time" "0.000000"
  906. "max_tmp_tables" "32"
  907. "max_user_connections" "0"
  908. "max_write_lock_count" "4294967295"
  909. "metadata_locks_cache_size" "1024"
  910. "metadata_locks_hash_instances" "8"
  911. "min_examined_row_limit" "0"
  912. "mrr_buffer_size" "262144"
  913. "multi_range_count" "256"
  914. "myisam_block_size" "1024"
  915. "myisam_data_pointer_size" "6"
  916. "myisam_max_sort_file_size" "9223372036853727232"
  917. "myisam_mmap_size" "18446744073709551615"
  918. "myisam_recover_options" "BACKUP,QUICK"
  919. "myisam_repair_threads" "1"
  920. "myisam_sort_buffer_size" "134216704"
  921. "myisam_stats_method" "NULLS_UNEQUAL"
  922. "myisam_use_mmap" "OFF"
  923. "mysql56_temporal_format" "ON"
  924. "net_buffer_length" "16384"
  925. "net_read_timeout" "30"
  926. "net_retry_count" "10"
  927. "net_write_timeout" "60"
  928. "old" "OFF"
  929. "old_alter_table" "DEFAULT"
  930. "old_mode"
  931. "old_passwords" "OFF"
  932. "open_files_limit" "10000"
  933. "optimizer_prune_level" "1"
  934. "optimizer_search_depth" "62"
  935. "optimizer_selectivity_sampling_limit" "100"
  936. "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=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"
  937. "optimizer_trace" "enabled=off"
  938. "optimizer_trace_max_mem_size" "1048576"
  939. "optimizer_use_condition_selectivity" "4"
  940. "performance_schema" "OFF"
  941. "performance_schema_accounts_size" "-1"
  942. "performance_schema_digests_size" "-1"
  943. "performance_schema_events_stages_history_long_size" "-1"
  944. "performance_schema_events_stages_history_size" "-1"
  945. "performance_schema_events_statements_history_long_size" "-1"
  946. "performance_schema_events_statements_history_size" "-1"
  947. "performance_schema_events_waits_history_long_size" "-1"
  948. "performance_schema_events_waits_history_size" "-1"
  949. "performance_schema_hosts_size" "-1"
  950. "performance_schema_max_cond_classes" "90"
  951. "performance_schema_max_cond_instances" "-1"
  952. "performance_schema_max_digest_length" "1024"
  953. "performance_schema_max_file_classes" "50"
  954. "performance_schema_max_file_handles" "32768"
  955. "performance_schema_max_file_instances" "-1"
  956. "performance_schema_max_mutex_classes" "200"
  957. "performance_schema_max_mutex_instances" "-1"
  958. "performance_schema_max_rwlock_classes" "40"
  959. "performance_schema_max_rwlock_instances" "-1"
  960. "performance_schema_max_socket_classes" "10"
  961. "performance_schema_max_socket_instances" "-1"
  962. "performance_schema_max_stage_classes" "160"
  963. "performance_schema_max_statement_classes" "202"
  964. "performance_schema_max_table_handles" "-1"
  965. "performance_schema_max_table_instances" "-1"
  966. "performance_schema_max_thread_classes" "50"
  967. "performance_schema_max_thread_instances" "-1"
  968. "performance_schema_session_connect_attrs_size" "-1"
  969. "performance_schema_setup_actors_size" "100"
  970. "performance_schema_setup_objects_size" "100"
  971. "performance_schema_users_size" "-1"
  972. "pid_file" "/var/lib/mysql/web11. martind.com.pid"
  973. "plugin_dir" "/usr/lib64/mysql/plugin/"
  974. "plugin_maturity" "gamma"
  975. "port" "3306"
  976. "preload_buffer_size" "32768"
  977. "profiling" "OFF"
  978. "profiling_history_size" "15"
  979. "progress_report_time" "5"
  980. "protocol_version" "10"
  981. "proxy_protocol_networks"
  982. "query_alloc_block_size" "16384"
  983. "query_cache_limit" "1048576"
  984. "query_cache_min_res_unit" "4096"
  985. "query_cache_size" "524288"
  986. "query_cache_strip_comments" "OFF"
  987. "query_cache_type" "ON"
  988. "query_cache_wlock_invalidate" "OFF"
  989. "query_prealloc_size" "24576"
  990. "range_alloc_block_size" "4096"
  991. "read_binlog_speed_limit" "0"
  992. "read_buffer_size" "131072"
  993. "read_only" "OFF"
  994. "read_rnd_buffer_size" "262144"
  995. "relay_log"
  996. "relay_log_basename"
  997. "relay_log_index"
  998. "relay_log_info_file" "relay-log.info"
  999. "relay_log_purge" "ON"
  1000. "relay_log_recovery" "OFF"
  1001. "relay_log_space_limit" "0"
  1002. "replicate_annotate_row_events" "ON"
  1003. "replicate_do_db"
  1004. "replicate_do_table"
  1005. "replicate_events_marked_for_skip" "REPLICATE"
  1006. "replicate_ignore_db"
  1007. "replicate_ignore_table"
  1008. "replicate_wild_do_table"
  1009. "replicate_wild_ignore_table"
  1010. "report_host"
  1011. "report_password"
  1012. "report_port" "3306"
  1013. "report_user"
  1014. "rowid_merge_buff_size" "8388608"
  1015. "rpl_semi_sync_master_enabled" "OFF"
  1016. "rpl_semi_sync_master_timeout" "10000"
  1017. "rpl_semi_sync_master_trace_level" "32"
  1018. "rpl_semi_sync_master_wait_no_slave" "ON"
  1019. "rpl_semi_sync_master_wait_point" "AFTER_COMMIT"
  1020. "rpl_semi_sync_slave_delay_master" "OFF"
  1021. "rpl_semi_sync_slave_enabled" "OFF"
  1022. "rpl_semi_sync_slave_kill_conn_timeout" "5"
  1023. "rpl_semi_sync_slave_trace_level" "32"
  1024. "secure_auth" "ON"
  1025. "secure_file_priv"
  1026. "secure_timestamp" "NO"
  1027. "server_id" "1"
  1028. "session_track_schema" "ON"
  1029. "session_track_state_change" "OFF"
  1030. "session_track_system_variables" "autocommit,character_set_client,character_set_connection,character_set_results,time_zone"
  1031. "session_track_transaction_info" "OFF"
  1032. "skip_external_locking" "ON"
  1033. "skip_name_resolve" "OFF"
  1034. "skip_networking" "OFF"
  1035. "skip_show_database" "OFF"
  1036. "slave_compressed_protocol" "OFF"
  1037. "slave_ddl_exec_mode" "IDEMPOTENT"
  1038. "slave_domain_parallel_threads" "0"
  1039. "slave_exec_mode" "STRICT"
  1040. "slave_load_tmpdir" "/tmp"
  1041. "slave_max_allowed_packet" "1073741824"
  1042. "slave_net_timeout" "60"
  1043. "slave_parallel_max_queued" "131072"
  1044. "slave_parallel_mode" "conservative"
  1045. "slave_parallel_threads" "0"
  1046. "slave_parallel_workers" "0"
  1047. "slave_run_triggers_for_rbr" "NO"
  1048. "slave_skip_errors" "OFF"
  1049. "slave_sql_verify_checksum" "ON"
  1050. "slave_transaction_retries" "10"
  1051. "slave_transaction_retry_errors" "1158,1159,1160,1161,1205,1213,1429,2013,12701"
  1052. "slave_transaction_retry_interval" "0"
  1053. "slave_type_conversions"
  1054. "slow_launch_time" "2"
  1055. "slow_query_log" "ON"
  1056. "slow_query_log_file" "web11-slow.log"
  1057. "socket" "/var/lib/mysql/mysql.sock"
  1058. "sort_buffer_size" "2097152"
  1059. "sql_auto_is_null" "OFF"
  1060. "sql_big_selects" "ON"
  1061. "sql_buffer_result" "OFF"
  1062. "sql_log_bin" "ON"
  1063. "sql_log_off" "OFF"
  1064. "sql_mode" "STRICT_TRANS_TABLES,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION"
  1065. "sql_notes" "ON"
  1066. "sql_quote_show_create" "ON"
  1067. "sql_safe_updates" "OFF"
  1068. "sql_select_limit" "18446744073709551615"
  1069. "sql_slave_skip_counter" "0"
  1070. "sql_warnings" "OFF"
  1071. "ssl_ca"
  1072. "ssl_capath"
  1073. "ssl_cert"
  1074. "ssl_cipher"
  1075. "ssl_crl"
  1076. "ssl_crlpath"
  1077. "ssl_key"
  1078. "standard_compliant_cte" "ON"
  1079. "storage_engine" "InnoDB"
  1080. "stored_program_cache" "256"
  1081. "strict_password_validation" "ON"
  1082. "sync_binlog" "0"
  1083. "sync_frm" "ON"
  1084. "sync_master_info" "10000"
  1085. "sync_relay_log" "10000"
  1086. "sync_relay_log_info" "10000"
  1087. "system_time_zone" "EDT"
  1088. "system_versioning_alter_history" "ERROR"
  1089. "system_versioning_asof" "DEFAULT"
  1090. "table_definition_cache" "400"
  1091. "table_open_cache" "2000"
  1092. "table_open_cache_instances" "8"
  1093. "tcp_keepalive_interval" "0"
  1094. "tcp_keepalive_probes" "0"
  1095. "tcp_keepalive_time" "0"
  1096. "tcp_nodelay" "ON"
  1097. "thread_cache_size" "151"
  1098. "thread_concurrency" "10"
  1099. "thread_handling" "one-thread-per-connection"
  1100. "thread_pool_idle_timeout" "60"
  1101. "thread_pool_max_threads" "65536"
  1102. "thread_pool_oversubscribe" "3"
  1103. "thread_pool_prio_kickup_timer" "1000"
  1104. "thread_pool_priority" "auto"
  1105. "thread_pool_size" "8"
  1106. "thread_pool_stall_limit" "500"
  1107. "thread_stack" "299008"
  1108. "time_format" "%H:%i:%s"
  1109. "time_zone" "SYSTEM"
  1110. "timed_mutexes" "OFF"
  1111. "tls_version" "TLSv1.1,TLSv1.2,TLSv1.3"
  1112. "tmp_disk_table_size" "18446744073709551615"
  1113. "tmp_memory_table_size" "16777216"
  1114. "tmp_table_size" "16777216"
  1115. "tmpdir" "/tmp"
  1116. "transaction_alloc_block_size" "8192"
  1117. "transaction_prealloc_size" "4096"
  1118. "tx_isolation" "REPEATABLE-READ"
  1119. "tx_read_only" "OFF"
  1120. "unique_checks" "ON"
  1121. "updatable_views_with_limit" "YES"
  1122. "use_stat_tables" "PREFERABLY_FOR_QUERIES"
  1123. "userstat" "OFF"
  1124. "version" "10.4.12-MariaDB"
  1125. "version_comment" "MariaDB Server"
  1126. "version_compile_machine" "x86_64"
  1127. "version_compile_os" "Linux"
  1128. "version_malloc_library" "system"
  1129. "version_source_revision" "ba6bfc402c352372cc1a9ec20b5dc50b2204549f"
  1130. "version_ssl_library" "OpenSSL 1.0.1e-fips 11 Feb 2013"
  1131. "wait_timeout" "28800"
  1132. "wsrep_osu_method" "TOI"
  1133. "wsrep_sr_store" "table"
  1134. "wsrep_auto_increment_control" "ON"
  1135. "wsrep_causal_reads" "OFF"
  1136. "wsrep_certification_rules" "strict"
  1137. "wsrep_certify_nonpk" "ON"
  1138. "wsrep_cluster_address"
  1139. "wsrep_cluster_name" "my_wsrep_cluster"
  1140. "wsrep_convert_lock_to_trx" "OFF"
  1141. "wsrep_data_home_dir" "/var/lib/mysql/"
  1142. "wsrep_dbug_option"
  1143. "wsrep_debug" "NONE"
  1144. "wsrep_desync" "OFF"
  1145. "wsrep_dirty_reads" "OFF"
  1146. "wsrep_drupal_282555_workaround" "OFF"
  1147. "wsrep_forced_binlog_format" "NONE"
  1148. "wsrep_gtid_domain_id" "0"
  1149. "wsrep_gtid_mode" "OFF"
  1150. "wsrep_ignore_apply_errors" "7"
  1151. "wsrep_load_data_splitting" "OFF"
  1152. "wsrep_log_conflicts" "OFF"
  1153. "wsrep_max_ws_rows" "0"
  1154. "wsrep_max_ws_size" "2147483647"
  1155. "wsrep_mysql_replication_bundle" "0"
  1156. "wsrep_node_address"
  1157. "wsrep_node_incoming_address" "AUTO"
  1158. "wsrep_node_name" "web11. martind.com"
  1159. "wsrep_notify_cmd"
  1160. "wsrep_on" "OFF"
  1161. "wsrep_patch_version" "wsrep_26.22"
  1162. "wsrep_provider" "none"
  1163. "wsrep_provider_options"
  1164. "wsrep_recover" "OFF"
  1165. "wsrep_reject_queries" "NONE"
  1166. "wsrep_replicate_myisam" "OFF"
  1167. "wsrep_restart_slave" "OFF"
  1168. "wsrep_retry_autocommit" "1"
  1169. "wsrep_slave_fk_checks" "ON"
  1170. "wsrep_slave_uk_checks" "OFF"
  1171. "wsrep_slave_threads" "1"
  1172. "wsrep_sst_auth"
  1173. "wsrep_sst_donor"
  1174. "wsrep_sst_donor_rejects_queries" "OFF"
  1175. "wsrep_sst_method" "rsync"
  1176. "wsrep_sst_receive_address" "AUTO"
  1177. "wsrep_start_position" "00000000-0000-0000-0000-000000000000:-1"
  1178. "wsrep_sync_wait" "0"
  1179. "wsrep_trx_fragment_size" "0"
  1180. "wsrep_trx_fragment_unit" "bytes"
  1181. "1" "system user" "Daemon" "InnoDB purge coordinator" "0"
  1182. "4" "system user" "Daemon" "InnoDB purge worker" "0"
  1183. "3" "system user" "Daemon" "InnoDB purge worker" "0"
  1184. "2" "system user" "Daemon" "InnoDB purge worker" "0"
  1185. "5" "system user" "Daemon" "InnoDB shutdown handler" "0"
  1186. "11980197" "root" "localhost:47820" " martindv3" "Query" "0" "Closing tables" "SHOW FULL PROCESSLIST" "0"
  1187. "11980266" "root" "localhost:48002" " martindv3" "Sleep" "427" "0"
  1188. "11982669" " martind" "localhost" " martind" "Sleep" "256" "0"
  1189. "11982717" " martind" "localhost:44020" " martind" "Sleep" "275" "0"
  1190. "11987342" " martindv3" "localhost" " martindv3" "Sleep" "1" "0"
  1191. "11987343" " martindv3" "localhost" " martindv3" "Sleep" "0" "0"
  1192. "11987344" " martindv3" "localhost" " martindv3" "Sleep" "0" "0"
  1193. "11987347" " martindv3" "localhost" " martindv3" "Sleep" "0" "0"
  1194. "11987349" " martindv3" "localhost" " martindv3" "Sleep" "0" "0"
  1195. "11987350" " martindv3" "localhost:41026" " martindv3" "Sleep" "2" "0"
  1196. "11987351" " martindv3" "localhost" " martindv3" "Sleep" "0" "0"
  1197. "11987353" " martindv3" "localhost" " martindv3" "Sleep" "0" "0"
  1198. "11987355" " martindv3" "localhost" " martindv3" "Sleep" "0" "0"
  1199. "11987356" " martindv3" "localhost:41044" " martindv3" "Sleep" "1" "0"
  1200. "11987358" " martindv3" "localhost:41048" " martindv3" "Sleep" "1" "0"
  1201. "11987359" " martindv3" "localhost" " martindv3" "Sleep" "1" "0"
  1202. "11987360" " martindv3" "localhost:41050" " martindv3" "Sleep" "1" "0"
  1203. "11987361" " martindv3" "localhost:41052" " martindv3" "Sleep" "2" "0"
  1204. "11987362" " martindv3" "localhost" " martindv3" "Sleep" "0" "0"
  1205. "11987363" " martindv3" "localhost" " martindv3" "Sleep" "1" "0"
  1206. "11987364" " martindv3" "localhost:41064" " martindv3" "Sleep" "1" "0"
  1207. "11987366" " martindv3" "localhost:41068" " martindv3" "Sleep" "1" "0"
  1208. "11987367" " martindv3" "localhost" " martindv3" "Sleep" "0" "0"
  1209. "11987368" " martindv3" "localhost:41070" " martindv3" "Sleep" "1" "0"
  1210. "11987369" " martindv3" "localhost" " martindv3" "Sleep" "0" "0"
  1211. "11987372" " martindv3" "localhost:41082" " martindv3" "Sleep" "2" "0"
  1212. "11987374" " martindv3" "localhost" " martindv3" "Sleep" "0" "0"
  1213. "11987375" " martindv3" "localhost:41092" " martindv3" "Sleep" "0" "0"
  1214. "11987376" " martindv3" "localhost" " martindv3" "Sleep" "0" "0"
  1215. "11987377" " martindv3" "localhost:41112" " martindv3" "Sleep" "1" "0"
  1216. "11987379" " martindv3" "localhost:41124" " martindv3" "Sleep" "1" "0"
  1217. "11987380" " martindv3" "localhost:41126" " martindv3" "Sleep" "1" "0"
  1218. "11987382" " martindv3" "localhost" " martindv3" "Sleep" "0" "0"
  1219. "11987383" " martindv3" "localhost:41134" " martindv3" "Sleep" "0" "0"
  1220. "11987385" " martindv3" "localhost" " martindv3" "Sleep" "0" "0"
  1221. "11987386" " martindv3" "localhost:41138" " martindv3" "Sleep" "0" "0"
  1222. "11987387" " martindv3" "localhost" " martindv3" "Sleep" "0" "0"
  1223. "11987388" " martindv3" "localhost" " martindv3" "Sleep" "0" "0"
  1224. "11987389" " martindv3" "localhost:41152" " martindv3" "Sleep" "0" "0"
  1225. "11987390" " martindv3" "localhost" " martindv3" "Sleep" "0" "0"
  1226. "11987391" " martindv3" "localhost:41160" " martindv3" "Sleep" "0" "0"
  1227. "11987392" " martindv3" "localhost" " martindv3" "Sleep" "0" "0"
  1228. "11987394" " martindv3" "localhost" " martindv3" "Sleep" "0" "0"
  1229. "11987395" " martindv3" "localhost" " martindv3" "Sleep" "0" "0"
  1230. "11987396" " martindv3" "localhost" " martindv3" "Sleep" "0" "0"
  1231. "11987397" " martindv3" "localhost" " martindv3" "Sleep" "0" "0"
  1232. "11987398" " martindv3" "localhost" " martindv3" "Sleep" "0" "0"
  1233. "11987400" " martindv3" "localhost" " martindv3" "Sleep" "0" "0"
  1234. "11987401" " martindv3" "localhost:41180" " martindv3" "Sleep" "0" "0"
  1235. "11987402" " martindv3" "localhost" " martindv3" "Sleep" "0" "0"
  1236. "11987403" " martindv3" "localhost:41182" " martindv3" "Sleep" "0" "0"
  1237. "11987404" " martindv3" "localhost:41198" " martindv3" "Sleep" "1" "0"
  1238. "11987405" " martindv3" "localhost:41200" " martindv3" "Sleep" "0" "0"
  1239. "11987406" " martindv3" "localhost:41202" " martindv3" "Sleep" "0" "0"
  1240. "11987407" " martindv3" "localhost:41204" " martindv3" "Sleep" "0" "0"
  1241. "11987408" " martindv3" "localhost:41206" " martindv3" "Sleep" "1" "0"
  1242. "11987410" " martindv3" "localhost:41210" " martindv3" "Sleep" "0" "0"
  1243. "11987411" " martindv3" "localhost:41212" " martindv3" "Sleep" "0" "0"
  1244. "11987413" " martindv3" "localhost:41216" " martindv3" "Sleep" "0" "0"
  1245. "11987414" " martindv3" "localhost" " martindv3" "Sleep" "0" "0"
  1246. "11987415" " martindv3" "localhost:41240" " martindv3" "Sleep" "0" "0"
  1247. "11987416" " martindv3" "localhost:41266" " martindv3" "Sleep" "1" "0"
  1248. "11987417" " martindv3" "localhost" " martindv3" "Sleep" "0" "0"
  1249. "11987418" " martindv3" "localhost" " martindv3" "Sleep" "0" "0"
  1250. "11987419" " martindv3" "localhost" " martindv3" "Sleep" "0" "0"
  1251. "11987420" " martindv3" "localhost:41324" " martindv3" "Sleep" "0" "0"
  1252. "11987421" " martindv3" "localhost" " martindv3" "Sleep" "0" "0"
  1253. "11987422" " martindv3" "localhost:41332" " martindv3" "Sleep" "1" "0"
  1254. "11987423" " martindv3" "localhost" " martindv3" "Sleep" "0" "0"
  1255. "11987424" " martindv3" "localhost:41334" " martindv3" "Sleep" "0" "0"
  1256. "11987425" " martindv3" "localhost" " martindv3" "Sleep" "0" "0"
  1257. "11987426" " martindv3" "localhost" " martindv3" "Sleep" "0" "0"
  1258. "11987427" " martindv3" "localhost" " martindv3" "Sleep" "0" "0"
  1259. "11987428" " martindv3" "localhost:41348" " martindv3" "Sleep" "0" "0"
  1260. "11987429" " martindv3" "localhost:41354" " martindv3" "Sleep" "0" "0"
  1261. "11987430" " martindv3" "localhost" " martindv3" "Sleep" "0" "0"
  1262. "11987431" " martindv3" "localhost:41358" " martindv3" "Sleep" "0" "0"
  1263. "11987432" " martindv3" "localhost:41360" " martindv3" "Sleep" "0" "0"
  1264. "11987433" " martindv3" "localhost" " martindv3" "Sleep" "0" "0"
  1265. "11987434" " martindv3" "localhost:41362" " martindv3" "Sleep" "0" "0"
  1266. "11987435" " martindv3" "localhost" " martindv3" "Sleep" "0" "0"
  1267. "11987436" " martindv3" "localhost" " martindv3" "Sleep" "0" "0"
  1268. "11987437" " martindv3" "localhost:41370" " martindv3" "Sleep" "0" "0"
  1269. "11987438" " martindv3" "localhost:41374" " martindv3" "Sleep" "0" "0"
  1270. "11987439" " martindv3" "localhost" " martindv3" "Sleep" "0" "0"
  1271. "11987440" " martindv3" "localhost:41376" " martindv3" "Sleep" "0" "0"
  1272. "11987441" " martindv3" "localhost" " martindv3" "Sleep" "0" "0"
  1273. "11987442" " martindv3" "localhost" " martindv3" "Sleep" "0" "0"
  1274. "11987443" " martindv3" "localhost" " martindv3" "Sleep" "0" "0"
  1275. "11987444" " martindv3" "localhost:41398" " martindv3" "Sleep" "0" "0"
  1276. "11987445" " martind" "localhost" " martind" "Sleep" "0" "0"
  1277. "11987446" " martindv3" "localhost" " martindv3" "Sleep" "0" "0"
  1278. "11987447" " martindv3" "localhost" " martindv3" "Sleep" "0" "0"
  1279. "11987448" " martindv3" "localhost:41408" " martindv3" "Sleep" "0" "0"
  1280. "11987449" " martindv3" "localhost:41418" " martindv3" "Sleep" "0" "0"
  1281. "11987450" " martindv3" "localhost:41420" " martindv3" "Sleep" "0" "0"
  1282. "11987451" " martindv3" "localhost:41422" " martindv3" "Sleep" "0" "0"
  1283. "11987452" " martindv3" "localhost" " martindv3" "Sleep" "0" "0"
  1284. "11987453" " martind" "localhost" " martind" "Sleep" "0" "0"
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement