Search Results
https://dev.mysql.com/doc/refman/8.4/en/sys-extract-table-from-file-name.html
Parameters path VARCHAR(512): The full path to a data file from which to extract the table name. Given a file path name, returns the path component that represents the table name. This function is useful when extracting file I/O information from ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-install-debian.html
The section provides information about installing NDB Cluster on Debian and related Linux distributions such Ubuntu using the .deb files supplied by Oracle for this purpose. This file is named using the pattern shown here, according to the ...
https://dev.mysql.com/doc/refman/8.4/en/sys-io-global-by-file-by-latency.html
These views summarize global I/O consumers to display time waiting for I/O, grouped by file. The io_global_by_file_by_latency and x$io_global_by_file_by_latency views have these columns: file The file path name. total_latency The total wait time of ...
https://dev.mysql.com/doc/refman/8.4/en/sys-io-global-by-file-by-bytes.html
These views summarize global I/O consumers to display amount of I/O, grouped by file. The io_global_by_file_by_bytes and x$io_global_by_file_by_bytes views have these columns: file The file path name. avg_read The average number of bytes per read ...write_pct The percentage of total bytes of I/O that were ...By default, ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-information-schema-system-tables.html
InnoDB INFORMATION_SCHEMA schema object tables include the tables listed here: INNODB_DATAFILES INNODB_TABLESTATS INNODB_FOREIGN INNODB_COLUMNS INNODB_INDEXES INNODB_FIELDS INNODB_TABLESPACES INNODB_TABLESPACES_BRIEF INNODB_FOREIGN_COLS ...The ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-file-instances-table.html
The file_instances table lists all the files seen by the Performance Schema when executing file I/O instrumentation. When a file is deleted from the disk, it is also removed from the file_instances table. If a file was opened and then closed, it ...
https://dev.mysql.com/doc/refman/8.4/en/sys-latest-file-io.html
requested The number of data bytes requested for the file I/O event. These views summarize file I/O activity, grouped by file and thread. The latest_file_io and x$latest_file_io views have these columns: thread For foreground threads, the account ...
https://dev.mysql.com/doc/refman/8.4/en/mysqldumpslow.html
mysqldumpslow parses MySQL slow query log files and summarizes their contents. Normally, mysqldumpslow groups queries that are similar except for the particular values of number and string data values. The MySQL slow query log contains information ...-a Do not abstract all numbers to N and strings to ...
https://dev.mysql.com/doc/refman/8.4/en/myisamlog.html
To create such a file, start the server with a --log-isam=log_file option. Invoke myisamlog like this: myisamlog [options] [file_name [tbl_name] ...] The default operation is update (-u). The default log file name is myisam.log if no log_file ...If ...This option can be given multiple times to produce more and more ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-batch-commands.html
The mysql client typically is used interactively, like this: mysql db_name However, it is also possible to put your SQL statements in a file and then tell mysql to read its input from that file. To do so, create a text file text_file that contains ...For this you can insert statements like this: SELECT '<info_to_display>' AS ' '; The statement shown outputs ...