MySQL is always overloaded. What limits can be adjusted?" Adjusting settings makes no difference.

admin

The MySQL server is always full. What methods can be used to limit this? Adjusting settings does not seem to work.
Table locks         9854         If the value is too large, please consider increasing your database performance.
It's back again with lots of queries on a certain field.
SELECT COUNT(*) FROM `mac_vod` WHERE `vod_status`=1 AND (`vod_rel_vod` LIKE '%李立宏%' OR `vod_rel_vod` LIKE '%陈晓卿%' OR `vod_rel_vod` LIKE '%任长箴%' OR `vod_rel_vod` LIKE '%程工%') GROUP BY `vod_time` ORDER BY `vod_time` DESC LIMIT 0,6;