Search Results
https://dev.mysql.com/doc/refman/9.7/en/trigger-metadata.html
To obtain metadata about triggers: Query the TRIGGERS table of the INFORMATION_SCHEMA database.
https://dev.mysql.com/doc/refman/9.7/en/unix-signal-response.html
SIGHUP causes the server to reload the grant tables and to flush tables, logs, the thread cache, and the host cache. On Unix and Unix-like systems, a process can be the recipient of signals sent to it by the root system account or the system ...
https://dev.mysql.com/doc/refman/9.7/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/9.7/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/9.7/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/9.7/en/view-metadata.html
To obtain metadata about views: Query the VIEWS table of the INFORMATION_SCHEMA database.
https://dev.mysql.com/doc/refman/9.7/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/9.7/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/9.7/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 ...
https://dev.mysql.com/doc/refman/9.7/en/xa-states.html
An XA transaction progresses through the following states: Use XA START to start an XA transaction and put it in the ACTIVE state. For an ACTIVE XA transaction, issue the SQL statements that make up the transaction, and then issue an XA END ...