526互联

The MySQL server is running with the LOCK_WRITE_GROWTH option so it cannot execute this statement

发布时间 2023-08-11 10:32:16作者: 世人皆萌

然后百度

参考：The MySQL server is running with the LOCK_WRITE_GROWTH option so it cannot execute this statement_冰尘s1的博客-CSDN博客

mysql报错The MySQL server is running with the LOCK_WRITE_GROWTH option so it cannot executethisstatem_言默夜雨的博客-CSDN博客

查询数据库剩余容量

SELECT
TABLE_SCHEMA,
concat( TRUNCATE ( sum( data_length )/ 1024 / 1024, 2 ), 'MB' ) AS data_size,
concat( TRUNCATE ( sum( index_length )/ 1024 / 1024, 2 ), 'MB' ) AS index_size
FROM
information_schema.TABLES
GROUP BY TABLE_SCHEMA
ORDER BY sum( data_length ) DESC;

字段解释

注释：
table_schema:数据库名
table_name：表名
table_rows:记录数
data_length:数据大小
index_length:数据库剩余容量
engine:所使用的存储引擎

查询系统文件

    SELECT file_name,CONCAT(TOTAL_EXTENTS,'MB') AS 'FileSize' FROM INFORMATION_SCHEMA.FILES ORDER BY TOTAL_EXTENTS DESC LIMIT 20