O'Reilly logo

CentOS High Performance by Gabriel Cánepa

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required