PDF (US Ltr)
- 43.2Mb
PDF (A4)
- 43.3Mb
Man Pages (TGZ)
- 295.2Kb
Man Pages (Zip)
- 400.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/events-privileges.html
Com_alter_event: The number of ALTER EVENT statements executed since the last server restart. To enable or disable the execution of scheduled events, it is necessary to set the value of the global event_scheduler system variable. The EVENT ...
https://dev.mysql.com/doc/refman/8.0/en/faqs-replication.html
To handle the process manually, you should be able to switch from a failed source to a pre-configured replica by altering your application to talk to the new server or by adjusting the DNS for the MySQL server from the failed server to the new ...
https://dev.mysql.com/doc/refman/8.0/en/faqs-views.html
What happens to a view if an underlying table is dropped or renamed? After a view has been created, it is possible to drop or alter a table or view to which the definition refers. What happens to a view if an underlying table is dropped or renamed? ...
https://dev.mysql.com/doc/refman/8.0/en/federated-usagenotes.html
It does not support ALTER TABLE, or any Data Definition Language statements that directly affect the structure of the table, other than DROP TABLE. The following items indicate features that the FEDERATED storage engine does and does not support: ...
https://dev.mysql.com/doc/refman/8.0/en/fips-mode.html
MySQL supports FIPS mode when a supported OpenSSL library and FIPS Object Module are available on the host system. FIPS mode on the server side applies to cryptographic operations performed by the server. This includes replication (source/replica ...
https://dev.mysql.com/doc/refman/8.0/en/forcing-innodb-recovery.html
If you encounter a runaway rollback caused by a failing mass import or ALTER TABLE, you can kill the mysqld process and set innodb_force_recovery to 3 to bring the database up without the rollback, and then DROP the table that is causing the runaway ... To investigate database page corruption, you might dump your tables from the database with SELECT ...
https://dev.mysql.com/doc/refman/8.0/en/fulltext-search.html
A FULLTEXT index definition can be given in the CREATE TABLE statement when a table is created, or added later using ALTER TABLE or CREATE INDEX. MATCH (col1,col2,...) AGAINST (expr [search_modifier]) search_modifier: { IN NATURAL LANGUAGE MODE | ...
https://dev.mysql.com/doc/refman/8.0/en/group-replication-frequently-asked-questions.html
Alternatively, from MySQL 8.0.21, you can specify them on the START GROUP_REPLICATION statement each time Group Replication is started. Alternatively, another way of fixing the issue specifically in Group Replication is to issue a STOP ...What is ...
https://dev.mysql.com/doc/refman/8.0/en/group-replication-system-variables.html
If an alternative port number is specified by the report_port system variable, that one is used instead. If their values have already been modified from the default, Group Replication does not alter them. For alternative mitigation strategies to ...
https://dev.mysql.com/doc/refman/8.0/en/index-statistics.html
(This may occur for bulk inserts or deletes, or some ALTER TABLE statements, for example.) If this happens, the statistics are collected using whatever value innodb_stats_method or myisam_stats_method has at the time. Storage engines collect ...