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/postinstallation.html
When you are ready to create additional user accounts, you can find information on the MySQL access control system and account management in Section 6.2, “Access Control and Account Management”. This section discusses tasks that you should ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-index-types.html
To get the best performance from queries, inserts, and other database operations, it is important to understand how InnoDB uses the clustered index to optimize the common lookup and DML operations. If there is no logical unique and non-null column ... Each InnoDB table has a special index called the clustered index that stores row ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-statistics-estimation.html
The auto-rehash feature enables automatic name completion of database, table, and column names for interactive users. The default setting for innodb_stats_on_metadata was changed to OFF when persistent optimizer statistics were enabled by default in ...For information about persistent optimizer statistics, see Section 14.8.11.1, “Configuring Persistent Optimizer Statistics ...Optimizer statistics ...
https://dev.mysql.com/doc/refman/5.7/en/cannot-create.html
If you get an error of the following type for some queries, it means that MySQL cannot create a temporary file for the result set in the temporary directory: Can't create/write to file '\\sqla3fe_0.ism'. The preceding error is a typical message for ...One fix is to start mysqld with the --tmpdir option or to add the option to the [mysqld] section of your option ...
https://dev.mysql.com/doc/refman/5.7/en/error-log-syslog.html
(On Windows, log_syslog is enabled by default.) If log_syslog is enabled, the following system variables can also be used for finer control. Note Using mysqld_safe for syslog error logging is deprecated; you should use the server system variables ...
https://dev.mysql.com/doc/refman/5.7/en/index-extensions.html
To check whether disabling use of index extensions improves performance, use this statement: SET optimizer_switch = 'use_index_extensions=off'; Use of index extensions by the optimizer is subject to the usual limits on the number of key parts in an ...This can result in more efficient query execution plans and better ... InnoDB automatically ...
https://dev.mysql.com/doc/refman/5.7/en/information-schema-innodb-metrics-table.html
To start, stop, and reset counters, set one of the system variables innodb_monitor_enable, innodb_monitor_disable, innodb_monitor_reset, or innodb_monitor_reset_all, using the name of the counter, the name of the module, a wildcard match for such a ... The INNODB_METRICS table provides a wide variety of InnoDB performance information, complementing the specific focus areas of the Performance Schema tables for ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-performance-multiple_io_threads.html
You can set values for these parameters in the MySQL option file (my.cnf or my.ini); you cannot change values dynamically. These parameters signify the number of background threads used for read and write requests, respectively. The default value ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-backup-configuration.html
You can also set a location for the backup files using the BackupDataDir configuration parameter. Five configuration parameters are essential for backup: BackupDataBufferSize The amount of memory used to buffer data before it is written to disk. In ...
https://dev.mysql.com/doc/refman/5.7/en/optimize-character.html
For character and string columns, follow these guidelines: Use binary collation order for fast comparison and sort operations, when you do not need language-specific collation features. When comparing values from different columns, declare those ...