We are seeing our db spike to 100% CPU usage occasionally and using MySql workbench I see a lot of queries that are essentially searches for content or content created by users (via xenforo/library/XenForo/Search/SourceHandler/MySqlFt.php). I'm not sure if this is what's causing the issue but the queries frequently have the status of "waiting for table lock" and running one of the example queries took 50 seconds to return a result.
Is this an obvious case for https://xenforo.com/help/enhanced-search? I believe we had it before but it stopped working and then we migrated to 1.3 (with new engineers) so any knowledge of that is probably gone. If it is something we need to do, can we do something to help mitigate the slowness until we migrate? Disabling search is obviously an extreme measure but anything else from the db side?