The default database is SQLite not MySQL. SQLite is not recommended for working with lots of data and high write volumes.
Check “When Not TO Use SQLite” here.
What I would recommend is, to start excluding entities, for which you don’t need any history like sun.sun or sensor.time.
Check this thread here.