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?
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?