after upgrade to 6.2.2 my CPU usage become 100% even if no users online.
JAY Please use top to see what process is taking up cpu
top
its sql. https://gyazo.com/596bebe01c8a345fce0b77fe40664b11
JAY This has nothing to do with panel updates. You can check if there is a slow query or run this command show full processlist; to see what mysql is doing now.
show full processlist;
this is what most users need this features to see what is happening with sql which query is runing more cpu and how to fix it. https://gyazo.com/9c7adaf522fb3a082342895d779ddafe
jazz1611 Hello, I can't reproduce this bug, can you try to repair the panel.
aaPanel_Jose hello, seem it bug come from my browser. also can you make set other port of webserver to default when add site? this just support site without SSL can other port but SSL always set 443, if i want set SSL to other port need edit in .conf. I use nginx or apache is backend and other webserver is frontend.
jazz1611 The ssl port panel is limited to 443. You can manually change port 443 to another port in the site configuration file after applying for a certificate.
jose any fix for me
JAY Your problem is that mysql has a lot of update statements in execution. you need to troubleshoot the program or if you try to restart mysql
aaPanel_Jose it was not happening before only after update tried restart and even upgraded sql to mariadb latest version.
@aaPanel_Jose hello, i know it related to SSL port limit. i was integrated the vDDoS (https://github.com/duy13/vDDoS-Protection) to aaPanel with (https://github.com/duy13/vDDoS-Auto-Add) and working fine with good DDoS Protection. vDDoS-Protection is frontend, Nginx or Apache is backend. if you can make custom port as default when add site is great!!!
jazz1611 If deploying ssl allows custom ports, it may cause problems for other users, let me consider
JAY emmm, but the panel does not actively connect to mysql, you try to stop the panel run bt stop(will not affect your business), and then observe whether the mysql load has dropped
bt stop
Its possible to code new function like user management?
ijazlink We are considering this matter
how to delete imported databases.no option to delete them
JAY The uploaded database file will be stored here, delete the corresponding file. /www/backup/database
We will add the delete button as soon as possible.
Current I using CyberPanel but i will move to AAPanel
tiendungdev what is the reasons of moving ?