PDF (US Ltr)
- 35.1Mb
PDF (A4)
- 35.2Mb
Man Pages (TGZ)
- 256.4Kb
Man Pages (Zip)
- 361.3Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/not-enough-file-handles.html
There is also a “hard” limit that can be overridden only if you start mysqld_safe or mysqld as root (just remember that you also need to start the server with the --user option in this case so that it does not continue to run as root after it ...
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/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/innodb-compression-tuning-monitoring.html
The information in these tables is system-wide: it summarizes the compression statistics across all compressed tables in your database. Based on the information in the INNODB_CMP and INNODB_CMP_PER_INDEX tables and overall application performance ...
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/extended-show.html
INFORMATION_SCHEMA is an information database, so its name is included in the output from SHOW DATABASES. Some extensions to SHOW statements accompany the implementation of INFORMATION_SCHEMA: SHOW can be used to get information about the structure ...Several SHOW statements accept a WHERE clause that provides more flexibility in specifying which rows to ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-online-add-node-basics.html
You should also bear in mind that using MAX_ROWS to set the number of partitions in this fashion is deprecated in NDB 7.5.4 and later, where you should use PARTITION_BALANCE instead; see Section 13.1.18.9, “Setting NDB Comment Options”, for more ...This procedure applies whether you are using ndbd or ndbmtd binaries for the data node ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-replication-tables.html
This is similar to the information available from the SHOW SLAVE STATUS statement, but representation in table form is more accessible and has usability benefits: SHOW SLAVE STATUS output is useful for visual inspection, but not so much for ...The ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-api-definition.html
(NDB 7.5.0) This refers to the Id set for one of the computers (hosts) defined in a [computer] section of the configuration file. A normal configuration uses the management server as arbitrator, setting its ArbitrationRank to 1 (the default for ...
https://dev.mysql.com/doc/refman/5.7/en/partitioning-selection.html
MySQL 5.7 supports explicit selection of partitions and subpartitions that, when executing a statement, should be checked for rows matching a given WHERE condition. Partition selection is similar to partition pruning, in that only specific ...SQL ...