PDF (US Ltr)
- 35.0Mb
PDF (A4)
- 35.1Mb
Man Pages (TGZ)
- 254.9Kb
Man Pages (Zip)
- 359.9Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/stored-program-variables.html
System variables and user-defined variables can be used in stored programs, just as they can be used outside stored-program context. It is not permitted to assign the value DEFAULT to stored procedure or function parameters or stored program local ...For information about the scope of local variables and how MySQL resolves ambiguous names, see Section 13.6.4.2, “Local Variable Scope and ...In addition, stored programs can use DECLARE to define local ...
https://dev.mysql.com/doc/refman/5.7/en/faqs-stored-procs.html
If replication or binary logging in general (for the purpose of point-in-time recovery) is active, then MySQL DBAs have two security options open to them: Any user wishing to create stored functions must be granted the SUPER privilege. You can ...Is ...
https://dev.mysql.com/doc/refman/5.7/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/5.7/en/information-schema-innodb-sys-columns-table.html
For character columns in multibyte character sets, this length value is the maximum length in bytes needed to represent a definition such as VARCHAR(N); that is, it might be 2*N, 3*N, and so on depending on the character encoding. The ...The ...
https://dev.mysql.com/doc/refman/5.7/en/optimizing-innodb-queries.html
To tune queries for InnoDB tables, create an appropriate set of indexes on each table. Follow these guidelines for InnoDB indexes: Because each InnoDB table has a primary key (whether you request one or not), specify a set of primary key columns ...
https://dev.mysql.com/doc/refman/5.7/en/external-locking.html
External locking is the use of file system locking to manage contention for MyISAM database tables by multiple processes. Do not start the server with the delay_key_write system variable set to ALL or use the DELAY_KEY_WRITE=1 table option for any ...Here are some examples: If you run multiple servers that use the same database directory (not recommended), each server must have external locking ...
https://dev.mysql.com/doc/refman/5.7/en/information-schema-statistics-table.html
Take this into account when specifying a prefix length for a nonbinary string column that uses a multibyte character set. TABLE_SCHEMA The name of the schema (database) to which the table containing the index belongs. INDEX_SCHEMA The name of the ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-autocommit-commit-rollback.html
If autocommit mode is enabled, each SQL statement forms a single transaction on its own. By default, MySQL starts the session for each new connection with autocommit enabled, so MySQL does a commit after each SQL statement if that statement did not ...If a statement returns an error, the commit or rollback behavior depends on the ...
https://dev.mysql.com/doc/refman/5.7/en/sys-diagnostics.html
Be careful with the medium setting and especially the full setting, which has a large performance impact. Configuration Options diagnostics() operation can be modified using the following configuration options or their corresponding user-defined ...
https://dev.mysql.com/doc/refman/5.7/en/deploy-mysql-nonlinux-docker.html
Other platforms are not supported, and users running the MySQL Docker images from Oracle on them are doing so at their own risk. Warning The MySQL Docker images provided by Oracle are built specifically for Linux platforms. This section discusses ...