How 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:
|
|
This will provide you with a table of information about the table statistics, including the amount of rows.