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 :

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

To increase the maximum open file descriptor, simply do :

(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 :

And add (or modify) :