MySql磁盘占满，阿里云提示“The MySQL server is running with the LOCK_WRITE_GROWTH option so it cannot execute “_the mysql server is running with the lock_write op-CSDN博客

网友收藏2023-11-11 17:24

链接地址：https://blog.csdn.net/f2315895270/article/details/118889613
链接标题：MySql磁盘占满，阿里云提示“The MySQL server is running with the LOCK_WRITE_GROWTH option so it cannot execute “_the mysql server is running with the lock_write op-CSDN博客
所属网站：blog.csdn.net
被收藏次数：5707

文章浏览阅读4.3k次，点赞2次，收藏3次。今天照常打开日志文件查看日志，结果发现一大堆报错：“The MySQL server is running with the LOCK_WRITE_GROWTH option so it cannot execute this statement”，遂查了一下原来是阿里云的数据库被锁了锁住的原因是因为磁盘占用满了，触发了阿里云的保护机制，自动给锁上了我们可以去分析一下是哪些表占用了多的空间，通过命令select TABLE_NAME, concat(truncate(data_length/10_the mysql server is running with the lock_write option so it cannot execute

本文地址：https://tebull.com/detail/150066.html

标签：the mysql server is running with the lock_write option so it cannot execute