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/mysql-installer-catalog-dashboard.html
If you are using a Commercial release of MySQL Installer, the icon opens the MySQL Installer Commercial License Information User Manual for licensing information, including licensing information relating to third-party software that may be included ... This section describes the MySQL Installer product catalog, the dashboard, and other actions related to product selection and ...Product Catalog MySQL Installer Dashboard Locating Products to Install Upgrading MySQL Server Removing MySQL Server Upgrading MySQL Installer Product Catalog The product ...
https://dev.mysql.com/doc/refman/5.7/en/multiple-key-caches.html
Use this for tables that are heavily used for searches but that are not updated. This feature enables you to assign different table indexes to different key caches. Any attempt to do this is ignored: mysql> SET GLOBAL key_buffer_size = 0; mysql> ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-indexes.html
For example, if you have a three-column index on (col1, col2, col3), you have indexed search capabilities on (col1), (col1, col2), and (col1, col2, col3). In this context, VARCHAR and CHAR are considered the same if they are declared as the same ...
https://dev.mysql.com/doc/refman/5.7/en/column-count-limit.html
This section describes limits on the number of columns in tables and the size of individual rows. The exact column limit depends on several factors: The maximum row size for a table constrains the number (and possibly size) of columns because the ...Column Count Limits Row Size Limits Column Count Limits MySQL has hard limit of 4096 columns per table, but the effective maximum may be less for a given ...
https://dev.mysql.com/doc/refman/5.7/en/log-file-maintenance.html
To handle this situation, you must manually create the new log file with the proper ownership after renaming the original log file. If you installed MySQL from an RPM distribution, this script should have been installed automatically. Be careful ...
https://dev.mysql.com/doc/refman/5.7/en/purge-binary-logs.html
This statement has no effect if the server was not started with the --log-bin option to enable binary logging. If you have an active replica that currently is reading one of the log files you are trying to delete, this statement does not delete the ... PURGE { BINARY | MASTER } LOGS { TO 'log_name' | BEFORE datetime_expr } The binary log is a set of files that contain information about data modifications made by the MySQL ...
https://dev.mysql.com/doc/refman/5.7/en/replica-logs-status.html
The metadata in this repository includes the connection configuration, the replication user account details, the SSL settings for the connection, and the file name and position where the replication I/O thread is currently reading from the source's ... A replica server creates two replication metadata repositories, the connection metadata repository and the applier metadata ...
https://dev.mysql.com/doc/refman/5.7/en/is-null-optimization.html
For example, MySQL can use indexes and ranges to search for NULL with IS NULL. This optimization does not occur in cases when the column might produce NULL anyway (for example, if it comes from a table on the right side of a LEFT JOIN). This ...
https://dev.mysql.com/doc/refman/5.7/en/monitor-innodb-mutex-waits-performance-schema.html
For example, to disable InnoDB mutex wait event instruments related to full-text search, add the following rule: performance-schema-instrument='wait/synch/mutex/innodb/fts%=OFF' Note Rules with a longer prefix such as wait/synch/mutex/innodb/fts% ...
https://dev.mysql.com/doc/refman/5.7/en/change-replication-filter.html
Filters set using this statement differ from those set using the server options in two key respects: The statement does not require restarting the server to take effect, only that the replication SQL thread be stopped using STOP SLAVE SQL_THREAD ...