1 views collected around this technical thread.
This article explains PHP's built‑in logging functions, demonstrates how to use error_log() with various parameters, shows how to extend logging via set_error_handler(), and introduces the Monolog library for advanced logging in backend development.
This article explains how to improve PHP logging performance by controlling log levels, batching writes, using asynchronous processes, and implementing log rotation, providing clear code examples for each technique in real-world PHP applications.
This article explains how to proactively identify non‑conforming date values during Oracle or MySQL data migrations by creating test tables, leveraging DBMS_ERRLOG for Oracle, using strict SQL_MODE and temporary tables for MySQL, and optionally applying regular‑expression checks.
This article explains how to install and configure MySQL 8.0's component_log_filter_dragnet, describes its core filter fields and actions, and provides practical examples for customizing error‑log output such as dropping, throttling, setting, and unsetting log entries based on time, priority, error codes, symbols, and subsystems.
The article demonstrates how to use MySQL error logs and gdb to trace a crash‑related bug, identify the affected function in the source code, compare version histories on GitHub, and confirm that the issue was fixed in MySQL 8.0.20.
This article explains how to configure Nginx access_log and error_log directives, customize log formats with log_format, and improve performance using open_log_file_cache, providing syntax details, parameter meanings, and practical examples.
This article explains how to diagnose MySQL client connection failures by checking whether the mysqld process is running, verifying network communication settings such as skip‑networking and bind‑address, and examining authentication or password issues via the error log.
This article explains how to investigate a MySQL crash when core dumps are disabled by extracting the crash address from the error log, obtaining the matching binary, using GDB to map the address to source code, and decoding encoded function signatures to pinpoint the underlying bug.
This guide demonstrates how to reproduce a MySQL crash, enable system‑level core dumps, adjust user limits, configure MySQL to generate core files, and use gdb to extract useful debugging information for complex failure analysis.
MySQL 8.0 adds JSON‑formatted error logs and flexible filtering components, allowing administrators to install JSON sink and filter modules, extract specific fields with tools like jq, and apply rules that drop or throttle messages to improve log readability and automation.