In addition, for the actual performance tests, you should note that MariaDB comes with several database-related utilities that can come in handy for a variety of administration tasks. One of them is
mysqlshow, which returns complete information about databases and tables in one quick command.
Its generic syntax is as follows:
mysqlshow [options] [db_name [tbl_name [col_name]]]
So, we could use the following command to display the description for the titles table in the
mysqlshow employees titles -h 192.168.0.4 -u root -p
You can list the complete set of utilities that are included in your MariaDB installation using the
ls /bin | grep mysql command. Each of those tools has a corresponding manual ...