Plesk Panel - very slow

[futureweb]

Hi,

one of our Plesk 12 Panels is really slow ... taking about 30-60 Seconds from sending Login Data to finally see the Start-Page of the Panel.
Ressources are the same as of our other Plesk Servers, no Ressource shortage on Server, no high CPU Load.
Don't really know where to start looking for the Slowdown?

Any advice would help!

Thx
Andreas Schnederle-Wagner

 

[IgorG]

Any results of logs investigation? Anything suspicious there?

 

[futureweb]

When accessing the Panel - no Log entries are generated within panel.log and in access.log only the requests one would expect ... so nothing suspicious!

Andreas

 

[IgorG]

Are you sure that this Plesk behaviour is not depending on used browser or network connection?

 

[futureweb]

Other Plesk Servers within the same Hosting Infrastructure working fine ... so yes ... I', sure it's not browser/network dependant.
Only difference from this Plesk Server to our others is that lots of those Hostings have been migrated with Plesk Migration Manager from a very old Plesk Server.

Andreas

 

[futureweb]

Well ... I just managed to get rid of the slowdown ... what I did was an OPTIMIZE TABLE on psa Database. Now it seems to work as fast as the other Servers ...

 

[IgorG]

Sure, useful procedure

 

[futureweb]

7 Days later - and login/Panel again really slow (login taking >20 Seconds) - did Optimize on PSA Table again - now login takes ~5-7 Seconds ...
How can it be that the Panel is getting so slow in that short time again? Any ideas how to prevent the slowdown?

As quick'n'dirty fix I introduced an optimize within my daily MySQL Backup Script:

/usr/bin/mysqlcheck -o -u $BACKUP_USER -p$BACKUP_PASS psa > /dev/null

But that's only symptom control and not getting rid of the root cause of the problem ...