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 :
1 2 3 4 5 6 7 |
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 :
1 |
ulimit -a |
To increase the maximum open file descriptor, simply do :
1 |
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 :
1 |
/etc/security/limits.conf |
And add (or modify) :
1 |
* hard nofile <value> |