yuedingwangji
V2EX  ›  问与答

mysql 启动内存的疑问

  •  
  •   yuedingwangji · Oct 31, 2018 · 1422 views
    This topic created in 2779 days ago, the information mentioned may be changed or developed.

    mysql 启动的时候占用的内存是怎么算的

    软件版本 mysql 5.6

    网上查看了一下,影响 mysql 的内存的参数主要大概是 innodb_buffer_pool_size key_buffer_size。 现在我把一份线上的配置拷贝到我自己的机器,配置如下

    
    [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
    # Disabling symbolic-links is recommended to prevent assorted security risks
    
    [mysqld_safe]
    log-error=/var/log/mysqld.log
    pid-file=/var/run/mysqld/mysqld.pid
    

    线上的机器,这份配置启动的时候占了 800M 内存, 而我自己的机器才占用了 214M 内存,

    请问有大佬知道这是怎么回事么?

    No Comments Yet
    About   ·   Help   ·   Advertise   ·   Blog   ·   API   ·   FAQ   ·   Solana   ·   2635 Online   Highest 6679   ·     Select Language
    创意工作者们的社区
    World is powered by solitude
    VERSION: 3.9.8.5 · 28ms · UTC 15:46 · PVG 23:46 · LAX 08:46 · JFK 11:46
    ♥ Do have faith in what you're doing.