How speed up the Importing large amount of data to database?

[josephgodwinke]

Hello @rssperky

There are several options choose one

MySQL optimization on CyberPanel

CyberPanel v1.7.7 and above gives you ability optimize and view MySQL status via platform. Register your self on cloud platform if you haven’t already, once registered you need to connect your server from here (Make sure you are on version 1.7.7 or above, you can visit upgrade instructions) MySQL Status Once your server is connected to platform, visit https://platform.cyberpanel.net/mysql//status Replace server name with name of your server in Cloud Platform. You will see something like: …

MariaDB / MySQL Tweaks As Default & Option

I recently had a support ticket where my web site had gone down, the admin panel was inaccessible, and all manner of other things were broken (FTP). Many services in a cyberpanel install depend on MySQL. The default MySQL config file (/etc/my.cnf) is bare-bones. There are really no options in it. This lead to my innodb-powered sites to suffer near 100% CPU usage on a high load site. I came up with a fix for it that served as good tweaks for both myisam and innodb. Here’s what I came up with: […