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/string-functions.html
This function does not work properly if the first argument contains a comma (,) character. (Multibyte characters therefore become more than two digits.) The inverse of this operation is performed by the UNHEX() function. mysql> SELECT ...For ...
https://dev.mysql.com/doc/refman/5.7/en/audit-log-file-reading.html
(This capability does not apply to log files written in other formats.) When the audit log plugin initializes and is configured for JSON logging, it uses the directory containing the current audit log file as the location to search for readable ...
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/firewall-installation.html
Installation can be performed using a graphical interface or manually: On Windows, MySQL Installer includes an option to enable MySQL Enterprise Firewall for you. Manual MySQL Enterprise Firewall installation involves running a script located in the ... MySQL Enterprise Firewall installation is a one-time operation that installs the elements described in Section 6.4.6.1, “Elements of MySQL Enterprise ...
https://dev.mysql.com/doc/refman/5.7/en/disk-issues.html
This section describes ways to configure storage devices when you can devote more and faster storage hardware to the database server. This problem becomes more apparent when the amount of data starts to grow so large that effective caching becomes ...For information about optimizing an InnoDB configuration to improve I/O performance, see Section 8.5.8, “Optimizing InnoDB Disk ...
https://dev.mysql.com/doc/refman/5.7/en/group-replication-limitations.html
This is because foreign key constraints that result in cascading operations executed by a multi-primary mode group can result in undetected conflicts and lead to inconsistent data across the members of the group. In single-primary mode this is not a ...Note that the limitations and issues described for multi-primary mode groups can also apply in single-primary mode clusters during a failover event, while the newly elected primary flushes out its applier queue from the old ...
https://dev.mysql.com/doc/refman/5.7/en/index-extensions.html
Consider this table definition: CREATE TABLE t1 ( i1 INT NOT NULL DEFAULT 0, i2 INT NOT NULL DEFAULT 0, d DATE DEFAULT NULL, PRIMARY KEY (i1, i2), INDEX k_d (d) ) ENGINE = InnoDB; This table defines the primary key on columns (i1, i2). It also ...
https://dev.mysql.com/doc/refman/5.7/en/information-schema-innodb-sys-tablestats-table.html
This data is used by the MySQL optimizer to calculate which index to use when querying an InnoDB table. This information is derived from in-memory data structures rather than data stored on disk. InnoDB tables are represented in this view if they ...
https://dev.mysql.com/doc/refman/5.7/en/myisam-repair.html
The discussion in this section describes how to use myisamchk on MyISAM tables (extensions .MYI and .MYD). In this case, you must use ALTER TABLE to increase the MAX_ROWS and AVG_ROW_LENGTH table option values: ALTER TABLE tbl_name MAX_ROWS=xxx ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-online-add-node-basics.html
In this section, we list the basic steps required to add new data nodes to an NDB Cluster. This procedure applies whether you are using ndbd or ndbmtd binaries for the data node processes. In the event that you have API nodes using dynamically ...