J
J
Jonathan Rosewood2014-07-13 02:57:41
PHP
Jonathan Rosewood, 2014-07-13 02:57:41

Why is MySQL running slow on local machine (windows)?

After installing and configuring MySQL server (version 5.6.19), PHP interpreter (version 5.5.14), Apache server (version 2.4.9, VC11 compiler) on Windows 8.1 Enterprise x64 (Interl(R) Core(TM) i5) operating system -2500 CPU @ 3.30 GHz, 8GB RAM), according to the guide , all calls from php to the MySQL server take a very long time (from 20 to 100 seconds), regardless of the type of call.
I encountered a similar problem earlier when installing the Denwer package version 3 (Apache 2.2.22, PHP 5.3.13, MySQL 5.5) and solved it by replacing the PHP plugin for Apache with a later version, but I did not find the reason for the slow work of the new version.
I ask for your help, dear ToasterUser.
Maybe I missed some setting?
php.ini
my.ini
httpd.conf

Answer the question

In order to leave comments, you need to log in

5 answer(s)
A
Alexander Borisovich, 2014-07-13
@Jonathan_Rosewood

Work with Mysql via sockets or via ip if currently working via sockets.

K
Kiska228, 2016-04-05
@Kiska228

You need to use the call to ip: 127.0.0.1, and not to localhost, in scripts, then the speed will increase.

N
Nazar Mokrinsky, 2014-07-13
@nazarpc

How about Open Server?
Just works out of the box. Works slower than Linux, but not as much.

V
VBKesha, 2014-07-13
@VBKesha

try adding skip-name-resolve to mysqld section

R
Rastishka, 2015-09-15
@Rastishka

Disabling ipv6 helped me

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question