I’ve got XAMPP installed on my Windows 7 Computer.
I’ve been developing on it for a while now but my development has come to a grinding halt because XAMPP is rendering my PHP pages really slowly.
It’s running so slowly, that it’s exceeding the 30 second time-out limit that I’ve got set in the PHP.ini file.
I don’t know what it could be that has all of a sudden prevented it from running properly.
I’ve tried the following:
- Reinstalled XAMPP and copied back my MySQL database files and website files
- Deactivated my Antivirus/firewall after reading articles that this might do the trick
But to no avail.
Could it be that my MySQL database is corrupted?
It’s not that my MySQL queries are slow, because I’ve got the exact same version of code live on my website.
I’m just looking for suggestions to rectify it so that I can continue the development.
This is the last bit of the MySQL error log
111119 17:24:11 [Note] Plugin ‘FEDERATED’ is disabled. 111119 17:24:11
InnoDB: The InnoDB memory heap is disabled 111119 17:24:11 InnoDB:
Mutexes and rw_locks use Windows interlocked functions 111119 17:24:11
InnoDB: Compressed tables use zlib 1.2.3 111119 17:24:11 InnoDB:
Initializing buffer pool, size = 16.0M 111119 17:24:11 InnoDB:
Completed initialization of buffer pool 111119 17:24:11 InnoDB:
highest supported file format is Barracuda. 111119 17:24:12 InnoDB:
Waiting for the background threads to start 111119 17:24:13 InnoDB:
1.1.8 started; log sequence number 1595675 111119 17:24:14 [Note] Event Scheduler: Loaded 0 events 111119 17:24:14 [Note]
c:xamppmysqlbinmysqld.exe: ready for connections. Version:
‘5.5.16’ socket: ” port: 3306 MySQL Community Server (GPL) 111119
17:32:24 [Note] c:xamppmysqlbinmysqld.exe: Normal shutdown111119 17:32:24 [Note] Event Scheduler: Purging the queue. 0 events
111119 17:32:24 InnoDB: Starting shutdown… 111119 17:32:25 InnoDB:
Shutdown completed; log sequence number 1595675 111119 17:32:25 [Note]
c:xamppmysqlbinmysqld.exe: Shutdown complete111119 17:33:26 [Note] Plugin ‘FEDERATED’ is disabled. 111119 17:33:26
InnoDB: The InnoDB memory heap is disabled 111119 17:33:26 InnoDB:
Mutexes and rw_locks use Windows interlocked functions 111119 17:33:26
InnoDB: Compressed tables use zlib 1.2.3 111119 17:33:26 InnoDB:
Initializing buffer pool, size = 16.0M 111119 17:33:26 InnoDB:
Completed initialization of buffer pool 111119 17:33:26 InnoDB:
highest supported file format is Barracuda. 111119 17:33:27 InnoDB:
Waiting for the background threads to start 111119 17:33:28 InnoDB:
1.1.8 started; log sequence number 1595675 111119 17:33:28 [Note] Event Scheduler: Loaded 0 events 111119 17:33:28 [Note]
c:xamppmysqlbinmysqld.exe: ready for connections. Version:
‘5.5.16’ socket: ” port: 3306 MySQL Community Server (GPL)
Advertisement
Answer
I used to have the same issues with PHP on xampp. After a while it started slowing down, there was no reason for it (code, mysql, apache were all fine).
The way I had gotten it to work was via xampp’s command line interface. I had switched the networking interface from v4v6 to just v4; and that that had done the trick, then shortly after it slowed down again… so doing the v4 back to v4v6 fixed, but again worstened.
So, after working with xampp for a number of years, I found that wamp worked best and has no issues on Windows 7.
Download wamp; it’s only 16mb too (compared to xampp’s 44mb).
http://wampserver.com/