Posts

TLDR Problem: Oversized log file consumed all remaining space, causing service anomalies Cause: MySQL was configured with mysql-general-log enabled, without scheduled cleanup Investigation Method: Checked MySQL settings and disk space usage Solution: Set up scheduled cleanup using logrotate Scenario The MySQL Slave in the production environment regularly generates analysis reports and emails them to relevant personnel. We received a notification that reports hadn’t been received for some time. Upon logging into the host to attempt manual sending, it failed due to insufficient space. ...

TLDR Issue：Unable to receive SSE after migrating Nginx configuration from test to production environment Cause：Nginx 1.22.0 defaults to using HTTP/1.0 instead of HTTP/1.1 Investigation : Enable debug logs and analyze Solution : Specify HTTP version 1.1 in Nginx global settings Scenario After migrating the same configuration from the test environment to the production environment, regular requests worked normally, but SSE had no response (Timeout). Manual and tool comparisons, as well as ChatGPT analysis, did not reveal any configuration issues. The only difference was that the test environment used Nginx version 1.22.1, while the production environment used version 1.22.0. ...