sizing_high.result | sizing_high.result | |||
---|---|---|---|---|
show variables like "table_definition_cache"; | show variables like "table_definition_cache"; | |||
Variable_name Value | Variable_name Value | |||
table_definition_cache 5000 | table_definition_cache 5000 | |||
show variables like "table_open_cache"; | show variables like "table_open_cache"; | |||
Variable_name Value | Variable_name Value | |||
table_open_cache 400 | table_open_cache 400 | |||
show variables like "max_connections"; | show variables like "max_connections"; | |||
Variable_name Value | Variable_name Value | |||
max_connections 200 | max_connections 200 | |||
show variables like "open_files_limit"; | ||||
Variable_name Value | ||||
open_files_limit 1024 | ||||
show variables like "%performance_schema%"; | show variables like "%performance_schema%"; | |||
Variable_name Value | Variable_name Value | |||
performance_schema ON | performance_schema ON | |||
performance_schema_accounts_size 100 | performance_schema_accounts_size 100 | |||
performance_schema_digests_size 10000 | performance_schema_digests_size 10000 | |||
performance_schema_events_stages_history_long_size 10000 | performance_schema_events_stages_history_long_size 10000 | |||
performance_schema_events_stages_history_size 10 | performance_schema_events_stages_history_size 10 | |||
performance_schema_events_statements_history_long_size 10000 | performance_schema_events_statements_history_long_size 10000 | |||
performance_schema_events_statements_history_size 10 | performance_schema_events_statements_history_size 10 | |||
performance_schema_events_waits_history_long_size 10000 | performance_schema_events_waits_history_long_size 10000 | |||
skipping to change at line 144 | skipping to change at line 147 | |||
performance_schema events_waits_summary_by_user_by_event_name.memory 1193600 | performance_schema events_waits_summary_by_user_by_event_name.memory 1193600 | |||
performance_schema events_waits_summary_by_host_by_event_name.row_size 32 | performance_schema events_waits_summary_by_host_by_event_name.row_size 32 | |||
performance_schema events_waits_summary_by_host_by_event_name.row_count 37300 | performance_schema events_waits_summary_by_host_by_event_name.row_count 37300 | |||
performance_schema events_waits_summary_by_host_by_event_name.memory 1193600 | performance_schema events_waits_summary_by_host_by_event_name.memory 1193600 | |||
performance_schema (pfs_user).row_size 128 | performance_schema (pfs_user).row_size 128 | |||
performance_schema (pfs_user).row_count 100 | performance_schema (pfs_user).row_count 100 | |||
performance_schema (pfs_user).memory 12800 | performance_schema (pfs_user).memory 12800 | |||
performance_schema (pfs_host).row_size 128 | performance_schema (pfs_host).row_size 128 | |||
performance_schema (pfs_host).row_count 100 | performance_schema (pfs_host).row_count 100 | |||
performance_schema (pfs_host).memory 12800 | performance_schema (pfs_host).memory 12800 | |||
performance_schema (pfs_stage_class).row_size 192 | performance_schema (pfs_stage_class).row_size 256 | |||
performance_schema (pfs_stage_class).row_count 150 | performance_schema (pfs_stage_class).row_count 150 | |||
performance_schema (pfs_stage_class).memory 28800 | performance_schema (pfs_stage_class).memory 38400 | |||
performance_schema events_stages_history.row_size 88 | performance_schema events_stages_history.row_size 88 | |||
performance_schema events_stages_history.row_count 5000 | performance_schema events_stages_history.row_count 5000 | |||
performance_schema events_stages_history.memory 440000 | performance_schema events_stages_history.memory 440000 | |||
performance_schema events_stages_history_long.row_size 88 | performance_schema events_stages_history_long.row_size 88 | |||
performance_schema events_stages_history_long.row_count 10000 | performance_schema events_stages_history_long.row_count 10000 | |||
performance_schema events_stages_history_long.memory 880000 | performance_schema events_stages_history_long.memory 880000 | |||
performance_schema events_stages_summary_by_thread_by_event_name.row_si ze 32 | performance_schema events_stages_summary_by_thread_by_event_name.row_si ze 32 | |||
performance_schema events_stages_summary_by_thread_by_event_name.row_co unt 75000 | performance_schema events_stages_summary_by_thread_by_event_name.row_co unt 75000 | |||
performance_schema events_stages_summary_by_thread_by_event_name.memory 2400000 | performance_schema events_stages_summary_by_thread_by_event_name.memory 2400000 | |||
performance_schema events_stages_summary_global_by_event_name.row_size 32 | performance_schema events_stages_summary_global_by_event_name.row_size 32 | |||
skipping to change at line 219 | skipping to change at line 222 | |||
performance_schema (digest_hash).count 0 | performance_schema (digest_hash).count 0 | |||
performance_schema (digest_hash).size 10000 | performance_schema (digest_hash).size 10000 | |||
performance_schema (filename_hash).count 0 | performance_schema (filename_hash).count 0 | |||
performance_schema (filename_hash).size 23385 | performance_schema (filename_hash).size 23385 | |||
performance_schema (host_hash).count 2 | performance_schema (host_hash).count 2 | |||
performance_schema (host_hash).size 100 | performance_schema (host_hash).size 100 | |||
performance_schema (setup_actor_hash).count 1 | performance_schema (setup_actor_hash).count 1 | |||
performance_schema (setup_actor_hash).size 100 | performance_schema (setup_actor_hash).size 100 | |||
performance_schema (setup_object_hash).count 4 | performance_schema (setup_object_hash).count 4 | |||
performance_schema (setup_object_hash).size 100 | performance_schema (setup_object_hash).size 100 | |||
performance_schema (table_share_hash).count 82 | performance_schema (table_share_hash).count 80 | |||
performance_schema (table_share_hash).size 12500 | performance_schema (table_share_hash).size 12500 | |||
performance_schema (user_hash).count 2 | performance_schema (user_hash).count 2 | |||
performance_schema (user_hash).size 100 | performance_schema (user_hash).size 100 | |||
performance_schema host_cache.size 336 | performance_schema host_cache.size 336 | |||
performance_schema performance_schema.memory 421541256 | performance_schema performance_schema.memory 421550856 | |||
End of changes. 5 change blocks. | ||||
3 lines changed or deleted | 6 lines changed or added | |||
This html diff was produced by rfcdiff 1.41. The latest version is available from http://tools.ietf.org/tools/rfcdiff/ |