ERROR 2013 (HY000): Lost connection to MySQL server at ‘rea_MySQL
当WEB服务器负载高的时候，经常会出现这种错误，
原因：
MySQL默认connect_timeout是5秒，超过了这个时间MySQL的server端就会返回“Bad handshake”。
解决办法：
1.大多数时候设置"set global connect_timeout=60"是可以解决问题的;
我们可以通过执行“SHOW STATUS LIKE 'aborted%'”，可以观察到| Variable_name | Value |
|---|---|
| Aborted_clients | 6 |
| Aborted_connects | 15010 |
觉得是否要增加connect_timeout的时间，"Aborted_connects"将会随着服务端放弃客户端初始连接而增加。如果"Aborted_connects"很大，并且不断增加，就需要增加"connect_timeout".
2.在MySQL的配置文件中[mysqld]添加"skip-name-resolve",减少域名解析的时间
3.部署服务器端的网络要好，至少大于100Mbps/s
4.如果是在调用mysql_query的时候出现的问题，那就需要把"net_read_timeout"的时间调成30秒，或者60秒，或者更大的值
5.如果还不能解决问题，那估计是你的SQL语句中含有BLOB这种大类型，我们就需要增加"max_allowed_packet"的值了
参考资料：
http://dev.mysql.com/doc/refman/5.0/en/error-lost-connection.html
Hot AI Tools
Undresser.AI Undress
AI-powered app for creating realistic nude photos
AI Clothes Remover
Online AI tool for removing clothes from photos.
Undress AI Tool
Undress images for free
Clothoff.io
AI clothes remover
Video Face Swap
Swap faces in any video effortlessly with our completely free AI face swap tool!
Hot Article
Hot Tools
Notepad++7.3.1
Easy-to-use and free code editor
SublimeText3 Chinese version
Chinese version, very easy to use
Zend Studio 13.0.1
Powerful PHP integrated development environment
Dreamweaver CS6
Visual web development tools
SublimeText3 Mac version
God-level code editing software (SublimeText3)
Hot Topics
1664
14
1423
52
1318
25
1268
29
1248
24
Comprehensive Guide to PHP 500 Errors: Causes, Diagnosis and Fixes
Mar 22, 2024 pm 12:45 PM
A Comprehensive Guide to PHP 500 Errors: Causes, Diagnosis, and Fixes During PHP development, we often encounter errors with HTTP status code 500. This error is usually called "500InternalServerError", which means that some unknown errors occurred while processing the request on the server side. In this article, we will explore the common causes of PHP500 errors, how to diagnose them, and how to fix them, and provide specific code examples for reference. Common causes of 1.500 errors 1.
What causes WPS Office to be unable to start a print job?
Mar 20, 2024 am 09:52 AM
When connecting a printer to a local area network and starting a print job, some minor problems may occur. For example, the problem "wpsoffice cannot start the print job..." occasionally occurs, resulting in the inability to print out files, etc., delaying our work and study, and causing a bad impact. , let me tell you how to solve the problem that wpsoffice cannot start the print job? Of course, you can upgrade the software or upgrade the driver to solve the problem, but this will take you a long time. Below I will give you a solution that can be solved in minutes. First of all, I noticed that wpsoffice cannot start the print job, resulting in the inability to print. To solve this problem, we need to investigate one by one. Also, make sure the printer is powered on and connected. Generally, abnormal connection will cause
What is the reason why screencasting fails? 'A must-read for newbies: How to solve the problem of unsuccessful wireless screencasting connection'
Feb 07, 2024 pm 05:03 PM
Why does wireless screencasting fail to connect? Some friends have reported that the connection fails when using wireless screen mirroring. What is going on? What should I do if the wireless screen mirroring connection fails? Please confirm whether your computer, TV and mobile phone are connected to the same WiFi network. Screen mirroring software requires devices to be on the same network to work properly, and Quick Screen Mirroring is no exception. Therefore, please quickly check your network settings. It is important to determine whether the screen mirroring function is supported. Smart TVs and mobile phones usually support DLNA or AirPlay functionality. If the screencast function is not supported, screencasting will not be possible. Confirm whether the device is connected correctly: There may be multiple devices under the same WiFi. Make sure you are connecting to the device you want to share the screen with. 4. Ensure that the network
Revealing the root causes of win11 blue screen
Jan 04, 2024 pm 05:32 PM
I believe many friends have encountered the problem of system blue screen, but I don’t know what is the cause of win11 blue screen. In fact, there are many reasons for system blue screen, and we can investigate and solve them in order. Reasons for win11 blue screen: 1. Insufficient memory 1. It may occur when running too many software or the game consumes too much memory. 2. Especially now there is a memory overflow bug in win11, so it is very likely to be encountered. 3. At this time, you can try to set up virtual memory to solve the problem, but the best way is to upgrade the memory module. 2. CPU overclocking and overheating 1. The causes of CPU problems are actually similar to those of memory. 2. It usually occurs when using post-processing, modeling and other software, or when playing large-scale games. 3. If the CPU consumption is too high, a blue screen will appear.
Why is Apple mobile phone charging so slow?
Mar 08, 2024 pm 06:28 PM
Some users may encounter slow charging speeds when using Apple phones. There are many reasons for this problem. It may be caused by low power of the charging device, device failure, problems with the USB interface of the mobile phone, or even battery aging and other factors. Why does Apple mobile phone charge very slowly? Answer: charging equipment problem, mobile phone hardware problem, mobile phone system problem. 1. When users use charging equipment with relatively low power, the charging speed of the mobile phone will be very slow. 2. Using third-party inferior chargers or charging cables will also cause slow charging. 3. It is recommended that users use the official original charger, or replace it with a regular certified high-power charger. 4. There is a problem with the user’s mobile phone hardware. For example, the USB interface of the mobile phone cannot be contacted.
Troubleshooting the causes and solutions for HTTP status code 550
Feb 20, 2024 am 09:49 AM
Explore the causes and solutions of HTTP status code 550 Introduction: In network communications, HTTP status codes play an important role and are used to indicate the results of the server processing the request. Among them, HTTP status code 550 is a relatively rare status code that is usually related to the server refusing to execute the request. This article will explore the causes of HTTP status code 550 and provide solutions. 1. The basic concept of HTTP status code. Before understanding the HTTP status code 550, let us first briefly understand the basic concept of HTTP status code.
Why does win11 shut down automatically?
Jan 01, 2024 pm 11:39 PM
Recently, a friend encountered the problem of Win11 automatically shutting down after updating the system. In many cases, it happens when playing games. I don’t know what caused it. In fact, this may be caused by insufficient computer configuration or system failure. Let’s take a look at the causes and solutions. Why does win11 automatically shut down? 1. Insufficient configuration 1. Windows 11 system has higher CPU and memory requirements than Windows 10. 2. Especially when running large-scale games and other tasks, it is very easy to automatically shut down. 3. Users can try to restore the usage status before automatic shutdown by right-clicking the start menu icon and opening the "Task Manager" page. 4. Let’s check the CPU, memory, and disk on this page.
What is the reason why the wifi function cannot be turned on? Attachment: How to fix the wifi function that cannot be turned on
Mar 14, 2024 pm 03:34 PM
Nowadays, in addition to data and wifi, mobile phones have two ways to access the Internet, and OPPO mobile phones are no exception. But what should we do if we can’t turn on the wifi function when using it? Don't worry yet, you might as well read this tutorial, it will help you! What should I do if my phone’s wifi function cannot be turned on? It may be because there is a slight delay when the WLAN switch is turned on. Please wait 2 seconds to see if it is turned on. Do not click continuously. 1. You can try to enter "Settings>WLAN" and try to turn on the WLAN switch again. 2. Please turn on/off airplane mode and try to turn on the WLAN switch again. 3. Restart the phone and try to see if WLAN can be turned on normally. 4. It is recommended to try restoring factory settings after backing up data. If none of the above methods solve your problem, please bring the purchased
