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/audit-log-legacy-filtering.html
The value for either variable can be NULL or a string containing one or more comma-separated account names, each in user_name@host_name format. Modifications to audit_log_include_accounts or audit_log_exclude_accounts affect only connections created ...This enables you to control whether audited events are written to the audit log file based on the account from which events originate or event ... Note This section describes legacy audit log filtering, which applies under either of these ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-page-compression.html
Page compression is enabled by specifying the COMPRESSION attribute with CREATE TABLE or ALTER TABLE. For page compression to work on Windows, the file system must be created with a cluster size smaller than 4K, and the innodb_page_size must be at ... InnoDB supports page-level compression for tables that reside in file-per-table ...
https://dev.mysql.com/doc/refman/5.7/en/precision-math-examples.html
Consider these statements: mysql> CREATE TABLE t (i INT, d DECIMAL, f FLOAT); mysql> INSERT INTO t VALUES(1,1,1); mysql> CREATE TABLE y SELECT AVG(i), AVG(d), AVG(f) FROM t; The result is a double only for the floating-point argument. This section ...
https://dev.mysql.com/doc/refman/5.7/en/replication-solutions-diffengines.html
Configuring different engines on the source and replica depends on how you set up the initial replication process: If you used mysqldump to create the database snapshot on your source, you could edit the dump file text to change the engine type used ... It does not matter for the replication process whether the source table on the source and the replicated table on the replica use different engine ...
https://dev.mysql.com/doc/refman/5.7/en/silent-column-changes.html
In some cases, MySQL silently changes column specifications from those given in a CREATE TABLE or ALTER TABLE statement. Trailing spaces are automatically deleted from ENUM and SET member values when the table is created. Specifying the CHARACTER ...These might be changes to a data type, to attributes associated with a data type, or to an index ...
https://dev.mysql.com/doc/refman/5.7/en/version-tokens-installation.html
To avoid this overhead, do not install it unless you plan to use it. This section describes how to install or uninstall Version Tokens, which is implemented in a plugin library file containing a plugin and loadable functions. For general information ...
https://dev.mysql.com/doc/refman/5.7/en/mysqldump-delimited-text.html
This section describes how to use mysqldump to create delimited-text dump files. The .sql file contains a CREATE TABLE statement for the table. The following command dumps the contents of the db1 database to files in the /tmp database: $> mysqldump ...For information about reloading such dump files, see Section 7.4.4, “Reloading Delimited-Text Format ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-transaction-tables.html
The cost of transaction instrumentation can be reduced various ways, such as enabling or disabling transaction instrumentation according to user, account, host, or thread (client connection). CREATE TABLE t2 (a INT) ENGINE = MyISAM; -- Transaction 1 ...Within the event hierarchy, wait events nest within stage events, which nest within statement events, which nest within transaction ...
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/backup-and-recovery.html
It is important to back up your databases so that you can recover your data and be up and running again in case problems occur, such as system crashes, hardware failures, or users deleting data by mistake. A group of MySQL servers can be configured ...Backups are also essential as a safeguard before upgrading a MySQL installation, and they can be used to transfer a MySQL installation to another system or to set up replica ...