Search Results
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-user-defined-functions-table.html
The user_defined_functions table contains a row for each loadable function registered automatically by a component or plugin, or manually by a CREATE FUNCTION statement. This is used to tell whether statements currently are accessing the function.
https://dev.mysql.com/doc/refman/8.4/en/postinstallation.html
This section discusses tasks that you should perform after installing MySQL: If necessary, initialize the data directory and create the MySQL grant tables. For other platforms and installation types, you must initialize the data directory manually.
https://dev.mysql.com/doc/refman/8.4/en/problems-connecting.html
For distributions that do not do this, you must initialize the data directory manually. To correct this when you invoke a client program, specify a --port option to indicate the proper port number, or a --socket option to indicate the proper named ... If you encounter problems when you try to connect to the MySQL server, the following items describe some courses of action you can take to correct the ...
https://dev.mysql.com/doc/refman/8.4/en/purge-binary-logs.html
This statement has no effect if the server was not started with the --log-bin option to enable binary logging. If you have an active replica that currently is reading one of the log files you are trying to delete, this statement does not delete the ... PURGE BINARY LOGS { TO 'log_name' | BEFORE datetime_expr } The binary log is a set of files that contain information about data modifications made by the MySQL ...
https://dev.mysql.com/doc/refman/8.4/en/rename-table.html
RENAME TABLE tbl_name TO new_tbl_name [, tbl_name2 TO new_tbl_name2] ... You must have ALTER and DROP privileges for the original table, and CREATE and INSERT privileges for the new table. You can rename tables locked with a LOCK TABLES statement, ...
https://dev.mysql.com/doc/refman/8.4/en/replication-asynchronous-connection-failover-replica.html
This is the case whether the sources are a managed group for which the membership is updated automatically, or whether they are added or changed manually using asynchronous_connection_failover_add_source(), ...To configure this feature, the ...
https://dev.mysql.com/doc/refman/8.4/en/replication-asynchronous-connection-failover.html
However, you can delete a managed group manually if it is no longer needed. This feature works with Group Replication, on a group configured in single-primary mode, where the group’s primary is a replica that has a replication channel using the ...
https://dev.mysql.com/doc/refman/8.4/en/replication-bugs.html
In this case, the replication thread stops and waits for you to clean up the tables manually to bring them into synchrony. When you have determined that there is no user error involved, and replication still either does not work at all or is ...
https://dev.mysql.com/doc/refman/8.4/en/replication-features-flush.html
This is not normally a problem because these statements do not modify table data. In addition, if you use FLUSH TABLES when renaming a MyISAM table that is part of a MERGE table, you must issue FLUSH TABLES manually on the replicas. Some forms of ...
https://dev.mysql.com/doc/refman/8.4/en/replication-features-invoked.html
For example, trying to replicate a loadable function with statement-based replication generates this warning because it currently cannot be determined by the MySQL server whether the function is deterministic. In the case of CREATE EVENT and ALTER ... Replication of invoked features such as loadable functions and stored programs (stored procedures and functions, triggers, and events) provides the following characteristics: The effects of the feature are always ...