PDF (US Ltr)
- 35.1Mb
PDF (A4)
- 35.2Mb
Man Pages (TGZ)
- 256.4Kb
Man Pages (Zip)
- 361.2Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/sys-extract-table-from-file-name.html
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 the Performance Schema that includes file path names. It provides a convenient way to display table ...
https://dev.mysql.com/doc/refman/5.7/en/zlib-decompress.html
The zlib_decompress utility decompresses mysqlpump output that was created using ZLIB compression. Invoke zlib_decompress like this: zlib_decompress input_file output_file Example: mysqlpump --compress-output=ZLIB > dump.zlib zlib_decompress ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-online-add-node-remarks.html
REORGANIZE PARTITION (or the execution of any other DDL statement), it is not possible to restart cluster data nodes. The creation of the node group is rolled back If the execution of CREATE NODEGROUP has reached the internal commit point: When ...
https://dev.mysql.com/doc/refman/5.7/en/mysqlimport.html
If the file does not exist or is otherwise inaccessible, an error occurs. If the file does not exist or is otherwise inaccessible, an error occurs. If you do not specify either option, an error occurs when a duplicate key value is found, and the ...
https://dev.mysql.com/doc/refman/5.7/en/group-by-modifiers.html
In this case, each time there is a change in value in any but the last grouping column, the query produces an extra super-aggregate summary row. The GROUP BY clause permits a WITH ROLLUP modifier that causes summary output to include extra rows ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-ndbinfo-cluster-transactions.html
The cluster_transactions table shows information about all ongoing transactions in an NDB Cluster. (Currently, the MySQL Server does not expose the NDB API transaction ID of an ongoing transaction.) block_instance refers to an instance of a kernel ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-ndbinfo-server-transactions.html
The server_transactions table is subset of the cluster_transactions table, but includes only those transactions in which the current SQL node (MySQL Server) is a participant, while including the relevant connection IDs. Together with the block ...
https://dev.mysql.com/doc/refman/5.7/en/mysqld-multi.html
(If the option is given multiple times, the last value is used.) Command-Line Format --defaults-extra-file=filename Type File name Default Value [none] For additional information about these and other option-file options, see Section 4.2.2.3, ...
https://dev.mysql.com/doc/refman/5.7/en/no-matching-rows.html
Remove one table at a time from the query until it returns some rows. Verify that the test file demonstrates the problem by executing these commands: $> mysqladmin create test2 $> mysql test2 < query.sql Attach the test file to a bug report, which ... If you have a complicated query that uses many tables but that returns no rows, you should use the following procedure to find out what is wrong: Test the query with EXPLAIN to check whether you can find something that is obviously ...
https://dev.mysql.com/doc/refman/5.7/en/analyze-table.html
Column Value Table The table name Op Always analyze Msg_type status, error, info, note, or warning Msg_text An informational message Key Distribution Analysis If the table has not changed since the last key distribution analysis, the table is not ...