paul scott1234 Posted May 9, 2014 Share Posted May 9, 2014 Hi all, I can't work out why my online shop is so slow loading, nearly a min to load, www.oemsparesworldwide.com, It never used to be so slow and no modifications have been done, I have checked all the usual in performance settings. Can anyone help? Link to comment Share on other sites More sharing options...
PrestaHeroes USA Posted May 9, 2014 Share Posted May 9, 2014 have you contacted your hosting company? There may be something going on that is impacting your website. This based on you sharing that no changes etc have been made. Link to comment Share on other sites More sharing options...
paul scott1234 Posted May 9, 2014 Author Share Posted May 9, 2014 I have not called them yet, because i have other websites running on my dedicated server, and they are all fine with speed, the back office is running fine, not slow at all. I have tried googles page speed test and it times out. Link to comment Share on other sites More sharing options...
PrestaHeroes USA Posted May 9, 2014 Share Posted May 9, 2014 I have not called them yet, because i have other websites running on my dedicated server, and they are all fine with speed, the back office is running fine, not slow at all. I have tried googles page speed test and it times out. have you checked for errors? might already be in your php error log, but you may need to turn on errors. Link to comment Share on other sites More sharing options...
paul scott1234 Posted May 9, 2014 Author Share Posted May 9, 2014 I have rung the server provider server is fine, apparently there is some mysql queries that are taking forever to load, I only have 2500 products on there so even more confused now. Link to comment Share on other sites More sharing options...
paul scott1234 Posted May 9, 2014 Author Share Posted May 9, 2014 Any ideas anyone ? Link to comment Share on other sites More sharing options...
paul scott1234 Posted May 10, 2014 Author Share Posted May 10, 2014 Help Link to comment Share on other sites More sharing options...
paul scott1234 Posted May 10, 2014 Author Share Posted May 10, 2014 After calling my hosting company, this is what they said, please remember this is a dedicated server not a shared server. I can see on your server that the mysql process is running flat out (it can only take over one CPU and has taken one over) It looks like some mysql queries are running slowly: mysql> show processlist;+--------+-----------+-----------+-----------+---------+------+--------------+------------------------------------------------------------------------------------------------------+| Id | User | Host | db | Command | Time | State | Info |+--------+-----------+-----------+-----------+---------+------+--------------+------------------------------------------------------------------------------------------------------+| 120279 | root | localhost | NULL | Query | 0 | NULL | show processlist || 120346 | oemspares | localhost | oemspares | Query | 5 | Sending data | SELECT p.*, pl.`description`, pl.`description_short`, pl.`link_rewrite`, pl.`meta_description`, pl.` || 120349 | oemspares | localhost | oemspares | Query | 6 | Sending data | SELECT p.*, pl.`description`, pl.`description_short`, pl.`link_rewrite`, pl.`meta_description`, pl.` || 120350 | oemspares | localhost | oemspares | Query | 1 | NULL | SHOW TABLE STATUS |+--------+-----------+-----------+-----------+---------+------+--------------+------------------------------------------------------------------------------------------------------+4 rows in set (0.00 sec) any help would be much appreciated on this matter Link to comment Share on other sites More sharing options...
Recommended Posts