0
votes
1answer
37 views

Re-ocurring issue with keys on temp tables

We run a large forum with lots of reads and writes, particularly to the posts and topics tables which are both innodb. Last week I started doing 12 hourly backups with innobackupex because mysqldump ...
0
votes
0answers
83 views

Mysql tmp file cause site exception error crash

Running Magento and every 3-15 days or so (fairly random) I get this error: exception 'Zend_Db_Statement_Exception' with message 'SQLSTATE[HY000]: General error: 1 Can't create/write to file ...
0
votes
3answers
860 views

mysql: Shall I change the mysql tmpdir from /tmp to /var/lib/mysql/tmp

Recently on one of the prodcution servers we have seen the replication being stopped due to the space issues on the /tmp drive which is having less space allocated. I would like to move the tmpdir ...
0
votes
2answers
84 views

applications unable to use /tmp

The disk on a Ubuntu server filled up causing a website to fail and some database corruption. After freeing some space (rogue wordpress backup plugin) and reimporting the database we found some ...