Keep banging my head against this and can't seem to get anywhere. I've got a dev site up on Centos 6.6 using KVM, with 4 cores and 8 GB of RAM allocated and PHP 5.3.3. I'm testing a large import via the web interface import. When I do, I've noticed that the box never uses more than 25% CPU and only has one thread for Apache. That 25% CPU usage all sits on one CPU core, effectively maxing it out. The worrisome thing is, I also can't open another instance of WordPress while this is running. That means that one user could lock out the whole box with a large report or mass deletion! (BTW, same thing happens on mass deletion of the 35,000 records, so it's not just the web import script.)
BTW: The host server isn't that busy and is nowhere near maxed out. Also, other tasks show that there is no bottle-necks in the usual places like CPU, network, or disk usage.
Things I've tried:
- Upping php.ini memory_limit - No changes
- Changing a thousand parameters in MySQL, mainly memory - No changes
- Upping max children in php.ini - No changes
- Adding FastCGI+PHP-FPM - No changes
- Adding WP-Super Cache - No changes
- Adding Memcached - No changes
- Upping file descriptors - No changes
- Adding Max Memory line to wp-config - No changes Who knows what else I've forgotten I've tried
Anybody have any ideas here?