[ic] mysql Errcode 28 writing /tmp
Stefan Hornburg (Racke)
racke at linuxia.de
Thu Apr 7 13:21:54 UTC 2011
On 04/07/2011 02:51 PM, Steve Graham wrote:
>> Hi Folks,
>> When trying to run one of the admin reports (Orders by Affiliate) I
>> get an
>> error that would seem to indicate mysql cannot write to /tmp
>> I have tried to find out why but haven't got very far, any advice please?
>> Here is the exact error as shown in IC admin, version is 5.6.0
>> table transactions: Query on table transactions failed: DBD::mysql::st
>> execute failed: Error writing file '/tmp/MYopm6dj' (Errcode: 28) at
>> /usr/local/interchange/lib/Vend/Table/DBI.pm line 2000.
> I run this cron job nightly....
> # remove old mysql query logs
> 30 4 * * * find /home/mysql/mysqld-bin.* -mtime +7 -type f | xargs rm -fv
> gets rid of old and sometimes very large log files...
The standard installation of Debian has the following settings in my.cnf
to prevent binary log files piling up:
expire_logs_days = 10
max_binlog_size = 100M
LinuXia Systems => http://www.linuxia.de/
Expert Interchange Consulting and System Administration
ICDEVGROUP => http://www.icdevgroup.org/
Interchange Development Team
More information about the interchange-users