PDF (US Ltr)
- 43.3Mb
PDF (A4)
- 43.4Mb
Man Pages (TGZ)
- 296.5Kb
Man Pages (Zip)
- 401.9Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/windows-troubleshooting.html
When installing and running MySQL for the first time, you may encounter certain errors that prevent the MySQL server from starting. The following examples show other common error messages you might encounter when installing MySQL and starting the ...This section helps you diagnose and correct some of these ...
https://dev.mysql.com/doc/refman/8.0/en/x-plugin-system-monitoring.html
Issue: mysql-py> \sql SELECT NAME, ENABLED, TIMED FROM performance_schema.setup_instruments WHERE NAME LIKE 'statement/%' AND NOT (ENABLED and TIMED) If this statement reports at least one row, you need to enable the instruments. For general X ...
https://dev.mysql.com/doc/refman/8.0/en/alter-event.html
ALTER EVENT myevent ON SCHEDULE AT CURRENT_TIMESTAMP + INTERVAL 1 DAY DO TRUNCATE TABLE myschema.mytable; Specify the options in an ALTER EVENT statement only for those characteristics that you want to change; omitted options keep their existing ...
https://dev.mysql.com/doc/refman/8.0/en/alter-instance.html
For additional information about reconfiguring the TLS context, including which system and status variables are context-related, see Server-Side Runtime Configuration and Monitoring for Encrypted Connections. If the CRL file is large, the server ...
https://dev.mysql.com/doc/refman/8.0/en/alter-resource-group.html
The name and type attributes are set at group creation time and cannot be modified thereafter with ALTER RESOURCE GROUP. ALTER RESOURCE GROUP group_name [VCPU [=] vcpu_spec [, vcpu_spec] ...] [THREAD_PRIORITY [=] N] [ENABLE|DISABLE [FORCE]] ...
https://dev.mysql.com/doc/refman/8.0/en/alter-table.html
This is sometimes also referred to as a “copying” or “offline” ALTER TABLE. This is sometimes also referred to as a “non-copying” or “online” ALTER TABLE. However, this is sometimes not the case, such as when you swap names or move ... ALTER TABLE tbl_name [alter_option [, alter_option] ...] [partition_options] alter_option: { table_options | ADD [COLUMN] col_name column_definition [FIRST | AFTER col_name] | ADD [COLUMN] (col_name column_definition,...) | ADD {INDEX | KEY} [index_name] [index_type] (key_part,...) [index_option] ...
https://dev.mysql.com/doc/refman/8.0/en/analyze-table.html
Statistics are collected again the next time the table is accessed. ANALYZE [NO_WRITE_TO_BINLOG | LOCAL] TABLE tbl_name UPDATE HISTOGRAM ON col_name [, col_name] ... [WITH N BUCKETS] ANALYZE [NO_WRITE_TO_BINLOG | LOCAL] TABLE tbl_name UPDATE ...
https://dev.mysql.com/doc/refman/8.0/en/arithmetic-functions.html
For example, to add date values, use DATE_ADD(); see Section 14.7, “Date and Time Functions”. Table 14.9 Arithmetic Operators Name Description %, MOD Modulo operator * Multiplication operator + Addition operator - Minus operator - Change the ...
https://dev.mysql.com/doc/refman/8.0/en/atomic-ddl.html
DDL operations such as ALTER TABLE may perform the Prepare and Perform phases multiple times prior to the Commit phase. An atomic DDL statement combines the data dictionary updates, storage engine operations, and binary log writes associated with a ...
https://dev.mysql.com/doc/refman/8.0/en/audit-api-message-emit.html
To install the audit_api_message_emit component, use this statement: INSTALL COMPONENT "file://component_audit_api_message_emit"; Component installation is a one-time operation that need not be done per server startup. As of MySQL 8.0.14, the ...