Recent Posts
MariaDB Tutorial / Troubleshoot Local and Remote MariaDB Connections
Diagnose MariaDB connections by layer, verify local TCP identity and actual table access, and review remote listener, host, firewall and certificate requirements without weakening checks by default.
MariaDB Tutorial / Create Users and Grant Only Required Privileges
Create a table-scoped MariaDB reader, inspect its real account identity, test allowed reads and denied operations, then verify revocation and review account dependencies before cleanup.
MariaDB Tutorial / Build and Reconcile Monthly Sales, Customer Totals, and Unsold Products
Create three related MariaDB reports from one order fixture, retain nonbuyers and find products without paid sales. Reconcile monthly and customer amounts and inspect join, status and date boundaries.
MariaDB Tutorial / Improve Date Filters, Sorting, and Pagination Without Changing Results
Compare equivalent date predicates and deterministic keyset pagination in MariaDB. Preserve exact results, account for version-specific DATE/YEAR optimization and review projection and search semantics.
MariaDB Tutorial / Read EXPLAIN and Compare Plans Before and After an Index
Use a thousand-row fixture to compare EXPLAIN before and after indexing with the actual returned rows. Distinguish ANALYZE FORMAT=JSON execution data from statistics maintenance.
MariaDB Tutorial / Design Single and Composite Indexes for Real Queries
Inspect existing keys, create a customer–time composite index and review leading columns, covering access and foreign-key dependencies. Preserve query results while evaluating read, write and storage costs.
MariaDB Tutorial / Change Table Structure Safely with ALTER TABLE
Practice an add-fill-constrain migration with a product SKU column, verify counts and rejected duplicates, and review metadata locks, online-change limits and recovery boundaries.
MariaDB Tutorial / Normalize an Order Database Without Losing Historical Facts
Analyze order-data dependencies and observe an update anomaly in a flattened copy. Separate current attributes from transaction snapshots and review keys, normal forms and deliberate denormalization.
MariaDB Tutorial / Compare Isolation Levels, Locks, and Deadlocks with Two Connections
Follow explicit A/B steps to compare isolation, row-lock waits and deadlocks. Complete blocks cover resetting values, rereading, cleaning up failures and restoring each connection’s settings.
MariaDB Tutorial / Start InnoDB Transactions with COMMIT and ROLLBACK
Run a complete two-row InnoDB transaction, compare rollback and commit, and verify affected counts and balances. Understand connection scope, error handling, locks and implicit-commit boundaries.