Search Results
https://dev.mysql.com/doc/connector-net/en/connector-net-programming-stored-proc.html
A stored procedure is a set of SQL statements that is stored in the server. For example, to create a stored procedure named add_emp, use the CommandText property with the default command type (SQL text commands) to execute each individual SQL ...
https://dev.mysql.com/doc/refman/9.7/en/charset-errors.html
If the server sends the error message to a client program, the server converts it from UTF-8 to the character set specified by the character_set_results system variable. This section describes how the MySQL server uses character sets for ...For ...
https://dev.mysql.com/doc/refman/9.7/en/clone-plugin-failure-handling.html
Concurrent DDL on the donor is blocked only if the clone_block_ddl variable is set to ON (the default setting is OFF). If the cloning operation is unable to obtain a DDL lock within the time limit specified by the clone_ddl_timeout variable, an ...
https://dev.mysql.com/doc/refman/9.7/en/myisam-repair.html
myisamchk also has variables that you can set to control memory allocation that may improve performance. If you are going to repair a table from the command line, you must first stop the mysqld server. Note that when you do mysqladmin shutdown on a ... The discussion in this section describes how to use myisamchk on MyISAM tables (extensions .MYI and ...
https://dev.mysql.com/doc/refman/9.7/en/replication-gtids.html
For information about MySQL Server options and variables relating to GTID-based replication, see Section 19.1.6.5, “Global Transaction ID System Variables”. In addition, once a transaction with a given GTID is committed on a given server, any ...
https://dev.mysql.com/doc/refman/9.7/en/replication.html
Replication enables data from one MySQL database server (known as a source) to be copied to one or more MySQL database servers (known as replicas). In this environment, all writes and updates must take place on the source server. The original type ...Replication is asynchronous by default; replicas do not need to be connected permanently to receive updates from a ...
https://dev.mysql.com/doc/mysql-shell/9.7/en/mysql-connections-in-javascript-and-python.html
You can use functions available in JavaScript and Python mode to create multiple session objects of your chosen types and assign them to variables. These session objects let you establish and manage concurrent connections to work with multiple ...
https://dev.mysql.com/doc/connectors/en/connector-j-session-state-tracker.html
Connector/J can receive information on client session state changes tracked by the server if the tracking has been enabled on the server. However, the session state change information can also be received using a SessionStateChangesListener, which ...The reception of the information is enabled by setting the Connector/J connection property trackSessionState to true (default value is false for the ...
https://dev.mysql.com/doc/connector-j/en/connector-j-session-state-tracker.html
Connector/J can receive information on client session state changes tracked by the server if the tracking has been enabled on the server. However, the session state change information can also be received using a SessionStateChangesListener, which ...The reception of the information is enabled by setting the Connector/J connection property trackSessionState to true (default value is false for the ...
https://dev.mysql.com/doc/relnotes/mysql-operator/en/news-8-0-33-2.0.9.html
For example, "mysql/mysql-operator" becomes "container-registry.oracle.com/mysql/community-operator" with similar changes for the router, server, and operating system. Known Limitation Functionality Added or Changed Bugs Fixed Known Limitation A ...