Thursday, July 25, 2013

slow website respond xampp windows 8 [solved]

http://www.apachefriends.org/f/viewtopic.php?f=16&t=51152

when user click php links that not require database it respond faster. localhost web respond with delay about 300ms if i have database query page. it occur even with simple mysql query. after searching around i found that windows 8 not able to locate localhost correctly (127.0.0.1 or ::0). this is my solution:

1. edit my.cnf located in C:\xampp\mysql\bin directory
2. find bind-address and uncomment 127.0.0.1 or ::1 which your pc use to connect localhost

 # Change here for bind listening  
 # bind-address="127.0.0.1"   
  bind-address = ::1     # for ipv6  

mine using ::1 and i uncomment that line.
3. restart mysql service. use xampp control panel (xampp-control) located at C:\xampp

you will see improvement after restart mysql service.
cheers.

No comments:

Related Posts Plugin for WordPress, Blogger...