PHP + Mysql terrible slow import

[guest29]

Hello friends.

I'm experiencing a strange issue with a CentOS server with Directadmin 1.44.3, PHP 5.3.28 Fastcgi, Mysql 5.1.

Premises: I've tried all types of system profiling and troubleshooting without finding any bottleneck: strace, sysdig and other profiling tools. Mysql is heavy tuned. DB's are optimized.

Problem is that a Php script that import circa 10.000 csv rows take almost 15 minutes to finish. I've tested the script on tons of other platforms with this results:

- same CentOS server with Directadmin 1.44.3, PHP 5.3.28 Mod Php, Mysql 5.1 (and Mysql 5.5 + 5.6): execution time circa 15 min

- same CentOS server with Directadmin 1.44.3, PHP 5.3.28 suPhp, Mysql 5.1 (and Mysql 5.5 + 5.6) execution time circa 15 min

- another CentOS server with Directadmin 1.44.3, PHP 5.3.28 Fastcgi, Mysql 5.1: execution time circa 7 min (!!)

- cheap hosting provider PHP 5.3.28, Mysql 5.1: execution time circa 1 min (!!)

- CentOS server with Cpanel, PHP 5.3.28, Mysql 5.1: execution time circa 7 min

My question is: there are limits for query per account on newer version of Directadmin that I'm not aware of?

Regards

G.

 

[SeLLeRoNe]

Definitly not a DA problem, i suppose just a MySQL configuration thing, check /etc/my.cnf and look for mysqlotuner to improove mysql speed.

Also, i would suggest you to update (if you can) to MySQL 5.5/5.6 that are quite faster than 5.1

Regards