csaw19

glob var sz

Nov 18th, 2019
182
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 6.50 KB | None | 0 0
  1. mysql> SHOW GLOBAL VARIABLES LIKE '%size%';
  2.  
  3. +----------------------------------------------------------+----------------------+
  4. | Variable_name | Value |
  5. +----------------------------------------------------------+----------------------+
  6. | binlog_cache_size | 32768 |
  7. | binlog_stmt_cache_size | 32768 |
  8. | binlog_transaction_dependency_history_size | 25000 |
  9. | bulk_insert_buffer_size | 8388608 |
  10. | delayed_queue_size | 1000 |
  11. | host_cache_size | 279 |
  12. | innodb_buffer_pool_chunk_size | 134217728 |
  13. | innodb_buffer_pool_size | 10737418240 |
  14. | innodb_change_buffer_max_size | 25 |
  15. | innodb_ft_cache_size | 8000000 |
  16. | innodb_ft_max_token_size | 84 |
  17. | innodb_ft_min_token_size | 3 |
  18. | innodb_ft_total_cache_size | 640000000 |
  19. | innodb_log_buffer_size | 16777216 |
  20. | innodb_log_file_size | 50331648 |
  21. | innodb_log_write_ahead_size | 8192 |
  22. | innodb_max_undo_log_size | 1073741824 |
  23. | innodb_online_alter_log_max_size | 134217728 |
  24. | innodb_page_size | 16384 |
  25. | innodb_purge_batch_size | 300 |
  26. | innodb_sort_buffer_size | 1048576 |
  27. | innodb_sync_array_size | 1 |
  28. | join_buffer_size | 262144 |
  29. | key_buffer_size | 16777216 |
  30. | key_cache_block_size | 1024 |
  31. | large_page_size | 0 |
  32. | max_binlog_cache_size | 18446744073709547520 |
  33. | max_binlog_size | 104857600 |
  34. | max_binlog_stmt_cache_size | 18446744073709547520 |
  35. | max_heap_table_size | 16777216 |
  36. | max_join_size | 18446744073709551615 |
  37. | max_relay_log_size | 0 |
  38. | metadata_locks_cache_size | 1024 |
  39. | myisam_data_pointer_size | 6 |
  40. | myisam_max_sort_file_size | 9223372036853727232 |
  41. | myisam_mmap_size | 18446744073709551615 |
  42. | myisam_sort_buffer_size | 8388608 |
  43. | ngram_token_size | 2 |
  44. | optimizer_trace_max_mem_size | 16384 |
  45. | parser_max_mem_size | 18446744073709551615 |
  46. | performance_schema_accounts_size | -1 |
  47. | performance_schema_digests_size | 5000 |
  48. | performance_schema_events_stages_history_long_size | 1000 |
  49. | performance_schema_events_stages_history_size | 10 |
  50. | performance_schema_events_statements_history_long_size | 1000 |
  51. | performance_schema_events_statements_history_size | 10 |
  52. | performance_schema_events_transactions_history_long_size | 1000 |
  53. | performance_schema_events_transactions_history_size | 10 |
  54. | performance_schema_events_waits_history_long_size | 1000 |
  55. | performance_schema_events_waits_history_size | 10 |
  56. | performance_schema_hosts_size | -1 |
  57. | performance_schema_session_connect_attrs_size | 512 |
  58. | performance_schema_setup_actors_size | -1 |
  59. | performance_schema_setup_objects_size | -1 |
  60. | performance_schema_users_size | -1 |
  61. | preload_buffer_size | 32768 |
  62. | profiling_history_size | 15 |
  63. | query_alloc_block_size | 8192 |
  64. | query_cache_size | 16777216 |
  65. | query_prealloc_size | 8192 |
  66. | range_alloc_block_size | 4096 |
  67. | range_optimizer_max_mem_size | 8388608 |
  68. | read_buffer_size | 131072 |
  69. | read_rnd_buffer_size | 262144 |
  70. | slave_pending_jobs_size_max | 16777216 |
  71. | sort_buffer_size | 262144 |
  72. | thread_cache_size | 8 |
  73. | tmp_table_size | 16777216 |
  74. | transaction_alloc_block_size | 8192 |
  75. | transaction_prealloc_size | 4096 |
  76. +----------------------------------------------------------+----------------------+
  77. 70 rows in set (0.39 sec)
  78.  
  79. mysql> SHOW GLOBAL VARIABLES like '%capacity%' ;
  80. +------------------------+-------+
  81. | Variable_name | Value |
  82. +------------------------+-------+
  83. | innodb_io_capacity | 200 |
  84. | innodb_io_capacity_max | 2000 |
  85. +------------------------+-------+
  86. 2 rows in set (0.00 sec)
Add Comment
Please, Sign In to add comment