The socket operation failed because the system did not have enough space for a buffer or because the queue was full - Wamp server

Question

I am building a browser game using PHP, Javascript and HTML5 and I am testing it on a local server. However, sometimes I get the following error:

Warning: mysqli::mysqli(): (HY000/2002): An operation on a socket could not be performed because the system lacked sufficient buffer space or because a queue was full. 

It blinks on the screen (e.g. SCREAM error) and then disappears. This does not affect the functionality of the application, but sometimes it can remain on the screen for up to 5-10 seconds. I mention that I use a lot of AJAX requests to work with database changes, the most noticeable of which is the fact that I have a timer that reads a set of svg cards in 2 seconds. I found the following lines in my.ini file (mysql configuration file). Should I try to change some of these values?

 # The MySQL server [wampmysqld] port = 3306 socket = /tmp/mysql.sock key_buffer = 16M max_allowed_packet = 1M table_cache = 64 sort_buffer_size = 512K net_buffer_length = 8K read_buffer_size = 256K read_rnd_buffer_size = 512K myisam_sort_buffer_size = 8M basedir=c:/wamp/bin/mysql/mysql5.5.24 log-error=c:/wamp/logs/mysql.log datadir=c:/wamp/bin/mysql/mysql5.5.24/data 

Or maybe I should look in the php.ini file? In addition, I am running the Wamp server on Windows 7.

Answer 1

Check the following steps:

http://blogs.msdn.com/b/sql_protocols/archive/2009/03/09/understanding-the-error-an-operation-on-a-socket-could-not-be-performed-because-the- system-lacked-sufficient-buffer-space-or-because-a-queue-was-full.aspx

The problem with the mines was the same, the first solution listed there helped!