Linux : Couldn’t execute ‘SHOW TRIGGERS LIKE ‘table_name”: Got error 28 from storage engine

By | December 7, 2013

Having this error performing task on your MySQL database?

Couldn’t execute ‘SHOW TRIGGERS LIKE ‘table_name”: Got error 28 from storage engine (1030)

This might happen under those two circumstances :

Your filesystem is full > [ make some room or add more storage! ]
You’ve reached the maximum open file > [ increase the maximum file descriptor ]

You can display the maximum open file limit directly in MySQL as followed :

mysql> SHOW VARIABLES LIKE 'Open_files_limit';
+------------------+-------+
| Variable_name    | Value |
+------------------+-------+
| open_files_limit | 1024  |
+------------------+-------+
1 row in set (0.00 sec)

Alternatively you can also check it out at the OS level :

ulimit -a

To increase the maximum open file descriptor, simply do :

ulimit -n <value>

(replace <value> with the desired number of open file permitted)

*The previous command won’t survive to reboot, value will return to default (1024). To make it permanent, edit the following :

/etc/security/limits.conf

And add (or modify) :

*     hard     nofile     <value>