PDF (US Ltr)
- 35.0Mb
PDF (A4)
- 35.1Mb
Man Pages (TGZ)
- 254.9Kb
Man Pages (Zip)
- 359.9Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/range-optimization.html
Additionally, for BTREE indexes, comparison of a key part with a constant value is a range condition when using the >, <, >=, <=, BETWEEN, !=, or <> operators, or LIKE comparisons if the argument to LIKE is a constant string that does not start with ... The range access method uses a single index to retrieve a subset of table rows that are contained within one or several index value ...
https://dev.mysql.com/doc/refman/5.7/en/partitioning-info.html
row *************************** id: 1 select_type: SIMPLE table: trb1 partitions: p0,p1,p2,p3 type: ALL possible_keys: NULL key: NULL key_len: NULL ref: NULL rows: 10 Extra: Using filesort In this case, all four partitions are searched. This ...
https://dev.mysql.com/doc/refman/5.7/en/audit-log-filter-definitions.html
Arguments can refer to predefined variables, event fields, or string or numeric constants. The following list describes the permitted predefined functions for function items: audit_log_exclude_accounts_is_null() Checks whether the ...For information ...
https://dev.mysql.com/doc/refman/5.7/en/show-columns.html
Collation The collation for nonbinary string columns, or NULL for other columns. The value is YES if NULL values can be stored in the column, NO if not. (A UNIQUE index permits multiple NULL values, but you can tell whether the column permits NULL ... SHOW [FULL] {COLUMNS | FIELDS} {FROM | IN} tbl_name [{FROM | IN} db_name] [LIKE 'pattern' | WHERE expr] SHOW COLUMNS displays information about the columns in a given ...
https://dev.mysql.com/doc/refman/5.7/en/audit-log-file-reading.html
A successful call to audit_log_read() to read events returns a JSON string containing an array of audit events: If the final value of the returned array is not a JSON null value, there are more events following those just read and audit_log_read() ...audit_log_read() takes an optional JSON string argument, and the result returned from a successful call to either function is a JSON ...
https://dev.mysql.com/doc/refman/5.7/en/mysqlbinlog-row-events.html
# at 218 #080828 15:03:08 server id 1 end_log_pos 258 Write_rows: table id 17 flags: STMT_END_F BINLOG ' fAS3SBMBAAAALAAAANoAAAAAABEAAAAAAAAABHRlc3QAAXQAAwMPCgIUAAQ= fAS3SBcBAAAAKAAAAAIBAAAQABEAAAAAAAEAA//8AQAAAAVhcHBsZQ== '/*!*/; ### INSERT INTO ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-disk-data-objects.html
An extra “NULL row” provides additional information about undo log files. NDB Cluster Disk Data storage is implemented using a number of Disk Data objects. These include the following: Tablespaces act as containers for other Disk Data objects.
https://dev.mysql.com/doc/refman/5.7/en/mysqlimport.html
--character-sets-dir=dir_name Command-Line Format --character-sets-dir=path Type String Default Value [none] The directory where character sets are installed. --debug[=debug_options], -# [debug_options] Command-Line Format --debug[=debug_options] ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-nutshell.html
JSON values are not stored as strings, instead using an internal binary format that permits quick read access to document elements. This function also works with a string that can be parsed as a JSON value. This function also accepts a valid string ... This section summarizes what has been added to, deprecated in, and removed from MySQL ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-events-statements-current-table.html
DIGEST The statement digest MD5 value as a string of 32 hexadecimal characters, or NULL if the statements_digest consumer is no. END_EVENT_ID This column is set to NULL when the event starts and updated to the thread current event number when the ...