There is a substantial MySQL database with data weighting hundreds of gigabytes. It experiences performance problems. Vertical and horizontal partitioning of tables are possible roads to increase performance.
In your opinion would splitting this database into several databases be beneficial to increase performance as well?
The project is based on Rails