mysql内存占用查询

-- 查询全局状态
SHOW GLOBAL STATUS LIKE 'Innodb_buffer_pool_pages_%';

-- 查询全局变量
SHOW GLOBAL VARIABLES LIKE 'innodb_buffer_pool_size';

import mysql.connector

def get_mysql_memory_usage(host, user, password, database):
    conn = mysql.connector.connect(host=host, user=user, password=password, database=database)
    cursor = conn.cursor()

    # 查询 InnoDB 缓冲池大小
    cursor.execute("SHOW GLOBAL VARIABLES LIKE 'innodb_buffer_pool_size'")
    buffer_pool_size = cursor.fetchone()[1]

    # 查询 InnoDB 缓冲池使用情况
    cursor.execute("SHOW GLOBAL STATUS LIKE 'Innodb_buffer_pool_pages_%'")
    buffer_pool_pages = cursor.fetchall()

    cursor.close()
    conn.close()

    return {
        'innodb_buffer_pool_size': buffer_pool_size,
        'innodb_buffer_pool_pages': buffer_pool_pages
    }

# 示例调用
memory_usage = get_mysql_memory_usage('localhost', 'root', 'password', 'testdb')
print(memory_usage)