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 page, which can be invoked from the command line as usual.

We will use another of the tools that are included by MariaDB to see how our database server performs when placed under significant load. The tool is mysqlslap, a diagnostic program designed...