PDF (US Ltr)
- 35.1Mb
PDF (A4)
- 35.2Mb
Man Pages (TGZ)
- 256.4Kb
Man Pages (Zip)
- 361.3Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/index-condition-pushdown-optimization.html
Index Condition Pushdown (ICP) is an optimization for the case where MySQL retrieves rows from a table using an index. Without ICP, the storage engine traverses the index to locate rows in the base table and returns them to the MySQL server which ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-information-schema-system-tables.html
The following table name aliases are used to shorten the query string: INFORMATION_SCHEMA.INNODB_SYS_TABLES: a INFORMATION_SCHEMA.INNODB_SYS_TABLESPACES: b INFORMATION_SCHEMA.INNODB_SYS_TABLESTATS: c An IF() control flow function is used to account ... You can extract metadata about schema objects managed by InnoDB using InnoDB INFORMATION_SCHEMA system ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-parameters.html
Each page that is stored in or read from the buffer pool is assigned to one of the buffer pool instances randomly, using a hashing function. innodb_trx_rseg_n_slots_debug Command-Line Format --innodb-trx-rseg-n-slots-debug=# System Variable ...
https://dev.mysql.com/doc/refman/5.7/en/install-plugin.html
A plugin is initialized by executing its initialization function, which handles any setup that the plugin must perform before it can be used. When the server shuts down, it executes the deinitialization function for each plugin that is loaded so ...
https://dev.mysql.com/doc/refman/5.7/en/ipv6-support.html
For example: mysql> CREATE USER 'bill'@'::1' IDENTIFIED BY 'secret'; mysql> GRANT SELECT ON mydb.* TO 'bill'@'::1'; IPv6 functions enable conversion between string and internal format IPv6 address formats, and checking whether values represent valid ... Support for IPv6 in MySQL includes these capabilities: MySQL Server can accept TCP/IP connections from clients connecting over ...
https://dev.mysql.com/doc/refman/5.7/en/libmysqld-options.html
To specify an option file for a C program, use the --defaults-file option as one of the elements of the second argument of the mysql_library_init() function. Any options that may be given with the mysqld server daemon, may be used with an embedded ...
https://dev.mysql.com/doc/refman/5.7/en/loop.html
Within a stored function, RETURN can also be used, which exits the function entirely. [begin_label:] LOOP statement_list END LOOP [end_label] LOOP implements a simple loop construct, enabling repeated execution of the statement list, which consists ...
https://dev.mysql.com/doc/refman/5.7/en/manual-info.html
This manual is not intended for use with older versions of the MySQL software due to the many functional and other differences between MySQL 5.7 and previous versions. Text in this style is used to indicate a program option that affects how the ...
https://dev.mysql.com/doc/refman/5.7/en/miscellaneous-optimization-tips.html
Similarly, if your application computes a single result based on several column values or large volumes of data, combining the computation into a loadable function can help performance. See Section 23.2, “Using Stored Routines” and Adding ...
https://dev.mysql.com/doc/refman/5.7/en/multibyte-characters.html
If you want to add support for a new character set named MYSET that includes multibyte characters, you must use multibyte character functions in the ctype-MYSET.c source file in the strings directory. The existing character sets provide the best ...