PDF (US Ltr)
- 43.3Mb
PDF (A4)
- 43.4Mb
Man Pages (TGZ)
- 297.2Kb
Man Pages (Zip)
- 402.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/innodb-introduction.html
InnoDB Enhancements and New Features For information about InnoDB enhancements and new features, refer to: The InnoDB enhancements list in Section 1.3, “What Is New in MySQL 8.0”. Additional InnoDB Information and Resources For InnoDB-related ...
https://dev.mysql.com/doc/refman/8.0/en/replication.html
MySQL 8.0 also supports delayed replication such that a replica deliberately lags behind the source by at least a specified amount of time; see Section 19.4.11, “Delayed Replication”. Replication enables data from one MySQL database server ...
https://dev.mysql.com/doc/refman/8.0/en/access-control.html
MySQL enables the creation of accounts that permit client users to connect to the server and access data managed by the server. The primary function of the MySQL privilege system is to authenticate a user who connects from a given host and to ...
https://dev.mysql.com/doc/refman/8.0/en/administrative-connection-interface.html
As mentioned in Connection Volume Management, to allow for the need to perform administrative operations even when max_connections connections are already established on the interfaces used for ordinary connections, the MySQL server permits a ...
https://dev.mysql.com/doc/refman/8.0/en/alter-table-partition-operations.html
ALGORITHM=1 causes the server to use the same key-hashing functions as MySQL 5.1 when computing the placement of rows in partitions; ALGORITHM=2 means that the server employs the key-hashing functions implemented and used by default for new KEY ...
https://dev.mysql.com/doc/refman/8.0/en/counting-rows.html
COUNT(*) counts the number of rows, so the query to count your animals looks like this: mysql> SELECT COUNT(*) FROM pet; +----------+ | COUNT(*) | +----------+ | 9 | +----------+ Earlier, you retrieved the names of the people who owned pets.
https://dev.mysql.com/doc/refman/8.0/en/gis-general-property-functions.html
mysql> SELECT ST_Dimension(ST_GeomFromText('LineString(1 1,2 2)')); +------------------------------------------------------+ | ST_Dimension(ST_GeomFromText('LineString(1 1,2 2)')) | +------------------------------------------------------+ | 1 | ...
https://dev.mysql.com/doc/refman/8.0/en/group-replication-multi-primary-mode.html
Group Replication does not handle client-side failover itself, so you need to arrange this using a middleware framework such as MySQL Router 8.0, a proxy, a connector, or the application itself. In MySQL 8.0.14 and later, if you want to have a ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-create-table-external.html
mysql> SELECT @@innodb_file_per_table; +-------------------------+ | @@innodb_file_per_table | +-------------------------+ | 1 | +-------------------------+ For more information about file-per-table tablespaces, see Section 17.6.3.2, ... There are ...
https://dev.mysql.com/doc/refman/8.0/en/partitioning-list.html
List partitioning in MySQL is similar to range partitioning in many ways. Note In MySQL 8.0, it is possible to match against only a list of integers (and possibly NULL—see Section 26.2.7, “How MySQL Partitioning Handles NULL”) when ...As in ...