uploading a .sql in phpmyadmin

[robbie_troster]

Uploading a .sql in phpmyadmin apasulty kills the load

Uploading a 2mb .sql is using 87.5cpu!

Load usually around 2.4cpus

when .sql is on it hits 90.3! - This is a Quad Core Xeon vps


Processor #1 Vendor: GenuineIntel
Processor #1 Name: Intel(R) Xeon(R) CPU X3360 @ 2.83GHz
Processor #1 speed: 708.410 MHz
Processor #1 cache size: 6144 KB

Processor #2 Vendor: GenuineIntel
Processor #2 Name: Intel(R) Xeon(R) CPU X3360 @ 2.83GHz
Processor #2 speed: 708.410 MHz
Processor #2 cache size: 6144 KB

Processor #3 Vendor: GenuineIntel
Processor #3 Name: Intel(R) Xeon(R) CPU X3360 @ 2.83GHz
Processor #3 speed: 708.410 MHz
Processor #3 cache size: 6144 KB

Processor #4 Vendor: GenuineIntel
Processor #4 Name: Intel(R) Xeon(R) CPU X3360 @ 2.83GHz
Processor #4 speed: 708.410 MHz
Processor #4 cache size: 6144 KB


Please help.... It is causing all the accounts on our vps to either load slowly or not load at all!

I'm thinking.. would using a remote MySQL solve this? if so, what do I have to do to set it up?

 

[Infopro]

Restore it from shell. Something like this should work.

mysql -u robbie_robbie -p robbie_robbiesdb < /home/robbie/DB_bu/robbie_robbiesdb.sql

 

[robbie_troster]

Restore it from shell. Something like this should work.

mysql -u robbie_robbie -p robbie_robbiesdb < /home/robbie/DB_bu/robbie_robbiesdb.sql

Yes, however I am on about clients.. They arn't allowed access to the root SSH so they do it via phpmyadmin (that's what it is there for)

Why does it create a heavy load? It scares me as I don't want a crashed server.

 

[Data 1]

Even if you could restore shell it would slow down.

IN MY OPINION they probably have too many accounts on the server. That's why I either say "shared" or "dedicated" because VDS/VPS is just a fancy way of doing shared. A server with too many people on it will be slow no matter what.

The type of site matters also. I have seen servers with 1000 accounts, all simple HTML pages and very fast. I have seen equal class servers with 20 heavy usage bulletin boards slow to a crawl.

Is that standard for a 3360 to only show 3/4 G clock? I have one 3220 that shows.... well I'll print it. Looks like you have more L2 though-

Processor #1 Vendor: GenuineIntel
Processor #1 Name: Intel(R) Xeon(R) CPU X3220 @ 2.40GHz
Processor #1 speed: 1596.000 MHz
Processor #1 cache size: 4096 KB

Processor #2 Vendor: GenuineIntel
Processor #2 Name: Intel(R) Xeon(R) CPU X3220 @ 2.40GHz
Processor #2 speed: 2394.000 MHz
Processor #2 cache size: 4096 KB

Processor #3 Vendor: GenuineIntel
Processor #3 Name: Intel(R) Xeon(R) CPU X3220 @ 2.40GHz
Processor #3 speed: 1596.000 MHz
Processor #3 cache size: 4096 KB

Processor #4 Vendor: GenuineIntel
Processor #4 Name: Intel(R) Xeon(R) CPU X3220 @ 2.40GHz
Processor #4 speed: 2394.000 MHz
Processor #4 cache size: 4096 KB

 

[robbie_troster]

This server has 104 accounts on it.

3.5Gigs of RAM which is plenty.

What I don't understand is why is it using 80% of the CPU? it never used to do that?!

 

[Infopro]

Is this with any database or one specifically?

 

[robbie_troster]

It happens for any database - new and old..... :/ ?

 

[Infopro]

Strange. If there was some sort of issue with the DB sure, but otherwise, not sure what the problem might be. A 2MB .sql should be able to be restored in seconds.

You might like to put in a ticket to cPanel and let them give it a go themselves to see if they can recreate the issue.