MySQL Query Performance Diagnostics: Utilizing Explain, Profile, and Trace
Database Operation Metrics
Monitoring session-level and global server statistics establishes a baseline before tuning. The following commands expose internal handler counts and I/O patterns:
SHOW SESSION STATUS LIKE 'Com_______';
SHOW GLOBAL STATUS LIKE 'Innodb_rows_%';
These metrics reveal insertion frequencies, commit volumes, and storage en ...
Posted on Mon, 17 Aug 2026 16:35:22 +0000 by greensweater
Optimizing Initial Credit Assignment for New Users in MySQL
Scenario
When onboarding new users, the system initializes account balances. Existing accounts require balance updates, while new accounts are created. All transactions are recorded in a detailed log.
The objective is to insert new user data by computing the set difference between input records and existing system data.
Performance Issue
Testin ...
Posted on Thu, 06 Aug 2026 16:14:48 +0000 by kiss_FM