CentOS High Performance

Introducing initial cluster tests

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 employees database:

mysqlshow employees titles -h 192.168.0.4 -u root -p

Note

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 ...