mysql查看数据库空间

-- 查看所有数据库的大小
SHOW DATABASES LIKE 'your_database_name';

-- 查看特定数据库的大小
SELECT table_schema AS `Database`, 
       SUM(data_length + index_length) / 1024 / 1024 AS `Size (MB)` 
FROM information_schema.TABLES 
WHERE table_schema = 'your_database_name' 
GROUP BY table_schema;

du -sh /path/to/your/mysql/data/directory

import mysql.connector

def get_database_size(host, user, password, database):
    conn = mysql.connector.connect(host=host, user=user, password=password, database=database)
    cursor = conn.cursor()
    
    query = """
    SELECT table_schema AS `Database`, 
           SUM(data_length + index_length) / 1024 / 1024 AS `Size (MB)` 
    FROM information_schema.TABLES 
    WHERE table_schema = %s 
    GROUP BY table_schema;
    """
    
    cursor.execute(query, (database,))
    result = cursor.fetchone()
    
    cursor.close()
    conn.close()
    
    return result

# 使用示例
size_info = get_database_size('localhost', 'your_user', 'your_password', 'your_database')
print(f"Database Size: {size_info[1]} MB")