- My Freespirits
- Freespirits Forum
- Main Forum
- English Section
- Mysql
- Slow performance of the MySQL on Plesk server
×
English Section!
We will be more than happy to help you with problems related to our services and products. Please feel free to write it down as clear as possible
We will be more than happy to help you with problems related to our services and products. Please feel free to write it down as clear as possible
Slow performance of the MySQL on Plesk server
- infogate
- Συντάκτης θέματος
- Αποσυνδεμένος
- Administrator
- Imagination is the beginning of creation
6 Χρόνια 2 Μήνες πριν - 6 Χρόνια 2 Μήνες πριν #36
από infogate
The best possible way to start your online marketing : fspirits.com/go/leadsleap-home
Explode Your Web Site Traffice: fspirits.com/go/sparktraffic
Start your affiliate journey here: fspirits.com/go/olsp-academy
Best Solution To Create Videos: fspirits.com/go/create-studio-pro
Best Solution To Create Graphics: fspirits.com/go/clickdesigns
Smart Chat Automation: fspirits.com/go/chatterpal
Multi-Purpose Video Maker: fspirits.com/go/avatar-builder
Multi-Purpose Video Creator: fspirits.com/go/video-creator
AI Human Spokesperson Videos: fspirits.com/go/humanpal
Slow performance of the MySQL on Plesk server δημιουργήθηκε από infogate
Symptoms
General Troubleshooting
1. Connect to the Plesk server via SSH or RDP.
2. Open the MySQL configuration file my.cnf or my.ini in any text editor. Locations of the file are:
- for CentOS/RHEL:- for Debian/Ubuntu:- For Windows:
3. Add the following directives under the [mysqld] section or increase the values if these directives are already defined:
4. Save the changes and close the file.
5. Restart the MySQL service:
- for CentOS/RHEL:-for Debian/Ubuntu:-for Windows:
Open Task Manager > Services and restart MySQL56 (or MySQL51) service:
6. Analyze and optimize all tables in all databases:
- for Linux:- for Windows:
- Server is slow due to high CPU usage caused by the "mysql" process.
- According to this KB article there are multiple slow queries.
- Websites that are using MySQL databases operate slow.
- Database dump takes too much time to complete.
General Troubleshooting
1. Connect to the Plesk server via SSH or RDP.
2. Open the MySQL configuration file my.cnf or my.ini in any text editor. Locations of the file are:
- for CentOS/RHEL:
/etc/my.cnf
/etc/mysql/my.cnf
%plesk_dir%Databases\MySQL\my.ini
3. Add the following directives under the [mysqld] section or increase the values if these directives are already defined:
innodb_buffer_pool_size=1024M
query_cache_size=64M
4. Save the changes and close the file.
5. Restart the MySQL service:
- for CentOS/RHEL:
# service mysqld restart
# service mysql restart
Open Task Manager > Services and restart MySQL56 (or MySQL51) service:
6. Analyze and optimize all tables in all databases:
- for Linux:
# MYSQL_PWD=`cat /etc/psa/.psa.shadow` mysqlcheck -uadmin --optimize --all-databases
%plesk_dir%\MySQL\bin\mysqlcheck.exe -uadmin -P3306 --optimize --all-databases
The best possible way to start your online marketing : fspirits.com/go/leadsleap-home
Explode Your Web Site Traffice: fspirits.com/go/sparktraffic
Start your affiliate journey here: fspirits.com/go/olsp-academy
Best Solution To Create Videos: fspirits.com/go/create-studio-pro
Best Solution To Create Graphics: fspirits.com/go/clickdesigns
Smart Chat Automation: fspirits.com/go/chatterpal
Multi-Purpose Video Maker: fspirits.com/go/avatar-builder
Multi-Purpose Video Creator: fspirits.com/go/video-creator
AI Human Spokesperson Videos: fspirits.com/go/humanpal
Last edit: 6 Χρόνια 2 Μήνες πριν by infogate.
Παρακαλούμε Σύνδεση ή Δημιουργία λογαριασμού για να συμμετάσχετε στη συζήτηση.
- infogate
- Συντάκτης θέματος
- Αποσυνδεμένος
- Administrator
- Imagination is the beginning of creation
6 Χρόνια 2 Μήνες πριν - 6 Χρόνια 2 Μήνες πριν #37
από infogate
The best possible way to start your online marketing : fspirits.com/go/leadsleap-home
Explode Your Web Site Traffice: fspirits.com/go/sparktraffic
Start your affiliate journey here: fspirits.com/go/olsp-academy
Best Solution To Create Videos: fspirits.com/go/create-studio-pro
Best Solution To Create Graphics: fspirits.com/go/clickdesigns
Smart Chat Automation: fspirits.com/go/chatterpal
Multi-Purpose Video Maker: fspirits.com/go/avatar-builder
Multi-Purpose Video Creator: fspirits.com/go/video-creator
AI Human Spokesperson Videos: fspirits.com/go/humanpal
Απαντήθηκε από infogate στο θέμα Slow performance of the MySQL on Plesk server
Παρακαλούμε συνδεθείτε για να δείτε τις απαντήσεις
The best possible way to start your online marketing : fspirits.com/go/leadsleap-home
Explode Your Web Site Traffice: fspirits.com/go/sparktraffic
Start your affiliate journey here: fspirits.com/go/olsp-academy
Best Solution To Create Videos: fspirits.com/go/create-studio-pro
Best Solution To Create Graphics: fspirits.com/go/clickdesigns
Smart Chat Automation: fspirits.com/go/chatterpal
Multi-Purpose Video Maker: fspirits.com/go/avatar-builder
Multi-Purpose Video Creator: fspirits.com/go/video-creator
AI Human Spokesperson Videos: fspirits.com/go/humanpal
Last edit: 6 Χρόνια 2 Μήνες πριν by infogate.
Παρακαλούμε Σύνδεση ή Δημιουργία λογαριασμού για να συμμετάσχετε στη συζήτηση.
- infogate
- Συντάκτης θέματος
- Αποσυνδεμένος
- Administrator
- Imagination is the beginning of creation
7 Μήνες 1 Ημέρα πριν #307
από infogate
The best possible way to start your online marketing : fspirits.com/go/leadsleap-home
Explode Your Web Site Traffice: fspirits.com/go/sparktraffic
Start your affiliate journey here: fspirits.com/go/olsp-academy
Best Solution To Create Videos: fspirits.com/go/create-studio-pro
Best Solution To Create Graphics: fspirits.com/go/clickdesigns
Smart Chat Automation: fspirits.com/go/chatterpal
Multi-Purpose Video Maker: fspirits.com/go/avatar-builder
Multi-Purpose Video Creator: fspirits.com/go/video-creator
AI Human Spokesperson Videos: fspirits.com/go/humanpal
Απαντήθηκε από infogate στο θέμα Slow performance of the MySQL on Plesk server
Παρακαλούμε συνδεθείτε για να δείτε τις απαντήσεις
The best possible way to start your online marketing : fspirits.com/go/leadsleap-home
Explode Your Web Site Traffice: fspirits.com/go/sparktraffic
Start your affiliate journey here: fspirits.com/go/olsp-academy
Best Solution To Create Videos: fspirits.com/go/create-studio-pro
Best Solution To Create Graphics: fspirits.com/go/clickdesigns
Smart Chat Automation: fspirits.com/go/chatterpal
Multi-Purpose Video Maker: fspirits.com/go/avatar-builder
Multi-Purpose Video Creator: fspirits.com/go/video-creator
AI Human Spokesperson Videos: fspirits.com/go/humanpal
Παρακαλούμε Σύνδεση ή Δημιουργία λογαριασμού για να συμμετάσχετε στη συζήτηση.
- My Freespirits
- Freespirits Forum
- Main Forum
- English Section
- Mysql
- Slow performance of the MySQL on Plesk server
Χρόνος δημιουργίας σελίδας: 0.060 δευτερόλεπτα