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/sql-transactional-statements.html
MySQL supports local transactions (within a given client session) through statements such as SET autocommit, START TRANSACTION, COMMIT, and ROLLBACK. XA transaction support enables MySQL to participate in distributed transactions as well.
https://dev.mysql.com/doc/refman/5.7/en/sys-extract-schema-from-file-name.html
Given a file path name, returns the path component that represents the schema name. This function assumes that the file name lies within the schema directory. For this reason, it does not work with partitions or tables defined using their own ...
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/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 ...