Advertisement
Guest User

gbstatus

a guest
May 6th, 2021
307
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 13.53 KB | None | 0 0
  1. Variable_name Value
  2. Aborted_clients 6
  3. Aborted_connects 0
  4. AuroraDb_commits 666681
  5. AuroraDb_commit_latency 1461570244
  6. AuroraDb_ddl_stmt_duration 148898
  7. AuroraDb_select_stmt_duration 147205046631
  8. AuroraDb_insert_stmt_duration 587039457
  9. AuroraDb_update_stmt_duration 2011186605
  10. AuroraDb_delete_stmt_duration 18199011
  11. AuroraDb_lockmgr_bitmaps0_in_use 0
  12. AuroraDb_lockmgr_bitmaps1_in_use 0
  13. AuroraDb_lockmgr_bitmaps_mem_used 1158176
  14. AuroraDb_thread_deadlocks 0
  15. Aurora_available_alter_table_log_entries 0
  16. Aurora_dict_sys_mem_size 3125092
  17. Aurora_fast_insert_cache_hits 0
  18. Aurora_fast_insert_cache_misses 572
  19. Aurora_fwd_master_dml_stmt_count 0
  20. Aurora_fwd_master_dml_stmt_duration 0
  21. Aurora_fwd_master_errors_rpc_timeout 0
  22. Aurora_fwd_master_errors_session_limit 0
  23. Aurora_fwd_master_errors_session_timeout 0
  24. Aurora_fwd_master_open_sessions 0
  25. Aurora_fwd_master_select_stmt_count 0
  26. Aurora_fwd_master_select_stmt_duration 0
  27. Aurora_highest_commit_lsn 7617325554
  28. Aurora_last_allocated_lsn_for_replication 7617325555
  29. Aurora_lockmgr_memory_used 1409614912
  30. Aurora_missing_history_on_replica_incidents 4121973667908301873
  31. Aurora_ml_actual_request_cnt 0
  32. Aurora_ml_actual_response_cnt 0
  33. Aurora_ml_cache_hit_cnt 0
  34. Aurora_ml_logical_request_cnt 0
  35. Aurora_ml_logical_response_cnt 0
  36. Aurora_ml_retry_request_cnt 0
  37. Aurora_ml_single_request_cnt 0
  38. Aurora_oom_response
  39. Aurora_pq_max_concurrent_requests 8
  40. Aurora_pq_request_attempted 0
  41. Aurora_pq_request_attempted_grouping_aggr 0
  42. Aurora_pq_request_attempted_partition_table 0
  43. Aurora_pq_request_by_force_config 0
  44. Aurora_pq_request_by_global_config 0
  45. Aurora_pq_request_by_hint 0
  46. Aurora_pq_request_by_session_config 0
  47. Aurora_pq_request_executed 0
  48. Aurora_pq_request_executed_grouping_aggr 0
  49. Aurora_pq_request_executed_partition_table 0
  50. Aurora_pq_request_failed 0
  51. Aurora_pq_request_failed_grouping_aggr 0
  52. Aurora_pq_request_failed_partition_table 0
  53. Aurora_pq_request_in_instance_type_r_12xlarge 0
  54. Aurora_pq_request_in_instance_type_r_16xlarge 0
  55. Aurora_pq_request_in_instance_type_r_24xlarge 0
  56. Aurora_pq_request_in_instance_type_r_2xlarge 0
  57. Aurora_pq_request_in_instance_type_r_4xlarge 0
  58. Aurora_pq_request_in_instance_type_r_8xlarge 0
  59. Aurora_pq_request_in_instance_type_r_large 0
  60. Aurora_pq_request_in_instance_type_r_xlarge 0
  61. Aurora_pq_request_in_instance_type_unsupported 0
  62. Aurora_pq_request_in_progress 0
  63. Aurora_pq_request_in_reader_instance 0
  64. Aurora_pq_request_in_writer_instance 0
  65. Aurora_pq_request_not_chosen 0
  66. Aurora_pq_request_not_chosen_below_min_rows 0
  67. Aurora_pq_request_not_chosen_column_bit 0
  68. Aurora_pq_request_not_chosen_column_geometry 0
  69. Aurora_pq_request_not_chosen_column_lob 0
  70. Aurora_pq_request_not_chosen_column_virtual 0
  71. Aurora_pq_request_not_chosen_custom_charset 0
  72. Aurora_pq_request_not_chosen_fast_ddl 0
  73. Aurora_pq_request_not_chosen_few_pages_outside_buffer_pool 0
  74. Aurora_pq_request_not_chosen_full_text_index 0
  75. Aurora_pq_request_not_chosen_grouping_aggr 0
  76. Aurora_pq_request_not_chosen_grouping_aggr_aggr_type 0
  77. Aurora_pq_request_not_chosen_grouping_aggr_config 0
  78. Aurora_pq_request_not_chosen_grouping_aggr_expression 0
  79. Aurora_pq_request_not_chosen_grouping_aggr_filter 0
  80. Aurora_pq_request_not_chosen_grouping_aggr_large_aggr_result 0
  81. Aurora_pq_request_not_chosen_high_buffer_pool_pct 0
  82. Aurora_pq_request_not_chosen_index_hint 0
  83. Aurora_pq_request_not_chosen_innodb_table_format 0
  84. Aurora_pq_request_not_chosen_long_trx 0
  85. Aurora_pq_request_not_chosen_no_where_clause 0
  86. Aurora_pq_request_not_chosen_range_scan 0
  87. Aurora_pq_request_not_chosen_row_length_too_long 0
  88. Aurora_pq_request_not_chosen_small_table 0
  89. Aurora_pq_request_not_chosen_temporary_table 0
  90. Aurora_pq_request_not_chosen_tx_isolation 0
  91. Aurora_pq_request_not_chosen_unsupported_access 0
  92. Aurora_pq_request_not_chosen_update_delete_stmts 0
  93. Aurora_pq_request_throttled 0
  94. Aurora_pq_request_with_bloom_filter 0
  95. Aurora_pq_request_with_lob 0
  96. Aurora_pq_stmt_attempted 0
  97. Aurora_pq_stmt_attempted_hash_join 0
  98. Aurora_repl_bytes_received 0
  99. Aurora_reserved_mem_exceeded_incidents 0
  100. Aurora_tmz_version 0
  101. Aurora_total_op_memory 0
  102. Aurora_total_op_temp_space 0
  103. Aurora_used_alter_table_log_entries 0
  104. Aurora_volume_bytes_left_total 140360444575744
  105. Binlog_cache_disk_use 0
  106. Binlog_cache_use 0
  107. Binlog_stmt_cache_disk_use 0
  108. Binlog_stmt_cache_use 0
  109. Bytes_received 112030592831
  110. Bytes_sent 258456053996
  111. Com_admin_commands 0
  112. Com_assign_to_keycache 0
  113. Com_alter_db 0
  114. Com_alter_db_upgrade 0
  115. Com_alter_event 0
  116. Com_alter_function 0
  117. Com_alter_instance 0
  118. Com_alter_procedure 0
  119. Com_alter_server 0
  120. Com_alter_table 0
  121. Com_alter_tablespace 0
  122. Com_alter_user 0
  123. Com_analyze 0
  124. Com_begin 373888
  125. Com_binlog 0
  126. Com_call_procedure 153697
  127. Com_change_db 1
  128. Com_change_master 0
  129. Com_change_repl_filter 0
  130. Com_check 0
  131. Com_checksum 0
  132. Com_commit 433212
  133. Com_create_db 0
  134. Com_create_event 0
  135. Com_create_function 0
  136. Com_create_index 0
  137. Com_create_procedure 0
  138. Com_create_server 0
  139. Com_create_table 0
  140. Com_create_trigger 8
  141. Com_create_udf 0
  142. Com_create_user 0
  143. Com_create_view 0
  144. Com_dealloc_sql 0
  145. Com_delete 71954
  146. Com_delete_multi 1443
  147. Com_do 92740
  148. Com_drop_db 0
  149. Com_drop_event 0
  150. Com_drop_function 0
  151. Com_drop_index 0
  152. Com_drop_procedure 1
  153. Com_drop_server 0
  154. Com_drop_table 0
  155. Com_drop_trigger 8
  156. Com_drop_user 0
  157. Com_drop_view 0
  158. Com_empty_query 0
  159. Com_execute_sql 0
  160. Com_explain_other 0
  161. Com_flush 945
  162. Com_get_diagnostics 0
  163. Com_grant 0
  164. Com_ha_close 0
  165. Com_ha_open 0
  166. Com_ha_read 0
  167. Com_help 0
  168. Com_insert 634834
  169. Com_insert_select 52672
  170. Com_install_plugin 0
  171. Com_kill 0
  172. Com_load 0
  173. Com_lock_tables 0
  174. Com_optimize 0
  175. Com_preload_keys 0
  176. Com_prepare_sql 0
  177. Com_purge 0
  178. Com_purge_before_date 397
  179. Com_release_savepoint 0
  180. Com_rename_table 0
  181. Com_rename_user 0
  182. Com_repair 0
  183. Com_replace 0
  184. Com_replace_select 83048
  185. Com_reset 0
  186. Com_resignal 0
  187. Com_revoke 0
  188. Com_revoke_all 0
  189. Com_rollback 336
  190. Com_rollback_to_savepoint 0
  191. Com_savepoint 0
  192. Com_select 9113463
  193. Com_set_option 264750
  194. Com_signal 0
  195. Com_show_binlog_events 0
  196. Com_show_binlogs 0
  197. Com_show_charsets 0
  198. Com_show_collations 0
  199. Com_show_create_db 0
  200. Com_show_create_event 0
  201. Com_show_create_func 0
  202. Com_show_create_proc 0
  203. Com_show_create_table 0
  204. Com_show_create_trigger 0
  205. Com_show_databases 0
  206. Com_show_engine_logs 0
  207. Com_show_engine_mutex 0
  208. Com_show_engine_status 0
  209. Com_show_events 0
  210. Com_show_errors 0
  211. Com_show_fields 0
  212. Com_show_function_code 0
  213. Com_show_function_status 0
  214. Com_show_grants 0
  215. Com_show_keys 0
  216. Com_show_master_status 0
  217. Com_show_open_tables 0
  218. Com_show_plugins 0
  219. Com_show_privileges 0
  220. Com_show_procedure_code 0
  221. Com_show_procedure_status 0
  222. Com_show_processlist 0
  223. Com_show_profile 0
  224. Com_show_profiles 0
  225. Com_show_relaylog_events 0
  226. Com_show_slave_hosts 0
  227. Com_show_slave_status 0
  228. Com_show_status 36
  229. Com_show_storage_engines 0
  230. Com_show_table_status 0
  231. Com_show_tables 0
  232. Com_show_triggers 0
  233. Com_show_variables 399
  234. Com_show_warnings 7
  235. Com_show_create_user 0
  236. Com_shutdown 0
  237. Com_slave_start 0
  238. Com_slave_stop 0
  239. Com_group_replication_start 0
  240. Com_group_replication_stop 0
  241. Com_stmt_execute 16296143
  242. Com_stmt_close 16275099
  243. Com_stmt_fetch 0
  244. Com_stmt_prepare 16275152
  245. Com_stmt_reset 0
  246. Com_stmt_send_long_data 0
  247. Com_truncate 0
  248. Com_uninstall_plugin 0
  249. Com_unlock_tables 0
  250. Com_update 494921
  251. Com_update_multi 103815
  252. Com_xa_commit 0
  253. Com_xa_end 0
  254. Com_xa_prepare 0
  255. Com_xa_recover 0
  256. Com_xa_rollback 0
  257. Com_xa_start 0
  258. Com_awslambda 0
  259. Com_alter_system 0
  260. Com_unit_test 0
  261. Com_show_volume_status 0
  262. Com_stmt_reprepare 0
  263. Compression OFF
  264. Connection_errors_accept 0
  265. Connection_errors_internal 0
  266. Connection_errors_max_connections 0
  267. Connection_errors_peer_address 0
  268. Connection_errors_select 0
  269. Connection_errors_tcpwrap 0
  270. Connections 2266422
  271. Created_tmp_disk_tables 982228
  272. Created_tmp_files 68950
  273. Created_tmp_tables 18657920
  274. Delayed_errors 0
  275. Delayed_insert_threads 0
  276. Delayed_writes 0
  277. External_threads_connected 14
  278. Flush_commands 1
  279. Handler_commit 15635900
  280. Handler_delete 89369
  281. Handler_discover 0
  282. Handler_external_lock 125236085
  283. Handler_mrr_init 0
  284. Handler_prepare 0
  285. Handler_read_first 3405352
  286. Handler_read_key 13594515353
  287. Handler_read_last 21973
  288. Handler_read_next 42095761252
  289. Handler_read_prev 3056
  290. Handler_read_rnd 248150228
  291. Handler_read_rnd_next 12645062756
  292. Handler_rollback 5533615
  293. Handler_savepoint 0
  294. Handler_savepoint_rollback 0
  295. Handler_update 52540426
  296. Handler_write 14605399096
  297. Innodb_buffer_pool_dump_status Dumping of buffer pool not started
  298. Innodb_buffer_pool_load_status Loading of buffer pool not started
  299. Innodb_buffer_pool_resize_status
  300. Innodb_buffer_pool_pages_data 2116512
  301. Innodb_buffer_pool_bytes_data 34676932608
  302. Innodb_buffer_pool_pages_dirty 354764
  303. Innodb_buffer_pool_bytes_dirty 5812453376
  304. Innodb_buffer_pool_pages_flushed 27846
  305. Innodb_buffer_pool_pages_free 3755104
  306. Innodb_buffer_pool_pages_misc 0
  307. Innodb_buffer_pool_pages_total 5871616
  308. Innodb_buffer_pool_read_ahead_rnd 0
  309. Innodb_buffer_pool_read_ahead 0
  310. Innodb_buffer_pool_read_ahead_evicted 0
  311. Innodb_logical_read_ahead_page_count 25096317
  312. Innodb_buffer_pool_read_requests 151995141357
  313. Innodb_buffer_pool_reads 1591154
  314. Innodb_buffer_pool_wait_free 0
  315. Innodb_buffer_pool_write_requests 78191498
  316. Innodb_data_fsyncs 0
  317. Innodb_data_pending_fsyncs 0
  318. Innodb_data_pending_reads 0
  319. Innodb_data_pending_writes 0
  320. Innodb_data_read 27567800320
  321. Innodb_data_reads 0
  322. Innodb_data_writes 0
  323. Innodb_data_written 0
  324. Innodb_dblwr_pages_written 0
  325. Innodb_dblwr_writes 0
  326. Innodb_log_waits 0
  327. Innodb_log_write_requests 0
  328. Innodb_log_writes 0
  329. Innodb_os_log_fsyncs 0
  330. Innodb_os_log_pending_fsyncs 0
  331. Innodb_os_log_pending_writes 0
  332. Innodb_os_log_written 0
  333. Innodb_page_size 16384
  334. Innodb_pages_created 371052
  335. Innodb_pages_read 1682681
  336. Innodb_pages_written 27846
  337. Innodb_row_lock_current_waits 0
  338. Innodb_row_lock_time 400442
  339. Innodb_row_lock_time_avg 480
  340. Innodb_row_lock_time_max 44051
  341. Innodb_row_lock_waits 834
  342. Innodb_rows_deleted 89368
  343. Innodb_rows_inserted 58989249
  344. Innodb_rows_read 50559229604
  345. Innodb_rows_updated 3202217
  346. Innodb_num_open_files 310
  347. Innodb_truncated_status_writes 0
  348. Innodb_available_undo_logs 128
  349. Key_blocks_not_flushed 0
  350. Key_blocks_unused 13396
  351. Key_blocks_used 0
  352. Key_read_requests 0
  353. Key_reads 0
  354. Key_write_requests 0
  355. Key_writes 0
  356. Last_query_cost 0.000000
  357. Last_query_partial_plans 0
  358. Locked_connects 0
  359. Max_execution_time_exceeded 0
  360. Max_execution_time_set 0
  361. Max_execution_time_set_failed 0
  362. Max_used_connections 110
  363. Max_used_connections_time 2021-05-05 20:20:46
  364. Not_flushed_delayed_rows 0
  365. Ongoing_anonymous_transaction_count 0
  366. Open_files 2
  367. Open_streams 0
  368. Open_table_definitions 485
  369. Open_tables 5984
  370. Opened_files 69261
  371. Opened_table_definitions 498
  372. Opened_tables 2084463
  373. Performance_schema_accounts_lost 0
  374. Performance_schema_cond_classes_lost 0
  375. Performance_schema_cond_instances_lost 0
  376. Performance_schema_digest_lost 0
  377. Performance_schema_file_classes_lost 0
  378. Performance_schema_file_handles_lost 0
  379. Performance_schema_file_instances_lost 0
  380. Performance_schema_hosts_lost 0
  381. Performance_schema_index_stat_lost 0
  382. Performance_schema_locker_lost 0
  383. Performance_schema_memory_classes_lost 0
  384. Performance_schema_metadata_lock_lost 0
  385. Performance_schema_mutex_classes_lost 0
  386. Performance_schema_mutex_instances_lost 0
  387. Performance_schema_nested_statement_lost 0
  388. Performance_schema_prepared_statements_lost 0
  389. Performance_schema_program_lost 0
  390. Performance_schema_rwlock_classes_lost 0
  391. Performance_schema_rwlock_instances_lost 0
  392. Performance_schema_session_connect_attrs_lost 0
  393. Performance_schema_socket_classes_lost 0
  394. Performance_schema_socket_instances_lost 0
  395. Performance_schema_stage_classes_lost 0
  396. Performance_schema_statement_classes_lost 0
  397. Performance_schema_table_handles_lost 0
  398. Performance_schema_table_instances_lost 0
  399. Performance_schema_table_lock_stat_lost 0
  400. Performance_schema_thread_classes_lost 0
  401. Performance_schema_thread_instances_lost 0
  402. Performance_schema_users_lost 0
  403. Prepared_stmt_count 5
  404. Qcache_free_blocks 4685
  405. Qcache_free_memory 8279176
  406. Qcache_hits 6303912
  407. Qcache_inserts 6590660
  408. Qcache_lowmem_prunes 585971
  409. Qcache_not_cached 2468119
  410. Qcache_queries_in_cache 484674
  411. Qcache_total_blocks 4471002
  412. Queries 55306887
  413. Questions 19923532
  414. Select_full_join 1285085
  415. Select_full_range_join 54763
  416. Select_range 402379
  417. Select_range_check 1652
  418. Select_scan 2347931
  419. Slave_heartbeat_period 0.000
  420. Slave_last_heartbeat
  421. Slave_open_temp_tables 0
  422. Slave_received_heartbeats 0
  423. Slave_retried_transactions 0
  424. Slave_running OFF
  425. Slow_launch_threads 0
  426. Slow_queries 266
  427. Sort_merge_passes 152110
  428. Sort_range 298972
  429. Sort_rows 614100951
  430. Sort_scan 393196
  431. Ssl_accept_renegotiates 0
  432. Ssl_accepts 0
  433. Ssl_callback_cache_hits 0
  434. Ssl_cipher
  435. Ssl_cipher_list
  436. Ssl_client_connects 0
  437. Ssl_connect_renegotiates 0
  438. Ssl_ctx_verify_depth 18446744073709551615
  439. Ssl_ctx_verify_mode 5
  440. Ssl_default_timeout 0
  441. Ssl_finished_accepts 0
  442. Ssl_finished_connects 0
  443. Ssl_server_not_after Aug 22 17:08:50 2024 GMT
  444. Ssl_server_not_before May 5 09:13:23 2021 GMT
  445. Ssl_session_cache_hits 0
  446. Ssl_session_cache_misses 0
  447. Ssl_session_cache_mode SERVER
  448. Ssl_session_cache_overflows 0
  449. Ssl_session_cache_size 128
  450. Ssl_session_cache_timeouts 0
  451. Ssl_sessions_reused 0
  452. Ssl_used_session_cache_entries 0
  453. Ssl_verify_depth 0
  454. Ssl_verify_mode 0
  455. Ssl_version
  456. Table_locks_immediate 90
  457. Table_locks_waited 0
  458. Table_open_cache_hits 228057772
  459. Table_open_cache_misses 2084463
  460. Table_open_cache_overflows 2078458
  461. Tc_log_max_pages_used 0
  462. Tc_log_page_size 0
  463. Tc_log_page_waits 0
  464. Threads_cached 0
  465. Threads_connected 18
  466. Threads_created 28
  467. Threads_running 6
  468. Time_since_zero_connections 0
  469. Uptime 119320
  470. Uptime_since_flush_status 119320
  471. server_audit_active OFF
  472. server_audit_last_error
  473. server_audit_writes_failed 0
  474. server_aurora_das_messages_missed 0
  475. server_aurora_das_messages_queued 0
  476. server_aurora_das_num_fatal_errors 0
  477. server_aurora_das_running OFF
  478.  
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement