Guides topic

MySQL

MySQL tutorials with CRUD, joins, keys, indexes and command-line administration examples.

articles: 20

Comparison11 October 2026
MySQL 8.4 LTS, 9.7 LTS or 26.7 Innovation: choosing a version and upgrading
MySQL now ships LTS and Innovation releases with calendar version numbers. Compare 8.4 LTS, 9.7 LTS and 26.7 Innovation, see the supported upgrade paths, and follow a checklist for moving an application from 8.4 to 9.7.
By Cloudsoft Zone
Tutorial10 October 2026
Build a read-only PHP MCP server with MySQL and the official SDK
Expose product lookup, bounded low-stock searches and an inventory summary to AI clients with the official PHP MCP SDK, PDO and local STDIO transport.
By Cloudsoft Zone
Troubleshooting guide9 October 2026
How to find and fix N+1 queries in Laravel Eloquent
N+1 queries make Laravel pages slow as data grows. Learn to detect them with preventLazyLoading and query listeners, then fix them with eager loading, withCount and Laravel 13's automatic eager loading.
By Cloudsoft Zone
Tutorial5 October 2026
How to read MySQL EXPLAIN and EXPLAIN ANALYZE to fix a slow query
A hands-on walkthrough of MySQL's EXPLAIN, FORMAT=TREE and EXPLAIN ANALYZE on MySQL 8.4 and 9.7 LTS: which columns matter, how to read the iterator tree, and how a composite index removes a full scan and a filesort.
By Cloudsoft Zone
Resource guide5 October 2026
MySQL backups for small teams: mysqldump, MySQL Shell and point-in-time recovery
A practical backup plan for MySQL 8.4 and 9.7: when to use mysqldump or MySQL Shell's parallel dump and load utilities, how to keep binary logs for point-in-time recovery, and a checklist for testing restores.
By Cloudsoft Zone
Interview preparation4 October 2026
CodeIgniter 4 model and Query Builder interview questions
Twelve CodeIgniter 4 interview questions on models and the Query Builder, with clear answers and code: mass assignment, soft deletes, casting, SQL safety.
By Cloudsoft Zone
Resource guide3 October 2026
Speed up the CakePHP 5 ORM: fix N+1 queries and heavy finds
Find and fix slow CakePHP 5.4 ORM queries: N+1 loops, contain() column bloat, matching(), the new subquery strategy, unhydratedFind(), CounterCache and caching.
By Cloudsoft Zone
Troubleshooting guide2 October 2026
CakePHP Migrations 5 upgrade: fix seeds, phinxlog and FK errors
Migrations 5 removed Phinx. Fix the common upgrade breakages: seeds run, cake_seeds tracking, fetchAll(), old base classes, foreign key names and phinxlog.
By Cloudsoft Zone
Troubleshooting guide26 September 2026
MySQL deadlocks and lock wait timeouts: causes, diagnosis and fixes
Why InnoDB returns errors 1213 and 1205, how isolation levels and gap locks decide what gets locked, how to find blocking transactions with the Performance Schema, and the application changes that make deadlocks rare.
By Cloudsoft Zone
Tutorial24 September 2026
Automated MySQL 8.4 backups to S3 with mysqldump, retention and restore tests
Set up nightly MySQL 8.4 logical backups to Amazon S3 or any S3-compatible store: a least-privilege backup user, integrity checks before upload, an upload-only IAM policy, lifecycle retention and an automated restore test.
By Cloudsoft Zone
Resource guide22 September 2026
Find slow MySQL queries with the slow log and Performance Schema
Set up the MySQL 8.4 slow query log, summarise it with mysqldumpslow, and use Performance Schema digests and sys views to find the queries costing most time.
By Cloudsoft Zone
Troubleshooting guide17 September 2026
Magento cron and indexers: how to set them up and fix common problems
Missing order emails, stale prices and invalid indexers usually trace back to cron. Learn how Magento cron and indexers work together, how to install the crontab, and how to diagnose and fix the most common failures.
By Cloudsoft Zone