MySQL之The table 'XXX' is full

1.扩展数据库表的大小:  

    tmp_table_size = 256M
    max_heap_table_size = 256M

    windows: mysql 找到my.ini 下[mysqld]   添加如上代码

    linux: vim /etc/my.cnf 下[mysqld] 添加如上代码

    或者: 进入到myslq 中,执行命令

   [root@localhost etc]# vi /etc/rc.d/init.d/mysql
   找到
   $bindir/mysqld_safe –datadir=$datadir –pid-file=$pid_file >/dev/null 2>&1 &
   修改为
   $bindir/mysqld_safe –datadir=$datadir –pid-file=$pid_file -O tmp_table_size=64M -O max_heap_table_size=32M >/dev/null 2>&1 &

   然后重启 mysql 

   service mysqld stop

   service mysqld start
 

转载至 https://blog.csdn.net/nv_ting/article/details/78481191 

posted @ 2019-05-17 19:43  TroubleBoy丶  阅读(111)  评论(0编辑  收藏  举报