PDF (US Ltr)
- 35.1Mb
PDF (A4)
- 35.2Mb
Man Pages (TGZ)
- 256.4Kb
Man Pages (Zip)
- 361.2Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/trigger-syntax.html
The statement following FOR EACH ROW defines the trigger body; that is, the statement to execute each time the trigger activates, which occurs once for each row affected by the triggering event. MySQL handles errors during trigger execution as ...It ... To create a trigger or drop a trigger, use the CREATE TRIGGER or DROP TRIGGER statement, described in Section 13.1.20, “CREATE TRIGGER Statement”, and Section 13.1.31, “DROP TRIGGER ...
https://dev.mysql.com/doc/refman/5.7/en/mysqldump.html
With --force, mysqldump prints the error message, but it also writes an SQL comment containing the view definition to the dump output and continues executing. The option value is a list of comma-separated error numbers specifying the errors to ...It ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-transaction-tables.html
Configuring Transaction Event Collection Transaction Boundaries Transaction Instrumentation Transactions and Nested Events Transactions and Stored Programs Transactions and Savepoints Transactions and Errors Configuring Transaction Event Collection ...Within the event hierarchy, wait events nest within stage events, which nest within statement events, which nest within transaction ...
https://dev.mysql.com/doc/refman/5.7/en/group-replication-configuring-instances.html
It might work, but chances are that the operations race and then the act of joining the group ends up in an error or a time out. The use of other storage engines, including the temporary MEMORY storage engine, might cause errors in Group Replication. Set the disabled_storage_engines system variable as follows to prevent their use: disabled_storage_engines="MyISAM,BLACKHOLE,FEDERATED,ARCHIVE,MEMORY" Note that with the MyISAM storage engine disabled, when you are upgrading a MySQL instance to a release where mysql_upgrade is still used (before MySQL 8.0.16), mysql_upgrade might fail with an ...
https://dev.mysql.com/doc/refman/5.7/en/proxy-users.html
This enables the external user to be a proxy for the second user; that is, to assume the privileges of the second user: The external user is a “proxy user” (a user who can impersonate or become known as another user). The second user is a ...The ...
https://dev.mysql.com/doc/refman/5.7/en/using-log-files.html
You can find the queries that take a long time to execute by starting mysqld with the slow query log enabled. You can also try the command EXPLAIN on all SELECT statements that takes a long time to ensure that mysqld is using indexes properly. If ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-ndbinfo-error-messages.html
The error_messages table provides information about The error_messages table contains the following columns: error_code Numeric error code error_description Description of error error_status Error status code error_classification Error ...
https://dev.mysql.com/doc/refman/5.7/en/group-replication-network-partitioning.html
If this happens, the attempt to add back the excluded member from the group results in an error with the message This member has more executed transactions than those present in the group. For example, in the above scenario of 5 servers where 3 ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-memory-summary-tables.html
Allocating a single byte one million times is not the same as allocating one million bytes a single time; tracking both sizes and counts can expose the difference. Memory summary tables do not contain timing information because memory events are not ...Operation counts help to understand or tune the overall pressure the server is putting on the memory allocator, which has an impact on ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-memcached-troubleshoot.html
If cas_column and expire_time_column fields of the innodb_memcached.containers table are set to NULL, the following error is returned when attempting to load the memcached plugin: InnoDB_Memcached: column 6 in the entry for config table 'containers' ...If you encounter the following error in the MySQL error log, the server might fail to start: failed to set rlimit for open ...