Search Results
https://dev.mysql.com/doc/refman/8.4/en/innodb-deadlock-example.html
Client A enables innodb_print_all_deadlocks, creates two tables, 'Animals' and 'Birds', and inserts data into each. The following example illustrates how an error can occur when a lock request causes a deadlock. Thererfore, the previous read-only ...
https://dev.mysql.com/doc/refman/8.4/en/partitioning-list.html
For more detailed syntactical information, see Section 15.1.20, “CREATE TABLE Statement”. As with the other partitioning examples, we assume that the default_storage_engine is InnoDB.) Suppose that there are 20 video stores distributed among 4 ... List partitioning in MySQL is similar to range partitioning in many ...
https://dev.mysql.com/doc/mysql-enterprise-backup/8.4/en/backup-performance.html
In an emergency, the time needed to uncompress the backup data before restoring it might be unacceptable. InnoDB Configuration Options Settings As discussed later, there are a number of reasons why you might prefer to run with the setting ... This ...
https://dev.mysql.com/doc/refman/8.4/en/mysqlbinlog.html
Note that mysqlbinlog returns a suitable error if you attempt to read an encrypted binary log file directly, but older versions of mysqlbinlog do not recognise the file as a binary log file at all. The other option values are intended only for ...
https://dev.mysql.com/doc/refman/8.4/en/function-resolution.html
When the parser encounters a word that is the name of a built-in function, it must determine whether the name signifies a function call or is instead a nonexpression reference to an identifier such as a table or column name. This occurs even when ...
https://dev.mysql.com/doc/connectors/en/connector-odbc-configuration-connection-parameters.html
Table 5.1 Connector/ODBC DSN Configuration Options Parameter GUI Option Default Value Comment user User ODBC The user name used to connect to MySQL. See Table 5.3, “Connector/ODBC Option Parameters” and Table 5.4, “Recommended Connector/ODBC ...On Unix and macOS, use the parameter name and value as the keyword/value pair in the DSN ...
https://dev.mysql.com/doc/connector-odbc/en/connector-odbc-configuration-connection-parameters.html
Table 5.1 Connector/ODBC DSN Configuration Options Parameter GUI Option Default Value Comment user User ODBC The user name used to connect to MySQL. See Table 5.3, “Connector/ODBC Option Parameters” and Table 5.4, “Recommended Connector/ODBC ...On Unix and macOS, use the parameter name and value as the keyword/value pair in the DSN ...
https://dev.mysql.com/doc/ndbapi/en/ndbapi-examples-array-adapter.html
This program inserts CHAR, VARCHAR, and BINARY column data into a table by constructing aRef objects using array adapters of the type defined in common/array_adapter.hpp (see Section 2.5.15, “Common Files for NDB API Array Examples”). static ...
https://dev.mysql.com/doc/refman/8.4/en/stored-programs-logging.html
If a stored program that modifies data is nondeterministic, it is not repeatable. Triggers can update tables, so error messages similar to those for stored functions occur with CREATE TRIGGER if you do not have the required privileges. If a function ... The binary log contains information about SQL statements that modify database ...
https://dev.mysql.com/doc/workbench/en/wb-data-modeling-menus.html
For example, if an EER Diagram is active and a table on the canvas is the currently selected object, a dialog box may open asking whether you want to remove the table from the canvas only or from the database as well. For example, if a table has a ... Some menu items are not available in the MySQL Workbench Community Edition of this application, and are available only in the MySQL Workbench Commercial ...