Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- mysql> show engine performance_schema status;
- +--------------------+-------------------------------------------------------------+-----------+
- | Type | Name | Status |
- +--------------------+-------------------------------------------------------------+-----------+
- | performance_schema | events_waits_current.size | 176 |
- | performance_schema | events_waits_current.count | 1536 |
- | performance_schema | events_waits_history.size | 176 |
- | performance_schema | events_waits_history.count | 2560 |
- | performance_schema | events_waits_history.memory | 450560 |
- | performance_schema | events_waits_history_long.size | 176 |
- | performance_schema | events_waits_history_long.count | 10000 |
- | performance_schema | events_waits_history_long.memory | 1760000 |
- | performance_schema | (pfs_mutex_class).size | 256 |
- | performance_schema | (pfs_mutex_class).count | 300 |
- | performance_schema | (pfs_mutex_class).memory | 76800 |
- | performance_schema | (pfs_rwlock_class).size | 256 |
- | performance_schema | (pfs_rwlock_class).count | 60 |
- | performance_schema | (pfs_rwlock_class).memory | 15360 |
- | performance_schema | (pfs_cond_class).size | 256 |
- | performance_schema | (pfs_cond_class).count | 100 |
- | performance_schema | (pfs_cond_class).memory | 25600 |
- | performance_schema | (pfs_thread_class).size | 256 |
- | performance_schema | (pfs_thread_class).count | 100 |
- | performance_schema | (pfs_thread_class).memory | 25600 |
- | performance_schema | (pfs_file_class).size | 320 |
- | performance_schema | (pfs_file_class).count | 80 |
- | performance_schema | (pfs_file_class).memory | 25600 |
- | performance_schema | mutex_instances.size | 80 |
- | performance_schema | mutex_instances.count | 4096 |
- | performance_schema | mutex_instances.memory | 327680 |
- | performance_schema | rwlock_instances.size | 88 |
- | performance_schema | rwlock_instances.count | 2048 |
- | performance_schema | rwlock_instances.memory | 180224 |
- | performance_schema | cond_instances.size | 72 |
- | performance_schema | cond_instances.count | 256 |
- | performance_schema | cond_instances.memory | 18432 |
- | performance_schema | threads.size | 4288 |
- | performance_schema | threads.count | 256 |
- | performance_schema | threads.memory | 1097728 |
- | performance_schema | file_instances.size | 704 |
- | performance_schema | file_instances.count | 4096 |
- | performance_schema | file_instances.memory | 2883584 |
- | performance_schema | (pfs_file_handle).size | 8 |
- | performance_schema | (pfs_file_handle).count | 32768 |
- | performance_schema | (pfs_file_handle).memory | 262144 |
- | performance_schema | events_waits_summary_by_thread_by_event_name.size | 32 |
- | performance_schema | events_waits_summary_by_thread_by_event_name.count | 141824 |
- | performance_schema | events_waits_summary_by_thread_by_event_name.memory | 4538368 |
- | performance_schema | (pfs_table_share).size | 1024 |
- | performance_schema | (pfs_table_share).count | 4096 |
- | performance_schema | (pfs_table_share).memory | 4194304 |
- | performance_schema | (pfs_table).size | 9280 |
- | performance_schema | (pfs_table).count | 1024 |
- | performance_schema | (pfs_table).memory | 9502720 |
- | performance_schema | setup_actors.size | 512 |
- | performance_schema | setup_actors.count | 128 |
- | performance_schema | setup_actors.memory | 65536 |
- | performance_schema | setup_objects.size | 448 |
- | performance_schema | setup_objects.count | 128 |
- | performance_schema | setup_objects.memory | 57344 |
- | performance_schema | (pfs_account).size | 896 |
- | performance_schema | (pfs_account).count | 128 |
- | performance_schema | (pfs_account).memory | 114688 |
- | performance_schema | events_waits_summary_by_account_by_event_name.size | 32 |
- | performance_schema | events_waits_summary_by_account_by_event_name.count | 70912 |
- | performance_schema | events_waits_summary_by_account_by_event_name.memory | 2269184 |
- | performance_schema | events_waits_summary_by_user_by_event_name.size | 32 |
- | performance_schema | events_waits_summary_by_user_by_event_name.count | 70912 |
- | performance_schema | events_waits_summary_by_user_by_event_name.memory | 2269184 |
- | performance_schema | events_waits_summary_by_host_by_event_name.size | 32 |
- | performance_schema | events_waits_summary_by_host_by_event_name.count | 70912 |
- | performance_schema | events_waits_summary_by_host_by_event_name.memory | 2269184 |
- | performance_schema | (pfs_user).size | 640 |
- | performance_schema | (pfs_user).count | 128 |
- | performance_schema | (pfs_user).memory | 81920 |
- | performance_schema | (pfs_host).size | 768 |
- | performance_schema | (pfs_host).count | 128 |
- | performance_schema | (pfs_host).memory | 98304 |
- | performance_schema | (pfs_stage_class).size | 256 |
- | performance_schema | (pfs_stage_class).count | 175 |
- | performance_schema | (pfs_stage_class).memory | 44800 |
- | performance_schema | events_stages_history.size | 104 |
- | performance_schema | events_stages_history.count | 2560 |
- | performance_schema | events_stages_history.memory | 266240 |
- | performance_schema | events_stages_history_long.size | 104 |
- | performance_schema | events_stages_history_long.count | 10000 |
- | performance_schema | events_stages_history_long.memory | 1040000 |
- | performance_schema | events_stages_summary_by_thread_by_event_name.size | 32 |
- | performance_schema | events_stages_summary_by_thread_by_event_name.count | 44800 |
- | performance_schema | events_stages_summary_by_thread_by_event_name.memory | 1433600 |
- | performance_schema | events_stages_summary_global_by_event_name.size | 32 |
- | performance_schema | events_stages_summary_global_by_event_name.count | 175 |
- | performance_schema | events_stages_summary_global_by_event_name.memory | 5600 |
- | performance_schema | events_stages_summary_by_account_by_event_name.size | 32 |
- | performance_schema | events_stages_summary_by_account_by_event_name.count | 22400 |
- | performance_schema | events_stages_summary_by_account_by_event_name.memory | 716800 |
- | performance_schema | events_stages_summary_by_user_by_event_name.size | 32 |
- | performance_schema | events_stages_summary_by_user_by_event_name.count | 22400 |
- | performance_schema | events_stages_summary_by_user_by_event_name.memory | 716800 |
- | performance_schema | events_stages_summary_by_host_by_event_name.size | 32 |
- | performance_schema | events_stages_summary_by_host_by_event_name.count | 22400 |
- | performance_schema | events_stages_summary_by_host_by_event_name.memory | 716800 |
- | performance_schema | (pfs_statement_class).size | 192 |
- | performance_schema | (pfs_statement_class).count | 218 |
- | performance_schema | (pfs_statement_class).memory | 41856 |
- | performance_schema | events_statements_history.size | 1456 |
- | performance_schema | events_statements_history.count | 2560 |
- | performance_schema | events_statements_history.memory | 3727360 |
- | performance_schema | events_statements_history_long.size | 1456 |
- | performance_schema | events_statements_history_long.count | 10000 |
- | performance_schema | events_statements_history_long.memory | 14560000 |
- | performance_schema | events_statements_summary_by_thread_by_event_name.size | 184 |
- | performance_schema | events_statements_summary_by_thread_by_event_name.count | 55808 |
- | performance_schema | events_statements_summary_by_thread_by_event_name.memory | 10268672 |
- | performance_schema | events_statements_summary_global_by_event_name.size | 184 |
- | performance_schema | events_statements_summary_global_by_event_name.count | 218 |
- | performance_schema | events_statements_summary_global_by_event_name.memory | 40112 |
- | performance_schema | events_statements_summary_by_account_by_event_name.size | 184 |
- | performance_schema | events_statements_summary_by_account_by_event_name.count | 27904 |
- | performance_schema | events_statements_summary_by_account_by_event_name.memory | 5134336 |
- | performance_schema | events_statements_summary_by_user_by_event_name.size | 184 |
- | performance_schema | events_statements_summary_by_user_by_event_name.count | 27904 |
- | performance_schema | events_statements_summary_by_user_by_event_name.memory | 5134336 |
- | performance_schema | events_statements_summary_by_host_by_event_name.size | 184 |
- | performance_schema | events_statements_summary_by_host_by_event_name.count | 27904 |
- | performance_schema | events_statements_summary_by_host_by_event_name.memory | 5134336 |
- | performance_schema | events_statements_current.size | 1456 |
- | performance_schema | events_statements_current.count | 2560 |
- | performance_schema | events_statements_current.memory | 3727360 |
- | performance_schema | (pfs_socket_class).size | 320 |
- | performance_schema | (pfs_socket_class).count | 10 |
- | performance_schema | (pfs_socket_class).memory | 3200 |
- | performance_schema | socket_instances.size | 312 |
- | performance_schema | socket_instances.count | 256 |
- | performance_schema | socket_instances.memory | 79872 |
- | performance_schema | events_statements_summary_by_digest.size | 4160 |
- | performance_schema | events_statements_summary_by_digest.count | 10000 |
- | performance_schema | events_statements_summary_by_digest.memory | 41600000 |
- | performance_schema | events_statements_summary_by_program.size | 448 |
- | performance_schema | events_statements_summary_by_program.count | 0 |
- | performance_schema | events_statements_summary_by_program.memory | 0 |
- | performance_schema | session_connect_attrs.size | 256 |
- | performance_schema | session_connect_attrs.count | 512 |
- | performance_schema | session_connect_attrs.memory | 131072 |
- | performance_schema | prepared_statements_instances.size | 1664 |
- | performance_schema | prepared_statements_instances.count | 0 |
- | performance_schema | prepared_statements_instances.memory | 0 |
- | performance_schema | (account_hash).count | 4 |
- | performance_schema | (account_hash).size | 4 |
- | performance_schema | (digest_hash).count | 5 |
- | performance_schema | (digest_hash).size | 8 |
- | performance_schema | (filename_hash).count | 207 |
- | performance_schema | (filename_hash).size | 256 |
- | performance_schema | (host_hash).count | 2 |
- | performance_schema | (host_hash).size | 2 |
- | performance_schema | (setup_actor_hash).count | 1 |
- | performance_schema | (setup_actor_hash).size | 1 |
- | performance_schema | (setup_object_hash).count | 20 |
- | performance_schema | (setup_object_hash).size | 32 |
- | performance_schema | (table_share_hash).count | 50 |
- | performance_schema | (table_share_hash).size | 64 |
- | performance_schema | (user_hash).count | 4 |
- | performance_schema | (user_hash).size | 4 |
- | performance_schema | (program_hash).count | 0 |
- | performance_schema | (program_hash).size | 1 |
- | performance_schema | host_cache.size | 512 |
- | performance_schema | (pfs_memory_class).row_size | 192 |
- | performance_schema | (pfs_memory_class).row_count | 450 |
- | performance_schema | (pfs_memory_class).memory | 86400 |
- | performance_schema | memory_summary_by_thread_by_event_name.row_size | 72 |
- | performance_schema | memory_summary_by_thread_by_event_name.row_count | 115200 |
- | performance_schema | memory_summary_by_thread_by_event_name.memory | 8294400 |
- | performance_schema | memory_summary_global_by_event_name.row_size | 72 |
- | performance_schema | memory_summary_global_by_event_name.row_count | 450 |
- | performance_schema | memory_summary_global_by_event_name.memory | 32400 |
- | performance_schema | memory_summary_by_account_by_event_name.row_size | 72 |
- | performance_schema | memory_summary_by_account_by_event_name.row_count | 57600 |
- | performance_schema | memory_summary_by_account_by_event_name.memory | 4147200 |
- | performance_schema | memory_summary_by_user_by_event_name.row_size | 72 |
- | performance_schema | memory_summary_by_user_by_event_name.row_count | 57600 |
- | performance_schema | memory_summary_by_user_by_event_name.memory | 4147200 |
- | performance_schema | memory_summary_by_host_by_event_name.row_size | 72 |
- | performance_schema | memory_summary_by_host_by_event_name.row_count | 57600 |
- | performance_schema | memory_summary_by_host_by_event_name.memory | 4147200 |
- | performance_schema | metadata_locks.row_size | 512 |
- | performance_schema | metadata_locks.row_count | 1024 |
- | performance_schema | metadata_locks.memory | 524288 |
- | performance_schema | events_transactions_history.size | 344 |
- | performance_schema | events_transactions_history.count | 2560 |
- | performance_schema | events_transactions_history.memory | 880640 |
- | performance_schema | events_transactions_history_long.size | 344 |
- | performance_schema | events_transactions_history_long.count | 10000 |
- | performance_schema | events_transactions_history_long.memory | 3440000 |
- | performance_schema | events_transactions_summary_by_thread_by_event_name.size | 88 |
- | performance_schema | events_transactions_summary_by_thread_by_event_name.count | 256 |
- | performance_schema | events_transactions_summary_by_thread_by_event_name.memory | 22528 |
- | performance_schema | events_transactions_summary_by_account_by_event_name.size | 88 |
- | performance_schema | events_transactions_summary_by_account_by_event_name.count | 128 |
- | performance_schema | events_transactions_summary_by_account_by_event_name.memory | 11264 |
- | performance_schema | events_transactions_summary_by_user_by_event_name.size | 88 |
- | performance_schema | events_transactions_summary_by_user_by_event_name.count | 128 |
- | performance_schema | events_transactions_summary_by_user_by_event_name.memory | 11264 |
- | performance_schema | events_transactions_summary_by_host_by_event_name.size | 88 |
- | performance_schema | events_transactions_summary_by_host_by_event_name.count | 128 |
- | performance_schema | events_transactions_summary_by_host_by_event_name.memory | 11264 |
- | performance_schema | table_lock_waits_summary_by_table.size | 344 |
- | performance_schema | table_lock_waits_summary_by_table.count | 0 |
- | performance_schema | table_lock_waits_summary_by_table.memory | 0 |
- | performance_schema | table_io_waits_summary_by_index_usage.size | 352 |
- | performance_schema | table_io_waits_summary_by_index_usage.count | 8192 |
- | performance_schema | table_io_waits_summary_by_index_usage.memory | 2883584 |
- | performance_schema | (history_long_statements_digest_token_array).count | 10000 |
- | performance_schema | (history_long_statements_digest_token_array).size | 1024 |
- | performance_schema | (history_long_statements_digest_token_array).memory | 10240000 |
- | performance_schema | (history_statements_digest_token_array).count | 2560 |
- | performance_schema | (history_statements_digest_token_array).size | 1024 |
- | performance_schema | (history_statements_digest_token_array).memory | 2621440 |
- | performance_schema | (current_statements_digest_token_array).count | 2560 |
- | performance_schema | (current_statements_digest_token_array).size | 1024 |
- | performance_schema | (current_statements_digest_token_array).memory | 2621440 |
- | performance_schema | (history_long_statements_text_array).count | 10000 |
- | performance_schema | (history_long_statements_text_array).size | 1024 |
- | performance_schema | (history_long_statements_text_array).memory | 10240000 |
- | performance_schema | (history_statements_text_array).count | 2560 |
- | performance_schema | (history_statements_text_array).size | 1024 |
- | performance_schema | (history_statements_text_array).memory | 2621440 |
- | performance_schema | (current_statements_text_array).count | 2560 |
- | performance_schema | (current_statements_text_array).size | 1024 |
- | performance_schema | (current_statements_text_array).memory | 2621440 |
- | performance_schema | (statements_digest_token_array).count | 10000 |
- | performance_schema | (statements_digest_token_array).size | 1024 |
- | performance_schema | (statements_digest_token_array).memory | 10240000 |
- | performance_schema | events_errors_summary_by_thread_by_error.size | 48848 |
- | performance_schema | events_errors_summary_by_thread_by_error.count | 256 |
- | performance_schema | events_errors_summary_by_thread_by_error.memory | 12505088 |
- | performance_schema | events_errors_summary_by_account_by_error.size | 48848 |
- | performance_schema | events_errors_summary_by_account_by_error.count | 128 |
- | performance_schema | events_errors_summary_by_account_by_error.memory | 6252544 |
- | performance_schema | events_errors_summary_by_user_by_error.size | 48848 |
- | performance_schema | events_errors_summary_by_user_by_error.count | 128 |
- | performance_schema | events_errors_summary_by_user_by_error.memory | 6252544 |
- | performance_schema | events_errors_summary_by_host_by_error.size | 48848 |
- | performance_schema | events_errors_summary_by_host_by_error.count | 128 |
- | performance_schema | events_errors_summary_by_host_by_error.memory | 6252544 |
- | performance_schema | events_errors_summary_global_by_error.size | 158272 |
- | performance_schema | events_errors_summary_global_by_error.count | 1 |
- | performance_schema | events_errors_summary_global_by_error.memory | 158272 |
- | performance_schema | (pfs_buffer_scalable_container).count | 19 |
- | performance_schema | (pfs_buffer_scalable_container).memory | 2096 |
- | performance_schema | (max_global_server_errors).count | 4946 |
- | performance_schema | (max_session_server_errors).count | 1526 |
- | performance_schema | performance_schema.memory | 228401680 |
- +--------------------+-------------------------------------------------------------+-----------+
- 248 rows in set (0.29 sec)
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement