Search across authors, categories, and technical themes. The layout mirrors the editorial references while staying responsive and fast.
This article explains how to use PHP's mysqli_num_rows function to retrieve the number of rows returned by a MySQL query, providing a step‑by‑step example that connects to the database, executes a SELECT statement, checks for errors, and outputs the row count.
This article explains how to reproduce a MySQL InnoDB lock‑wait scenario, use system tables such as information_schema.processlist, innodb_trx, sys.innodb_lock_waits and performance_schema to locate the blocking transaction, and finally resolve the issue by killing the offending session, while also providing quick‑check queries and parameter tuning advice.
This guide explains how to connect an Alibaba Cloud Bailei large language model to a MySQL database using MaxKB, create semantic‑to‑SQL nodes, define system roles, and build an AI assistant that can answer operational questions with natural‑language responses and SQL queries.
This article explains how the PHP mysqli_query function works with MySQL, provides a complete example for executing SELECT queries, and discusses its use for INSERT, UPDATE, DELETE operations along with result handling and related fetching functions.
This article demonstrates how to use PHP's mysqli_num_rows function to retrieve the number of rows returned by a MySQL query, including a complete example that connects to the database, executes a SELECT statement, checks for errors, obtains the row count, and outputs the result.
The article explains why using UUIDs as primary keys in MySQL large tables leads to poor index efficiency, slower inserts and queries, and costly index refreshes on updates, and then presents practical optimization techniques such as ordered UUIDs, binary storage, hybrid auto‑increment keys, and table partitioning.
This article explains how MySQL's count() works across storage engines, why InnoDB scans rows and can time out on massive tables, and presents practical alternatives such as using EXPLAIN rows, a dedicated count table, batch processing, or binlog‑to‑Hive for efficient row‑count estimation.
This article explains MySQL's three concurrency types—read‑read, read‑write, and write‑write—describes how InnoDB uses MVCC, shared and exclusive locks, and provides practical examples and code for handling update‑loss and write‑write conflicts with optimistic and pessimistic locking.
This article explains how to protect MySQL connections by using SSL/TLS, various password authentication plugins, digital signatures, and client/server certificate verification to prevent impersonation, password leakage, and data tampering.
This article explains why storing dates as strings is problematic, compares MySQL's DATETIME and TIMESTAMP types—including their storage size, range, and timezone behavior—provides practical SQL examples, discusses numeric Unix timestamps, and offers guidance on selecting the most suitable type for different scenarios.