MySQL – Page 3 – ITFROMZERO – Share tobe shared!

High-Speed MySQL Backup & Restore: Reducing Time from 15 Hours to 2 Hours with Mydumper

By admin August 1, 2026

Large MySQL database running slow with mysqldump? Discover how to use mydumper and myloader for multi-threaded backups, cutting recovery time by up to 80%.

MySQL

Is MySQL COUNT(*) Slow? Don’t Let Your Dashboard Freeze When Data Hits Millions of Rows

By admin July 30, 2026

Why does MySQL COUNT(*) slow down on large InnoDB datasets? This article analyzes the impact of MVCC and provides 4 optimization techniques using Counter Tables, Metadata, and Redis.

MySQL

MySQL Hash Join: A Lifesaver for Queries Lacking Indexes on MySQL 8.0.18+

By admin July 30, 2026

What is MySQL Hash Join? Learn how it works, how to configure join_buffer_size, and practical tips to significantly speed up JOIN queries lacking indexes.

MySQL

MySQL 9.0 and VECTOR: Embedding Storage Solution for AI Apps Without a Secondary DB

By admin July 22, 2026

MySQL 9.0 officially supports the VECTOR data type. Learn how to store AI embeddings, calculate Cosine distance, and build efficient semantic search systems directly in MySQL.

MySQL

MySQL Spatial Data: The Ultimate Guide to Handling GPS Coordinates and Finding Nearby Locations

By admin July 19, 2026

Is calculating GPS distance with DECIMAL slowing down MySQL? Discover how to use Spatial Data, POINT, and Spatial Index to optimize nearby location searches for maximum speed.

MySQL

MySQL E-commerce Schema Design: Don’t Let Your Database Become a Bottleneck When Scaling Up

By admin July 12, 2026

A practical guide to MySQL schema design for E-commerce. Learn how to manage product variants, inventory, and price snapshots to keep your system stable at scale.

MySQL

Connecting to MySQL with PHP PDO: Absolute Security with Prepared Statements and Transactions

By admin July 11, 2026

Switching from mysqli to PDO is a vital step for web security. Learn to use Prepared Statements to prevent SQL Injection and Transactions to protect data in PHP.

MySQL

MySQL, Spring Boot & HikariCP: Transaction and Connection Management Secrets to Prevent 2 AM Crashes

By admin July 11, 2026

Master MySQL and Spring Boot with this practical HikariCP optimization guide. Reduce database CPU load and eliminate Connection Timeout errors in large systems.

MySQL

MySQL Error Log and General Query Log: Production Troubleshooting Techniques for Sysadmins

By admin July 11, 2026

Learn how to configure MySQL Error Log and General Query Log for rapid system diagnostics. Practical insights on log management and production debugging.

MySQL

MySQL with Go (Golang): Connecting with database/sql, SQLX, and Optimizing Connection Pool for Microservices

By admin July 10, 2026

A practical guide to connecting MySQL with Go using database/sql and SQLX, complete with an optimized Connection Pool configuration for production microservices — solving too many connections errors and delivering meaningful query performance gains.