How to Change a MariaDB/MySQL Data Directory to a New Location on Linux
Step 1 — Moving the MariaDB Data Directory mysql -u root -p select @@datadir; Output: +-----------------+ | @@datadir | +-----------------+ | /var/lib/mysql/ | +-----------------+ 1 row in set (0.
Read MoreHow to count the amount of rows in MariaDB fast
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