转载自:
http://dev.mysql.com/doc/refman/5.6/en/memory-use.html
或者
http://dev.mysql.com/doc/refman/5.6/en/memory-use.html
- #!/bin/sh
- mysql -e "show variables; show status" | awk '
- {
- VAR[$1]=$2
- }
- END {
- MAX_CONN = VAR["max_connections"]
- MAX_USED_CONN = VAR["Max_used_connections"]
- BASE_MEM=VAR["key_buffer_size"] + VAR["query_cache_size"] + VAR["innodb_buffer_pool_size"] + VAR["innodb_additional_mem_pool_size"] + VAR["innodb_log_buffer_size"]
- MEM_PER_CONN=VAR["read_buffer_size"] + VAR["read_rnd_buffer_size"] + VAR["sort_buffer_size"] + VAR["join_buffer_size"] + VAR["binlog_cache_size"] + VAR["thread_stack"] + VAR["tmp_table_size"]
- MEM_TOTAL_MIN=BASE_MEM + MEM_PER_CONN*MAX_USED_CONN
- MEM_TOTAL_MAX=BASE_MEM + MEM_PER_CONN*MAX_CONN
- printf "+------------------------------------------+--------------------+\n"
- printf "| %40s | %15.3f MB |\n", "key_buffer_size", VAR["key_buffer_size"]/1048576
- printf "| %40s | %15.3f MB |\n", "query_cache_size", VAR["query_cache_size"]/1048576
- printf "| %40s | %15.3f MB |\n", "innodb_buffer_pool_size", VAR["innodb_buffer_pool_size"]/1048576
- printf "| %40s | %15.3f MB |\n", "innodb_additional_mem_pool_size", VAR["innodb_additional_mem_pool_size"]/1048576
- printf "| %40s | %15.3f MB |\n", "innodb_log_buffer_size", VAR["innodb_log_buffer_size"]/1048576
- printf "+------------------------------------------+--------------------+\n"
- printf "| %40s | %15.3f MB |\n", "BASE MEMORY", BASE_MEM/1048576
- printf "+------------------------------------------+--------------------+\n"
- printf "| %40s | %15.3f MB |\n", "sort_buffer_size", VAR["sort_buffer_size"]/1048576
- printf "| %40s | %15.3f MB |\n", "read_buffer_size", VAR["read_buffer_size"]/1048576
- printf "| %40s | %15.3f MB |\n", "read_rnd_buffer_size", VAR["read_rnd_buffer_size"]/1048576
- printf "| %40s | %15.3f MB |\n", "join_buffer_size", VAR["join_buffer_size"]/1048576
- printf "| %40s | %15.3f MB |\n", "thread_stack", VAR["thread_stack"]/1048576
- printf "| %40s | %15.3f MB |\n", "binlog_cache_size", VAR["binlog_cache_size"]/1048576
- printf "| %40s | %15.3f MB |\n", "tmp_table_size", VAR["tmp_table_size"]/1048576
- printf "+------------------------------------------+--------------------+\n"
- printf "| %40s | %15.3f MB |\n", "MEMORY PER CONNECTION", MEM_PER_CONN/1048576
- printf "+------------------------------------------+--------------------+\n"
- printf "| %40s | %18d |\n", "Max_used_connections", MAX_USED_CONN
- printf "| %40s | %18d |\n", "max_connections", MAX_CONN
- printf "+------------------------------------------+--------------------+\n"
- printf "| %40s | %15.3f MB |\n", "TOTAL (MIN)", MEM_TOTAL_MIN/1048576
- printf "| %40s | %15.3f MB |\n", "TOTAL (MAX)", MEM_TOTAL_MAX/1048576
- printf "+------------------------------------------+--------------------+\n"
- }'
或者
- SELECT ( @@key_buffer_size
- + @@query_cache_size
- + @@innodb_buffer_pool_size
- + @@innodb_additional_mem_pool_size
- + @@innodb_log_buffer_size
- + @@max_connections * ( @@read_buffer_size
- + @@read_rnd_buffer_size
- + @@sort_buffer_size
- + @@join_buffer_size
- + @@binlog_cache_size
- + @@thread_stack
- + @@tmp_table_size )
- ) / (1024 * 1024 * 1024) AS MAX_MEMORY_GB,
- ( @@key_buffer_size
- + @@query_cache_size
- + @@innodb_buffer_pool_size
- + @@innodb_additional_mem_pool_size
- + @@innodb_log_buffer_size)/ (1024 * 1024 * 1024) AS MIN_MEMORY_GB;
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/29254281/viewspace-2124854/ ，如需转载，请注明出处，否则将追究法律责任。
请登录后发表评论
登录
全部评论
