Docker下解决mysql出现

Docker下解决mysql出现"the table is full"的问题

Scroll Down

Docker修改mysql的配置

Mysql错误日志中打印"The Table xxx is full"

  1. 首先保证mysql服务active状态

image-20200723030238690

  1. 进入mysql容器中

docker exec -it mysql-dev /bin/bash

image-20200723030717015

  1. 查看max_heap_table_size

image-20200723031000061

  1. 修改/etc/my.cnf文件注意这里的my.cnf是容器里面的配置文件,重要的事说三遍:容器内部,容器内部,容器内部!!!切记不要自做聪明,退出当前bash,去修改外面的/etc/my.cnf!

    vim /etc/mysql/my.cnf

image-20200723031511199

image-20200723031610426

  1. 重启mysql容器

    docker restart mysql-dev

image-20200723031805554

  1. 查看结果

image-20200723031409949