单机模式standalone-config.json配置优化

优化建议:

单机版默认使用MySQL存储统计结果数据,Mysql的读写压力较大,需要预留服务器内存的30%~40%给MySQL服务。 此外redis的主从模式可能会存在单点写入故障问题,所以单机版的redis仍使用集群模式,即启动6个节点。

本服务按照以下规则进行配置:

整体按照:Mysql占用约1/3内存,其他服务占用1/3内存,空闲1/3内存。

redis_max_memory * 6 + standalone_xmx_memory + insights_xmx_memory <= 系统总内存的*30%。

mysql_max_memory ≈ innodb_buffer_pool_size + max_connections * (tmp_table_size + read_buffer_size + sort_buffer_size + ...)

如果服务器资源较为紧张,请务必关注服务器的内存使用率相关数据,内存使用率如果超过70%,请及时进行相关参数调整或扩容,防止内存刷满,导致服务故障(严重时可能会导致服务器无法登录的情况,需要重启解决)!

standalone-config.json快速配置参考

如果您对于各组件优化缺乏相关经验,可以按照自身服务器配置情况,直接拷贝以下配置即可!

单节点8G内存配置参考

  • standalone-config.json配置
    {
    "lighthouse": {
      "timezone": "Asia/Shanghai",
      "standalone_xmx_memory": "500M",
      "standalone_xms_memory": "500M",
      "insights_xmx_memory": "256M",
      "insights_xms_memory": "256M"
    },
    "redis": {
      "max_memory": "220M"
    },
    "mysql": {
      "max_connections": "50",
      "innodb_buffer_pool_size": "600M",
      "tmp_table_size": "8M",
      "max_heap_table_size": "8M"
    }
    }
    

单节点16G内存配置参考

  • standalone-config.json配置
    {
    "lighthouse": {
      "timezone": "Asia/Shanghai",
      "standalone_xmx_memory": "1000M",
      "standalone_xms_memory": "1000M",
      "insights_xmx_memory": "512M",
      "insights_xms_memory": "512M"
    },
    "redis": {
      "max_memory": "450M"
    },
    "mysql": {
      "max_connections": "80",
      "innodb_buffer_pool_size": "1300M",
      "tmp_table_size": "10M",
      "max_heap_table_size": "10M"
    }
    }
    

单节点32G内存配置参考

  • standalone-config.json配置
    {
    "lighthouse": {
      "timezone": "Asia/Shanghai",
      "standalone_xmx_memory": "2000M",
      "standalone_xms_memory": "2000M",
      "insights_xmx_memory": "1024M",
      "insights_xms_memory": "1024M"
    },
    "redis": {
      "max_memory": "900M"
    },
    "mysql": {
      "max_connections": "100",
      "innodb_buffer_pool_size": "2600M",
      "tmp_table_size": "16M",
      "max_heap_table_size": "16M"
    }
    }
    

单节点64G内存配置参考

  • standalone-config.json配置

    {
    "lighthouse": {
      "timezone": "Asia/Shanghai",
      "standalone_xmx_memory": "3000M",
      "standalone_xms_memory": "3000M",
      "insights_xmx_memory": "1024M",
      "insights_xms_memory": "1024M"
    },
    "redis": {
      "max_memory": "1800M"
    },
    "mysql": {
      "max_connections": "151",
      "innodb_buffer_pool_size": "5200M",
      "tmp_table_size": "16M",
      "max_heap_table_size": "16M"
    }
    }
    

    单节点128G内存配置参考

  • standalone-config.json配置

    {
    "lighthouse": {
      "timezone": "Asia/Shanghai",
      "standalone_xmx_memory": "3000M",
      "standalone_xms_memory": "3000M",
      "insights_xmx_memory": "1024M",
      "insights_xms_memory": "1024M"
    },
    "redis": {
      "max_memory": "3600M"
    },
    "mysql": {
      "max_connections": "151",
      "innodb_buffer_pool_size": "10000M",
      "tmp_table_size": "32M",
      "max_heap_table_size": "32M"
    }
    }
    

单节点256G内存配置参考

  • standalone-config.json配置
    {
    "lighthouse": {
      "timezone": "Asia/Shanghai",
      "standalone_xmx_memory": "5000M",
      "standalone_xms_memory": "5000M",
      "insights_xmx_memory": "2048M",
      "insights_xms_memory": "2048M"
    },
    "redis": {
      "max_memory": "7200M"
    },
    "mysql": {
      "max_connections": "200",
      "innodb_buffer_pool_size": "20000M",
      "tmp_table_size": "64M",
      "max_heap_table_size": "64M"
    }
    }
    

results matching ""

    No results matching ""