How to Change a MariaDB/MySQL Data Directory to a New Location on Linux
March 7, 2023
Step 1 — Moving the MariaDB Data Directory mysql -u root -p select @@datadir; Output: +-----------------+ | @@datadir | +-----------------+ | /var/lib/mysql/ | +-----------------+ 1 row in set (0.
Read More
How to count the amount of rows in MariaDB fast
February 11, 2023
If you need to find the fastest way to count the number of rows in a massive MariaDB, or MySQL table, then you can do the following instead of performing a select count() query:
Read More