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/regexp.html
This section does not contain all the details that can be found in Henry Spencer's regex(7) manual page. Table 12.14 Regular Expression Functions and Operators Name Description NOT REGEXP Negation of REGEXP REGEXP Whether string matches regular ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-innodb-cluster-introduction.html
This could involve making file copies, manually copying them, and so on. This chapter introduces MySQL InnoDB Cluster, which combines MySQL technologies to enable you to deploy and administer a complete integrated high availability solution for ...
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/mysql-installer-workflow.html
If you select this option, you are responsible for securing the Data folder and its related files manually after the server configuration finishes. This does not apply to files and directories for specific products, such as the MySQL server data ...
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/innodb-locking-reads.html
FOR UPDATE For index records the search encounters, locks the rows and any associated index entries, the same as if you issued an UPDATE statement for those rows. Your application code can ensure referential integrity throughout this sequence of ...
https://dev.mysql.com/doc/refman/5.7/en/account-names.html
This section describes the syntax for account names, including special values and wildcard rules. Because IP wildcard values are permitted in host values (for example, '198.51.100.%' to match every host on a subnet), someone could try to exploit ...