Search Results
https://dev.mysql.com/doc/refman/8.4/en/upgrade-troubleshooting.html
A schema mismatch in a MySQL 8.3 instance between the .frm file of a table and the InnoDB data dictionary can cause an upgrade to MySQL 8.4 to fail. To address this issue, dump and restore affected tables before attempting the upgrade again. If ...
https://dev.mysql.com/doc/refman/8.4/en/using-spatial-indexes.html
The optimizer investigates whether available spatial indexes can be involved in the search for queries that use a function such as MBRContains() or MBRWithin() in the WHERE clause. The following query finds all objects that are in the given ...
https://dev.mysql.com/doc/refman/8.4/en/validate-password-installation.html
INSTALL COMPONENT loads the component, and also registers it in the mysql.component system table to cause it to be loaded during subsequent server startups. To uninstall the validate_password component, use this statement: UNINSTALL COMPONENT ...
https://dev.mysql.com/doc/refman/8.4/en/view-check-option.html
The WITH CHECK OPTION clause can be given for an updatable view to prevent inserts to rows for which the WHERE clause in the select_statement is not true. In a WITH CHECK OPTION clause for an updatable view, the LOCAL and CASCADED keywords ...It ...
https://dev.mysql.com/doc/refman/8.4/en/view-metadata.html
To obtain metadata about views: Query the VIEWS table of the INFORMATION_SCHEMA database.
https://dev.mysql.com/doc/refman/8.4/en/window-function-descriptions.html
This section describes nonaggregate window functions that, for each row from a query, perform a calculation using rows related to that row. Most aggregate functions also can be used as window functions; see Section 14.19.1, “Aggregate Function ...
https://dev.mysql.com/doc/refman/8.4/en/windows-testing.html
In this case, start mysqld with the skip_name_resolve system variable enabled and use only localhost and IP addresses in the Host column of the MySQL grant tables. For more information about mysqlshow, see Section 6.5.6, “mysqlshow — Display ...
https://dev.mysql.com/doc/refman/8.4/en/windows-troubleshooting.html
Fatal error: Can't open and lock privilege tables: Table 'mysql.user' doesn't exist These messages often occur when the MySQL base or data directories are installed in different locations than the default locations (C:\Program Files\MySQL\MySQL ...
https://dev.mysql.com/doc/refman/8.4/en/x-plugin-option-variable-reference.html
This table provides an overview of the command options, system variables, and status variables provided by X Plugin.
https://dev.mysql.com/doc/refman/8.4/en/x-plugin-system-monitoring.html
To be able to monitor the generated SQL, the Performance Schema tables must be enabled. The SQL is registered under the performance_schema.events_statements_current, performance_schema.events_statements_history, and ... For general X Plugin ...