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/data-dictionary-limitations.html
This section describes temporary limitations introduced with the MySQL data dictionary. Manual creation of database directories under the data directory (for example, with mkdir) is unsupported. Manually created database directories are not ...DDL ...
https://dev.mysql.com/doc/refman/8.0/en/default-privileges.html
This is the case if the data directory was initialized using mysqld --initialize, either manually or using an installer that does not give you the option of specifying a password during the install operation. This section describes how to assign a ... The MySQL installation process involves initializing the data directory, including the grant tables in the mysql system schema that define MySQL ...
https://dev.mysql.com/doc/refman/8.0/en/drop-database.html
In this case, you must remove any remaining files or directories manually and issue the DROP DATABASE statement again. Be very careful with this statement! To use DROP DATABASE, you need the DROP privilege on the database. This includes all files ...
https://dev.mysql.com/doc/refman/8.0/en/function-loading.html
MySQL supports automatic function loading during server startup and manual loading thereafter. Installing Loadable Functions Uninstalling Loadable Functions Reinstalling or Upgrading Loadable Functions Installing Loadable Functions To load a ...
https://dev.mysql.com/doc/refman/8.0/en/group-replication-configuring-instances.html
This is preferable in a production deployment to installing the plugin manually. This is important when setting up Group Replication as it ensures you can configure the server before manually starting the plugin. This section explains the ...
https://dev.mysql.com/doc/refman/8.0/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 ... Limit on Group Size Limits on Transaction Size The following known limitations exist for Group ...
https://dev.mysql.com/doc/refman/8.0/en/group-replication-system-variables.html
This safeguard is particularly important when the server is configured to start Group Replication on server boot (group_replication_start_on_boot=ON), but it is also useful when Group Replication is started manually using a START GROUP_REPLICATION ... This section lists the system variables that are specific to the Group Replication ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-persistent-stats.html
In this case innodb_stats_persistent_sample_pages should be decreased until ANALYZE TABLE execution time is acceptable. To avoid this scenario, innodb_stats_include_delete_marked can be enabled to ensure that delete-marked records are included when ... The persistent optimizer statistics feature improves plan stability by storing statistics to disk and making them persistent across server restarts so that the optimizer is more likely to make consistent choices each time for a given ...
https://dev.mysql.com/doc/refman/8.0/en/linux-installation-rpm.html
Be aware that they may differ from those built by Oracle in features, capabilities, and conventions (including communication setup), and that the installation instructions in this manual do not necessarily apply to them. For example, to install ...
https://dev.mysql.com/doc/refman/8.0/en/linux-installation-yum-repo.html
This is a typical entry for a MySQL 8.0 subrepository: [mysql80-community] name=MySQL 8.0 Community Server baseurl=http://repo.mysql.com/yum/mysql-8.0-community/el/9/$basearch/ enabled=1 gpgcheck=1 ...MySQL 8.0 must be manually enabled via your ...