Optimize PSA database to prevent disk based temporary tables & improve performance
On a server that only runs Plesk as a mailserver and no website hosting I noticed that a bare Plesk 12 install
1 Uses a lot of joins without indexes
2 Uses a lot of queries that force temporary tables on disk instead of in-memory
3 Aborts plenty of connections without properly closing them
As mysqltuner reports:
[!!] Temporary tables created on disk: 45% (14K on disk / 32K total)
[!!] Connections aborted: 14%
It seems to me the PSA database design could do with a little love and optimization.
pleskiddie
shared this idea
Unfortunately, we have to close your request, because over the years it has not become quite popular for further implementation.
—
IG
-
Chris
commented
I would also like to see this done as it makes panel feel more sluggish that it should. Currently we use PSA database as an example of what not to do with regards to db construction and why for our developers.