Could you share your server configuration so we can look from there?
It could be a disk i/o issue, that's why the hardware configuration is an important thing to know!
» www.InstantDedicated.com - Online in no time » Dedicated Servers in [EU] Netherlands with DAILY support, also on weekends » DDOS Protected network - 100% Money Back if it doesn't work for you » Streaming / IPTV allowed | Up to 10 Gbit ports | 100% Network Uptime
I have just asked they have come back with the following
It seems that MySQL is using a lot of your memory, please see the attachment. These results can be produced by using the command "top" in command line. I would advise you to optimize your MySQL configurations.
please post your my.cnf here so that we may suggest some values.
Kevin Cheri : Senior Server Administrator / Freelancer : 9+ years Exp, reach me out for any help Server Optimization Expert / Mysql Guru / Migration Specialist
Skype : lynxmaestro
Gmail : [email protected]
I would suggest you first run top -c command via SSH for some time and see which process is consuming more CPU OR RAM resources and then try to troubleshoot the issue based on the results.
██ BestServerSupport | Outsourced Hosting Support and Server Management Service Provider
██ WHM/CPanel | HyperV Virtualization | Plesk | WebsitePanel | Windows VPS | OnAPP Cloud | Virtuzoo
██ Helpdesk Support | Cloud Administration | Dedicated Support | VPS Support
[email protected] [~]# ./mysqltuner.pl
./mysqltuner.pl: line 1: --2013-02-25: command not found
./mysqltuner.pl: line 2: Resolving: command not found
./mysqltuner.pl: line 3: Connecting: command not found
./mysqltuner.pl: line 3: 220.127.116.11: command not found
./mysqltuner.pl: line 3: :80...: command not found
./mysqltuner.pl: line 4: HTTP: command not found
./mysqltuner.pl: line 5: Location:: command not found
./mysqltuner.pl: line 6: --2013-02-25: command not found
./mysqltuner.pl: line 7: Resolving: command not found
./mysqltuner.pl: line 8: Connecting: command not found
./mysqltuner.pl: line 8: 18.104.22.168: command not found
./mysqltuner.pl: line 8: :443...: command not found
./mysqltuner.pl: line 9: HTTP: command not found
./mysqltuner.pl: line 10: syntax error near unexpected token `('
./mysqltuner.pl: line 10: `Length: 41847 (41K) [text/plain]'
Magento is a known performance pig; a server that can host normal sites with no problem can struggle to host Magento. While you can make the server faster, you'll only get so far without working on the application (ie Magento).
I'd look at adding another 4Gb of memory if you can; suspect that may help a little. (I haven't checked your "top" results, just on the run at the moment).
So, generic off the cuff comments on how to make Magento faster:
read some Magento performance tips - eg use flat catalogues
Look at using one of the Magento caching plugins - 10x throughput increase, as the pages come direct from disk rather than requiring Magento to load and run
Consider using a CDN for static content
Consider using Google CND for large JS files
Enable Expiry times on static content so it is cached more
Enable compression (this isn't trivial; it makes sites load faster but uses more CPU (with Expiry times and CDN this can make your site really sing)
Get the site owners to look at the sizes of their JPEGs and see if they can be optimized - use www.webpagetest.org
As others have said, if you're running PHP as a CGI you'd be better moving to PHP-FPM or similar; the CGI mode of running PHP loads both PHP and Magento on every page hit, which is very expensive.
This is just a quick intro - but if you do most of these things you'll see a huge jump in performance and throughput.
Another thought - if some of your sites get really large they should probably be running on their own servers or VPS or AWS instance.
this is my hardware recommendation for Magento Dedicated
CloudLinux for Operation system
Min 4GB Intel Xeon Quad Core , SSD 256GB just for Boot and running apache mysql optimize Mysql and PHP and use lightspeed for apache
and i promise you can have the best server performance at very low price Best regards Max
█ CloudFastservers.com|Cloud VPS Openstack KVM |Cloud VPS Windows
█ Cloud VPS and Hosting |24/7/365 Support
█ Data center and servers location: USA Florida, Europe Netherland
We are *not* a reseller. We own our servers, switches, routers and racks.