hello
my vp server information:
cpanel 90.0.15
mariadb 10.3
centos7.8
cpu 6 core
ram 5 G
my db have 550 table and 1Mb size and 1550 queries
when import db , after 20 min show internal server error 500
or when delete it slow response to me
or when drop 250 table.
my db is normal and it import fast in another server account
I set in my.cnf:
performance-schema=0
innodb_buffer_pool_size=1GB
max_allowed_packet=268435456
open_files_limit=55000
innodb_file_per_table=1
sql_mode=""
table_open_cache = 4000
log_error=/var/log/mysql/mysql_error1.log
general_log = on
slow_query_log = on
query_cache_size=0
query_cache_type=0
query_cache_limit=0
join_buffer_size=512K
tmp_table_size=128M
innodb_log_file_size=128M
innodb_buffer_pool_instances=1
but no effect
-----------------------------------
other section of cpanel or file manager are fast but mysql is slow
What is limiting and queuing?
my vp server information:
cpanel 90.0.15
mariadb 10.3
centos7.8
cpu 6 core
ram 5 G
my db have 550 table and 1Mb size and 1550 queries
when import db , after 20 min show internal server error 500
or when delete it slow response to me
or when drop 250 table.
my db is normal and it import fast in another server account
I set in my.cnf:
performance-schema=0
innodb_buffer_pool_size=1GB
max_allowed_packet=268435456
open_files_limit=55000
innodb_file_per_table=1
sql_mode=""
table_open_cache = 4000
log_error=/var/log/mysql/mysql_error1.log
general_log = on
slow_query_log = on
query_cache_size=0
query_cache_type=0
query_cache_limit=0
join_buffer_size=512K
tmp_table_size=128M
innodb_log_file_size=128M
innodb_buffer_pool_instances=1
but no effect
-----------------------------------
other section of cpanel or file manager are fast but mysql is slow
What is limiting and queuing?