`
fantaxy025025
  • 浏览: 1327972 次
  • 性别: Icon_minigender_1
  • 来自: 北京
社区版块
存档分类

【Mysql数据库】Cause: java.sql.SQLException: The table 'xxx' is full

 
阅读更多

=

本地开发测试,怎么会有这个问题呢?

原因是:磁盘满了。注意应该是快满了,实际情况是我的开发机还有2g就报错,可见mysql还挺人性化,不会搞死机器再报错。

=

Cause: java.sql.SQLException: The table 'xxx' is full

### Cause: java.sql.SQLException: The table 'xxx' is full

; uncategorized SQLException; SQL state [HY000]; error code [1114]; The table 'xxx' is full; nested exception is java.sql.SQLException: The table 'xxx' is full

 

 

 

If you encounter a full-table error, there are several reasons why it might have occurred:

原因1。

The disk might be full.

原因2。 

You are using InnoDB tables and have run out of room in an InnoDB tablespace file. The maximum tablespace size is also the maximum size for a table. For tablespace size limits, see Section 14.6.1.6, “Limits on InnoDB Tables”.

Generally, partitioning of tables into multiple tablespace files is recommended for tables larger than 1TB in size.

原因3。 

You have hit an operating system file size limit. For example, you are using MyISAM tables on an operating system that supports files only up to 2GB in size and you have hit this limit for the data file or index file.

原因4。 

You are using a MyISAM table and the space required for the table exceeds what is permitted by the internal pointer size. MyISAM permits data and index files to grow up to 256TB by default, but this limit can be changed up to the maximum permissible size of 65,536TB (2567 − 1 bytes).

————————————————

from:https://blog.csdn.net/db2china/article/details/84934947

 

对应的解决办法:

一、首先打开后台日志,进行新增或者修改的操作,看看日志后台是否有异常

 

二、于是就修改Mysql的配置文件my.ini,在[mysqld]下添加/修改两行:
tmp_table_size = 256M
max_heap_table_size = 256M
系统默认是16M,修改完后重启mysql

 

三. 硬盘空间满了,清理硬盘即可. 

 

参考:http://blog.sina.com.cn/s/blog_b1cb04510102yci5.html 

=

=

=

 

分享到:
评论

相关推荐

Global site tag (gtag.js) - Google Analytics