Search across authors, categories, and technical themes. The layout mirrors the editorial references while staying responsive and fast.
This article introduces ten powerful MySQLi functions—including prepared statements, parameter binding, result retrieval, batch queries, transaction control, charset setting, and connection monitoring—that enhance PHP developers’ ability to write secure, efficient, and maintainable code when interacting with MySQL databases.
This article provides a comprehensive index of a MySQL internals series covering the transaction, lock, and undo modules, detailing each sub‑topic such as transaction initialization, two‑phase commit, various lock types, deadlock handling, and undo log management across numerous linked articles.
This article explains how to use PHP's mysqli_query function to connect to a MySQL database, execute SELECT statements, process result sets with mysqli_fetch_assoc, and handle other query types such as INSERT, UPDATE, and DELETE, including full example code and best practices.
After upgrading a client from MySQL 5.7 to 8.0, query performance slowed dramatically due to changes in ORDER BY handling, and the article analyzes the root cause, presents verification tests, and recommends adding indexes to restore millisecond‑level response times.
This guide explains how to download, install, and verify MySQL on Windows, macOS, and Linux, configure the server and user permissions, and demonstrates essential SQL commands for creating databases, tables, and manipulating data, providing a comprehensive introduction for beginners.
Learn step‑by‑step how to set up a fully functional, self‑hosted email system on CentOS 7.9 using Postfix, Dovecot, MariaDB, OpenDKIM and Nginx, covering software installation, configuration files, database schema, TLS/SSL, DNS records, and webmail integration with Roundcube.
This article explains how to monitor system resources and record execution logs for databases, introduces Linux commands such as top, iostat, vmstat, shows how to enable and view MySQL slow query logs, and offers best practices and automation tools, while also promoting related AI and community services.
This article demonstrates how to connect to a MySQL database using mysqli, execute SELECT queries, and retrieve results row by row with the mysqli_fetch_assoc function in PHP, providing complete code examples for connection, querying, result iteration, and proper resource cleanup.
This article explains what MySQL indexes are, how they work, their advantages and drawbacks, the different types of indexes—including primary, ordinary, composite, and full‑text—and dives deep into B‑Tree and B+Tree structures, clustering, page organization, and best practices for efficient query performance.
The article explains how InnoDB handles transaction commit by modifying Insert and Update Undo segment states, generating a transaction commit number, adding rollback segments to the purge queue, and finally cleaning or caching Undo segments based on their usage and state.