Review MariaDB Columnstore for Support
To download the columnstore_review script direct to your linux server, you may use git or wget:
git clone https://github.com/mariadb-edwardstoever/columnstore_review.git
wget https://github.com/mariadb-edwardstoever/columnstore_review/archive/refs/heads/main.zip
This script is intended to be run while logged in as root.
If database is up, this script will connect as root@localhost via socket.
Switches:
--help # display this message
--version # only show the header with version information
--logs # create a compressed archive of logs for MariaDB Support Ticket
--backupdbrm # takes a compressed backup of extent map files in dbrm directory
--testschema # creates a test schema, tables, imports, queries, drops schema
--testschemakeep # creates a test schema, tables, imports, queries, does not drop
--ldlischema # using ldli, creates test schema, tables, imports, queries, drops schema
--ldlischemakeep # using ldli, creates test schema, tables, imports, queries, does not drop
--emptydirs # searches /var/lib/columnstore for empty directories
--notmysqldirs # searches /var/lib/columnstore for directories not owned by mysql
--emcheck # Checks the extent map for orphaned and missing files
--s3check # Checks the extent map against S3 storage
--pscs # Adds the pscs command. pscs lists running columnstore processes
--schemasync # Fix out-of-sync columnstore tables (CAL0009)
--tmpdir # Ensure owner of temporary dir after reboot (MCOL-4866 & MCOL-5242)
--clearrollback # Clear any rollback fragments from dbrm files
--killcolumnstore # Stop columnstore processes gracefully, then kill remaining processes
Color output switches:
--color=none # print headers without color
--color=red # print headers in red
--color=blue # print headers in blue
--color=green # print headers in green
--color=yellow # print headers in yellow
--color=magenta # print headers in magenta
--color=cyan # print headers in cyan (default color)
--color=lred # print headers in light red
--color=lblue # print headers in light blue
--color=lgreen # print headers in light green
--color=lyellow # print headers in light yellow
--color=lmagenta # print headers in light magenta
--color=lcyan # print headers in light cyan