M
M
Magi2016-04-07 22:52:00
MySQL
Magi, 2016-04-07 22:52:00

How to remove the error The table '/tmp/mysql/#sql_xxxxx' is full?

Ubuntu server 15.10, php5.6, nginx 1.9.3, mysql 5.7 in a virtual machine under Hyper-V in Windows 10
I set up seo-url in opencart 2, which is in the site subdirectory on joomla 3.5 After enabling seo in the opencart settings
In the mysql log
[ERROR] InnoDB: Tablespace innodb_temporary ran out of space errors appear . Please add another file or use 'autoextend' for the last file in setting innodb_temp_data_file_path
[ERROR] /usr/sbin/mysqld: The table '/tmp/mysql/#sql_c76e_2' is full [ERROR] /usr/sbin/mysqld: The table '/tmp/mysql/#sql_c76e_3' is full
I did this
mkdir /tmp/mysql
chown mysql:mysql /tmp/mysql
service mysql restart
There are rights, but there is not a single file in /tmp/mysql/.
In mysqld.cnf
Section InnoDB
innodb_flush_method = O_DIRECT
innodb_log_files_in_group = 2
innodb_log_file_size = 5M
innodb_flush_log_at_trx_commit = 1
innodb_file_per_table = 1
innodb_buffer_pool_size = 1G
innodb_log_buffer_size = 8M
innodb_max_undo_log_size = 50M
innodb_temp_data_file_path = ibtmp1: 12M: autoextend: max: 512M
If remove the restriction to 512 M, the file fills all the free place in a few minutes.
innodb_data_file_path = ibdata1:10M:autoextend:max:512M
innodb_thread_concurrency = 8
innodb_buffer_pool_instances = 8
innodb_buffer_pool_dump_pct = 75
innodb_flush_log_at_trx_commit = 0
sync_binlog = 0
innodb_io_capacity = 600
innodb_io_capacity_max = 1000
innodb_read_io_threads = 32
innodb_write_io_threads = 16
innodb_fast_shutdown = 0
innodb_max_dirty_pages_pct = 0
df -h
Fayl.sistema Size Used Used Dost% Cmontirovano in
udev 5,0G 5,0G 0 0% / dev
tmpfs 1,0G 110M 915M 11 % /run
/dev/sda2 35G 22G 12G 65% /
tmpfs 5.0G 0 5.0G 0% /dev/shm
tmpfs 5.0M 0 5.0M 0% /run/lock
tmpfs 5.0G 0 5.0G 0 % /sys/fs/cgroup
/dev/sda1 511M 3.4M 508M 1% /boot/efi
tmpfs 1.0G 0 1.0G 0% /run/user/1000

Answer the question

In order to leave comments, you need to log in

1 answer(s)
M
Magi, 2016-04-08
@Magi

$ df -h /tmp
Filesystem Size Used Ext Used% Mounted on
/dev/sda2 35G 22G 12G 64% /
$ df -i /tmp
Filesystem Inodes IUsed IFree IUsed% Mounted on
/dev/sda2 2331072 257846 2073226 12 % /

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question