Search Results
https://dev.mysql.com/doc/connector-python/en/connector-python-example-ddl.html
All DDL (Data Definition Language) statements are executed using a handle structure known as a cursor. If there is an error, we examine the error number to check if the database does not exist. On any other error, the application exits and displays ...The following examples show how to create the tables of the Employee Sample ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-limitations-other.html
As of MySQL 9.5.0, queries that call a stored function are supported with the following limitations: The query runs with forced secondary engine only: SET use_secondary_engine=forced; The function definition must not contain IF or ELSE statements.
https://dev.mysql.com/doc/refman/8.4/en/replication-features-max-allowed-packet.html
If you are replicating large column values (such as might be found in TEXT or BLOB columns) and max_allowed_packet is too small on the source, the source fails with an error, and the replica shuts down the replication I/O (receiver) thread.
https://dev.mysql.com/doc/internals/en/system-variables-controlling-trace.html
A brief overview from "mysqld --verbose --help": --optimizer-trace=name Controls tracing of the Optimizer: --optimizer-trace-features=name Enables/disables tracing of selected features of the Optimizer: ...
https://dev.mysql.com/doc/internals/en/caching.html
(Note that the some of the filenames contain an incorrect spelling of the word “cache.”) Key Cache A shared cache for all B-tree index blocks in the different NISAM files. Uses hashing and reverse linked lists for quick caching of the most ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-buffer-pool-flushing.html
This setting is recommended for non-rotational storage (SSD) devices where seek time is not a significant factor. When table data is stored on a traditional HDD storage device, flushing neighbor pages in one operation reduces I/O overhead (primarily ... InnoDB performs certain tasks in the background, including flushing of dirty pages from the buffer ...
https://dev.mysql.com/doc/refman/8.4/en/alter-user.html
When ALTER USER adds, modifies, or drops second and third factors in a single statement, operations are executed sequentially, but if any operation in the sequence fails the entire ALTER USER statement fails. Statements that modify secondary ...
https://dev.mysql.com/doc/workbench/en/wb-validation-plugins.html
Figure 9.21 Modeling: Validate Tab Information, warning, and error messages include an icon to show the severity of each issue visually. MySQL Workbench provides validation modules so that you can test your models before implementing them. The ...
https://dev.mysql.com/doc/internals/en/select-structure.html
At the time of creating or performing any JOIN::* operation, LEX::current_select points to an appropriate SELECT_LEX. There are two structures that describe selects: st_select_lex (SELECT_LEX) for representing SELECT itself st_select_lex_unit ...
https://dev.mysql.com/doc/internals/en/code-tree-representation.html
This is safe as the size of the trees is limited by either having a maximum of 256 elements for byte value compression or 4096 elements for distinct column value compression. Every left branch gets a 0 bit, every right branch gets a 1 bit. The ...