PDF (US Ltr)
- 43.3Mb
PDF (A4)
- 43.4Mb
Man Pages (TGZ)
- 297.1Kb
Man Pages (Zip)
- 402.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/keyring-plugin-installation.html
(Also, for general information about installing plugins, see Section 7.6.1, “Installing and Uninstalling Plugins”.) To use a keyring component instead, begin with Section 8.4.4.2, “Keyring Component Installation”. Note Only one keyring ...
https://dev.mysql.com/doc/refman/8.0/en/optimizing-innodb-storage-layout.html
You may find that there are significant gains for some and not for others, or that the gains decrease over time until you next optimize the table. Once your data reaches a stable size, or a growing table has increased by tens or some hundreds of ...
https://dev.mysql.com/doc/refman/8.0/en/outer-join-optimization.html
MySQL implements an A LEFT JOIN B join_specification as follows: Table B is set to depend on table A and all tables on which A depends. (In other words, any condition in the WHERE clause is not used.) All standard join optimizations are performed, ...Table A is set to depend on all tables (except B) that are used in the LEFT JOIN ...
https://dev.mysql.com/doc/refman/8.0/en/privilege-changes.html
If you modify the grant tables indirectly using an account-management statement, the server notices these changes and loads the grant tables into memory again immediately. If you modify the grant tables directly using statements such as INSERT, ...
https://dev.mysql.com/doc/refman/8.0/en/replication-solutions-backups-mysqldump.html
Because the format of the information is SQL statements, the file can easily be distributed and applied to running servers in the event that you need access to the data in an emergency. Tip Consider using the MySQL Shell dump utilities, which ...
https://dev.mysql.com/doc/refman/8.0/en/spatial-types.html
MySQL spatial extensions enable the generation, storage, and analysis of geographic features: Data types for representing spatial values Functions for manipulating spatial values Spatial indexing for improved access times to spatial columns The ...
https://dev.mysql.com/doc/refman/8.0/en/group-replication-probes-and-statistics.html
The monitoring mechanism works by having each member deploying a set of probes to collect information about its work queues and throughput. Such probes are scattered throughout the plugin stack and allow one to establish metrics, such as: the ...It ...
https://dev.mysql.com/doc/refman/8.0/en/selecting-rows.html
String comparisons normally are case-insensitive, so you can specify the name as 'bowser', 'BOWSER', and so forth. As shown in the preceding section, it is easy to retrieve an entire table. But typically you don't want to see the entire table, ...
https://dev.mysql.com/doc/refman/8.0/en/table-size-limit.html
For up-to-date information operating system file size limits, refer to the documentation specific to your operating system. Windows users, please note that FAT and VFAT (FAT32) are not considered suitable for production use with MySQL. You are using ... The effective maximum table size for MySQL databases is usually determined by operating system constraints on file sizes, not by MySQL internal ...
https://dev.mysql.com/doc/refman/8.0/en/upgrade-troubleshooting.html
In this case, check the date for your mysql.h file and libmysqlclient.a library to verify that they are from the new MySQL distribution. A schema mismatch in a MySQL 5.7 instance between the .frm file of a table and the InnoDB data dictionary can ...If problems occur, such as that the new mysqld server does not start, verify that you do not have an old my.cnf file from your previous ...