DBMS - Suay.Site

How to cache MySQL / MariaDB query results

Posted by Alex On May 27, 2025

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 query caching 3. How to enable and configure MySQL / MariaDB query result caching 4. How to check MySQL /...

Should I close MySQL connections with $mysqli->close() in PHP scripts. Should I use $result->free()

Posted by Alex On April 17, 2025

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 tangible results When to use $mysqli->close() and $result->free() Is it possible to close the MySQL database connection before completing the processing of query results...

How to list all current connections to MySQL and MariaDB databases

Posted by Alex On April 15, 2025

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 data row by row instead of in a table Alternative syntax for SHOW FULL PROCESSLIST How to display only certain columns...

PHP Fatal error: Uncaught mysqli_sql_exception: Too many connections in (SOLVED)

Posted by Alex On April 10, 2025

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 maximum number of connections to MySQL / MariaDB What is the maximum number of connections that can be established for MySQL and MariaDB 1. Error “Uncaught mysqli_sql_exception:...

How to transfer a database between DBMS servers without creating a database dump file (MySQL and MariaDB)

Posted by Alex On April 7, 2025

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/MariaDB instance to another when both MySQL/MariaDB instances are running on the same machine How to transfer a database from one MySQL/MariaDB...

How to run multiple MySQL/MariaDB server instances on one machine

Posted by Alex On April 3, 2025

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 instance 4. Correcting the mariadb@.service file 5. How to configure a second MySQL or MariaDB instance 5.1 How to...

What do dots mean in MySQL and MariaDB SQL queries. How to refer from a table to a column in another table

Posted by Alex On March 1, 2025

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 if qualified column names are used Conclusion Sources What do dots mean in MySQL and MariaDB SQL queries Consider the...

How to display results in MySQL and MariaDB without a table and without extraneous characters

Posted by Alex On September 23, 2024

Contents How to output data without a table when saving results to a file How to display results without a table on the screen How to display results in mariadb and mysql clients without a table How to configure the output of results without a table by default When working with MySQL and MariaDB in the command line, the results...

Error ‘mysqli::real_connect(): (HY000/1524): Plugin 'mysql_native_password' is not loaded’ (SOLVED)

Posted by Alex On September 20, 2024

Contents ERROR 1524 (HY000): Plugin 'mysql_native_password' is not loaded How to switch a user from mysql_native_password to another authentication plugin Solution for ERROR 1524 (HY000): Plugin 'mysql_native_password' is not loaded in Windows Solution to ERROR 1524 (HY000): Plugin 'mysql_native_password' is not loaded on Linux Resolve ERROR 1524 (HY000): Plugin 'mysql_native_password' is not loaded on macOS/Homebrew Resolve ERROR 1524 (HY000): Plugin...

How to find rows with empty column value in MySQL/MariaDB table (in phpMyAdmin and in command line)

Posted by Alex On August 16, 2024

How to find rows with empty column value in phpMyAdmin Suppose you want to find rows in a table where the value of a certain column is empty. To do this, you try to use the table search in phpMyAdmin. If you go to the “Search” tab in phpMyAdmin and click the “Go” button without entering any values (since you...