Search Results
https://dev.mysql.com/doc/refman/8.4/en/sql-prepared-statements.html
Typically, database applications process large volumes of almost-identical statements, with only changes to literal or variable values in clauses such as WHERE for queries and deletes, SET for updates, and VALUES for inserts. For example, the C API ...Using prepared statements with placeholders for parameter values has the following benefits: Less overhead for parsing the statement each time it is ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-async-exec-prepared-stmt-app.html
Application-level asynchronous task lets you filter and track tasks for individual application users using an application-managed user ID. The next few parameter values specify the application-managed user ID app_user_01, database to use demo_db, ...
https://dev.mysql.com/doc/internals/en/user-level-locks.html
User-level locks are controlled with the SQL functions GET_LOCK(str,timeout) IS_FREE_LOCK(str) IS_USED_LOCK(str) RELEASE_LOCK(str) They can be used at places where SQL statements accept SQL functions. Nevertheless, a couple of synchronization ...
https://dev.mysql.com/doc/connectors/en/connector-net-tutorials-ssl-pfx.html
using (MySqlConnection connection = new MySqlConnection( "database=test;user=sslclient;" + "CertificateFile=H:\\git\\mysql-trunk\\mysql-test\\std_data\\client.pfx;" + "CertificatePassword=pass;" + "SslMode=Required ")) { connection.Open(); } The ...
https://dev.mysql.com/doc/connector-net/en/connector-net-tutorials-ssl-pfx.html
using (MySqlConnection connection = new MySqlConnection( "database=test;user=sslclient;" + "CertificateFile=H:\\git\\mysql-trunk\\mysql-test\\std_data\\client.pfx;" + "CertificatePassword=pass;" + "SslMode=Required ")) { connection.Open(); } The ...
https://dev.mysql.com/doc/refman/8.4/en/group-replication-frequently-asked-questions.html
How do I set credentials for the distributed recovery process? You can set the user credentials permanently as the credentials for the group_replication_recovery channel, using a CHANGE REPLICATION SOURCE TO statement. User credentials set using ...
https://dev.mysql.com/doc/refman/8.4/en/replication-gtids-concepts.html
The tag is a user-defined string used to identify a specific group of transactions; see the description of the gtid_next system variable for permitted syntax. When constructing a GTID set, a user-defined tag is treated as part of the UUID. For ...If ... A global transaction identifier (GTID) is a unique identifier created and associated with each transaction committed on the server of origin (the ...
https://dev.mysql.com/doc/ndbapi/en/mgm-errors.html
Value Description NDB_MGM_COULD_NOT_ENTER_SINGLE_USER_MODE Unable to enter single-user mode NDB_MGM_COULD_NOT_EXIT_SINGLE_USER_MODE Unable to exit single-user mode Configuration Errors These errors result when the management server is unable to ...
https://dev.mysql.com/doc/refman/8.4/en/information-schema-applicable-roles-table.html
The APPLICABLE_ROLES table provides information about the roles that are applicable for the current user. The APPLICABLE_ROLES table has these columns: USER The user name part of the current user account. GRANTEE The user name part of the account ...GRANTEE_HOST The host name part of the account to which the role is ...
https://dev.mysql.com/doc/refman/8.4/en/starting-server.html
Start the MySQL server like this if your installation includes mysqld_safe: $> bin/mysqld_safe --user=mysql & Note For Linux systems on which MySQL is installed using RPM packages, server startup and shutdown is managed using systemd rather than ...