mysql is full_mysql内存表table xxx is full解决

数据库插入错误解析

最新推荐文章于 2023-06-20 21:14:31 发布

原创最新推荐文章于 2023-06-20 21:14:31 发布 · 375 阅读

0 ·

CC 4.0 BY-SA版权

文章标签：

#mysql is full

本文记录了一次在执行大量数据插入操作时遇到的错误'Thetable't_heap_log_action_game_dairy'isfull'，并详细展示了出现问题的具体SQL语句。通过分析可以发现，此错误与表空间满有关。

Last_Error: Error 'The table 't_heap_log_action_game_dairy' is

full' on query. Default database: 'fxtv_log'. Query: 'INSERT INTO

`t_heap_log_action_game_dairy` VALUES

(173522,368316,761217,23,20161024,1),(173523,368317,761217,23,20161024,1),(173524,843465,0,7,20161024,1),(173525,321557,19196,4,20161024,1),(173526,729559,1848213,29,20161024,1),(173527,1004730,0,29,20161024,1),(173528,772424,0,23,20161024,1),(173529,731819,0,7,20161024,1),(173530,282683,50399,16,20161024,1),(173531,344256,0,1196,20161024,1),(173532,319421,0,29,20161024,1),(173533,411831,1725387,747,20161024,1),(173534,964798,1995373,29,20161024,1),(173535,411831,0,4,20161024,1),(173536,282683,50399,3258,20161024,1),(173537,177089,353693,4393,20161024,1),(173538,833704,0,29,20161024,1),(173539,967091,85573,3469,20161024,4),(173540,967091,85573,3813,20161024,2),(173541,361768,1695452,4,20161024,1),(173542,700237,2005457,29,20161024,2),(173543,90224,105382,16,20161024,1),(173544,971993,1998145,4,20161024,1),(173545,180549,437200,507,20161024,1),(173546,25982