Find guides, reviews, and articles on the topic you need.
Contents 0. In MySQL, query caching has been completely removed in recent versions, while in MariaDB, on the contrary, it has become enabled by default. 1. How MySQL / MariaDB query caching works 2. When to use MySQL / MariaDB que…
Read article →Contents What are $mysqli->close() and $result->free() used for in PHP Is it necessary to close connections to MySQL / MariaDB and clear the result of the SQL query? When using $mysqli->close() and $result->free() will NOT give ta…
Read article →Contents List of running operations and processes on MySQL and MariaDB server How to view MySQL and MariaDB processes in real time What do the fields in the SHOW PROCESSLIST output mean How to display MySQL and MariaDB process dat…
Read article →Contents Error “Uncaught mysqli_sql_exception: Too many connections” Why does the “Too many connections” error occur How to temporarily increase the maximum number of connections to MySQL / MariaDB How to permanently increase the…
Read article →Contents Is it possible to transfer a database from one MySQL / MariaDB server to another without creating an intermediate file How to transfer a database from one server to another How to transfer a database from one MySQL/MariaD…
Read article →Contents 1. Why you might want to run multiple MySQL or MariaDB servers on one computer 2. What you need to run multiple MySQL or MariaDB servers on one computer 3. Differences between MySQL and MariaDB when starting a second DBMS…
Read article →Contents What do dots mean in MySQL and MariaDB SQL queries Identifier qualifiers in MySQL and MariaDB When to qualify a column name and when not to “ERROR 1046 (3D000): No database selected” / “#1046 - No database selected” even…
Read article →Consider a situation where you need to find out whether a certain column exists in a table that is located in a database managed by a MySQL or MariaDB DBMS. In this post, we'll look at the SQL query syntax for getting a list of co…
Read article →Table of contents 1. Why phpMyAdmin does not show the full contents of a cell (column) 2. How to view the full contents of a cell in phpMyAdmin 3. Why does changing column widths not show the entire data? 4.How to increase the num…
Read article →Table of contents 1. How does searching through databases and tables work in phpMyAdmin 2. Instructions for using the search function in phpMyAdmin 3. Search the database as a whole. Search multiple tables simultaneously 4. Single…
Read article →
