import to mysql show error 500

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?

navid

October 20, 2020 11:15

too I test importing by command line and it is slow

cPanelLauren

October 20, 2020 13:56

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.

October 20, 2020 14:43

I follow this

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.

October 22, 2020 10:09

solved. my data center change server vm problem was with i/o vm

import to mysql show error 500

Comments

Didn't find what you were looking for?