Optimize Database

We have a project in the field of online fitness with more than 5 years of history.
There are problems with a swollen and poorly optimized database (mysql)
The essence of the task: to analyze the structure, to give recommendations for optimization, ideally - to implement.

Stack: php (october cms), vue js, rest api