January 2016
Intermediate to advanced
146 pages
3h 8m
English
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 -pYou 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 ...
Read now
Unlock full access