Search Results
https://dev.mysql.com/doc/refman/8.4/en/mrr-optimization.html
Reading rows using a range scan on a secondary index can result in many random disk accesses to the base table when the table is large and not stored in the storage engine's cache. With the Disk-Sweep Multi-Range Read (MRR) optimization, MySQL ...
https://dev.mysql.com/doc/internals/en/transformations-singlerow.html
Item_singlerow_subselect will be rewritten only if it contains no FROM clause, and it is not part of UNION, and it is a scalar subquery. For now, there will be no conversion of subqueries with field or reference on top of item list (on the one ...
https://dev.mysql.com/doc/workbench/en/wb-design-schema.html
Database change management is a complex process that involves maintaining different versions of database schemas and manually modifying existing databases. To help with this administration task, MySQL Workbench includes schema synchronization and ...
https://dev.mysql.com/doc/workbench/en/wb-printing.html
The printing options used to create printouts of your EER Diagrams are found under the File menu. To create documentation of your models, see Section 9.1.1.1.5.1, “The DBDoc Model Reporting Dialog Window (MySQL Workbench Commercial)”.
https://dev.mysql.com/doc/connectors/en/connector-python-api-mysqlconnection-constructor.html
Syntax: cnx = MySQLConnection(**kwargs) The MySQLConnection constructor initializes the attributes and when at least one argument is passed, it tries to connect to the MySQL server. For a complete list of arguments, see Section 6.7.1, ...
https://dev.mysql.com/doc/connector-python/en/connector-python-api-mysqlconnection-constructor.html
Syntax: cnx = MySQLConnection(**kwargs) The MySQLConnection constructor initializes the attributes and when at least one argument is passed, it tries to connect to the MySQL server. For a complete list of arguments, see Section 7.1, ...
https://dev.mysql.com/doc/connector-python/en/connector-python-cext-module.html
To use the C Extension directly, import the _mysql_connector module rather than mysql.connector, then use the _mysql_connector.MySQL() class to obtain a MySQL instance. For example: import _mysql_connector ccnx = _mysql_connector.MySQL() ...
https://dev.mysql.com/doc/internals/en/automatic-trace-purging.html
Thus, if a statement contains substatements (example: invokes stored procedures, stored functions, triggers), the top statement and substatements each generate one trace, but at the execution's end only the last substatement's trace is visible. A ...
https://dev.mysql.com/doc/internals/en/client-wants-native-server-wants-old.html
$ mysql --default-auth=mysql_native_password ## against a mysql_old_password user Initial Handshake Packet: 50 00 00 00 0a 35 2e 36 2e 34 2d 6d 37 2d 6c 6f P....5.6.4-m7-lo 67 00 5d 0a 00 00 66 5c 7b 74 55 2d 7b 4b 00 ff g.]...f\{tU-{K.. ff 08 02 ...
https://dev.mysql.com/doc/internals/en/client-wants-old-server-wants-native.html
$ mysql --default-auth=mysql_old_password ## against a mysql_native_password user Initial Handshake Packet: 50 00 00 00 0a 35 2e 36 2e 34 2d 6d 37 2d 6c 6f P....5.6.4-m7-lo 67 00 5b 0a 00 00 6c 2e 3e 2f 6c 55 44 36 00 ff g.[...l.>/lUD6.. ff 08 02 ...