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/innodb-table-import.html
If a ROW_FORMAT option is not defined explicitly in the table definition or ROW_FORMAT=DEFAULT is used, the innodb_default_row_format setting must be the same on the source and destination instances. A convenient way to accomplish this is to add ...
https://dev.mysql.com/doc/refman/5.7/en/aggregate-functions.html
For SET or ENUM values, the cast operation causes the underlying numeric value to be used. mysql> SELECT student_name, MIN(test_score), MAX(test_score) FROM student GROUP BY student_name; For MAX(), MySQL currently compares ENUM and SET columns by ... This section describes aggregate functions that operate on sets of ...If you use an aggregate function in a statement ...
https://dev.mysql.com/doc/refman/5.7/en/json-search-functions.html
The functions in this section perform search operations on JSON values to extract data from them, report whether data exists at a location within them, or report the path to data within them. A candidate object is contained in a target object if ...
https://dev.mysql.com/doc/refman/5.7/en/creating-ssl-rsa-files-using-mysql.html
Files created using mysql_ssl_rsa_setup are owned by the user who invoked that program. For some distribution types, such as RPM and DEB packages, mysql_ssl_rsa_setup invocation occurs during data directory initialization. Automatic SSL and RSA File ...Important Server autogeneration and mysql_ssl_rsa_setup help lower the barrier to using SSL by making it easier to generate the required ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-system-tablespace.html
When using a raw disk partition, ensure that the user ID that runs the MySQL server has read and write privileges for that partition. For example, if running the server as the mysql user, the partition must be readable and writeable by mysql. To do ... The system tablespace is the storage area for the InnoDB data dictionary, the doublewrite buffer, the change buffer, and undo ...It ...
https://dev.mysql.com/doc/refman/5.7/en/system-variable-privileges.html
For some system variables, setting the session value may have effects outside the current session and thus is a restricted operation that can be done only by users who have the SUPER privilege. In contrast to setting global runtime values, setting ...Setting the session value of these variables affects binary logging for the current session, but may also have wider implications for the integrity of server replication and ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-replication-failover.html
Of course, it is not possible for one mysqld instance to access user variables set on another server instance directly. We have employed a user variable @latest here to represent the value obtained in Step 1. This means that the ndb_apply_status ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-consumer-configurations.html
The consumer settings in the setup_consumers table form a hierarchy from higher levels to lower. If you do not need the information provided by enabling lower-level settings, disable them and the Performance Schema executes less code on your behalf ...The following discussion describes how consumers work, showing specific configurations and their effects as consumer settings are enabled progressively from high to ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-memcached-intro.html
The default settings represent a combination of high reliability and the fewest surprises for database applications. For example, default settings avoid uncommitted data on the database side, or stale data returned for memcached get requests. You ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-ndbinfo-nodes.html
SINGLEUSER is displayed in the status column for all data nodes when the cluster is in single user mode (see Section 21.6.6, “NDB Cluster Single User Mode”). For example, if you put the cluster in single user mode, you can sometimes see data ...