单机模式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%，请及时进行相关参数调整或扩容，防止内存刷满，导致服务故障（严重时可能会导致服务器无法登录的情况，需要重启解决）！

1. standalone-config.json快速配置参考

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

1.1. 单节点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"
  }
  }
  

1.2. 单节点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"
  }
  }
  

1.3. 单节点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"
  }
  }
  

1.4. 单节点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"
  }
  }
  

  1.5. 单节点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"
  }
  }
  

1.6. 单节点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"
  }
  }