MySQL error: Out of memory (Needed 76016 bytes) problem

Check mysqld configuration my.conf

Out of memory (Needed 76016 bytes) problem

Key_buffer_size + (read_buffer_size + sort_buffer_size) *max_connections

Note: This server has a total of 3G memory: The final large to the following

Key_buffer = 200M
Key_buffer_size = 1294963200
#max_join_size = 4294967295
Max_join_size = 1294967295
Max_allowed_packet = 1M
#table_open_cache = 512
Table_cache = 512
Sort_buffer_size = 2294967295
Read_buffer_size = 2147479552
#write_buffer_size = 4294967295
Read_rnd_buffer_size = 4M
Myisam_sort_buffer_size = 64M
Thread_cache_size = 8
Query_cache_size= 16M

Of course, if you run a PHP problem, we can manipulate several parameters in php.ini.

Modify PHP.ini

such as the following area

Max_execution_time = 120; Maximum execution time of each script, in seconds
Max_input_time = 60; Maximum amount of time each script may spend parsing request data
Memory_limit = 64M; Maximum amount of memory a script may consume (64MB)

Restart Apache or IIS