Advertisement
Guest User

Untitled

a guest
Jan 23rd, 2020
231
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 14.05 KB | None | 0 0
  1. Variable_name;Value
  2. Aborted_clients;2483
  3. Aborted_connects;93146
  4. Access_denied_errors;93135
  5. Acl_column_grants;0
  6. Acl_database_grants;29
  7. Acl_function_grants;0
  8. Acl_procedure_grants;0
  9. Acl_package_spec_grants;0
  10. Acl_package_body_grants;0
  11. Acl_proxy_users;1
  12. Acl_role_grants;0
  13. Acl_roles;0
  14. Acl_table_grants;10
  15. Acl_users;23
  16. Aria_pagecache_blocks_not_flushed;0
  17. Aria_pagecache_blocks_unused;15706
  18. Aria_pagecache_blocks_used;1243
  19. Aria_pagecache_read_requests;459057608
  20. Aria_pagecache_reads;81250
  21. Aria_pagecache_write_requests;4558492
  22. Aria_pagecache_writes;255734
  23. Aria_transaction_log_syncs;197
  24. Binlog_commits;0
  25. Binlog_group_commits;0
  26. Binlog_group_commit_trigger_count;0
  27. Binlog_group_commit_trigger_lock_wait;0
  28. Binlog_group_commit_trigger_timeout;0
  29. Binlog_snapshot_file;
  30. Binlog_snapshot_position;0
  31. Binlog_bytes_written;0
  32. Binlog_cache_disk_use;0
  33. Binlog_cache_use;0
  34. Binlog_stmt_cache_disk_use;0
  35. Binlog_stmt_cache_use;0
  36. Busy_time;0.000000
  37. Bytes_received;599014130998
  38. Bytes_sent;42689995480466
  39. Column_compressions;0
  40. Column_decompressions;0
  41. Com_admin_commands;116253
  42. Com_alter_db;0
  43. Com_alter_db_upgrade;0
  44. Com_alter_event;0
  45. Com_alter_function;0
  46. Com_alter_procedure;0
  47. Com_alter_server;0
  48. Com_alter_sequence;0
  49. Com_alter_table;22
  50. Com_alter_tablespace;0
  51. Com_alter_user;0
  52. Com_analyze;0
  53. Com_assign_to_keycache;0
  54. Com_begin;0
  55. Com_binlog;0
  56. Com_call_procedure;662690
  57. Com_change_db;111
  58. Com_change_master;0
  59. Com_check;0
  60. Com_checksum;0
  61. Com_commit;0
  62. Com_compound_sql;0
  63. Com_create_db;0
  64. Com_create_event;0
  65. Com_create_function;0
  66. Com_create_index;0
  67. Com_create_package;0
  68. Com_create_package_body;0
  69. Com_create_procedure;0
  70. Com_create_role;0
  71. Com_create_sequence;0
  72. Com_create_server;0
  73. Com_create_table;15
  74. Com_create_temporary_table;0
  75. Com_create_trigger;4
  76. Com_create_udf;0
  77. Com_create_user;2
  78. Com_create_view;0
  79. Com_dealloc_sql;2
  80. Com_delete;9511474
  81. Com_delete_multi;3093
  82. Com_do;0
  83. Com_drop_db;0
  84. Com_drop_event;0
  85. Com_drop_function;0
  86. Com_drop_index;0
  87. Com_drop_procedure;0
  88. Com_drop_package;0
  89. Com_drop_package_body;0
  90. Com_drop_role;0
  91. Com_drop_server;0
  92. Com_drop_sequence;0
  93. Com_drop_table;2
  94. Com_drop_temporary_table;0
  95. Com_drop_trigger;0
  96. Com_drop_user;0
  97. Com_drop_view;0
  98. Com_empty_query;0
  99. Com_execute_immediate;0
  100. Com_execute_sql;2
  101. Com_flush;0
  102. Com_get_diagnostics;0
  103. Com_grant;2
  104. Com_grant_role;0
  105. Com_ha_close;0
  106. Com_ha_open;0
  107. Com_ha_read;0
  108. Com_help;0
  109. Com_insert;63605620
  110. Com_insert_select;44118
  111. Com_install_plugin;0
  112. Com_kill;1
  113. Com_load;0
  114. Com_lock_tables;0
  115. Com_multi;0
  116. Com_optimize;0
  117. Com_preload_keys;0
  118. Com_prepare_sql;2
  119. Com_purge;0
  120. Com_purge_before_date;0
  121. Com_release_savepoint;0
  122. Com_rename_table;3
  123. Com_rename_user;0
  124. Com_repair;0
  125. Com_replace;28182079
  126. Com_replace_select;133
  127. Com_reset;1546
  128. Com_resignal;0
  129. Com_revoke;0
  130. Com_revoke_all;0
  131. Com_revoke_role;0
  132. Com_rollback;0
  133. Com_rollback_to_savepoint;0
  134. Com_savepoint;0
  135. Com_select;3986160638
  136. Com_set_option;761825
  137. Com_show_authors;0
  138. Com_show_binlog_events;0
  139. Com_show_binlogs;0
  140. Com_show_charsets;11
  141. Com_show_collations;64
  142. Com_show_contributors;0
  143. Com_show_create_db;0
  144. Com_show_create_event;0
  145. Com_show_create_func;0
  146. Com_show_create_package;0
  147. Com_show_create_package_body;0
  148. Com_show_create_proc;3
  149. Com_show_create_table;1304
  150. Com_show_create_trigger;31
  151. Com_show_create_user;0
  152. Com_show_databases;88
  153. Com_show_engine_logs;0
  154. Com_show_engine_mutex;0
  155. Com_show_engine_status;0
  156. Com_show_errors;0
  157. Com_show_events;68
  158. Com_show_explain;0
  159. Com_show_fields;62844
  160. Com_show_function_status;181
  161. Com_show_generic;0
  162. Com_show_grants;0
  163. Com_show_keys;0
  164. Com_show_master_status;0
  165. Com_show_open_tables;31
  166. Com_show_package_status;0
  167. Com_show_package_body_status;0
  168. Com_show_plugins;0
  169. Com_show_privileges;0
  170. Com_show_procedure_status;181
  171. Com_show_processlist;0
  172. Com_show_profile;0
  173. Com_show_profiles;0
  174. Com_show_relaylog_events;0
  175. Com_show_slave_hosts;0
  176. Com_show_slave_status;0
  177. Com_show_status;1027118
  178. Com_show_storage_engines;64
  179. Com_show_table_status;846
  180. Com_show_tables;0
  181. Com_show_triggers;226
  182. Com_show_variables;1059
  183. Com_show_warnings;0
  184. Com_shutdown;0
  185. Com_signal;0
  186. Com_start_all_slaves;0
  187. Com_start_slave;0
  188. Com_stmt_close;4129522738
  189. Com_stmt_execute;4138804712
  190. Com_stmt_fetch;0
  191. Com_stmt_prepare;4138804898
  192. Com_stmt_reprepare;2
  193. Com_stmt_reset;0
  194. Com_stmt_send_long_data;0
  195. Com_stop_all_slaves;0
  196. Com_stop_slave;0
  197. Com_truncate;4
  198. Com_uninstall_plugin;0
  199. Com_unlock_tables;0
  200. Com_update;55803905
  201. Com_update_multi;18565
  202. Com_xa_commit;0
  203. Com_xa_end;0
  204. Com_xa_prepare;0
  205. Com_xa_recover;0
  206. Com_xa_rollback;0
  207. Com_xa_start;0
  208. Compression;OFF
  209. Connection_errors_accept;0
  210. Connection_errors_internal;0
  211. Connection_errors_max_connections;0
  212. Connection_errors_peer_address;0
  213. Connection_errors_select;0
  214. Connection_errors_tcpwrap;0
  215. Connections;206910348
  216. Cpu_time;0.000000
  217. Created_tmp_disk_tables;313992
  218. Created_tmp_files;183
  219. Created_tmp_tables;33417062
  220. Delayed_errors;0
  221. Delayed_insert_threads;0
  222. Delayed_writes;0
  223. Delete_scan;65849
  224. Empty_queries;447681789
  225. Executed_events;0
  226. Executed_triggers;8133919
  227. Feature_check_constraint;0
  228. Feature_custom_aggregate_functions;0
  229. Feature_delay_key_write;0
  230. Feature_dynamic_columns;0
  231. Feature_fulltext;3447906
  232. Feature_gis;0
  233. Feature_invisible_columns;0
  234. Feature_json;0
  235. Feature_locale;0
  236. Feature_subquery;27415586
  237. Feature_system_versioning;0
  238. Feature_timezone;0
  239. Feature_trigger;1123
  240. Feature_window_functions;0
  241. Feature_xml;0
  242. Flush_commands;1
  243. Handler_commit;2879127877
  244. Handler_delete;33986154
  245. Handler_discover;0
  246. Handler_external_lock;0
  247. Handler_icp_attempts;35630513620
  248. Handler_icp_match;32129046895
  249. Handler_mrr_init;0
  250. Handler_mrr_key_refills;0
  251. Handler_mrr_rowid_refills;0
  252. Handler_prepare;0
  253. Handler_read_first;267963
  254. Handler_read_key;35792508275
  255. Handler_read_last;4615142
  256. Handler_read_next;1992654788984
  257. Handler_read_prev;152405517339
  258. Handler_read_retry;0
  259. Handler_read_rnd;10811186838
  260. Handler_read_rnd_deleted;4601
  261. Handler_read_rnd_next;238690143016
  262. Handler_rollback;18572
  263. Handler_savepoint;0
  264. Handler_savepoint_rollback;0
  265. Handler_tmp_delete;0
  266. Handler_tmp_update;2245275887
  267. Handler_tmp_write;1184352978
  268. Handler_update;989146474
  269. Handler_write;91941089
  270. Innodb_buffer_pool_dump_status;
  271. Innodb_buffer_pool_load_status;Buffer pool(s) load completed at 191120 0:16:09
  272. Innodb_buffer_pool_resize_status;
  273. Innodb_buffer_pool_load_incomplete;OFF
  274. Innodb_buffer_pool_pages_data;447128
  275. Innodb_buffer_pool_bytes_data;7325745152
  276. Innodb_buffer_pool_pages_dirty;13996
  277. Innodb_buffer_pool_bytes_dirty;229310464
  278. Innodb_buffer_pool_pages_flushed;94293677
  279. Innodb_buffer_pool_pages_free;6142
  280. Innodb_buffer_pool_pages_misc;87402
  281. Innodb_buffer_pool_pages_total;540672
  282. Innodb_buffer_pool_read_ahead_rnd;0
  283. Innodb_buffer_pool_read_ahead;46922289
  284. Innodb_buffer_pool_read_ahead_evicted;285
  285. Innodb_buffer_pool_read_requests;1112667564038
  286. Innodb_buffer_pool_reads;41879422
  287. Innodb_buffer_pool_wait_free;164
  288. Innodb_buffer_pool_write_requests;3885899268
  289. Innodb_data_fsyncs;37494366
  290. Innodb_data_pending_fsyncs;0
  291. Innodb_data_pending_reads;0
  292. Innodb_data_pending_writes;0
  293. Innodb_data_read;1502090250752
  294. Innodb_data_reads;91680779
  295. Innodb_data_writes;101466776
  296. Innodb_data_written;1727763120640
  297. Innodb_dblwr_pages_written;0
  298. Innodb_dblwr_writes;0
  299. Innodb_log_waits;0
  300. Innodb_log_write_requests;332482673
  301. Innodb_log_writes;6491681
  302. Innodb_os_log_fsyncs;7168331
  303. Innodb_os_log_pending_fsyncs;0
  304. Innodb_os_log_pending_writes;0
  305. Innodb_os_log_written;182569362432
  306. Innodb_page_size;16384
  307. Innodb_pages_created;2380714
  308. Innodb_pages_read;91680502
  309. Innodb_pages0_read;378
  310. Innodb_pages_written;94294050
  311. Innodb_row_lock_current_waits;0
  312. Innodb_row_lock_time;302261455
  313. Innodb_row_lock_time_avg;329
  314. Innodb_row_lock_time_max;61943
  315. Innodb_row_lock_waits;917931
  316. Innodb_rows_deleted;34233706
  317. Innodb_rows_inserted;56192699
  318. Innodb_rows_read;2415741028294
  319. Innodb_rows_updated;927686020
  320. Innodb_system_rows_deleted;0
  321. Innodb_system_rows_inserted;0
  322. Innodb_system_rows_read;0
  323. Innodb_system_rows_updated;0
  324. Innodb_num_open_files;389
  325. Innodb_truncated_status_writes;0
  326. Innodb_available_undo_logs;128
  327. Innodb_undo_truncations;0
  328. Innodb_page_compression_saved;0
  329. Innodb_num_index_pages_written;0
  330. Innodb_num_non_index_pages_written;0
  331. Innodb_num_pages_page_compressed;0
  332. Innodb_num_page_compressed_trim_op;0
  333. Innodb_num_pages_page_decompressed;0
  334. Innodb_num_pages_page_compression_error;0
  335. Innodb_num_pages_encrypted;0
  336. Innodb_num_pages_decrypted;0
  337. Innodb_have_lz4;OFF
  338. Innodb_have_lzo;OFF
  339. Innodb_have_lzma;ON
  340. Innodb_have_bzip2;OFF
  341. Innodb_have_snappy;OFF
  342. Innodb_have_punch_hole;ON
  343. Innodb_defragment_compression_failures;0
  344. Innodb_defragment_failures;0
  345. Innodb_defragment_count;0
  346. Innodb_instant_alter_column;6
  347. Innodb_onlineddl_rowlog_rows;0
  348. Innodb_onlineddl_rowlog_pct_used;0
  349. Innodb_onlineddl_pct_progress;0
  350. Innodb_secondary_index_triggered_cluster_reads;201774993469
  351. Innodb_secondary_index_triggered_cluster_reads_avoided;0
  352. Innodb_encryption_rotation_pages_read_from_cache;0
  353. Innodb_encryption_rotation_pages_read_from_disk;0
  354. Innodb_encryption_rotation_pages_modified;0
  355. Innodb_encryption_rotation_pages_flushed;0
  356. Innodb_encryption_rotation_estimated_iops;0
  357. Innodb_encryption_key_rotation_list_length;0
  358. Innodb_encryption_n_merge_blocks_encrypted;0
  359. Innodb_encryption_n_merge_blocks_decrypted;0
  360. Innodb_encryption_n_rowlog_blocks_encrypted;0
  361. Innodb_encryption_n_rowlog_blocks_decrypted;0
  362. Innodb_scrub_background_page_reorganizations;0
  363. Innodb_scrub_background_page_splits;0
  364. Innodb_scrub_background_page_split_failures_underflow;0
  365. Innodb_scrub_background_page_split_failures_out_of_filespace;0
  366. Innodb_scrub_background_page_split_failures_missing_index;0
  367. Innodb_scrub_background_page_split_failures_unknown;0
  368. Innodb_scrub_log;0
  369. Innodb_encryption_num_key_requests;0
  370. Key_blocks_not_flushed;0
  371. Key_blocks_unused;13344
  372. Key_blocks_used;51
  373. Key_blocks_warm;43
  374. Key_read_requests;15561048
  375. Key_reads;49
  376. Key_write_requests;155
  377. Key_writes;117
  378. Last_query_cost;0.000000
  379. Master_gtid_wait_count;0
  380. Master_gtid_wait_time;0
  381. Master_gtid_wait_timeouts;0
  382. Max_statement_time_exceeded;0
  383. Max_used_connections;301
  384. Memory_used;542782664
  385. Memory_used_initial;289695960
  386. Not_flushed_delayed_rows;0
  387. Open_files;269
  388. Open_streams;0
  389. Open_table_definitions;437
  390. Open_tables;4096
  391. Opened_files;1258171
  392. Opened_plugin_libraries;0
  393. Opened_table_definitions;520
  394. Opened_tables;5771
  395. Opened_views;0
  396. Performance_schema_accounts_lost;0
  397. Performance_schema_cond_classes_lost;0
  398. Performance_schema_cond_instances_lost;0
  399. Performance_schema_digest_lost;0
  400. Performance_schema_file_classes_lost;0
  401. Performance_schema_file_handles_lost;0
  402. Performance_schema_file_instances_lost;0
  403. Performance_schema_hosts_lost;0
  404. Performance_schema_locker_lost;0
  405. Performance_schema_mutex_classes_lost;0
  406. Performance_schema_mutex_instances_lost;0
  407. Performance_schema_rwlock_classes_lost;0
  408. Performance_schema_rwlock_instances_lost;0
  409. Performance_schema_session_connect_attrs_lost;0
  410. Performance_schema_socket_classes_lost;0
  411. Performance_schema_socket_instances_lost;0
  412. Performance_schema_stage_classes_lost;0
  413. Performance_schema_statement_classes_lost;0
  414. Performance_schema_table_handles_lost;0
  415. Performance_schema_table_instances_lost;0
  416. Performance_schema_thread_classes_lost;0
  417. Performance_schema_thread_instances_lost;0
  418. Performance_schema_users_lost;0
  419. Prepared_stmt_count;3
  420. Qcache_free_blocks;24238
  421. Qcache_free_memory;59914960
  422. Qcache_hits;1259699944
  423. Qcache_inserts;2684144053
  424. Qcache_lowmem_prunes;11779191
  425. Qcache_not_cached;12853154
  426. Qcache_queries_in_cache;46843
  427. Qcache_total_blocks;118160
  428. Queries;12625002243
  429. Questions;4346902882
  430. Rows_read;772444412453
  431. Rows_sent;94204232679
  432. Rows_tmp_read;3345244631
  433. Rpl_semi_sync_master_clients;0
  434. Rpl_semi_sync_master_get_ack;0
  435. Rpl_semi_sync_master_net_avg_wait_time;0
  436. Rpl_semi_sync_master_net_wait_time;0
  437. Rpl_semi_sync_master_net_waits;0
  438. Rpl_semi_sync_master_no_times;0
  439. Rpl_semi_sync_master_no_tx;0
  440. Rpl_semi_sync_master_request_ack;0
  441. Rpl_semi_sync_master_status;OFF
  442. Rpl_semi_sync_master_timefunc_failures;0
  443. Rpl_semi_sync_master_tx_avg_wait_time;0
  444. Rpl_semi_sync_master_tx_wait_time;0
  445. Rpl_semi_sync_master_tx_waits;0
  446. Rpl_semi_sync_master_wait_pos_backtraverse;0
  447. Rpl_semi_sync_master_wait_sessions;0
  448. Rpl_semi_sync_master_yes_tx;0
  449. Rpl_semi_sync_slave_send_ack;0
  450. Rpl_semi_sync_slave_status;OFF
  451. Rpl_status;AUTH_MASTER
  452. Rpl_transactions_multi_engine;0
  453. Select_full_join;52525
  454. Select_full_range_join;0
  455. Select_range;292475291
  456. Select_range_check;0
  457. Select_scan;6048081
  458. Slave_connections;0
  459. Slave_heartbeat_period;0.000
  460. Slave_open_temp_tables;0
  461. Slave_received_heartbeats;0
  462. Slave_retried_transactions;0
  463. Slave_running;OFF
  464. Slave_skipped_errors;0
  465. Slaves_connected;0
  466. Slaves_running;0
  467. Slow_launch_threads;14
  468. Slow_queries;3413
  469. Sort_merge_passes;53
  470. Sort_priority_queue_sorts;30020371
  471. Sort_range;263479521
  472. Sort_rows;16560465791
  473. Sort_scan;21355451
  474. Ssl_accept_renegotiates;0
  475. Ssl_accepts;0
  476. Ssl_callback_cache_hits;0
  477. Ssl_cipher;
  478. Ssl_cipher_list;
  479. Ssl_client_connects;0
  480. Ssl_connect_renegotiates;0
  481. Ssl_ctx_verify_depth;0
  482. Ssl_ctx_verify_mode;0
  483. Ssl_default_timeout;0
  484. Ssl_finished_accepts;0
  485. Ssl_finished_connects;0
  486. Ssl_server_not_after;
  487. Ssl_server_not_before;
  488. Ssl_session_cache_hits;0
  489. Ssl_session_cache_misses;0
  490. Ssl_session_cache_mode;NONE
  491. Ssl_session_cache_overflows;0
  492. Ssl_session_cache_size;0
  493. Ssl_session_cache_timeouts;0
  494. Ssl_sessions_reused;0
  495. Ssl_used_session_cache_entries;0
  496. Ssl_verify_depth;0
  497. Ssl_verify_mode;0
  498. Ssl_version;
  499. Subquery_cache_hit;2460419274
  500. Subquery_cache_miss;18503882
  501. Syncs;428
  502. Table_locks_immediate;7780417
  503. Table_locks_waited;0
  504. Table_open_cache_active_instances;2
  505. Table_open_cache_hits;12017246740
  506. Table_open_cache_misses;14420381
  507. Table_open_cache_overflows;1390
  508. Tc_log_max_pages_used;0
  509. Tc_log_page_size;4096
  510. Tc_log_page_waits;0
  511. Threadpool_idle_threads;0
  512. Threadpool_threads;0
  513. Threads_cached;9
  514. Threads_connected;4
  515. Threads_created;7326159
  516. Threads_running;6
  517. Transactions_gtid_foreign_engine;0
  518. Transactions_multi_engine;0
  519. Update_scan;134780
  520. Uptime;5568485
  521. Uptime_since_flush_status;5568485
  522. wsrep_cluster_conf_id;18446744073709551615
  523. wsrep_cluster_size;0
  524. wsrep_cluster_state_uuid;
  525. wsrep_cluster_status;Disconnected
  526. wsrep_connected;OFF
  527. wsrep_local_bf_aborts;0
  528. wsrep_local_index;18446744073709551615
  529. wsrep_provider_name;
  530. wsrep_provider_vendor;
  531. wsrep_provider_version;
  532. wsrep_ready;OFF
  533. wsrep_thread_count;0
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement