how much memory is used when mysql starts
Software version mysql 5.6
after looking at it on the Internet, the main parameter that affects the memory of mysql is probably innodb_buffer_pool_size
key_buffer_size.
now I copy an online configuration to my own machine and configure it as follows
[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
user=mysql
innodb_buffer_pool_size = 1024M
datadir = /var/lib/mysql
socket=/var/lib/mysql/mysql.sock
port = 3306
server_id = 11
expire_logs_days = 10
sort_buffer_size = 1M
join_buffer_size = 1M
query_cache_size = 512M
query_cache_limit = 2M
query_cache_min_res_unit = 2k
thread_stack = 192K
tmp_table_size = 246M
max_heap_table_size = 246M
key_buffer_size = 300M
read_buffer_size = 1M
read_rnd_buffer_size = 16M
bulk_insert_buffer_size = 64M
max_connections = 3600
-sharp Disabling symbolic-links is recommended to prevent assorted security risks
[mysqld_safe]
log-error=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pidonline machine, this configuration takes up 800m of memory when it starts, while my own machine only takes up 214m of memory.
does any boss know what"s going on?