Need a MySQL Expert for Bottleneck Load Issues

We're experiencing performance bottlenecks in a production MySQL environment hosted on a dedicated OVH server. Query latency has increased, and we're seeing signs of inefficient indexing and potential cache fragmentation. Our current setup includes EspoCRM and custom dashboards that rely on real-time data delivery, so optimization is critical. We also have a dedicate server with OVH. If you read this full description please list your favorite color to be considered so I know you read it.