import to mysql show error 500

navid

Member
Apr 21, 2015
7
1
51
m
cPanel Access Level
Reseller Owner
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?
 

cPanelLauren

Product Owner
Staff member
Nov 14, 2017
13,296
1,252
313
Houston
I would recommend you enlist the assistance of a qualified system administrator, to troubleshoot the issue. You might also look into tools like MySQL Tuner to get an idea of what is occurring, If you are not comfortable performing these actions, I would recommend you work with your system administrator to ensure the integrity of your system. If you do not have a system administrator, you may be able to find assistance at System Administration Services.
 

navid

Member
Apr 21, 2015
7
1
51
m
cPanel Access Level
Reseller Owner
I follow this
Code:
To optimize your mariadb parameters you can use the Tuning-Primer.sh script. First, install additional tools:

yum install bc net-tools -y

Download the optimization script:

wget https://launchpadlibrarian.net/78745738/tuning-primer.sh

Assign the execute permissions to a .sh file:

chmod +x tuning-primer.sh

Run the script:

./tuning-primer.sh
on the 2 servers
and parameters be same.