MariaDB

How to Change a MariaDB/MySQL Data Directory to a New Location on Linux

March 7, 2023 #Linux #MariaDB #MySQL

Step 1 — Moving the MariaDB Data Directory

mysql -u root -p

select @@datadir;

Output:
  +-----------------+
  | @@datadir       | …

How to count the amount of rows in MariaDB fast

February 11, 2023 #MariaDB #MySQL

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 …