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/firewall.html
MySQL Enterprise Edition includes MySQL Enterprise Firewall, an application-level firewall that enables database administrators to permit or deny SQL statement execution based on matching against lists of accepted statement patterns. For a given ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-memcached-developing.html
Typically, writing an application for the InnoDB memcached plugin involves some degree of rewriting or adapting existing code that uses MySQL or the memcached API. You can perform the conversion on the application side, or by using the CAST() ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-performance-optimizer-statistics.html
You can manually modify the mysql.innodb_table_stats and mysql.innodb_index_stats tables to force a specific query optimization plan or to test alternative plans without modifying the database. This section describes how to configure persistent and ...Persistent optimizer statistics also provide control and flexibility with these additional benefits: You can use the innodb_stats_auto_recalc configuration option to control whether statistics are updated automatically after substantial changes to a ...
https://dev.mysql.com/doc/refman/5.7/en/logical-operators.html
Most of this is common to different SQL database servers, although some servers may return any nonzero value for TRUE. For example, the following statements all assess to TRUE: mysql> SELECT 10 IS TRUE; -> 1 mysql> SELECT -10 IS TRUE; -> 1 mysql> ...
https://dev.mysql.com/doc/refman/5.7/en/mysqldump-definition-data-dumps.html
The --no-data option tells mysqldump not to dump table data, resulting in the dump file containing only statements to create the tables. Conversely, the --no-create-info option tells mysqldump to suppress CREATE statements from the output, so that ...
https://dev.mysql.com/doc/refman/5.7/en/creating-ssl-rsa-files.html
RSA key files enable MySQL to support secure password exchange over unencrypted connections for accounts authenticated by the sha256_password plugin. The following discussion describes how to create the files required for SSL and RSA support in ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-disk-management.html
Within these constraints, InnoDB tries to optimize the database work and the organization of disk files to minimize the amount of disk I/O. Sometimes, I/O is postponed until the database is not busy, or until everything needs to be brought to a ...
https://dev.mysql.com/doc/refman/5.7/en/group-replication-server-states.html
If servers are communicating properly, all report the same states for all servers. However, if there is a network partition, or a server leaves the group, then different information could be reported, depending on which server is queried. If the ...
https://dev.mysql.com/doc/refman/5.7/en/group-replication-the-group.html
In MySQL Group Replication, a set of servers forms a replication group. A group has a name, which takes the form of a UUID. If a server leaves the group, for instance it was taken down for maintenance, the remaining servers notice that it has left ...The group is dynamic and servers can leave (either voluntarily or involuntarily) and join it at any ...
https://dev.mysql.com/doc/refman/5.7/en/ipv6-system-support.html
These links may be helpful in setting up IPv6 on various platforms: Windows Gentoo Linux Ubuntu Linux Linux (Generic) macOS . Before MySQL Server can accept IPv6 connections, the operating system on your server host must support IPv6. To produce a ...As a simple test to determine whether that is true, try this command: $> ping6 ::1 16 bytes from ::1, icmp_seq=0 hlim=64 time=0.171 ms 16 bytes from ::1, icmp_seq=1 hlim=64 time=0.077 ms ...