Search Results
https://dev.mysql.com/doc/refman/8.4/en/storage-engine-setting.html
When you create a new table, you can specify which storage engine to use by adding an ENGINE table option to the CREATE TABLE statement: -- ENGINE=INNODB not needed unless you have set a different -- default storage engine. CREATE TABLE t1 (i INT) ...You can specify the default engine by using the --default-storage-engine server startup option, or by setting the default-storage-engine option in the my.cnf configuration ...
https://dev.mysql.com/doc/mysql-enterprise-backup/8.4/en/mysqlbackup.privileges.html
Here are the privileges required by mysqlbackup: The minimum privileges for the MySQL user with which mysqlbackup connects to the server include: SELECT on all databases and tables, for table locks that protect the backups against inconsistency ...
https://dev.mysql.com/doc/internals/en/x-protocol-messages-messages.html
Returns Mysqlx.Resultset:: message Update { required Collection collection = 2; optional DataModel data_model = 3; optional Mysqlx.Expr.Expr criteria = 4; repeated Mysqlx.Datatypes.Scalar args = 8; optional Limit limit = 5; repeated Order order = 6; ... Topics in this section: Message Structure Message Sequence Common Messages Connection Session Expectations CRUD SQL Result Sets Expressions Data Types This section provides detailed information about how X Protocol defines ...
https://dev.mysql.com/doc/ndbapi/en/ndb-ndbblob.html
NdbBlob Class Overview NdbBlob::ActiveHook NdbBlob::blobsFirstBlob() NdbBlob::blobsNextBlob() NdbBlob::close() NdbBlob::getBlobEventName() NdbBlob::getBlobTableName() NdbBlob::getColumn() NdbBlob::getLength() NdbBlob::getNull() ... This section ...
https://dev.mysql.com/doc/refman/8.4/en/index-condition-pushdown-optimization.html
Index Condition Pushdown (ICP) is an optimization for the case where MySQL retrieves rows from a table using an index. Without ICP, the storage engine traverses the index to locate rows in the base table and returns them to the MySQL server which ...With ICP enabled, and if parts of the WHERE condition can be evaluated by using only columns from the index, the MySQL server pushes this part of the WHERE condition down to the storage ...
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/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/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/workbench/en/dbdoc-templates-markers.html
Using the table The table shows which variables are defined in which sections. If a variable type is a variable, then the table describes its data dictionary, and a parent dictionary if type is a section. These markers can be used in any template, ...
https://dev.mysql.com/doc/mysql-em-plugin/en/myoem-config-metric-performanceschema-category.html
Table 7.27 Performance Schema Configuration Metrics NameDescriptionAccounts Size The number of rows in the accounts table. Digests Size The maximum number of rows in the events_statements_summary_by_digest table. Events Stages History Long Size The ... Lists the Performance Schema configuration metrics and provides a brief description of ...