2

I had to change the tmpdir directory from /tmp to /db/tmp/ folder due to the fact I didn't have enough space. When I changed my path and I ran SHOW ENGINES; I got below result;

  1. ARCHIVE
  2. MRG_MYISAM
  3. CSV
  4. MYISAM
  5. MEMORY

But, when I changed the directory back to /tmp my Innodb engine came back. SHOW ENGINES;

  1. ARCHIVE
  2. MRG_MYISAM
  3. CSV
  4. MYISAM
  5. MEMORY
  6. InnoDB

Does anyone know why MySQL is acting strange like that? This is a show stopper for me and causing my production server to crash.

John Gardeniers
  • 27,458
  • 12
  • 55
  • 109
Kourosh Samia
  • 321
  • 1
  • 5
  • 12

1 Answers1

0

You should add the following to /etc/my.cnf

[mysqld]
tmpdir=/db/tmp

then service mysql restart (For tmpdir, restart is required)

Also, run this in Linux just in case:

$ chown mysql:mysql /db/tmp
$ chmod 777 /db/tmp

Give it a Try !!!

RolandoMySQLDBA
  • 16,544
  • 3
  • 48
  • 84