API tools faq
paste
Advertisement
GrottoFalls

Untitled

GrottoFalls
Dec 20th, 2019
1,441
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 32.35 KB | None | 0 0
raw download clone embed print report
  1. SHOW GLOBAL STATUS
  2.  
  3. Aborted_clients 208
  4. Aborted_connects 4690
  5. AuroraDb_commits 314761
  6. AuroraDb_commit_latency 1746505758
  7. AuroraDb_ddl_stmt_duration 0
  8. AuroraDb_select_stmt_duration 86487701987
  9. AuroraDb_insert_stmt_duration 84914866
  10. AuroraDb_update_stmt_duration 207752170
  11. AuroraDb_delete_stmt_duration 457501092
  12. AuroraDb_lockmgr_bitmaps0_in_use 430
  13. AuroraDb_lockmgr_bitmaps1_in_use 0
  14. AuroraDb_lockmgr_bitmaps_mem_used 20640
  15. AuroraDb_thread_deadlocks 0
  16. Aurora_available_alter_table_log_entries 0
  17. Aurora_dict_sys_mem_size 911335
  18. Aurora_fast_insert_cache_hits 0
  19. Aurora_fast_insert_cache_misses 0
  20. Aurora_lockmgr_memory_used 72821472
  21. Aurora_missing_history_on_replica_incidents 0
  22. Aurora_repl_bytes_received 0
  23. Aurora_reserved_mem_exceeded_incidents 0
  24. Aurora_total_op_memory 0
  25. Aurora_total_op_memory_limit 207353446
  26. Aurora_total_op_temp_space 0
  27. Aurora_total_op_temp_space_limit 23271909785
  28. Aurora_used_alter_table_log_entries 0
  29. Binlog_cache_disk_use 0
  30. Binlog_cache_use 0
  31. Binlog_stmt_cache_disk_use 0
  32. Binlog_stmt_cache_use 0
  33. Bytes_received 739255810
  34. Bytes_sent 3524164251
  35. Com_admin_commands 19
  36. Com_assign_to_keycache 0
  37. Com_alter_db 0
  38. Com_alter_db_upgrade 0
  39. Com_alter_event 0
  40. Com_alter_function 0
  41. Com_alter_procedure 0
  42. Com_alter_server 0
  43. Com_alter_table 0
  44. Com_alter_tablespace 0
  45. Com_alter_user 0
  46. Com_analyze 0
  47. Com_begin 0
  48. Com_binlog 0
  49. Com_call_procedure 0
  50. Com_change_db 61
  51. Com_change_master 0
  52. Com_check 0
  53. Com_checksum 0
  54. Com_commit 42987
  55. Com_create_db 0
  56. Com_create_event 0
  57. Com_create_function 0
  58. Com_create_index 0
  59. Com_create_procedure 0
  60. Com_create_server 0
  61. Com_create_table 0
  62. Com_create_trigger 0
  63. Com_create_udf 0
  64. Com_create_user 0
  65. Com_create_view 0
  66. Com_dealloc_sql 0
  67. Com_delete 151
  68. Com_delete_multi 0
  69. Com_do 0
  70. Com_drop_db 0
  71. Com_drop_event 0
  72. Com_drop_function 0
  73. Com_drop_index 0
  74. Com_drop_procedure 0
  75. Com_drop_server 0
  76. Com_drop_table 0
  77. Com_drop_trigger 0
  78. Com_drop_user 0
  79. Com_drop_view 0
  80. Com_empty_query 0
  81. Com_execute_sql 0
  82. Com_flush 819
  83. Com_get_diagnostics 0
  84. Com_grant 0
  85. Com_ha_close 0
  86. Com_ha_open 0
  87. Com_ha_read 0
  88. Com_help 0
  89. Com_insert 178074
  90. Com_insert_select 0
  91. Com_install_plugin 0
  92. Com_kill 144
  93. Com_load 0
  94. Com_lock_tables 0
  95. Com_optimize 0
  96. Com_preload_keys 0
  97. Com_prepare_sql 0
  98. Com_purge 0
  99. Com_purge_before_date 286
  100. Com_release_savepoint 0
  101. Com_rename_table 0
  102. Com_rename_user 0
  103.  
  104. Com_repair 0
  105. Com_replace 2
  106. Com_replace_select 0
  107. Com_reset 0
  108. Com_resignal 0
  109. Com_revoke 0
  110. Com_revoke_all 0
  111. Com_rollback 0
  112. Com_rollback_to_savepoint 0
  113. Com_savepoint 0
  114. Com_select 690454
  115. Com_set_option 325510
  116. Com_signal 0
  117. Com_show_binlog_events 0
  118. Com_show_binlogs 4
  119. Com_show_charsets 13
  120. Com_show_collations 3
  121. Com_show_create_db 0
  122. Com_show_create_event 0
  123. Com_show_create_func 0
  124. Com_show_create_proc 0
  125. Com_show_create_table 8
  126. Com_show_create_trigger 1
  127. Com_show_databases 3
  128. Com_show_engine_logs 0
  129. Com_show_engine_mutex 0
  130. Com_show_engine_status 0
  131. Com_show_events 0
  132. Com_show_errors 0
  133. Com_show_fields 927
  134. Com_show_function_code 0
  135. Com_show_function_status 1
  136. Com_show_grants 4
  137. Com_show_keys 783
  138. Com_show_master_status 7
  139. Com_show_open_tables 0
  140. Com_show_plugins 17
  141. Com_show_privileges 0
  142. Com_show_procedure_code 0
  143. Com_show_procedure_status 1
  144. Com_show_processlist 129
  145. Com_show_profile 0
  146. Com_show_profiles 0
  147. Com_show_relaylog_events 0
  148. Com_show_slave_hosts 0
  149. Com_show_slave_status 12
  150. Com_show_status 1050
  151. Com_show_storage_engines 3
  152. Com_show_table_status 0
  153. Com_show_tables 66
  154. Com_show_triggers 0
  155. Com_show_variables 418
  156. Com_show_warnings 11
  157. Com_slave_start 0
  158. Com_slave_stop 0
  159. Com_stmt_close 5647596
  160. Com_stmt_execute 5647748
  161. Com_stmt_fetch 0
  162. Com_stmt_prepare 5647916
  163. Com_stmt_reprepare 0
  164. Com_stmt_reset 0
  165. Com_stmt_send_long_data 0
  166. Com_truncate 66
  167. Com_uninstall_plugin 0
  168. Com_unlock_tables 0
  169. Com_update 137140
  170. Com_update_multi 0
  171. Com_xa_commit 0
  172. Com_xa_end 0
  173. Com_xa_prepare 0
  174. Com_xa_recover 0
  175. Com_xa_rollback 0
  176. Com_xa_start 0
  177. Com_awslambda 0
  178. Com_alter_system 0
  179. Com_unit_test 1406
  180. Com_show_volume_status 0
  181. Compression OFF
  182. Connection_errors_accept 0
  183. Connection_errors_internal 0
  184. Connection_errors_max_connections 4694
  185. Connection_errors_peer_address 0
  186. Connection_errors_select 0
  187. Connection_errors_tcpwrap 0
  188. Connections 467780
  189. Created_tmp_disk_tables 1840
  190. Created_tmp_files 667
  191. Created_tmp_tables 138455
  192. Delayed_errors 0
  193. Delayed_insert_threads 0
  194. Delayed_writes 0
  195. External_threads_connected 2
  196. Flush_commands 1
  197. Handler_commit 5704396
  198. Handler_delete 8482060
  199. Handler_discover 0
  200. Handler_external_lock 1474490
  201. Handler_mrr_init 0
  202. Handler_prepare 0
  203. Handler_read_first 164858
  204.  
  205. Handler_read_key 853220
  206. Handler_read_last 1771
  207. Handler_read_next 23860103
  208. Handler_read_prev 2266974749
  209. Handler_read_rnd 310269
  210. Handler_read_rnd_next 1059381168
  211. Handler_rollback 55643
  212. Handler_savepoint 0
  213. Handler_savepoint_rollback 0
  214. Handler_update 247534
  215. Handler_write 1199236
  216. Innodb_buffer_pool_dump_status not started
  217. Innodb_buffer_pool_load_status not started
  218. Innodb_buffer_pool_pages_data 96114
  219. Innodb_buffer_pool_bytes_data 1574731776
  220. Innodb_buffer_pool_pages_dirty 0
  221. Innodb_buffer_pool_bytes_dirty 0
  222. Innodb_buffer_pool_pages_flushed 0
  223. Innodb_buffer_pool_pages_free 2048
  224. Innodb_buffer_pool_pages_misc 0
  225. Innodb_buffer_pool_pages_total 98162
  226. Innodb_buffer_pool_read_ahead_rnd 0
  227. Innodb_buffer_pool_read_ahead 0
  228. Innodb_buffer_pool_read_ahead_evicted 0
  229. Innodb_logical_read_ahead_page_count 9024466
  230. Innodb_buffer_pool_read_requests 14028374003
  231. Innodb_buffer_pool_reads 89103
  232. Innodb_buffer_pool_wait_free 0
  233. Innodb_buffer_pool_write_requests 62917255
  234. Innodb_data_fsyncs 0
  235. Innodb_data_pending_fsyncs 0
  236. Innodb_data_pending_reads 0
  237. Innodb_data_pending_writes 0
  238. Innodb_data_read 2269806592
  239. Innodb_data_reads 0
  240. Innodb_data_writes 0
  241. Innodb_data_written 0
  242. Innodb_dblwr_pages_written 0
  243. Innodb_dblwr_writes 0
  244. Innodb_have_atomic_builtins ON
  245. Innodb_log_waits 0
  246. Innodb_log_write_requests 0
  247. Innodb_log_writes 1
  248. Innodb_os_log_fsyncs 0
  249. Innodb_os_log_pending_fsyncs 0
  250. Innodb_os_log_pending_writes 0
  251. Innodb_os_log_written 512
  252. Innodb_page_size 16384
  253. Innodb_pages_created 25869
  254. Innodb_pages_read 138538
  255. Innodb_pages_written 0
  256. Innodb_row_lock_current_waits 0
  257. Innodb_row_lock_time 31542
  258. Innodb_row_lock_time_avg 6
  259. Innodb_row_lock_time_max 4942
  260. Innodb_row_lock_waits 5005
  261. Innodb_rows_deleted 8482192
  262. Innodb_rows_inserted 135996
  263. Innodb_rows_read 3349463403
  264. Innodb_rows_updated 348842
  265. Innodb_num_open_files 130
  266. Innodb_truncated_status_writes 0
  267. Innodb_available_undo_logs 128
  268. Key_blocks_not_flushed 0
  269. Key_blocks_unused 13375
  270. Key_blocks_used 21
  271. Key_read_requests 42
  272. Key_reads 21
  273. Key_write_requests 0
  274. Key_writes 0
  275. Last_query_cost 0.000000
  276. Last_query_partial_plans 0
  277. Max_used_connections 96
  278. Not_flushed_delayed_rows 0
  279. Open_files 2
  280. Open_streams 0
  281. Open_table_definitions 206
  282. Open_tables 714
  283. Opened_files 8270
  284. Opened_table_definitions 272
  285. Opened_tables 3636
  286. Performance_schema_accounts_lost 0
  287. Performance_schema_cond_classes_lost 0
  288. Performance_schema_cond_instances_lost 0
  289. Performance_schema_digest_lost 0
  290. Performance_schema_file_classes_lost 0
  291. Performance_schema_file_handles_lost 0
  292. Performance_schema_file_instances_lost 0
  293. Performance_schema_hosts_lost 0
  294. Performance_schema_locker_lost 0
  295. Performance_schema_mutex_classes_lost 0
  296. Performance_schema_mutex_instances_lost 0
  297. Performance_schema_rwlock_classes_lost 0
  298. Performance_schema_rwlock_instances_lost 0
  299. Performance_schema_session_connect_attrs_lost 0
  300. Performance_schema_socket_classes_lost 0
  301. Performance_schema_socket_instances_lost 0
  302. Performance_schema_stage_classes_lost 0
  303. Performance_schema_statement_classes_lost 0
  304. Performance_schema_table_handles_lost 0
  305.  
  306. Performance_schema_table_instances_lost 0
  307. Performance_schema_thread_classes_lost 0
  308. Performance_schema_thread_instances_lost 0
  309. Performance_schema_users_lost 0
  310. Prepared_stmt_count 0
  311. Qcache_free_blocks 15
  312. Qcache_free_memory 34906552
  313. Qcache_hits 4985913
  314. Qcache_inserts 80405
  315. Qcache_lowmem_prunes 0
  316. Qcache_not_cached 293646
  317. Qcache_queries_in_cache 24877
  318. Qcache_total_blocks 80461
  319. Queries 18124882
  320. Questions 6829350
  321. Rsa_public_key
  322. Select_full_join 1680
  323. Select_full_range_join 0
  324. Select_range 6222
  325. Select_range_check 0
  326. Select_scan 93157
  327. Slave_heartbeat_period 0.000
  328. Slave_last_heartbeat
  329. Slave_open_temp_tables 0
  330. Slave_received_heartbeats 0
  331. Slave_retried_transactions 0
  332. Slave_running OFF
  333. Slow_launch_threads 0
  334. Slow_queries 1369
  335. Sort_merge_passes 331
  336. Sort_range 7043
  337. Sort_rows 550197
  338. Sort_scan 8995
  339. Ssl_accept_renegotiates 0
  340. Ssl_accepts 19
  341. Ssl_callback_cache_hits 0
  342. Ssl_cipher
  343. Ssl_cipher_list
  344. Ssl_client_connects 0
  345. Ssl_connect_renegotiates 0
  346. Ssl_ctx_verify_mode 5
  347. Ssl_default_timeout 0
  348. Ssl_finished_accepts 19
  349. Ssl_finished_connects 0
  350. Ssl_server_not_after
  351. Ssl_server_not_before
  352. Ssl_session_cache_hits 0
  353. Ssl_session_cache_misses 10
  354. Ssl_session_cache_mode SERVER
  355. Ssl_session_cache_overflows 0
  356. Ssl_session_cache_size 128
  357. Ssl_session_cache_timeouts 0
  358. Ssl_sessions_reused 0
  359. Ssl_used_session_cache_entries 0
  360. Ssl_verify_depth 0
  361. Ssl_verify_mode 0
  362. Ssl_version
  363. Table_locks_immediate 736767
  364. Table_locks_waited 0
  365. Table_open_cache_hits 7120114
  366. Table_open_cache_misses 874
  367. Table_open_cache_overflows 0
  368. Tc_log_max_pages_used 0
  369. Tc_log_page_size 0
  370. Tc_log_page_waits 0
  371. Threads_cached 0
  372. Threads_connected 6
  373. Threads_created 103
  374. Threads_running 1
  375. Time_since_zero_connections 0
  376. Uptime 85976
  377. Uptime_since_flush_status 85976
  378. aurora_scheduler_health_check ON
  379. server_audit_active OFF
  380. server_audit_last_error
  381. server_audit_writes_failed 0
  382.  
  383. SHOW GLOBAL VARIABLES
  384.  
  385. aurora_binlog_use_large_read_buffer OFF
  386. aurora_enable_repl_bin_log_filtering ON
  387. aurora_enable_replica_log_compression ON
  388. aurora_enable_staggered_replica_restart OFF
  389. aurora_enable_zdr OFF
  390. aurora_lab_mode OFF
  391. aurora_load_from_s3_role
  392. aurora_max_alter_table_log_entries 1000
  393. aurora_max_connections_limit 16000
  394. aurora_select_into_s3_role
  395. aurora_use_key_prefetch ON
  396. aurora_version 1.17.8
  397. aurora_zdr_timeout_on_replica_fall_behind ON
  398. auto_increment_increment 1
  399. auto_increment_offset 1
  400. autocommit ON
  401. automatic_sp_privileges ON
  402. aws_default_lambda_role
  403. aws_default_s3_role
  404. awsauthenticationplugin_max_backoff_delay 2000
  405. awsauthenticationplugin_max_retry_count 3
  406. awsauthenticationplugin_retry_delay 250
  407. back_log 68
  408. basedir /rdsdbbin/oscar/
  409. big_tables OFF
  410. bind_address *
  411. binlog_cache_size 32768
  412. binlog_checksum CRC32
  413. binlog_direct_non_transactional_updates OFF
  414. binlog_format STATEMENT
  415. binlog_max_flush_queue_time 0
  416. binlog_order_commits ON
  417. binlog_row_image FULL
  418. binlog_rows_query_log_events OFF
  419. binlog_stmt_cache_size 32768
  420. bulk_insert_buffer_size 8388608
  421. character_set_client latin1
  422. character_set_connection latin1
  423. character_set_database latin1
  424. character_set_filesystem binary
  425. character_set_results latin1
  426. character_set_server latin1
  427. character_set_system utf8
  428. character_sets_dir /rdsdbbin/oscar-5.6.10a.200340.0/share/charsets/
  429. collation_connection latin1_swedish_ci
  430. collation_database latin1_swedish_ci
  431. collation_server latin1_swedish_ci
  432. completion_type NO_CHAIN
  433. concurrent_insert AUTO
  434. connect_timeout 10
  435. core_file ON
  436. datadir /rdsdbdata/db/
  437. date_format %Y-%m-%d
  438. datetime_format %Y-%m-%d %H:%i:%s
  439. default_storage_engine InnoDB
  440. default_tmp_storage_engine InnoDB
  441. default_week_format 0
  442. delay_key_write ON
  443. delayed_insert_limit 100
  444. delayed_insert_timeout 300
  445. delayed_queue_size 1000
  446. disconnect_on_expired_password ON
  447. div_precision_increment 4
  448. end_markers_in_json OFF
  449. enforce_gtid_consistency OFF
  450. eq_range_index_dive_limit 10
  451. event_scheduler OFF
  452. expire_logs_days 0
  453. explicit_defaults_for_timestamp ON
  454. flush OFF
  455. flush_time 0
  456. foreign_key_checks ON
  457. ft_boolean_syntax + -><()~*:""&|
  458. ft_max_word_len 84
  459. ft_min_word_len 4
  460. ft_query_expansion_limit 20
  461. ft_stopword_file (built-in)
  462. general_log ON
  463. general_log_file /rdsdbdata/log/general/mysql-general.log
  464. group_concat_max_len 1024
  465. gtid_executed
  466. gtid_mode OFF
  467. gtid_owned
  468. gtid_purged
  469. have_compress YES
  470. have_crypt YES
  471. have_dynamic_loading YES
  472. have_geometry YES
  473. have_openssl YES
  474. have_profiling YES
  475. have_query_cache YES
  476. have_rtree_keys YES
  477. have_ssl YES
  478. have_symlink YES
  479. host_cache_size 128
  480. hostname ip-10-3-2-231
  481. ignore_builtin_innodb OFF
  482. ignore_db_dirs
  483. ignore_default_storage_engine_errors OFF
  484.  
  485. init_connect
  486. init_file
  487. init_slave
  488. innodb_adaptive_flushing ON
  489. innodb_adaptive_flushing_lwm 10
  490. innodb_adaptive_hash_index OFF
  491. innodb_adaptive_max_sleep_delay 150000
  492. innodb_additional_mem_pool_size 8388608
  493. innodb_api_bk_commit_interval 5
  494. innodb_api_disable_rowlock OFF
  495. innodb_api_enable_binlog OFF
  496. innodb_api_enable_mdl OFF
  497. innodb_api_trx_level 0
  498. innodb_aurora_enable_auto_akp OFF
  499. innodb_autoextend_increment 64
  500. innodb_autoinc_lock_mode 1
  501. innodb_buffer_pool_dump_at_shutdown OFF
  502. innodb_buffer_pool_dump_now OFF
  503. innodb_buffer_pool_dump_pct 100
  504. innodb_buffer_pool_filename ib_buffer_pool
  505. innodb_buffer_pool_instances 8
  506. innodb_buffer_pool_load_abort OFF
  507. innodb_buffer_pool_load_at_startup OFF
  508. innodb_buffer_pool_load_now OFF
  509. innodb_buffer_pool_size 1610612736
  510. innodb_change_buffer_max_size 25
  511. innodb_change_buffering none
  512. innodb_checksum_algorithm none
  513. innodb_checksums OFF
  514. innodb_cmp_per_index_enabled OFF
  515. innodb_commit_concurrency 0
  516. innodb_compression_failure_threshold_pct 5
  517. innodb_compression_level 6
  518. innodb_compression_pad_pct_max 50
  519. innodb_concurrency_tickets 5000
  520. innodb_data_file_path ibdata1:12M:autoextend
  521. innodb_data_home_dir
  522. innodb_disable_sort_file_cache OFF
  523. innodb_doublewrite OFF
  524. innodb_fast_shutdown 1
  525. innodb_file_format Antelope
  526. innodb_file_format_check ON
  527. innodb_file_format_max Antelope
  528. innodb_file_per_table ON
  529. innodb_flush_log_at_timeout 1
  530. innodb_flush_log_at_trx_commit 1
  531. innodb_flush_method O_DIRECT
  532. innodb_flush_neighbors 1
  533. innodb_flushing_avg_loops 30
  534. innodb_force_load_corrupted OFF
  535. innodb_force_recovery 0
  536. innodb_ft_aux_table
  537. innodb_ft_cache_size 8000000
  538. innodb_ft_enable_diag_print OFF
  539. innodb_ft_enable_stopword ON
  540. innodb_ft_max_token_size 84
  541. innodb_ft_min_token_size 3
  542. innodb_ft_num_word_optimize 2000
  543. innodb_ft_result_cache_limit 2000000000
  544. innodb_ft_server_stopword_table
  545. innodb_ft_sort_pll_degree 2
  546. innodb_ft_total_cache_size 640000000
  547. innodb_ft_user_stopword_table
  548. innodb_io_capacity 200
  549. innodb_io_capacity_max 2000
  550. innodb_large_prefix OFF
  551. innodb_lock_wait_timeout 50
  552. innodb_locks_unsafe_for_binlog OFF
  553. innodb_log_buffer_size 8388608
  554. innodb_log_file_size 50331648
  555. innodb_log_files_in_group 2
  556. innodb_log_group_home_dir ./
  557. innodb_lru_scan_depth 1024
  558. innodb_max_dirty_pages_pct 75
  559. innodb_max_dirty_pages_pct_lwm 0
  560. innodb_max_purge_lag 0
  561. innodb_max_purge_lag_delay 0
  562. innodb_mirrored_log_groups 1
  563. innodb_monitor_disable
  564. innodb_monitor_enable
  565. innodb_monitor_reset
  566. innodb_monitor_reset_all
  567. innodb_old_blocks_pct 37
  568. innodb_old_blocks_time 1000
  569. innodb_online_alter_log_max_size 134217728
  570. innodb_open_files 1821
  571. innodb_optimize_fulltext_only OFF
  572. innodb_page_size 16384
  573. innodb_print_all_deadlocks OFF
  574. innodb_purge_batch_size 300
  575. innodb_purge_threads 1
  576. innodb_random_read_ahead OFF
  577. innodb_read_ahead_threshold 56
  578. innodb_read_io_threads 4
  579. innodb_read_only OFF
  580. innodb_replication_delay 0
  581. innodb_rollback_on_timeout OFF
  582. innodb_rollback_segments 128
  583. innodb_shared_buffer_pool_uses_huge_pages ON
  584. innodb_sort_buffer_size 1048576
  585.  
  586. innodb_spin_wait_delay 6
  587. innodb_stats_auto_recalc ON
  588. innodb_stats_method nulls_equal
  589. innodb_stats_on_metadata OFF
  590. innodb_stats_persistent ON
  591. innodb_stats_persistent_sample_pages 20
  592. innodb_stats_sample_pages 8
  593. innodb_stats_transient_sample_pages 8
  594. innodb_strict_mode OFF
  595. innodb_support_xa ON
  596. innodb_sync_array_size 1
  597. innodb_sync_spin_loops 30
  598. innodb_table_locks ON
  599. innodb_thread_concurrency 0
  600. innodb_thread_sleep_delay 10000
  601. innodb_undo_directory .
  602. innodb_undo_logs 128
  603. innodb_undo_tablespaces 0
  604. innodb_use_native_aio OFF
  605. innodb_use_sys_malloc ON
  606. innodb_version 1.2.10
  607. innodb_write_io_threads 4
  608. interactive_timeout 28800
  609. join_buffer_size 262144
  610. keep_files_on_create OFF
  611. key_buffer_size 16777216
  612. key_cache_age_threshold 300
  613. key_cache_block_size 1024
  614. key_cache_division_limit 100
  615. large_files_support ON
  616. large_page_size 0
  617. large_pages OFF
  618. lc_messages en_US
  619. lc_messages_dir /rdsdbbin/oscar-5.6.10a.200340.0/share/
  620. lc_time_names en_US
  621. license GPL
  622. local_infile ON
  623. lock_wait_timeout 31536000
  624. locked_in_memory OFF
  625. log_bin OFF
  626. log_bin_basename
  627. log_bin_index
  628. log_bin_trust_function_creators OFF
  629. log_bin_use_v1_row_events OFF
  630. log_error /rdsdbdata/log/error/mysql-error.log
  631. log_output FILE
  632. log_queries_not_using_indexes OFF
  633. log_slave_updates ON
  634. log_throttle_queries_not_using_indexes 0
  635. log_warnings 1
  636. long_query_time 2.000000
  637. low_priority_updates OFF
  638. lower_case_file_system OFF
  639. lower_case_table_names 0
  640. master_info_repository TABLE
  641. master_verify_checksum OFF
  642. max_allowed_packet 4194304
  643. max_binlog_cache_size 18446744073709547520
  644. max_binlog_size 134217728
  645. max_binlog_stmt_cache_size 18446744073709547520
  646. max_connect_errors 100
  647. max_connections 90
  648. max_delayed_threads 20
  649. max_digest_length 1024
  650. max_error_count 64
  651. max_heap_table_size 16777216
  652. max_insert_delayed_threads 20
  653. max_join_size 18446744073709551615
  654. max_length_for_sort_data 1024
  655. max_prepared_stmt_count 16382
  656. max_relay_log_size 0
  657. max_seeks_for_key 18446744073709551615
  658. max_sort_length 1024
  659. max_sp_recursion_depth 0
  660. max_tmp_tables 32
  661. max_user_connections 0
  662. max_write_lock_count 18446744073709551615
  663. metadata_locks_cache_size 1024
  664. min_examined_row_limit 0
  665. multi_range_count 256
  666. myisam_data_pointer_size 6
  667. myisam_max_sort_file_size 9223372036853727232
  668. myisam_mmap_size 18446744073709551615
  669. myisam_recover_options OFF
  670. myisam_repair_threads 1
  671. myisam_sort_buffer_size 8388608
  672. myisam_stats_method nulls_unequal
  673. myisam_use_mmap OFF
  674. net_buffer_length 16384
  675. net_read_timeout 30
  676. net_retry_count 10
  677. net_write_timeout 60
  678. new OFF
  679. old OFF
  680. old_alter_table OFF
  681. old_passwords 0
  682. open_files_limit 65535
  683. optimizer_prune_level 1
  684. optimizer_search_depth 62
  685. optimizer_switch index_merge=on,index_merge_union=on,index_merge_so...
  686.  
  687. optimizer_trace enabled=off,one_line=off
  688. optimizer_trace_features greedy_search=on,range_optimizer=on,dynamic_range=...
  689. optimizer_trace_limit 1
  690. optimizer_trace_max_mem_size 16384
  691. optimizer_trace_offset -1
  692. performance_schema OFF
  693. performance_schema__auto__ ON
  694. performance_schema_accounts_size 10
  695. performance_schema_digests_size 1000
  696. performance_schema_events_stages_history_long_size 100
  697. performance_schema_events_stages_history_size 5
  698. performance_schema_events_statements_history_long_... 100
  699. performance_schema_events_statements_history_size 5
  700. performance_schema_events_waits_history_long_size 100
  701. performance_schema_events_waits_history_size 5
  702. performance_schema_hosts_size 20
  703. performance_schema_max_cond_classes 80
  704. performance_schema_max_cond_instances 6359
  705. performance_schema_max_digest_length 1024
  706. performance_schema_max_file_classes 50
  707. performance_schema_max_file_handles 32768
  708. performance_schema_max_file_instances 18433
  709. performance_schema_max_mutex_classes 200
  710. performance_schema_max_mutex_instances 86812
  711. performance_schema_max_rwlock_classes 40
  712. performance_schema_max_rwlock_instances 18549
  713. performance_schema_max_socket_classes 10
  714. performance_schema_max_socket_instances 128
  715. performance_schema_max_stage_classes 150
  716. performance_schema_max_statement_classes 177
  717. performance_schema_max_table_handles 2024
  718. performance_schema_max_table_instances 6070
  719. performance_schema_max_thread_classes 50
  720. performance_schema_max_thread_instances 173
  721. performance_schema_session_connect_attrs_size 512
  722. performance_schema_setup_actors_size 100
  723. performance_schema_setup_objects_size 100
  724. performance_schema_users_size 5
  725. pid_file /rdsdbdata/log/mysql-3306.pid
  726. plugin_dir /rdsdbbin/oscar-5.6.10a.200340.0/lib/plugin/
  727. port 3306
  728. preload_buffer_size 32768
  729. profiling OFF
  730. profiling_history_size 15
  731. protocol_version 10
  732. query_alloc_block_size 8192
  733. query_cache_limit 1048576
  734. query_cache_min_res_unit 4096
  735. query_cache_size 89479168
  736. query_cache_type ON
  737. query_cache_wlock_invalidate OFF
  738. query_prealloc_size 8192
  739. range_alloc_block_size 4096
  740. read_buffer_size 262144
  741. read_only OFF
  742. read_rnd_buffer_size 524288
  743. relay_log /rdsdbdata/log/relaylog/relaylog
  744. relay_log_basename /rdsdbdata/log/relaylog/relaylog
  745. relay_log_index /rdsdbdata/log/relaylog/relaylog.index
  746. relay_log_info_file relay-log.info
  747. relay_log_info_repository TABLE
  748. relay_log_purge ON
  749. relay_log_recovery ON
  750. relay_log_space_limit 1000000000
  751. report_host
  752. report_password
  753. report_port 3306
  754. report_user
  755. require_fk_checks_for_ddl OFF
  756. rpl_stop_slave_timeout 31536000
  757. secure_auth ON
  758. secure_file_priv /tmp/
  759. server_audit_cw_upload OFF
  760. server_audit_events
  761. server_audit_excl_users
  762. server_audit_incl_users
  763. server_audit_logging OFF
  764. server_audit_mode 0
  765. server_audit_query_log_limit 1024
  766. server_id 2121389343
  767. server_id_bits 32
  768. server_uuid 863d55ed-be16-3278-b915-346be218c061
  769. session_track_system_variables
  770. sha256_password_private_key_path private_key.pem
  771. sha256_password_public_key_path public_key.pem
  772. skip_external_locking ON
  773. skip_name_resolve ON
  774. skip_networking OFF
  775. skip_show_database OFF
  776. slave_allow_batching OFF
  777. slave_checkpoint_group 512
  778. slave_checkpoint_period 300
  779. slave_compressed_protocol OFF
  780. slave_exec_mode STRICT
  781. slave_load_tmpdir /rdsdbdata/tmp/
  782. slave_max_allowed_packet 1073741824
  783. slave_net_timeout 3600
  784. slave_parallel_workers 0
  785. slave_pending_jobs_size_max 16777216
  786. slave_rows_search_algorithms TABLE_SCAN,INDEX_SCAN
  787.  
  788. slave_skip_errors OFF
  789. slave_sql_verify_checksum ON
  790. slave_transaction_retries 10
  791. slave_type_conversions
  792. slow_launch_time 2
  793. slow_query_log ON
  794. slow_query_log_file /rdsdbdata/log/slowquery/mysql-slowquery.log
  795. socket /tmp/mysql.sock
  796. sort_buffer_size 262144
  797. sql_auto_is_null OFF
  798. sql_big_selects ON
  799. sql_buffer_result OFF
  800. sql_log_bin ON
  801. sql_log_off OFF
  802. sql_mode
  803. sql_notes ON
  804. sql_quote_show_create ON
  805. sql_safe_updates OFF
  806. sql_select_limit 18446744073709551615
  807. sql_slave_skip_counter 0
  808. sql_warnings OFF
  809. ssl_ca /rdsdbdata/rds-metadata/ca-cert.pem
  810. ssl_capath
  811. ssl_cert /rdsdbdata/rds-metadata/server-cert.pem
  812. ssl_cipher AES256-SHA:AES128-SHA:DES-CBC3-SHA:ADH-DES-CBC3-SH...
  813. ssl_crl
  814. ssl_crlpath
  815. ssl_key /rdsdbdata/rds-metadata/server-key.pem
  816. storage_engine InnoDB
  817. stored_program_cache 256
  818. sync_binlog 1
  819. sync_frm ON
  820. sync_master_info 10000
  821. sync_relay_log 10000
  822. sync_relay_log_info 10000
  823. system_time_zone UTC
  824. table_definition_cache 5463
  825. table_open_cache 1821
  826. table_open_cache_instances 4
  827. thread_cache_size 2
  828. thread_concurrency 10
  829. thread_handling multiple-connections-per-thread
  830. thread_stack 262144
  831. time_format %H:%i:%s
  832. time_zone America/Denver
  833. timed_mutexes OFF
  834. tmp_table_size 16777216
  835. tmpdir /rdsdbdata/tmp/
  836. transaction_alloc_block_size 8192
  837. transaction_prealloc_size 4096
  838. tx_isolation REPEATABLE-READ
  839. tx_read_only OFF
  840. unique_checks ON
  841. updatable_views_with_limit YES
  842. user_disable_external_log OFF
  843. version 5.6.10-log
  844. version_comment MySQL Community Server (GPL)
  845. version_compile_machine x86_64
  846. version_compile_os Linux
  847. wait_timeout 28800
  848.  
  849. SHOW FULL PROCESSLIST
  850.  
  851. 1 rdsadmin localhost
  852. NULL
  853. Sleep 1 delayed send ok done
  854. NULL
  855.  
  856. 2 rdsadmin localhost
  857. NULL
  858. Sleep 1 delayed send ok done
  859. NULL
  860.  
  861. 3 rdsadmin localhost
  862. NULL
  863. Sleep 6 delayed send ok done
  864. NULL
  865.  
  866. 1231 rdsadmin localhost
  867. NULL
  868. Sleep 12 delayed send ok done
  869. NULL
  870.  
  871. 468311 admin (*removed ip*) driverinterface Query 0 init SHOW FULL PROCESSLIST
  872. 468312 admin (*removed ip*)
  873. NULL
  874. Sleep 0 cleaned up
  875. NULL
  876.  
  877. SHOW ENGINE INNODB STATUS
  878.  
  879. InnoDB
  880. =====================================
  881. 2019-12-20 16:10:05 2ab6da333700 INNODB MONITOR OUTPUT
  882. =====================================
  883. Per second averages calculated from the last 7 seconds
  884. -----------------
  885. BACKGROUND THREAD
  886. -----------------
  887. srv_master_thread loops: 81333 srv_active, 0 srv_shutdown, 5227 srv_idle
  888. srv_master_thread log flush and writes: 0
  889. ----------
  890. SEMAPHORES
  891. ----------
  892. OS WAIT ARRAY INFO: reservation count 1462857
  893. OS WAIT ARRAY INFO: signal count 250932
  894. Mutex spin waits 177223666, rounds 126041313, OS waits 1131817
  895. RW-shared spins 349357, rounds 10499395, OS waits 302060
  896. RW-excl spins 1978, rounds 646794, OS waits 21064
  897. Spin rounds per wait: 0.71 mutex, 30.05 RW-shared, 326.99 RW-excl
  898. ------------
  899. TRANSACTIONS
  900. ------------
  901. Trx id counter 36517457
  902. Purge done for trx's n:o < 36516928 undo n:o < 0 state: running but idle
  903. History list length 442
  904. LIST OF TRANSACTIONS FOR EACH SESSION:
  905. ---TRANSACTION 0, not started
  906. MySQL thread id 471918, OS thread handle 0x2ab6da333700, query id 18171206 (*removed ip*) admin init
  907. show engine innodb status
  908. ---TRANSACTION 36517454, not started
  909. MySQL thread id 471919, OS thread handle 0x2ab6d5050700, query id 18171201 (*removed ip*) admin cleaned up
  910. ---TRANSACTION 36517448, not started
  911. MySQL thread id 471916, OS thread handle 0x2ab6d7c40700, query id 18171195 (*removed ip*) admin cleaned up
  912. ---TRANSACTION 36517406, not started
  913. MySQL thread id 471911, OS thread handle 0x2ab6d53de700, query id 18171146 (*removed ip*) admin cleaned up
  914. ---TRANSACTION 36517378, not started
  915. MySQL thread id 471908, OS thread handle 0x2ab6d6dc6700, query id 18171119 (*removed ip*) admin cleaned up
  916. ---TRANSACTION 36504090, not started
  917. MySQL thread id 1231, OS thread handle 0x2ab652bcb700, query id 18150792 localhost rdsadmin delayed send ok done
  918. ---TRANSACTION 36517210, not started
  919. MySQL thread id 3, OS thread handle 0x2ab652b8a700, query id 18170840 localhost rdsadmin cleaned up
  920. ---TRANSACTION 36515590, not started
  921. MySQL thread id 1, OS thread handle 0x2ab652b8a700, query id 18171102 localhost rdsadmin delayed send ok done
  922. ---TRANSACTION 36517416, not started
  923. MySQL thread id 2, OS thread handle 0x2ab652b49700, query id 18171163 localhost rdsadmin delayed send ok done
  924. --------
  925. FILE I/O
  926. --------
  927. I/O thread 0 state: waiting for i/o request (insert buffer thread)
  928. I/O thread 1 state: waiting for i/o request (log thread)
  929. I/O thread 2 state: waiting for i/o request (read thread)
  930. I/O thread 3 state: waiting for i/o request (read thread)
  931. I/O thread 4 state: waiting for i/o request (read thread)
  932. I/O thread 5 state: waiting for i/o request (read thread)
  933. I/O thread 6 state: waiting for i/o request (write thread)
  934. I/O thread 7 state: waiting for i/o request (write thread)
  935. I/O thread 8 state: waiting for i/o request (write thread)
  936. I/O thread 9 state: waiting for i/o request (write thread)
  937. Pending normal aio reads: 0 [0, 0, 0, 0] , aio writes: 0 [0, 0, 0, 0] ,
  938. ibuf aio reads: 0, log i/o's: 0, sync i/o's: 0
  939. Pending flushes (fsync) log: 0; buffer pool: 0
  940. 0 OS file reads, 0 OS file writes, 0 OS fsyncs
  941. 0.00 reads/s, 0 avg bytes/read, 0.00 writes/s, 0.00 fsyncs/s
  942. -------------------------------------
  943. INSERT BUFFER AND ADAPTIVE HASH INDEX
  944. -------------------------------------
  945. Ibuf: size 1, free list len 0, seg size 2, 0 merges
  946. merged operations:
  947. insert 0, delete mark 0, delete 0
  948. discarded operations:
  949. insert 0, delete mark 0, delete 0
  950. Adaptive hash table 0: Hash table size 99709, node heap has 0 buffer(s)
  951. Adaptive hash table 1: Hash table size 99709, node heap has 0 buffer(s)
  952. Adaptive hash table 2: Hash table size 99709, node heap has 0 buffer(s)
  953. Adaptive hash table 3: Hash table size 99709, node heap has 0 buffer(s)
  954. Adaptive hash table 4: Hash table size 99709, node heap has 0 buffer(s)
  955. Adaptive hash table 5: Hash table size 99709, node heap has 0 buffer(s)
  956. Adaptive hash table 6: Hash table size 99709, node heap has 0 buffer(s)
  957. Adaptive hash table 7: Hash table size 99709, node heap has 0 buffer(s)
  958. Adaptive hash table 8: Hash table size 99709, node heap has 0 buffer(s)
  959. Adaptive hash table 9: Hash table size 99709, node heap has 0 buffer(s)
  960. Adaptive hash table 10: Hash table size 99709, node heap has 0 buffer(s)
  961. Adaptive hash table 11: Hash table size 99709, node heap has 0 buffer(s)
  962. Adaptive hash table 12: Hash table size 99709, node heap has 0 buffer(s)
  963. Adaptive hash table 13: Hash table size 99709, node heap has 0 buffer(s)
  964. Adaptive hash table 14: Hash table size 99709, node heap has 0 buffer(s)
  965. Adaptive hash table 15: Hash table size 99709, node heap has 0 buffer(s)
  966. Adaptive hash table 16: Hash table size 99709, node heap has 0 buffer(s)
  967. Adaptive hash table 17: Hash table size 99709, node heap has 0 buffer(s)
  968. Adaptive hash table 18: Hash table size 99709, node heap has 0 buffer(s)
  969. Adaptive hash table 19: Hash table size 99709, node heap has 0 buffer(s)
  970. Adaptive hash table 20: Hash table size 99709, node heap has 0 buffer(s)
  971. Adaptive hash table 21: Hash table size 99709, node heap has 0 buffer(s)
  972. Adaptive hash table 22: Hash table size 99709, node heap has 0 buffer(s)
  973. Adaptive hash table 23: Hash table size 99709, node heap has 0 buffer(s)
  974. Adaptive hash table 24: Hash table size 99709, node heap has 0 buffer(s)
  975. Adaptive hash table 25: Hash table size 99709, node heap has 0 buffer(s)
  976. Adaptive hash table 26: Hash table size 99709, node heap has 0 buffer(s)
  977. Adaptive hash table 27: Hash table size 99709, node heap has 0 buffer(s)
  978. Adaptive hash table 28: Hash table size 99709, node heap has 0 buffer(s)
  979. Adaptive hash table 29: Hash table size 99709, node heap has 0 buffer(s)
  980. Adaptive hash table 30: Hash table size 99709, node heap has 0 buffer(s)
  981. Adaptive hash table 31: Hash table size 99709, node heap has 0 buffer(s)
  982. 0.00 hash searches/s, 553738.47 non-hash searches/s
  983. ---
  984. LOG
  985. ---
  986. Log sequence number 8204
  987. Log flushed up to   8204
  988. Pages flushed up to 8204
  989. Last checkpoint at  8192
  990. 0 pending log writes, 0 pending chkp writes
  991. 0 log i/o's done, 0.00 log i/o's/second
  992. ----------------------
  993. BUFFER POOL AND MEMORY
  994. ----------------------
  995. Total memory allocated 0; in additional pool allocated 0
  996. Dictionary memory allocated 911335
  997. Buffer pool size   98162
  998. Free buffers       2050
  999. Database pages     96112
  1000. Old database pages 35438
  1001. Modified db pages  0
  1002. Pending reads 0
  1003. Pending writes: LRU 0, flush list 0 single page 0
  1004. Pages made young 190382, not young 10813320
  1005. 0.00 youngs/s, 0.00 non-youngs/s
  1006. Pages read 138550, created 25889, written 0
  1007. 0.00 reads/s, 0.00 creates/s, 0.00 writes/s
  1008. Buffer pool hit rate 1000 / 1000, young-making rate 0 / 1000 not 0 / 1000
  1009. Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
  1010. LRU len: 96112, unzip_LRU len: 0
  1011. I/O sum[0]:cur[0], unzip sum[0]:cur[0]
  1012. ----------------------
  1013. INDIVIDUAL BUFFER POOL INFO
  1014. ----------------------
  1015. ---BUFFER POOL 0
  1016. Buffer pool size   49081
  1017. Free buffers       1024
  1018. Database pages     48057
  1019. Old database pages 17719
  1020. Modified db pages  0
  1021. Pending reads 0
  1022. Pending writes: LRU 0, flush list 0 single page 0
  1023. Pages made young 93687, not young 5607817
  1024. 0.00 youngs/s, 0.00 non-youngs/s
  1025. Pages read 70677, created 12411, written 0
  1026. 0.00 reads/s, 0.00 creates/s, 0.00 writes/s
  1027. Buffer pool hit rate 1000 / 1000, young-making rate 0 / 1000 not 0 / 1000
  1028. Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
  1029. LRU len: 48057, unzip_LRU len: 0
  1030. I/O sum[0]:cur[0], unzip sum[0]:cur[0]
  1031. ---BUFFER POOL 1
  1032. Buffer pool size   49081
  1033. Free buffers       1026
  1034. Database pages     48055
  1035. Old database pages 17719
  1036. Modified db pages  0
  1037. Pending reads 0
  1038. Pending writes: LRU 0, flush list 0 single page 0
  1039. Pages made young 96695, not young 5205503
  1040. 0.00 youngs/s, 0.00 non-youngs/s
  1041. Pages read 67873, created 13478, written 0
  1042. 0.00 reads/s, 0.00 creates/s, 0.00 writes/s
  1043. Buffer pool hit rate 1000 / 1000, young-making rate 0 / 1000 not 0 / 1000
  1044. Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
  1045. LRU len: 48055, unzip_LRU len: 0
  1046. I/O sum[0]:cur[0], unzip sum[0]:cur[0]
  1047. --------------
  1048. ROW OPERATIONS
  1049. --------------
  1050. 0 queries inside InnoDB, 0 queries in queue
  1051. 0 read views open inside InnoDB
  1052. Main thread process no. 19494, id 46964824000256, state: sleeping
  1053. Number of rows inserted 137167, updated 351630, deleted 8482194, read 3519074083
  1054. 1.86 inserts/s, 4.29 updates/s, 0.00 deletes/s, 557594.77 reads/s
  1055. ----------------------------
  1056. END OF INNODB MONITOR OUTPUT
  1057. ============================
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!