Search Results
https://dev.mysql.com/doc/refman/8.4/en/storage-requirements.html
While a NULL itself does not require any storage space, NDB reserves 4 bytes per row if the table definition contains any columns allowing NULL, up to 32 NULL columns. InnoDB Table Storage Requirements NDB Table Storage Requirements Numeric Type ...
https://dev.mysql.com/doc/workbench/en/wb-model-overview-privileges.html
The Schema Privileges panel has the following sections, used to create users for your schemas and to define roles: Users Roles The following figure displays the Schema Privileges section of the MySQL Model tab. Figure 9.7 Roles and Privileges ...
https://dev.mysql.com/doc/connectors/en/connector-net-tutorials-efmodel-ddl.html
This tutorial demonstrates how to create MySQL DDL from an Entity Framework model. Minimally, you will need Microsoft Visual Studio 2017 and MySQL Connector/NET 6.10 to perform this tutorial. Select ADO.NET Entity Data Model and click Add to open ...
https://dev.mysql.com/doc/connectors/en/connector-python-api-errors-custom-error-exception.html
Syntax: errors.custom_error_exception(error=None, exception=None) This method defines custom exceptions for MySQL server errors and returns current customizations. If error is a MySQL Server error number, you must also pass the exception class. The ...
https://dev.mysql.com/doc/connector-net/en/connector-net-tutorials-efmodel-ddl.html
This tutorial demonstrates how to create MySQL DDL from an Entity Framework model. Minimally, you will need Microsoft Visual Studio 2017 and MySQL Connector/NET 6.10 to perform this tutorial. Select ADO.NET Entity Data Model and click Add to open ...
https://dev.mysql.com/doc/connector-python/en/connector-python-api-errors-custom-error-exception.html
Syntax: errors.custom_error_exception(error=None, exception=None) This method defines custom exceptions for MySQL server errors and returns current customizations. If error is a MySQL Server error number, you must also pass the exception class. The ...
https://dev.mysql.com/doc/internals/en/logging-transactions-rules-for-non-committing-statements.html
The preliminary rules above, together with the principles for logging format, have been used to construct the following rules. CALL statements are unrolled (see ???TODO: add section about unrolling???), so that each statement executed by the stored ...
https://dev.mysql.com/doc/internals/en/not-so-fast-path.html
If the servers default auth method doesn't match the clients or accounts auth method a extra round is needed as usual. server uses mysql_native_password as default: 4d 00 00 00 0a 35 2e 36 2e 37 2d 6c 6f 67 00 01 M....5.6.7-log.. 00 00 00 51 5f 5a ...
https://dev.mysql.com/doc/internals/en/optimizer-partition-pruning.html
Partitions that did not get into this set (that is, those that were pruned away) will not be accessed at all: this is how query execution is made faster. With non-transactional tables such as MyISAM, locks are placed on entire partitioned table. It ...
https://dev.mysql.com/doc/internals/en/transactions-life-cycle.html
It will be filled in again by the next statement, and emptied again at the next statement's end. When a new connection is established, thd->transaction members are initialized to an empty state. If a statement uses any tables, all affected engines ...