Freaks City

Server Layer The Server layer encompasses connectors, the query cache, parser, optimizer, and executor. It includes most of MySQL's core service functionalities and all built-in functions (e.g., date, time, mathematical, encryption). Cross-storage-engine features such as stored procedures, triggers, and views are implemented here. Connection Po ...

Log4j2 Overview In software development, testing, and production environments, logs capture critical information about application behavior and error stack traces. Proper use of logging frameworks significantly improves problem-solving efficiency. Log4j 1.x was widely used but suffered from memory leaks, maintenance difficulties, and reliance o ...

Database SchemaTable CreationCREATE TABLE `request_audit_log` ( `log_id` BIGINT NOT NULL AUTO_INCREMENT, `created_at` DATETIME NOT NULL COMMENT 'Request timestamp', `client_ip` VARCHAR(30) NOT NULL COMMENT 'Client IP address', `api_category` VARCHAR(50) NOT NULL DEFAULT 'General' COMMENT 'API category', `endpoint_url` VARCHAR(100) NOT ...

Properties Files Properties files store key-value pairs, with keys being unique. They typically use the .properties extension. Reading Properties Files import java.io.FileReader; import java.util.Properties; import java.util.Set; public class PropertiesReader { public static void main(String[] args) throws Exception { Properties pr ...

Capturing Crash Information Adding a Global Uncaught Exception Hook To record unexpected failures, install a handler for uncaught exceptions at the thread level. This catches errors that escape typical try-catch blocks. Thread.setDefaultUncaughtExceptionHandler((thread, throwable) -> { String logEntry = String.format("[FATAL] Thread ...

Applications often require structured logging to track events, errors, and operational details. Python’s built-in logging module provides a flexible framework for emitting log mesages from applications. It supports multiple severity levels: CRITICAL, ERROR, WARNING, INFO, and DEBUG, in descending order of severity. By default, the root logger o ...