Search Results
https://dev.mysql.com/doc/refman/8.4/en/replication-solutions-scaleout.html
You can use replication as a scale-out solution; that is, where you want to split up the load of database queries across multiple database servers, within some reasonable limitations. Replication in this situation enables you to distribute the ...
https://dev.mysql.com/doc/refman/8.4/en/revoke.html
The lower_case_table_names setting can only be configured when initializing the server.) When successfully executed from the mysql program, REVOKE responds with Query OK, 0 rows affected. A revoked privilege that is granted but not known to the ...
https://dev.mysql.com/doc/refman/8.4/en/select.html
When you use ORDER BY or GROUP BY to sort a column in a SELECT, the server sorts values using only the initial number of bytes indicated by the max_sort_length system variable. Within stored programs, LIMIT parameters can be specified using ...
https://dev.mysql.com/doc/refman/8.4/en/windows-extract-archive.html
To install MySQL manually, do the following: If you are upgrading from a previous version then refer to Section 3.11, “Upgrading MySQL on Windows” before beginning the upgrade process. Make sure that you are logged in as a user with ...
https://dev.mysql.com/doc/mysql-enterprise-backup/8.4/en/installing.html
Install MySQL Enterprise Backup on each database server whose contents you intend to back up. Typically, you perform all backup and restore operations locally, by running mysqlbackup on the same server as the MySQL instance. Verify the installation ...MySQL Enterprise Backup is packaged as either an archive file (.tgz, archived with tar and compressed with gzip) or as a platform-specific ...
https://dev.mysql.com/doc/mysql-cluster-manager/8.4/en/mcm-client-commands.html
These commands are issued to the management agent using the mysql client program included with the MySQL NDB Cluster distribution (for information about the mysql client not specific to using MySQL Cluster Manager, see mysql — The MySQL ...An ...
https://dev.mysql.com/doc/c-api/8.4/en/c-api-prepared-statement-interface.html
The MySQL client/server protocol provides for the use of prepared statements. Another advantage of prepared statements is that it uses a binary protocol that makes data transfer between client and server more efficient. For more information, see ...
https://dev.mysql.com/doc/c-api/8.4/en/mysql-errno.html
A rule of thumb is that all functions that have to ask the server for information reset mysql_errno() if they succeed. For example, the mysql client program displays errors using the following format, where 1146 is the mysql_errno() value and ...
https://dev.mysql.com/doc/c-api/8.4/en/mysql-options4.html
MYSQL_OPT_CONNECT_ATTR_ADD (argument types: char *, char *) This option adds an attribute key-value pair to the current set of connection attributes to pass to the server at connect time. Key names that begin with an underscore (_) are reserved for ... int mysql_options4(MYSQL *mysql, enum mysql_option option, const void *arg1, const void *arg2) Description mysql_options4() is similar to mysql_options() but has an extra fourth argument so that two values can be passed for the option specified in the second ...
https://dev.mysql.com/doc/c-api/8.4/en/mysql-stmt-prepare.html
For more information, see Caching of Prepared Statements and Stored Programs. CR_SERVER_LOST The connection to the server was lost during the query CR_UNKNOWN_ERROR An unknown error occurred. int mysql_stmt_prepare(MYSQL_STMT *stmt, const char ...