WampServer has suddenly become very slow
Posted by: Cell Guy (---.hsd1.va.comcast.net)
Date: July 05, 2014 08:57PM

I'm running WampServer 2.4 on Windows 7 Pro and haven't had any problems recently until today. Suddenly, without any changes to my website (that I can think of), WampServer has become very, very slow.

I ran an XDebug profiler and the snapshot shows that the entire execution time of my site is only 25ms, but Chrome shows the page taking 1.04 seconds to be returned. When I make AJAX requests, they also take 1.04 seconds to be returned.

What might have caused this? I tried disabling Avast! antivirus, but it didn't seem to make a difference.

Options: ReplyQuote
Re: WampServer has suddenly become very slow
Posted by: Cell Guy (---.hsd1.va.comcast.net)
Date: July 07, 2014 06:52PM

Never mind. Without making any changes, wampserver suddenly went back to working normally. No idea why it suddenly sped up :-/

Options: ReplyQuote
Re: WampServer has suddenly become very slow
Posted by: Cell Guy (---.hsd1.va.comcast.net)
Date: July 07, 2014 07:24PM

Well, I take that back! Now it's back to taking 1.07 seconds for requests to be returned, no matter how small. Again, I didn't change *anything* at all, it just suddenly became slow again :-(

Any ideas?

Options: ReplyQuote
Re: WampServer has suddenly become very slow
Posted by: Otomatic (Moderator)
Date: July 07, 2014 07:42PM

Hi,

In the parameters for connect to MySQL, replace the host "localhost" by "127.0.0.1" (Without the quotes)

---------------------------------------------------------------
Documentation Apache - Documentation PHP - Documentation MySQL - Wampserver install files & addons

Options: ReplyQuote
Re: WampServer has suddenly become very slow
Posted by: Cell Guy (---.hsd1.va.comcast.net)
Date: July 07, 2014 08:28PM

Hi Otomatic,

What file(s) are you referring to?

Options: ReplyQuote
Re: WampServer has suddenly become very slow
Posted by: Cell Guy (---.hsd1.va.comcast.net)
Date: July 07, 2014 11:31PM

Turns out it was totally my fault. I had enabled PHP's XDebug and did not realize that if you don't have your IDE listening for the connecting, the site will hang for about a second!

Thanks!

Options: ReplyQuote
Re: WampServer has suddenly become very slow
Posted by: xdop (---.200.178.107.gae.googleusercontent.com)
Date: July 08, 2014 03:53AM

i have faced the same questions several times.

the question was caused by Windows 7 service package (KBxxxxxxx), my windows no any change, besides System Auto Update.

MySQL became very slow, time more than 1 minutes.

Options: ReplyQuote
Re: WampServer has suddenly become very slow
Posted by: Otomatic (Moderator)
Date: July 08, 2014 09:48AM

Cell Guy a écrit:
-------------------------------------------------------
> Hi Otomatic,
>
> What file(s) are you referring to?

For PhpMyAdmin: wamp\apps\phpmyadmin4.x.y\config.inc.php
$cfg['Servers'][$i]['host'] = '127.0.0.1';
And all the configuration files for web applications for which it is asked for the name of the MySQL server, for example:
$db_host = '127.0.0.1';
in place of $db_host = 'localhost';

---------------------------------------------------------------
Documentation Apache - Documentation PHP - Documentation MySQL - Wampserver install files & addons

Options: ReplyQuote


Sorry, only registered users may post in this forum.