› MySQL 5.5 Community Server
› MySQL 5.6 Community Server
› Percona Configuration Wizard
› XtraBackup 搭建主从复制
Great Sites on MySQL
› Percona
› MySQL Performance Blog
› Severalnines
推荐管理工具
› Sequel Pro
› phpMyAdmin
推荐书目
› MySQL Cookbook
MySQL 相关项目
› MariaDB
› Drizzle
参考文档
› http://mysql-python.sourceforge.net/MySQLdb.html
pmispig
V2EX  ›  MySQL

请问怎么分析 mysql 5.7 内存占用

  •  
  •   pmispig · Apr 6, 2021 · 2424 views
    This topic created in 1998 days ago, the information mentioned may be changed or developed.

    看到 mysql 进程的 RES 是 5G 当前连接数为 600.

    innodb-buffer-pool-size        = 1G
    tmp-table-size                 = 32M
    max-heap-table-size            = 32M
    table-definition-cache         = 4096
    table-open-cache               = 50
    query-cache-type               = 0
    query-cache-size               = 0
    
    2 replies  •  2021-04-06 10:59:02 +08:00
    pmispig
        1
    pmispig  
    OP
       Apr 6, 2021
    max_allowed_packet= 512M
    securityCoding
        2
    securityCoding  
       Apr 6, 2021
    看监控大盘
    About   ·   Help   ·   Advertise   ·   Blog   ·   API   ·   FAQ   ·   Privacy   ·   Solana   ·   2427 Online   Highest 6679   ·     Select Language
    创意工作者们的社区
    World is powered by solitude
    VERSION: 3.9.8.5 · 26ms · UTC 05:19 · PVG 13:19 · LAX 22:19 · JFK 01:19
    ♥ Do have faith in what you're doing.