MySQL Administration and Utilities

Let's look at the administration and utilities in MySQL and understand how to use them -

ibd2sdi

It is an extract Utility for Serialized Dictionary Information (SDI) from InnoDB tablespace files. SDI data exists in all persistent InnoDB tablespace files. ibd2sdi can be used while running or when the server is offline.

innochecksum

It prints the checksum of the InnoDB file. It reads the InnoDB tablespace file, calculates a checksum for each page, compares the calculated checksum with the stored checksum, and reports a mismatch, thereby displaying corrupted pages. It was originally developed to speed up the verification of tablespace file integrity after a power outage, but it can also be used after a file copy

It can be called as follows -

shell> innochecksum [options] file_name

myisam_ftdump

It displays information about FULLTEXT indexes in MyISAM tables. It reads the MyISAM index file directly, so it must be run on the server host where the table is located. Before using myisam_ftdump, users must ensure that if the server is running, they first issue a FLUSH TABLES statement.

It can be called as follows -

shell > myisam_ftdump [options] tbl_name index_num

myisamchk

It gets information about user database tables or checks, repairs or optimizes them. It is used with MyISAM tables, i.e. tables with .MYD and .MYI files for storing data and indexes. Using myisamchk with partitioned tables is not supported.

It can be called as follows -

shell> myisamchk [options] tbl_name ...

myisamlog

It processes the contents of the MyISAM log file. To create such a file, start the server with the --log-isam=log_file option.

It can be called as follows -

shell> myisamlog [options] [file_name [tbl_name] ...]

myisampack

It compresses MyISAM tables. It works by compressing each column in the table individually. Typically, myisampack packs 40% to 70% of the data file.

It can be called as follows -

shell> myisampack [options] file_name ...

mysqlbinlog

The server's binary log consists of files containing "events" that help describe the impact on the database Modifications made to the content. The server writes these files in binary format. To display content in text format, use the mysqlbinlog utility.

It can be called as follows -

shell> mysqlbinlog [options] log_file ...

mysqldumpslow

The MySQL slow query log contains information about queries that take a long time to execute. This utility parses MySQL slow query log files and summarizes their contents.

It can be called as follows -

shell> mysqldumpslow [options] [log_file ...]

The above is the detailed content of MySQL Administration and Utilities. For more information, please follow other related articles on the PHP Chinese website!