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/index-preloading.html
If there are enough blocks in a key cache to hold blocks of an entire index, or at least the blocks corresponding to its nonleaf nodes, it makes sense to preload the key cache with index blocks before starting to use it. Preloading enables you to ...
https://dev.mysql.com/doc/refman/5.7/en/information-schema-ndb-transid-mysql-connection-map-table.html
The ndb_transid_mysql_connection_map table provides a mapping between NDB transactions, NDB transaction coordinators, and MySQL Servers attached to an NDB Cluster as API nodes. This information is used when populating the server_operations and ...
https://dev.mysql.com/doc/refman/5.7/en/macos-installation-prefpane.html
The MySQL Installation Package includes a MySQL preference pane that enables you to start, stop, and control automated startup during boot of your MySQL installation. This preference pane is installed by default, and is listed under your system's ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-programs-ndb-print-frag-file.html
It is intended for use in helping to diagnose issues with data node restarts. Each fragment file contains records of the fragments belonging to each NDB table. For more information about cluster fragment files, see NDB Cluster Data Node File System ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-stage-summary-tables.html
row *************************** EVENT_NAME: stage/sql/checking permissions COUNT_STAR: 57 SUM_TIMER_WAIT: 26501888880 MIN_TIMER_WAIT: 7317456 AVG_TIMER_WAIT: 464945295 MAX_TIMER_WAIT: 12858936792 ... row *************************** EVENT_NAME: ...
https://dev.mysql.com/doc/refman/5.7/en/column-indexes.html
The maximum number of indexes per table and the maximum index length is defined per storage engine. If a search term exceeds the index prefix length, the index is used to exclude non-matching rows, and the remaining rows are examined for possible ...
https://dev.mysql.com/doc/refman/5.7/en/security-plugins.html
(MySQL Enterprise Edition only) MySQL Enterprise Audit, implemented using a server plugin, uses the open MySQL Audit API to enable standard, policy-based monitoring and logging of connection and query activity executed on specific MySQL servers.
https://dev.mysql.com/doc/refman/5.7/en/innodb-checkpoints.html
Although in the past large log files could make crash recovery take excessive time, starting with MySQL 5.5, performance enhancements to crash recovery make it possible to use large log files with fast startup after a crash. Making your log files ...
https://dev.mysql.com/doc/refman/5.7/en/server-configuration-defaults.html
For general instructions on setting parameters at startup or runtime, see Section 5.1.6, “Server Command Options”, and Section 5.1.7, “Server System Variables”. After completing the installation process, you can edit the default option file ... The MySQL server has many operating parameters, which you can change at server startup using command-line options or configuration files (option ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-config.html
mysql_config provides you with useful information for compiling your MySQL client and connecting it to MySQL. It is a shell script, so it is available only on Unix and Unix-like systems. Note As of MySQL 5.7.9, pkg-config can be used as an ...