D
D
Dan Ryehood2016-02-04 05:12:00
MySQL
Dan Ryehood, 2016-02-04 05:12:00

Why are regular queries running for tens of seconds?

In general, I locally made a site on a laptop that works with MySQL. All OK.
But then I decided to merge it to another computer, stationary (to share it on the grid). Delivered Open Server. All flooded. It turned out that the site responds for tens of seconds. The problem is MySQL, because if we do not work with it, the pages are loaded instantly.
Installed WIMP. Same stuff. Obviously, something in the computer settings interferes with the normal operation of the database daemon.
There are all sorts of tips on the network: disable Ipv6 (disabled), pick hosts (picked, but I knew that would not help). Everything is in vain.
PHP+MySQL+Apache
Win Server 2008 R2
Well, what could be the problem??! Surely someone has come across. D-=
UPD
In general, I copied the Open Server folder from the laptop to the local server and launched from this folder. Everything works fine. But why the database server worked with such brakes under an open server build configured from scratch, as well as under a completely different build - WAMP - remains a mystery.

Answer the question

In order to leave comments, you need to log in

3 answer(s)
A
Alexander Taratin, 2016-02-04
@Taraflex

Use 127.0.0.1 instead of localhost in mysql connection settings

X
xmoonlight, 2016-02-04
@xmoonlight

1. antivirus + firewall (not stock!)
2. bridges in network interfaces (virtual or VPN-like)
3. radio binding and virtual interfaces

V
Vladimir, 2016-02-04
@rostel

Sketch a script in several lines to find out at what stage of the brake.
If in the process of connecting, one must be twisted.
If the request is really long, turn something else.

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question