Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- mysql> SHOW GLOBAL VARIABLES LIKE '%size%';
- +----------------------------------------------------------+----------------------+
- | Variable_name | Value |
- +----------------------------------------------------------+----------------------+
- | binlog_cache_size | 32768 |
- | binlog_stmt_cache_size | 32768 |
- | binlog_transaction_dependency_history_size | 25000 |
- | bulk_insert_buffer_size | 8388608 |
- | delayed_queue_size | 1000 |
- | host_cache_size | 279 |
- | innodb_buffer_pool_chunk_size | 134217728 |
- | innodb_buffer_pool_size | 10737418240 |
- | innodb_change_buffer_max_size | 25 |
- | innodb_ft_cache_size | 8000000 |
- | innodb_ft_max_token_size | 84 |
- | innodb_ft_min_token_size | 3 |
- | innodb_ft_total_cache_size | 640000000 |
- | innodb_log_buffer_size | 16777216 |
- | innodb_log_file_size | 50331648 |
- | innodb_log_write_ahead_size | 8192 |
- | innodb_max_undo_log_size | 1073741824 |
- | innodb_online_alter_log_max_size | 134217728 |
- | innodb_page_size | 16384 |
- | innodb_purge_batch_size | 300 |
- | innodb_sort_buffer_size | 1048576 |
- | innodb_sync_array_size | 1 |
- | join_buffer_size | 262144 |
- | key_buffer_size | 16777216 |
- | key_cache_block_size | 1024 |
- | large_page_size | 0 |
- | max_binlog_cache_size | 18446744073709547520 |
- | max_binlog_size | 104857600 |
- | max_binlog_stmt_cache_size | 18446744073709547520 |
- | max_heap_table_size | 16777216 |
- | max_join_size | 18446744073709551615 |
- | max_relay_log_size | 0 |
- | metadata_locks_cache_size | 1024 |
- | myisam_data_pointer_size | 6 |
- | myisam_max_sort_file_size | 9223372036853727232 |
- | myisam_mmap_size | 18446744073709551615 |
- | myisam_sort_buffer_size | 8388608 |
- | ngram_token_size | 2 |
- | optimizer_trace_max_mem_size | 16384 |
- | parser_max_mem_size | 18446744073709551615 |
- | performance_schema_accounts_size | -1 |
- | performance_schema_digests_size | 5000 |
- | performance_schema_events_stages_history_long_size | 1000 |
- | performance_schema_events_stages_history_size | 10 |
- | performance_schema_events_statements_history_long_size | 1000 |
- | performance_schema_events_statements_history_size | 10 |
- | performance_schema_events_transactions_history_long_size | 1000 |
- | performance_schema_events_transactions_history_size | 10 |
- | performance_schema_events_waits_history_long_size | 1000 |
- | performance_schema_events_waits_history_size | 10 |
- | performance_schema_hosts_size | -1 |
- | performance_schema_session_connect_attrs_size | 512 |
- | performance_schema_setup_actors_size | -1 |
- | performance_schema_setup_objects_size | -1 |
- | performance_schema_users_size | -1 |
- | preload_buffer_size | 32768 |
- | profiling_history_size | 15 |
- | query_alloc_block_size | 8192 |
- | query_cache_size | 16777216 |
- | query_prealloc_size | 8192 |
- | range_alloc_block_size | 4096 |
- | range_optimizer_max_mem_size | 8388608 |
- | read_buffer_size | 131072 |
- | read_rnd_buffer_size | 262144 |
- | slave_pending_jobs_size_max | 16777216 |
- | sort_buffer_size | 262144 |
- | thread_cache_size | 8 |
- | tmp_table_size | 16777216 |
- | transaction_alloc_block_size | 8192 |
- | transaction_prealloc_size | 4096 |
- +----------------------------------------------------------+----------------------+
- 70 rows in set (0.39 sec)
- mysql> SHOW GLOBAL VARIABLES like '%capacity%' ;
- +------------------------+-------+
- | Variable_name | Value |
- +------------------------+-------+
- | innodb_io_capacity | 200 |
- | innodb_io_capacity_max | 2000 |
- +------------------------+-------+
- 2 rows in set (0.00 sec)
Add Comment
Please, Sign In to add comment