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>