API tools faq
paste
Advertisement
Guest User

Untitled

a guest
Sep 9th, 2021
3,738
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 87.69 KB | None | 0 0
raw download clone embed print report
  1. STATUS:
  2. MariaDB [(none)]> SHOW GLOBAL STATUS;
  3. +--------------------------------------------------------------+--------------------------------------------------+
  4. | Variable_name | Value |
  5. +--------------------------------------------------------------+--------------------------------------------------+
  6. | Aborted_clients | 27 |
  7. | Aborted_connects | 27 |
  8. | Access_denied_errors | 29 |
  9. | Acl_column_grants | 0 |
  10. | Acl_database_grants | 350 |
  11. | Acl_function_grants | 0 |
  12. | Acl_procedure_grants | 0 |
  13. | Acl_package_spec_grants | 0 |
  14. | Acl_package_body_grants | 0 |
  15. | Acl_proxy_users | 2 |
  16. | Acl_role_grants | 0 |
  17. | Acl_roles | 0 |
  18. | Acl_table_grants | 63 |
  19. | Acl_users | 145 |
  20. | Aria_pagecache_blocks_not_flushed | 0 |
  21. | Aria_pagecache_blocks_unused | 15706 |
  22. | Aria_pagecache_blocks_used | 1534 |
  23. | Aria_pagecache_read_requests | 1510431 |
  24. | Aria_pagecache_reads | 45146 |
  25. | Aria_pagecache_write_requests | 129261 |
  26. | Aria_pagecache_writes | 113300 |
  27. | Aria_transaction_log_syncs | 83 |
  28. | Binlog_commits | 0 |
  29. | Binlog_group_commits | 0 |
  30. | Binlog_group_commit_trigger_count | 0 |
  31. | Binlog_group_commit_trigger_lock_wait | 0 |
  32. | Binlog_group_commit_trigger_timeout | 0 |
  33. | Binlog_snapshot_file | |
  34. | Binlog_snapshot_position | 0 |
  35. | Binlog_bytes_written | 0 |
  36. | Binlog_cache_disk_use | 4487 |
  37. | Binlog_cache_use | 285951 |
  38. | Binlog_stmt_cache_disk_use | 0 |
  39. | Binlog_stmt_cache_use | 0 |
  40. | Busy_time | 0.000000 |
  41. | Bytes_received | 661866742 |
  42. | Bytes_sent | 4856307441 |
  43. | Column_compressions | 0 |
  44. | Column_decompressions | 0 |
  45. | Com_admin_commands | 0 |
  46. | Com_alter_db | 1 |
  47. | Com_alter_db_upgrade | 0 |
  48. | Com_alter_event | 0 |
  49. | Com_alter_function | 0 |
  50. | Com_alter_procedure | 0 |
  51. | Com_alter_server | 0 |
  52. | Com_alter_sequence | 0 |
  53. | Com_alter_table | 881 |
  54. | Com_alter_tablespace | 0 |
  55. | Com_alter_user | 0 |
  56. | Com_analyze | 0 |
  57. | Com_assign_to_keycache | 0 |
  58. | Com_begin | 0 |
  59. | Com_binlog | 0 |
  60. | Com_call_procedure | 0 |
  61. | Com_change_db | 589693 |
  62. | Com_change_master | 0 |
  63. | Com_check | 0 |
  64. | Com_checksum | 0 |
  65. | Com_commit | 5 |
  66. | Com_compound_sql | 0 |
  67. | Com_create_db | 1 |
  68. | Com_create_event | 0 |
  69. | Com_create_function | 0 |
  70. | Com_create_index | 0 |
  71. | Com_create_package | 0 |
  72. | Com_create_package_body | 0 |
  73. | Com_create_procedure | 0 |
  74. | Com_create_role | 0 |
  75. | Com_create_sequence | 0 |
  76. | Com_create_server | 0 |
  77. | Com_create_table | 122 |
  78. | Com_create_temporary_table | 0 |
  79. | Com_create_trigger | 0 |
  80. | Com_create_udf | 0 |
  81. | Com_create_user | 1 |
  82. | Com_create_view | 0 |
  83. | Com_dealloc_sql | 0 |
  84. | Com_delete | 8880 |
  85. | Com_delete_multi | 0 |
  86. | Com_do | 0 |
  87. | Com_drop_db | 0 |
  88. | Com_drop_event | 0 |
  89. | Com_drop_function | 0 |
  90. | Com_drop_index | 0 |
  91. | Com_drop_procedure | 0 |
  92. | Com_drop_package | 0 |
  93. | Com_drop_package_body | 0 |
  94. | Com_drop_role | 0 |
  95. | Com_drop_server | 0 |
  96. | Com_drop_sequence | 0 |
  97. | Com_drop_table | 11 |
  98. | Com_drop_temporary_table | 0 |
  99. | Com_drop_trigger | 0 |
  100. | Com_drop_user | 0 |
  101. | Com_drop_view | 0 |
  102. | Com_empty_query | 0 |
  103. | Com_execute_immediate | 0 |
  104. | Com_execute_sql | 0 |
  105. | Com_flush | 50 |
  106. | Com_get_diagnostics | 0 |
  107. | Com_grant | 4 |
  108. | Com_grant_role | 0 |
  109. | Com_ha_close | 0 |
  110. | Com_ha_open | 0 |
  111. | Com_ha_read | 0 |
  112. | Com_help | 0 |
  113. | Com_insert | 167260 |
  114. | Com_insert_select | 1488 |
  115. | Com_install_plugin | 0 |
  116. | Com_kill | 0 |
  117. | Com_load | 0 |
  118. | Com_lock_tables | 0 |
  119. | Com_multi | 0 |
  120. | Com_optimize | 0 |
  121. | Com_preload_keys | 0 |
  122. | Com_prepare_sql | 0 |
  123. | Com_purge | 0 |
  124. | Com_purge_before_date | 0 |
  125. | Com_release_savepoint | 0 |
  126. | Com_rename_table | 0 |
  127. | Com_rename_user | 0 |
  128. | Com_repair | 0 |
  129. | Com_replace | 0 |
  130. | Com_replace_select | 0 |
  131. | Com_reset | 0 |
  132. | Com_resignal | 0 |
  133. | Com_revoke | 0 |
  134. | Com_revoke_all | 0 |
  135. | Com_revoke_role | 0 |
  136. | Com_rollback | 328443 |
  137. | Com_rollback_to_savepoint | 0 |
  138. | Com_savepoint | 0 |
  139. | Com_select | 2590477 |
  140. | Com_set_option | 690066 |
  141. | Com_show_authors | 0 |
  142. | Com_show_binlog_events | 0 |
  143. | Com_show_binlogs | 0 |
  144. | Com_show_charsets | 46 |
  145. | Com_show_collations | 48 |
  146. | Com_show_contributors | 0 |
  147. | Com_show_create_db | 1 |
  148. | Com_show_create_event | 0 |
  149. | Com_show_create_func | 0 |
  150. | Com_show_create_package | 0 |
  151. | Com_show_create_package_body | 0 |
  152. | Com_show_create_proc | 48 |
  153. | Com_show_create_table | 299306 |
  154. | Com_show_create_trigger | 0 |
  155. | Com_show_create_user | 0 |
  156. | Com_show_databases | 59 |
  157. | Com_show_engine_logs | 0 |
  158. | Com_show_engine_mutex | 0 |
  159. | Com_show_engine_status | 0 |
  160. | Com_show_errors | 0 |
  161. | Com_show_events | 0 |
  162. | Com_show_explain | 0 |
  163. | Com_show_fields | 7279 |
  164. | Com_show_function_status | 1 |
  165. | Com_show_generic | 0 |
  166. | Com_show_grants | 0 |
  167. | Com_show_keys | 475 |
  168. | Com_show_master_status | 0 |
  169. | Com_show_open_tables | 0 |
  170. | Com_show_package_status | 0 |
  171. | Com_show_package_body_status | 0 |
  172. | Com_show_plugins | 0 |
  173. | Com_show_privileges | 0 |
  174. | Com_show_procedure_status | 1 |
  175. | Com_show_processlist | 0 |
  176. | Com_show_profile | 0 |
  177. | Com_show_profiles | 146 |
  178. | Com_show_relaylog_events | 0 |
  179. | Com_show_slave_hosts | 0 |
  180. | Com_show_slave_status | 0 |
  181. | Com_show_status | 776931 |
  182. | Com_show_storage_engines | 0 |
  183. | Com_show_table_status | 16924 |
  184. | Com_show_tables | 6808 |
  185. | Com_show_triggers | 3376 |
  186. | Com_show_variables | 472736 |
  187. | Com_show_warnings | 17 |
  188. | Com_shutdown | 0 |
  189. | Com_signal | 0 |
  190. | Com_start_all_slaves | 0 |
  191. | Com_start_slave | 0 |
  192. | Com_stmt_close | 0 |
  193. | Com_stmt_execute | 0 |
  194. | Com_stmt_fetch | 0 |
  195. | Com_stmt_prepare | 0 |
  196. | Com_stmt_reprepare | 0 |
  197. | Com_stmt_reset | 0 |
  198. | Com_stmt_send_long_data | 0 |
  199. | Com_stop_all_slaves | 0 |
  200. | Com_stop_slave | 0 |
  201. | Com_truncate | 40 |
  202. | Com_uninstall_plugin | 0 |
  203. | Com_unlock_tables | 0 |
  204. | Com_update | 830335 |
  205. | Com_update_multi | 326 |
  206. | Com_xa_commit | 0 |
  207. | Com_xa_end | 0 |
  208. | Com_xa_prepare | 0 |
  209. | Com_xa_recover | 0 |
  210. | Com_xa_rollback | 0 |
  211. | Com_xa_start | 0 |
  212. | Compression | OFF |
  213. | Connection_errors_accept | 0 |
  214. | Connection_errors_internal | 0 |
  215. | Connection_errors_max_connections | 0 |
  216. | Connection_errors_peer_address | 0 |
  217. | Connection_errors_select | 0 |
  218. | Connection_errors_tcpwrap | 0 |
  219. | Connections | 1709569 |
  220. | Cpu_time | 0.000000 |
  221. | Created_tmp_disk_tables | 250040 |
  222. | Created_tmp_files | 5129 |
  223. | Created_tmp_tables | 2954537 |
  224. | Delayed_errors | 0 |
  225. | Delayed_insert_threads | 0 |
  226. | Delayed_writes | 0 |
  227. | Delete_scan | 428 |
  228. | Empty_queries | 348051 |
  229. | Executed_events | 0 |
  230. | Executed_triggers | 0 |
  231. | Feature_check_constraint | 0 |
  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 | 0 |
  239. | Feature_locale | 0 |
  240. | Feature_subquery | 555 |
  241. | Feature_system_versioning | 0 |
  242. | Feature_timezone | 0 |
  243. | Feature_trigger | 0 |
  244. | Feature_window_functions | 0 |
  245. | Feature_xml | 0 |
  246. | Flush_commands | 1 |
  247. | Handler_commit | 8391666 |
  248. | Handler_delete | 14555 |
  249. | Handler_discover | 1248 |
  250. | Handler_external_lock | 0 |
  251. | Handler_icp_attempts | 1293305047 |
  252. | Handler_icp_match | 1293245991 |
  253. | Handler_mrr_init | 0 |
  254. | Handler_mrr_key_refills | 0 |
  255. | Handler_mrr_rowid_refills | 0 |
  256. | Handler_prepare | 3558744 |
  257. | Handler_read_first | 28155 |
  258. | Handler_read_key | 1327569967 |
  259. | Handler_read_last | 2086 |
  260. | Handler_read_next | 1842232931 |
  261. | Handler_read_prev | 673168 |
  262. | Handler_read_retry | 0 |
  263. | Handler_read_rnd | 29687413 |
  264. | Handler_read_rnd_deleted | 8628 |
  265. | Handler_read_rnd_next | 383701741 |
  266. | Handler_rollback | 3245 |
  267. | Handler_savepoint | 0 |
  268. | Handler_savepoint_rollback | 0 |
  269. | Handler_tmp_delete | 0 |
  270. | Handler_tmp_update | 1136289083 |
  271. | Handler_tmp_write | 94771721 |
  272. | Handler_update | 25425391 |
  273. | Handler_write | 337022 |
  274. | Innodb_buffer_pool_dump_status | |
  275. | Innodb_buffer_pool_load_status | Buffer pool(s) load completed at 210828 16:37:47 |
  276. | Innodb_buffer_pool_resize_status | |
  277. | Innodb_buffer_pool_load_incomplete | OFF |
  278. | Innodb_buffer_pool_pages_data | 253564 |
  279. | Innodb_buffer_pool_bytes_data | 4154392576 |
  280. | Innodb_buffer_pool_pages_dirty | 0 |
  281. | Innodb_buffer_pool_bytes_dirty | 0 |
  282. | Innodb_buffer_pool_pages_flushed | 12339779 |
  283. | Innodb_buffer_pool_pages_free | 4096 |
  284. | Innodb_buffer_pool_pages_misc | 4484 |
  285. | Innodb_buffer_pool_pages_total | 262144 |
  286. | Innodb_buffer_pool_read_ahead_rnd | 0 |
  287. | Innodb_buffer_pool_read_ahead | 21370 |
  288. | Innodb_buffer_pool_read_ahead_evicted | 0 |
  289. | Innodb_buffer_pool_read_requests | 5544605948 |
  290. | Innodb_buffer_pool_reads | 322395 |
  291. | Innodb_buffer_pool_wait_free | 0 |
  292. | Innodb_buffer_pool_write_requests | 312107395 |
  293. | Innodb_data_fsyncs | 5108885 |
  294. | Innodb_data_pending_fsyncs | 0 |
  295. | Innodb_data_pending_reads | 0 |
  296. | Innodb_data_pending_writes | 0 |
  297. | Innodb_data_read | 6129355264 |
  298. | Innodb_data_reads | 388548 |
  299. | Innodb_data_writes | 14700262 |
  300. | Innodb_data_written | 431101179392 |
  301. | Innodb_dblwr_pages_written | 12339648 |
  302. | Innodb_dblwr_writes | 1543322 |
  303. | Innodb_log_waits | 0 |
  304. | Innodb_log_write_requests | 62359304 |
  305. | Innodb_log_writes | 572407 |
  306. | Innodb_os_log_fsyncs | 790953 |
  307. | Innodb_os_log_pending_fsyncs | 0 |
  308. | Innodb_os_log_pending_writes | 0 |
  309. | Innodb_os_log_written | 26641836544 |
  310. | Innodb_page_size | 16384 |
  311. | Innodb_pages_created | 258730 |
  312. | Innodb_pages_read | 374097 |
  313. | Innodb_pages0_read | 12045 |
  314. | Innodb_pages_written | 12339779 |
  315. | Innodb_row_lock_current_waits | 0 |
  316. | Innodb_row_lock_time | 86303 |
  317. | Innodb_row_lock_time_avg | 1078 |
  318. | Innodb_row_lock_time_max | 17935 |
  319. | Innodb_row_lock_waits | 80 |
  320. | Innodb_rows_deleted | 14555 |
  321. | Innodb_rows_inserted | 337017 |
  322. | Innodb_rows_read | 2177994687 |
  323. | Innodb_rows_updated | 25425388 |
  324. | Innodb_system_rows_deleted | 0 |
  325. | Innodb_system_rows_inserted | 0 |
  326. | Innodb_system_rows_read | 0 |
  327. | Innodb_system_rows_updated | 0 |
  328. | Innodb_num_open_files | 4096 |
  329. | Innodb_truncated_status_writes | 0 |
  330. | Innodb_available_undo_logs | 128 |
  331. | Innodb_undo_truncations | 0 |
  332. | Innodb_page_compression_saved | 0 |
  333. | Innodb_num_index_pages_written | 0 |
  334. | Innodb_num_non_index_pages_written | 0 |
  335. | Innodb_num_pages_page_compressed | 0 |
  336. | Innodb_num_page_compressed_trim_op | 0 |
  337. | Innodb_num_pages_page_decompressed | 0 |
  338. | Innodb_num_pages_page_compression_error | 0 |
  339. | Innodb_num_pages_encrypted | 0 |
  340. | Innodb_num_pages_decrypted | 0 |
  341. | Innodb_have_lz4 | ON |
  342. | Innodb_have_lzo | OFF |
  343. | Innodb_have_lzma | OFF |
  344. | Innodb_have_bzip2 | OFF |
  345. | Innodb_have_snappy | ON |
  346. | Innodb_have_punch_hole | ON |
  347. | Innodb_defragment_compression_failures | 0 |
  348. | Innodb_defragment_failures | 0 |
  349. | Innodb_defragment_count | 0 |
  350. | Innodb_instant_alter_column | 307 |
  351. | Innodb_onlineddl_rowlog_rows | 0 |
  352. | Innodb_onlineddl_rowlog_pct_used | 0 |
  353. | Innodb_onlineddl_pct_progress | 0 |
  354. | Innodb_secondary_index_triggered_cluster_reads | 1376436710 |
  355. | Innodb_secondary_index_triggered_cluster_reads_avoided | 0 |
  356. | Innodb_encryption_rotation_pages_read_from_cache | 0 |
  357. | Innodb_encryption_rotation_pages_read_from_disk | 0 |
  358. | Innodb_encryption_rotation_pages_modified | 0 |
  359. | Innodb_encryption_rotation_pages_flushed | 0 |
  360. | Innodb_encryption_rotation_estimated_iops | 0 |
  361. | Innodb_encryption_key_rotation_list_length | 0 |
  362. | Innodb_encryption_n_merge_blocks_encrypted | 0 |
  363. | Innodb_encryption_n_merge_blocks_decrypted | 0 |
  364. | Innodb_encryption_n_rowlog_blocks_encrypted | 0 |
  365. | Innodb_encryption_n_rowlog_blocks_decrypted | 0 |
  366. | Innodb_encryption_n_temp_blocks_encrypted | 0 |
  367. | Innodb_encryption_n_temp_blocks_decrypted | 0 |
  368. | Innodb_scrub_background_page_reorganizations | 0 |
  369. | Innodb_scrub_background_page_splits | 0 |
  370. | Innodb_scrub_background_page_split_failures_underflow | 0 |
  371. | Innodb_scrub_background_page_split_failures_out_of_filespace | 0 |
  372. | Innodb_scrub_background_page_split_failures_missing_index | 0 |
  373. | Innodb_scrub_background_page_split_failures_unknown | 0 |
  374. | Innodb_scrub_log | 0 |
  375. | Innodb_encryption_num_key_requests | 0 |
  376. | Key_blocks_not_flushed | 0 |
  377. | Key_blocks_unused | 107161 |
  378. | Key_blocks_used | 36 |
  379. | Key_blocks_warm | 0 |
  380. | Key_read_requests | 536 |
  381. | Key_reads | 114 |
  382. | Key_write_requests | 34 |
  383. | Key_writes | 34 |
  384. | Last_query_cost | 0.000000 |
  385. | Master_gtid_wait_count | 0 |
  386. | Master_gtid_wait_time | 0 |
  387. | Master_gtid_wait_timeouts | 0 |
  388. | Max_statement_time_exceeded | 0 |
  389. | Max_used_connections | 15 |
  390. | Memory_used | 530462896 |
  391. | Memory_used_initial | 273828472 |
  392. | Not_flushed_delayed_rows | 0 |
  393. | Open_files | 10 |
  394. | Open_streams | 0 |
  395. | Open_table_definitions | 9000 |
  396. | Open_tables | 4096 |
  397. | Opened_files | 1572191 |
  398. | Opened_plugin_libraries | 0 |
  399. | Opened_table_definitions | 292161 |
  400. | Opened_tables | 301816 |
  401. | Opened_views | 0 |
  402. | Performance_schema_accounts_lost | 0 |
  403. | Performance_schema_cond_classes_lost | 0 |
  404. | Performance_schema_cond_instances_lost | 0 |
  405. | Performance_schema_digest_lost | 0 |
  406. | Performance_schema_file_classes_lost | 0 |
  407. | Performance_schema_file_handles_lost | 0 |
  408. | Performance_schema_file_instances_lost | 0 |
  409. | Performance_schema_hosts_lost | 0 |
  410. | Performance_schema_locker_lost | 0 |
  411. | Performance_schema_mutex_classes_lost | 0 |
  412. | Performance_schema_mutex_instances_lost | 0 |
  413. | Performance_schema_rwlock_classes_lost | 0 |
  414. | Performance_schema_rwlock_instances_lost | 0 |
  415. | Performance_schema_session_connect_attrs_lost | 0 |
  416. | Performance_schema_socket_classes_lost | 0 |
  417. | Performance_schema_socket_instances_lost | 0 |
  418. | Performance_schema_stage_classes_lost | 0 |
  419. | Performance_schema_statement_classes_lost | 0 |
  420. | Performance_schema_table_handles_lost | 0 |
  421. | Performance_schema_table_instances_lost | 0 |
  422. | Performance_schema_thread_classes_lost | 0 |
  423. | Performance_schema_thread_instances_lost | 0 |
  424. | Performance_schema_users_lost | 0 |
  425. | Prepared_stmt_count | 0 |
  426. | Qcache_free_blocks | 0 |
  427. | Qcache_free_memory | 0 |
  428. | Qcache_hits | 0 |
  429. | Qcache_inserts | 0 |
  430. | Qcache_lowmem_prunes | 0 |
  431. | Qcache_not_cached | 0 |
  432. | Qcache_queries_in_cache | 0 |
  433. | Qcache_total_blocks | 0 |
  434. | Queries | 8510238 |
  435. | Questions | 7834983 |
  436. | Rows_read | 1764422561 |
  437. | Rows_sent | 52557744 |
  438. | Rows_tmp_read | 1234325312 |
  439. | Rpl_semi_sync_master_clients | 0 |
  440. | Rpl_semi_sync_master_get_ack | 0 |
  441. | Rpl_semi_sync_master_net_avg_wait_time | 0 |
  442. | Rpl_semi_sync_master_net_wait_time | 0 |
  443. | Rpl_semi_sync_master_net_waits | 0 |
  444. | Rpl_semi_sync_master_no_times | 0 |
  445. | Rpl_semi_sync_master_no_tx | 0 |
  446. | Rpl_semi_sync_master_request_ack | 0 |
  447. | Rpl_semi_sync_master_status | OFF |
  448. | Rpl_semi_sync_master_timefunc_failures | 0 |
  449. | Rpl_semi_sync_master_tx_avg_wait_time | 0 |
  450. | Rpl_semi_sync_master_tx_wait_time | 0 |
  451. | Rpl_semi_sync_master_tx_waits | 0 |
  452. | Rpl_semi_sync_master_wait_pos_backtraverse | 0 |
  453. | Rpl_semi_sync_master_wait_sessions | 0 |
  454. | Rpl_semi_sync_master_yes_tx | 0 |
  455. | Rpl_semi_sync_slave_send_ack | 0 |
  456. | Rpl_semi_sync_slave_status | OFF |
  457. | Rpl_status | AUTH_MASTER |
  458. | Rpl_transactions_multi_engine | 0 |
  459. | Select_full_join | 14491 |
  460. | Select_full_range_join | 16330 |
  461. | Select_range | 240502 |
  462. | Select_range_check | 0 |
  463. | Select_scan | 1769005 |
  464. | Slave_connections | 0 |
  465. | Slave_heartbeat_period | 0.000 |
  466. | Slave_open_temp_tables | 0 |
  467. | Slave_received_heartbeats | 0 |
  468. | Slave_retried_transactions | 0 |
  469. | Slave_running | OFF |
  470. | Slave_skipped_errors | 0 |
  471. | Slaves_connected | 0 |
  472. | Slaves_running | 0 |
  473. | Slow_launch_threads | 0 |
  474. | Slow_queries | 0 |
  475. | Sort_merge_passes | 45 |
  476. | Sort_priority_queue_sorts | 19139 |
  477. | Sort_range | 80900 |
  478. | Sort_rows | 15480471 |
  479. | Sort_scan | 179438 |
  480. | Ssl_accept_renegotiates | 0 |
  481. | Ssl_accepts | 0 |
  482. | Ssl_callback_cache_hits | 0 |
  483. | Ssl_cipher | |
  484. | Ssl_cipher_list | |
  485. | Ssl_client_connects | 0 |
  486. | Ssl_connect_renegotiates | 0 |
  487. | Ssl_ctx_verify_depth | 0 |
  488. | Ssl_ctx_verify_mode | 0 |
  489. | Ssl_default_timeout | 0 |
  490. | Ssl_finished_accepts | 0 |
  491. | Ssl_finished_connects | 0 |
  492. | Ssl_server_not_after | |
  493. | Ssl_server_not_before | |
  494. | Ssl_session_cache_hits | 0 |
  495. | Ssl_session_cache_misses | 0 |
  496. | Ssl_session_cache_mode | NONE |
  497. | Ssl_session_cache_overflows | 0 |
  498. | Ssl_session_cache_size | 0 |
  499. | Ssl_session_cache_timeouts | 0 |
  500. | Ssl_sessions_reused | 0 |
  501. | Ssl_used_session_cache_entries | 0 |
  502. | Ssl_verify_depth | 0 |
  503. | Ssl_verify_mode | 0 |
  504. | Ssl_version | |
  505. | Subquery_cache_hit | 0 |
  506. | Subquery_cache_miss | 0 |
  507. | Syncs | 961612 |
  508. | Table_locks_immediate | 251 |
  509. | Table_locks_waited | 0 |
  510. | Table_open_cache_active_instances | 1 |
  511. | Table_open_cache_hits | 4230136 |
  512. | Table_open_cache_misses | 301840 |
  513. | Table_open_cache_overflows | 296987 |
  514. | Tc_log_max_pages_used | 5 |
  515. | Tc_log_page_size | 4096 |
  516. | Tc_log_page_waits | 0 |
  517. | Threadpool_idle_threads | 0 |
  518. | Threadpool_threads | 0 |
  519. | Threads_cached | 11 |
  520. | Threads_connected | 4 |
  521. | Threads_created | 32 |
  522. | Threads_running | 6 |
  523. | Transactions_gtid_foreign_engine | 0 |
  524. | Transactions_multi_engine | 961104 |
  525. | Update_scan | 9685 |
  526. | Uptime | 1012021 |
  527. | Uptime_since_flush_status | 1012021 |
  528. | wsrep_applier_thread_count | 16 |
  529. | wsrep_apply_oooe | 0.008102 |
  530. | wsrep_apply_oool | 0.000177 |
  531. | wsrep_apply_window | 1.011974 |
  532. | wsrep_causal_reads | 0 |
  533. | wsrep_cert_deps_distance | 31.361381 |
  534. | wsrep_cert_index_size | 129 |
  535. | wsrep_cert_interval | 0.013298 |
  536. | wsrep_cluster_conf_id | 28 |
  537. | wsrep_cluster_size | 3 |
  538. | wsrep_cluster_state_uuid | b3c56acd-d17a-11ea-aa05-af73b589f500 |
  539. | wsrep_cluster_status | Primary |
  540. | wsrep_cluster_weight | 3 |
  541. | wsrep_commit_oooe | 0.000000 |
  542. | wsrep_commit_oool | 0.000063 |
  543. | wsrep_commit_window | 1.007588 |
  544. | wsrep_connected | ON |
  545. | wsrep_desync_count | 0 |
  546. | wsrep_evs_delayed | |
  547. | wsrep_evs_evict_list | |
  548. | wsrep_evs_repl_latency | 0.000570014/0.00157737/0.0070307/0.00139769/47 |
  549. | wsrep_evs_state | OPERATIONAL |
  550. | wsrep_flow_control_paused | 0.000001 |
  551. | wsrep_flow_control_paused_ns | 656100335 |
  552. | wsrep_flow_control_recv | 5 |
  553. | wsrep_flow_control_sent | 0 |
  554. | wsrep_gcomm_uuid | 3f653ed7-080f-11ec-8ead-0e0df283bf97 |
  555. | wsrep_incoming_addresses | node3:3306,node2:3306,node1:3306 |
  556. | wsrep_last_committed | 27644527 |
  557. | wsrep_local_bf_aborts | 11 |
  558. | wsrep_local_cached_downto | 27587901 |
  559. | wsrep_local_cert_failures | 4 |
  560. | wsrep_local_commits | 285918 |
  561. | wsrep_local_index | 0 |
  562. | wsrep_local_recv_queue | 0 |
  563. | wsrep_local_recv_queue_avg | 0.002058 |
  564. | wsrep_local_recv_queue_max | 21 |
  565. | wsrep_local_recv_queue_min | 0 |
  566. | wsrep_local_replays | 2 |
  567. | wsrep_local_send_queue | 0 |
  568. | wsrep_local_send_queue_avg | 0.000010 |
  569. | wsrep_local_send_queue_max | 2 |
  570. | wsrep_local_send_queue_min | 0 |
  571. | wsrep_local_state | 4 |
  572. | wsrep_local_state_comment | Synced |
  573. | wsrep_local_state_uuid | b3c56acd-d17a-11ea-aa05-af73b589f500 |
  574. | wsrep_open_connections | 0 |
  575. | wsrep_open_transactions | 0 |
  576. | wsrep_protocol_version | 9 |
  577. | wsrep_provider_name | Galera |
  578. | wsrep_provider_vendor | Codership Oy <info@codership.com> |
  579. | wsrep_provider_version | 3.25(rddf9876) |
  580. | wsrep_ready | ON |
  581. | wsrep_received | 693356 |
  582. | wsrep_received_bytes | 4027814738 |
  583. | wsrep_repl_data_bytes | 1583462702 |
  584. | wsrep_repl_keys | 8259178 |
  585. | wsrep_repl_keys_bytes | 72975464 |
  586. | wsrep_repl_other_bytes | 0 |
  587. | wsrep_replicated | 286936 |
  588. | wsrep_replicated_bytes | 1763234552 |
  589. | wsrep_rollbacker_thread_count | 1 |
  590. | wsrep_thread_count | 17 |
  591. +--------------------------------------------------------------+--------------------------------------------------+
  592. 585 rows in set (0.005 sec)
  593.  
  594.  
  595.  
  596. VARIABLES:
  597.  
  598. Variable_name Value
  599. alter_algorithm DEFAULT
  600. aria_block_size 8192
  601. aria_checkpoint_interval 30
  602. aria_checkpoint_log_activity 1048576
  603. aria_encrypt_tables OFF
  604. aria_force_start_after_recovery_failures 0
  605. aria_group_commit none
  606. aria_group_commit_interval 0
  607. aria_log_file_size 1073741824
  608. aria_log_purge_type immediate
  609. aria_max_sort_file_size 9223372036853727232
  610. aria_page_checksum ON
  611. aria_pagecache_age_threshold 300
  612. aria_pagecache_buffer_size 134217728
  613. aria_pagecache_division_limit 100
  614. aria_pagecache_file_hash_size 512
  615. aria_recover_options BACKUP,QUICK
  616. aria_repair_threads 1
  617. aria_sort_buffer_size 268434432
  618. aria_stats_method nulls_unequal
  619. aria_sync_log_dir NEWFILE
  620. aria_used_for_temp_tables ON
  621. auto_increment_increment 3
  622. auto_increment_offset 1
  623. autocommit ON
  624. automatic_sp_privileges ON
  625. back_log 80
  626. basedir /usr
  627. big_tables OFF
  628. bind_address 0.0.0.0
  629. binlog_annotate_row_events ON
  630. binlog_cache_size 32768
  631. binlog_checksum CRC32
  632. binlog_commit_wait_count 0
  633. binlog_commit_wait_usec 100000
  634. binlog_direct_non_transactional_updates OFF
  635. binlog_file_cache_size 16384
  636. binlog_format ROW
  637. binlog_optimize_thread_scheduling ON
  638. binlog_row_image FULL
  639. binlog_stmt_cache_size 32768
  640. bulk_insert_buffer_size 8388608
  641. character_set_client utf8mb4
  642. character_set_connection utf8mb4
  643. character_set_database utf8mb4
  644. character_set_filesystem binary
  645. character_set_results utf8mb4
  646. character_set_server utf8mb4
  647. character_set_system utf8
  648. character_sets_dir /usr/share/mysql/charsets/
  649. check_constraint_checks ON
  650. collation_connection utf8mb4_general_ci
  651. collation_database utf8mb4_general_ci
  652. collation_server utf8mb4_general_ci
  653. column_compression_threshold 100
  654. column_compression_zlib_level 6
  655. column_compression_zlib_strategy DEFAULT_STRATEGY
  656. column_compression_zlib_wrap OFF
  657. completion_type NO_CHAIN
  658. concurrent_insert AUTO
  659. connect_timeout 10
  660. core_file OFF
  661. datadir /var/lib/mysql/
  662. date_format %Y-%m-%d
  663. datetime_format %Y-%m-%d %H:%i:%s
  664. deadlock_search_depth_long 15
  665. deadlock_search_depth_short 4
  666. deadlock_timeout_long 50000000
  667. deadlock_timeout_short 10000
  668. debug_no_thread_alarm OFF
  669. default_regex_flags
  670. default_storage_engine InnoDB
  671. default_tmp_storage_engine
  672. default_week_format 0
  673. delay_key_write ON
  674. delayed_insert_limit 100
  675. delayed_insert_timeout 300
  676. delayed_queue_size 1000
  677. div_precision_increment 4
  678. encrypt_binlog OFF
  679. encrypt_tmp_disk_tables OFF
  680. encrypt_tmp_files OFF
  681. enforce_storage_engine
  682. eq_range_index_dive_limit 0
  683. event_scheduler OFF
  684. expensive_subquery_limit 100
  685. expire_logs_days 10
  686. explicit_defaults_for_timestamp OFF
  687. extra_max_connections 1
  688. extra_port 0
  689. flush OFF
  690. flush_time 0
  691. foreign_key_checks ON
  692. ft_boolean_syntax + -><()~*:""&|
  693. ft_max_word_len 84
  694. ft_min_word_len 4
  695. ft_query_expansion_limit 20
  696. ft_stopword_file (built-in)
  697. general_log OFF
  698. general_log_file node3.log
  699. group_concat_max_len 1048576
  700. gtid_binlog_pos
  701. gtid_binlog_state
  702. gtid_current_pos
  703. gtid_domain_id 0
  704. gtid_ignore_duplicates OFF
  705. gtid_pos_auto_engines
  706. gtid_slave_pos
  707. gtid_strict_mode OFF
  708. have_compress YES
  709. have_crypt YES
  710. have_dynamic_loading YES
  711. have_geometry YES
  712. have_openssl NO
  713. have_profiling YES
  714. have_query_cache YES
  715. have_rtree_keys YES
  716. have_ssl DISABLED
  717. have_symlink YES
  718. histogram_size 0
  719. histogram_type SINGLE_PREC_HB
  720. host_cache_size 279
  721. hostname node3.local
  722. idle_readonly_transaction_timeout 0
  723. idle_transaction_timeout 0
  724. idle_write_transaction_timeout 0
  725. ignore_builtin_innodb OFF
  726. ignore_db_dirs
  727. in_predicate_conversion_threshold 1000
  728. init_connect
  729. init_file
  730. init_slave
  731. innodb_adaptive_flushing ON
  732. innodb_adaptive_flushing_lwm 10.000000
  733. innodb_adaptive_hash_index ON
  734. innodb_adaptive_hash_index_parts 8
  735. innodb_adaptive_max_sleep_delay 150000
  736. innodb_autoextend_increment 64
  737. innodb_autoinc_lock_mode 2
  738. innodb_background_scrub_data_check_interval 3600
  739. innodb_background_scrub_data_compressed OFF
  740. innodb_background_scrub_data_interval 604800
  741. innodb_background_scrub_data_uncompressed OFF
  742. innodb_buf_dump_status_frequency 0
  743. innodb_buffer_pool_chunk_size 134217728
  744. innodb_buffer_pool_dump_at_shutdown ON
  745. innodb_buffer_pool_dump_now OFF
  746. innodb_buffer_pool_dump_pct 25
  747. innodb_buffer_pool_filename ib_buffer_pool
  748. innodb_buffer_pool_instances 4
  749. innodb_buffer_pool_load_abort OFF
  750. innodb_buffer_pool_load_at_startup ON
  751. innodb_buffer_pool_load_now OFF
  752. innodb_buffer_pool_size 4294967296
  753. innodb_change_buffer_max_size 25
  754. innodb_change_buffering all
  755. innodb_checksum_algorithm crc32
  756. innodb_checksums ON
  757. innodb_cmp_per_index_enabled OFF
  758. innodb_commit_concurrency 0
  759. innodb_compression_algorithm zlib
  760. innodb_compression_default OFF
  761. innodb_compression_failure_threshold_pct 5
  762. innodb_compression_level 6
  763. innodb_compression_pad_pct_max 50
  764. innodb_concurrency_tickets 5000
  765. innodb_data_file_path ibdata1:1G:autoextend
  766. innodb_data_home_dir
  767. innodb_deadlock_detect ON
  768. innodb_default_encryption_key_id 1
  769. innodb_default_row_format dynamic
  770. innodb_defragment OFF
  771. innodb_defragment_fill_factor 0.900000
  772. innodb_defragment_fill_factor_n_recs 20
  773. innodb_defragment_frequency 40
  774. innodb_defragment_n_pages 7
  775. innodb_defragment_stats_accuracy 0
  776. innodb_disable_sort_file_cache OFF
  777. innodb_disallow_writes OFF
  778. innodb_doublewrite ON
  779. innodb_encrypt_log OFF
  780. innodb_encrypt_tables OFF
  781. innodb_encrypt_temporary_tables OFF
  782. innodb_encryption_rotate_key_age 1
  783. innodb_encryption_rotation_iops 100
  784. innodb_encryption_threads 0
  785. innodb_fast_shutdown 1
  786. innodb_fatal_semaphore_wait_threshold 600
  787. innodb_file_format
  788. innodb_file_per_table ON
  789. innodb_fill_factor 100
  790. innodb_flush_log_at_timeout 1
  791. innodb_flush_log_at_trx_commit 0
  792. innodb_flush_method fsync
  793. innodb_flush_neighbors 1
  794. innodb_flush_sync ON
  795. innodb_flushing_avg_loops 30
  796. innodb_force_load_corrupted OFF
  797. innodb_force_primary_key OFF
  798. innodb_force_recovery 0
  799. innodb_ft_aux_table
  800. innodb_ft_cache_size 8000000
  801. innodb_ft_enable_diag_print OFF
  802. innodb_ft_enable_stopword ON
  803. innodb_ft_max_token_size 84
  804. innodb_ft_min_token_size 3
  805. innodb_ft_num_word_optimize 2000
  806. innodb_ft_result_cache_limit 2000000000
  807. innodb_ft_server_stopword_table
  808. innodb_ft_sort_pll_degree 2
  809. innodb_ft_total_cache_size 640000000
  810. innodb_ft_user_stopword_table
  811. innodb_idle_flush_pct 100
  812. innodb_immediate_scrub_data_uncompressed OFF
  813. innodb_instant_alter_column_allowed add_last
  814. innodb_io_capacity 1600
  815. innodb_io_capacity_max 3200
  816. innodb_large_prefix
  817. innodb_lock_schedule_algorithm fcfs
  818. innodb_lock_wait_timeout 50
  819. innodb_locks_unsafe_for_binlog OFF
  820. innodb_log_buffer_size 67108864
  821. innodb_log_checksums ON
  822. innodb_log_compressed_pages ON
  823. innodb_log_file_size 536870912
  824. innodb_log_files_in_group 2
  825. innodb_log_group_home_dir ./
  826. innodb_log_optimize_ddl OFF
  827. innodb_log_write_ahead_size 8192
  828. innodb_lru_scan_depth 1024
  829. innodb_max_dirty_pages_pct 75.000000
  830. innodb_max_dirty_pages_pct_lwm 0.000000
  831. innodb_max_purge_lag 0
  832. innodb_max_purge_lag_delay 0
  833. innodb_max_purge_lag_wait 4294967295
  834. innodb_max_undo_log_size 10485760
  835. innodb_monitor_disable
  836. innodb_monitor_enable
  837. innodb_monitor_reset
  838. innodb_monitor_reset_all
  839. innodb_old_blocks_pct 37
  840. innodb_old_blocks_time 1000
  841. innodb_online_alter_log_max_size 134217728
  842. innodb_open_files 4096
  843. innodb_optimize_fulltext_only OFF
  844. innodb_page_cleaners 4
  845. innodb_page_size 16384
  846. innodb_prefix_index_cluster_optimization OFF
  847. innodb_print_all_deadlocks OFF
  848. innodb_purge_batch_size 300
  849. innodb_purge_rseg_truncate_frequency 128
  850. innodb_purge_threads 4
  851. innodb_random_read_ahead OFF
  852. innodb_read_ahead_threshold 56
  853. innodb_read_io_threads 4
  854. innodb_read_only OFF
  855. innodb_replication_delay 0
  856. innodb_rollback_on_timeout OFF
  857. innodb_rollback_segments 128
  858. innodb_scrub_log OFF
  859. innodb_scrub_log_speed 256
  860. innodb_sort_buffer_size 1048576
  861. innodb_spin_wait_delay 4
  862. innodb_stats_auto_recalc ON
  863. innodb_stats_include_delete_marked OFF
  864. innodb_stats_method nulls_equal
  865. innodb_stats_modified_counter 0
  866. innodb_stats_on_metadata OFF
  867. innodb_stats_persistent ON
  868. innodb_stats_persistent_sample_pages 20
  869. innodb_stats_sample_pages 8
  870. innodb_stats_traditional ON
  871. innodb_stats_transient_sample_pages 8
  872. innodb_status_output OFF
  873. innodb_status_output_locks OFF
  874. innodb_strict_mode OFF
  875. innodb_sync_array_size 1
  876. innodb_sync_spin_loops 30
  877. innodb_table_locks ON
  878. innodb_temp_data_file_path ibtmp1:12M:autoextend
  879. innodb_thread_concurrency 0
  880. innodb_thread_sleep_delay 10000
  881. innodb_tmpdir
  882. innodb_undo_directory ./
  883. innodb_undo_log_truncate OFF
  884. innodb_undo_logs 128
  885. innodb_undo_tablespaces 0
  886. innodb_use_atomic_writes ON
  887. innodb_use_native_aio ON
  888. innodb_version 10.3.29
  889. innodb_write_io_threads 4
  890. interactive_timeout 28800
  891. join_buffer_size 2097152
  892. join_buffer_space_limit 2097152
  893. join_cache_level 2
  894. keep_files_on_create OFF
  895. key_buffer_size 134217728
  896. key_cache_age_threshold 300
  897. key_cache_block_size 1024
  898. key_cache_division_limit 100
  899. key_cache_file_hash_size 512
  900. key_cache_segments 0
  901. large_files_support ON
  902. large_page_size 0
  903. large_pages OFF
  904. lc_messages en_US
  905. lc_messages_dir /usr/share/mysql
  906. lc_time_names en_US
  907. license GPL
  908. local_infile ON
  909. lock_wait_timeout 86400
  910. locked_in_memory OFF
  911. log_bin OFF
  912. log_bin_basename
  913. log_bin_compress OFF
  914. log_bin_compress_min_len 256
  915. log_bin_index
  916. log_bin_trust_function_creators OFF
  917. log_disabled_statements sp
  918. log_error /var/log/mysql/error.log
  919. log_output FILE
  920. log_queries_not_using_indexes OFF
  921. log_slave_updates OFF
  922. log_slow_admin_statements ON
  923. log_slow_disabled_statements sp
  924. 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
  925. log_slow_rate_limit 1
  926. log_slow_slave_statements ON
  927. log_slow_verbosity query_plan
  928. log_tc_size 24576
  929. log_warnings 2
  930. long_query_time 60.000000
  931. low_priority_updates OFF
  932. lower_case_file_system OFF
  933. lower_case_table_names 0
  934. master_verify_checksum OFF
  935. max_allowed_packet 16777216
  936. max_binlog_cache_size 18446744073709547520
  937. max_binlog_size 1073741824
  938. max_binlog_stmt_cache_size 18446744073709547520
  939. max_connect_errors 100
  940. max_connections 151
  941. max_delayed_threads 20
  942. max_digest_length 1024
  943. max_error_count 64
  944. max_heap_table_size 16777216
  945. max_insert_delayed_threads 20
  946. max_join_size 18446744073709551615
  947. max_length_for_sort_data 1024
  948. max_long_data_size 16777216
  949. max_prepared_stmt_count 16382
  950. max_recursive_iterations 4294967295
  951. max_relay_log_size 1073741824
  952. max_seeks_for_key 4294967295
  953. max_session_mem_used 9223372036854775807
  954. max_sort_length 1024
  955. max_sp_recursion_depth 0
  956. max_statement_time 0.000000
  957. max_tmp_tables 32
  958. max_user_connections 0
  959. max_write_lock_count 4294967295
  960. metadata_locks_cache_size 1024
  961. metadata_locks_hash_instances 8
  962. min_examined_row_limit 0
  963. mrr_buffer_size 262144
  964. multi_range_count 256
  965. myisam_block_size 1024
  966. myisam_data_pointer_size 6
  967. myisam_max_sort_file_size 9223372036853727232
  968. myisam_mmap_size 18446744073709551615
  969. myisam_recover_options BACKUP,QUICK
  970. myisam_repair_threads 1
  971. myisam_sort_buffer_size 134216704
  972. myisam_stats_method NULLS_UNEQUAL
  973. myisam_use_mmap OFF
  974. mysql56_temporal_format ON
  975. net_buffer_length 16384
  976. net_read_timeout 30
  977. net_retry_count 10
  978. net_write_timeout 60
  979. old OFF
  980. old_alter_table DEFAULT
  981. old_mode
  982. old_passwords OFF
  983. open_files_limit 32768
  984. optimizer_prune_level 1
  985. optimizer_search_depth 62
  986. optimizer_selectivity_sampling_limit 100
  987. 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
  988. optimizer_use_condition_selectivity 1
  989. performance_schema OFF
  990. performance_schema_accounts_size -1
  991. performance_schema_digests_size -1
  992. performance_schema_events_stages_history_long_size -1
  993. performance_schema_events_stages_history_size -1
  994. performance_schema_events_statements_history_long_size -1
  995. performance_schema_events_statements_history_size -1
  996. performance_schema_events_waits_history_long_size -1
  997. performance_schema_events_waits_history_size -1
  998. performance_schema_hosts_size -1
  999. performance_schema_max_cond_classes 80
  1000. performance_schema_max_cond_instances -1
  1001. performance_schema_max_digest_length 1024
  1002. performance_schema_max_file_classes 50
  1003. performance_schema_max_file_handles 32768
  1004. performance_schema_max_file_instances -1
  1005. performance_schema_max_mutex_classes 200
  1006. performance_schema_max_mutex_instances -1
  1007. performance_schema_max_rwlock_classes 40
  1008. performance_schema_max_rwlock_instances -1
  1009. performance_schema_max_socket_classes 10
  1010. performance_schema_max_socket_instances -1
  1011. performance_schema_max_stage_classes 160
  1012. performance_schema_max_statement_classes 200
  1013. performance_schema_max_table_handles -1
  1014. performance_schema_max_table_instances -1
  1015. performance_schema_max_thread_classes 50
  1016. performance_schema_max_thread_instances -1
  1017. performance_schema_session_connect_attrs_size -1
  1018. performance_schema_setup_actors_size 100
  1019. performance_schema_setup_objects_size 100
  1020. performance_schema_users_size -1
  1021. pid_file /run/mysqld/mysqld.pid
  1022. plugin_dir /usr/lib/x86_64-linux-gnu/mariadb19/plugin/
  1023. plugin_maturity gamma
  1024. port 3306
  1025. preload_buffer_size 32768
  1026. profiling OFF
  1027. profiling_history_size 15
  1028. progress_report_time 5
  1029. protocol_version 10
  1030. proxy_protocol_networks
  1031. query_alloc_block_size 16384
  1032. query_cache_limit 1048576
  1033. query_cache_min_res_unit 4096
  1034. query_cache_size 0
  1035. query_cache_strip_comments OFF
  1036. query_cache_type OFF
  1037. query_cache_wlock_invalidate OFF
  1038. query_prealloc_size 24576
  1039. range_alloc_block_size 4096
  1040. read_binlog_speed_limit 0
  1041. read_buffer_size 131072
  1042. read_only OFF
  1043. read_rnd_buffer_size 262144
  1044. relay_log
  1045. relay_log_basename
  1046. relay_log_index
  1047. relay_log_info_file relay-log.info
  1048. relay_log_purge ON
  1049. relay_log_recovery OFF
  1050. relay_log_space_limit 0
  1051. replicate_annotate_row_events ON
  1052. replicate_do_db
  1053. replicate_do_table
  1054. replicate_events_marked_for_skip REPLICATE
  1055. replicate_ignore_db
  1056. replicate_ignore_table
  1057. replicate_wild_do_table
  1058. replicate_wild_ignore_table
  1059. report_host
  1060. report_password
  1061. report_port 3306
  1062. report_user
  1063. rowid_merge_buff_size 8388608
  1064. rpl_semi_sync_master_enabled OFF
  1065. rpl_semi_sync_master_timeout 10000
  1066. rpl_semi_sync_master_trace_level 32
  1067. rpl_semi_sync_master_wait_no_slave ON
  1068. rpl_semi_sync_master_wait_point AFTER_COMMIT
  1069. rpl_semi_sync_slave_delay_master OFF
  1070. rpl_semi_sync_slave_enabled OFF
  1071. rpl_semi_sync_slave_kill_conn_timeout 5
  1072. rpl_semi_sync_slave_trace_level 32
  1073. secure_auth ON
  1074. secure_file_priv
  1075. secure_timestamp NO
  1076. server_id 3
  1077. session_track_schema ON
  1078. session_track_state_change OFF
  1079. session_track_system_variables autocommit,character_set_client,character_set_connection,character_set_results,time_zone
  1080. session_track_transaction_info OFF
  1081. skip_external_locking ON
  1082. skip_name_resolve ON
  1083. skip_networking OFF
  1084. skip_show_database OFF
  1085. slave_compressed_protocol OFF
  1086. slave_ddl_exec_mode IDEMPOTENT
  1087. slave_domain_parallel_threads 0
  1088. slave_exec_mode STRICT
  1089. slave_load_tmpdir /tmp
  1090. slave_max_allowed_packet 1073741824
  1091. slave_net_timeout 60
  1092. slave_parallel_max_queued 131072
  1093. slave_parallel_mode conservative
  1094. slave_parallel_threads 0
  1095. slave_parallel_workers 0
  1096. slave_run_triggers_for_rbr NO
  1097. slave_skip_errors OFF
  1098. slave_sql_verify_checksum ON
  1099. slave_transaction_retries 10
  1100. slave_transaction_retry_errors 1213,1205
  1101. slave_transaction_retry_interval 0
  1102. slave_type_conversions
  1103. slow_launch_time 2
  1104. slow_query_log ON
  1105. slow_query_log_file /var/log/mysql/mariadb-slow.log
  1106. socket /run/mysqld/mysqld.sock
  1107. sort_buffer_size 2097152
  1108. sql_auto_is_null OFF
  1109. sql_big_selects ON
  1110. sql_buffer_result OFF
  1111. sql_log_bin ON
  1112. sql_log_off OFF
  1113. sql_mode ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION
  1114. sql_notes ON
  1115. sql_quote_show_create ON
  1116. sql_safe_updates OFF
  1117. sql_select_limit 18446744073709551615
  1118. sql_slave_skip_counter 0
  1119. sql_warnings OFF
  1120. ssl_ca
  1121. ssl_capath
  1122. ssl_cert
  1123. ssl_cipher
  1124. ssl_crl
  1125. ssl_crlpath
  1126. ssl_key
  1127. standard_compliant_cte ON
  1128. storage_engine InnoDB
  1129. stored_program_cache 256
  1130. strict_password_validation ON
  1131. sync_binlog 0
  1132. sync_frm ON
  1133. sync_master_info 10000
  1134. sync_relay_log 10000
  1135. sync_relay_log_info 10000
  1136. system_time_zone CEST
  1137. system_versioning_alter_history ERROR
  1138. system_versioning_asof DEFAULT
  1139. table_definition_cache 9000
  1140. table_open_cache 4096
  1141. table_open_cache_instances 3
  1142. tcp_keepalive_interval 0
  1143. tcp_keepalive_probes 0
  1144. tcp_keepalive_time 0
  1145. thread_cache_size 151
  1146. thread_concurrency 10
  1147. thread_handling one-thread-per-connection
  1148. thread_pool_idle_timeout 60
  1149. thread_pool_max_threads 65536
  1150. thread_pool_oversubscribe 3
  1151. thread_pool_prio_kickup_timer 1000
  1152. thread_pool_priority auto
  1153. thread_pool_size 4
  1154. thread_pool_stall_limit 500
  1155. thread_stack 299008
  1156. time_format %H:%i:%s
  1157. time_zone SYSTEM
  1158. timed_mutexes OFF
  1159. tmp_disk_table_size 18446744073709551615
  1160. tmp_memory_table_size 16777216
  1161. tmp_table_size 16777216
  1162. tmpdir /tmp
  1163. transaction_alloc_block_size 8192
  1164. transaction_prealloc_size 4096
  1165. tx_isolation REPEATABLE-READ
  1166. tx_read_only OFF
  1167. unique_checks ON
  1168. updatable_views_with_limit YES
  1169. use_stat_tables NEVER
  1170. userstat OFF
  1171. version 10.3.29-MariaDB-0+deb10u1-log
  1172. version_comment Debian 10
  1173. version_compile_machine x86_64
  1174. version_compile_os debian-linux-gnu
  1175. version_malloc_library system
  1176. version_source_revision 4f143a88bcb36e94e9edba8a3c5b4a350dcd9bf9
  1177. version_ssl_library YaSSL 2.4.4
  1178. wait_timeout 28800
  1179. wsrep_osu_method TOI
  1180. wsrep_auto_increment_control ON
  1181. wsrep_causal_reads OFF
  1182. wsrep_certification_rules strict
  1183. wsrep_certify_nonpk ON
  1184. wsrep_cluster_address gcomm://node1,node2,node3
  1185. wsrep_cluster_name galera_cluster
  1186. wsrep_convert_lock_to_trx OFF
  1187. wsrep_data_home_dir /var/lib/mysql/
  1188. wsrep_dbug_option
  1189. wsrep_debug OFF
  1190. wsrep_desync OFF
  1191. wsrep_dirty_reads OFF
  1192. wsrep_drupal_282555_workaround OFF
  1193. wsrep_forced_binlog_format NONE
  1194. wsrep_gtid_domain_id 0
  1195. wsrep_gtid_mode OFF
  1196. wsrep_load_data_splitting ON
  1197. wsrep_log_conflicts OFF
  1198. wsrep_max_ws_rows 0
  1199. wsrep_max_ws_size 2147483647
  1200. wsrep_mysql_replication_bundle 0
  1201. wsrep_node_address node3
  1202. wsrep_node_incoming_address AUTO
  1203. wsrep_node_name node3
  1204. wsrep_notify_cmd
  1205. wsrep_on ON
  1206. wsrep_patch_version wsrep_25.24
  1207. wsrep_provider /usr/lib/galera/libgalera_smm.so
  1208. wsrep_provider_options base_dir = /var/lib/mysql/; base_host = node3; base_port = 4567; cert.log_conflicts = no; cert.optimistic_pa = yes; debug = no; evs.auto_evict = 0; evs.causal_keepalive_period = PT1S; evs.debug_log_mask = 0x1; evs.delay_margin = PT1S; evs.delayed_keep_period = PT30S; evs.inactive_check_period = PT0.5S; evs.inactive_timeout = PT15S; evs.info_log_mask = 0; evs.install_timeout = PT7.5S; evs.join_retrans_period = PT1S; evs.keepalive_period = PT1S; evs.max_install_timeouts = 3; evs.send_window = 4; evs.stats_report_period = PT1M; evs.suspect_timeout = PT5S; evs.use_aggregate = true; evs.user_send_window = 2; evs.version = 0; evs.view_forget_timeout = P1D; gcache.dir = /var/lib/mysql/; gcache.keep_pages_size = 0; gcache.mem_size = 0; gcache.name = /var/lib/mysql//galera.cache; gcache.page_size = 128M; gcache.recover = no; gcache.size = 128M; gcomm.thread_prio = ; gcs.fc_debug = 0; gcs.fc_factor = 1.0; gcs.fc_limit = 16; gcs.fc_master_slave = no; gcs.max_packet_size = 64500; gcs.max_throttle = 0.25; gcs.recv_q_hard_limit = 9223372036854775807; gcs.recv_q_soft_limit = 0.25; gcs.sync_donor = no; gmcast.listen_addr = tcp://0.0.0.0:4567; gmcast.mcast_addr = ; gmcast.mcast_ttl = 1; gmcast.peer_timeout = PT3S; gmcast.segment = 0; gmcast.time_wait = PT5S; gmcast.version = 0; ist.recv_addr = node3; pc.announce_timeout = PT3S; pc.checksum = false; pc.ignore_quorum = false; pc.ignore_sb = false; pc.linger = PT20S; pc.npvo = false; pc.recovery = true; pc.version = 0; pc.wait_prim = true; pc.wait_prim_timeout = PT30S; pc.weight = 1; protonet.backend = asio; protonet.version = 0; repl.causal_read_timeout = PT30S; repl.commit_order = 3; repl.key_format = FLAT8; repl.max_ws_size = 2147483647; repl.proto_max = 9; socket.checksum = 2; socket.recv_buf_size = 212992;
  1209. wsrep_recover OFF
  1210. wsrep_reject_queries NONE
  1211. wsrep_replicate_myisam OFF
  1212. wsrep_restart_slave OFF
  1213. wsrep_retry_autocommit 1
  1214. wsrep_slave_fk_checks ON
  1215. wsrep_slave_uk_checks OFF
  1216. wsrep_slave_threads 16
  1217. wsrep_sst_auth ********
  1218. wsrep_sst_donor
  1219. wsrep_sst_donor_rejects_queries OFF
  1220. wsrep_sst_method mariabackup
  1221. wsrep_sst_receive_address AUTO
  1222. wsrep_start_position b3c56acd-d17a-11ea-aa05-af73b589f500:26682258
  1223. wsrep_sync_wait 0
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!