PDF (US Ltr)
- 43.3Mb
PDF (A4)
- 43.4Mb
Man Pages (TGZ)
- 297.2Kb
Man Pages (Zip)
- 402.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/innodb-compression-tuning.html
Setting the compressed page size too large wastes some space, but the pages do not have to be compressed as often. You can expect less compression from a MySQL compressed table than from file-based compression tools, because MySQL compresses data in ...Whether to adjust the size of the buffer pool based on run-time performance characteristics, such as the amount of time the system spends compressing and uncompressing ...
https://dev.mysql.com/doc/refman/8.0/en/connection-interfaces.html
To accommodate a large number of simultaneous connections, the stack size per thread must be kept small, leading to a situation where it is either too small or the server consumes large amounts of memory. In this connection thread model, there are ... This section describes aspects of how the MySQL server manages client ...
https://dev.mysql.com/doc/refman/8.0/en/create-table.html
You need to set this only for large tables with variable-size rows. (See Section 7.1.8, “Server System Variables”.) If you want all your tables to be able to grow above the default limit and are willing to have your tables slightly slower and ...
https://dev.mysql.com/doc/refman/8.0/en/optimizing-innodb-logging.html
Thus, if you have transactions that update, insert, or delete many rows, making the log buffer larger saves disk I/O. If you specify a value for innodb_log_write_ahead_size that is larger than the innodb_page_size value, the ... Consider the ...When ...
https://dev.mysql.com/doc/refman/8.0/en/mysqldump.html
With large data sizes, even if the backup step takes a reasonable time, restoring the data can be very slow because replaying the SQL statements involves disk I/O for insertion, index creation, and so on. For large-scale backup and restore, a ...
https://dev.mysql.com/doc/refman/8.0/en/password-management.html
Password failure tracking, to enable temporary account locking after too many consecutive incorrect-password login failures. To expire an account password manually, use the ALTER USER statement: ALTER USER 'jeffrey'@'localhost' PASSWORD EXPIRE; This ... MySQL supports these password-management capabilities: Password expiration, to require passwords to be changed ...
https://dev.mysql.com/doc/refman/8.0/en/gone-away.html
More information on setting the packet size is given in Section B.3.2.8, “Packet Too Large”. You can also get these errors if you send a query to the server that is incorrect or too large. If mysqld receives a packet that is too large or out of ...You may also need to increase the maximum packet size on the client ... This ...
https://dev.mysql.com/doc/refman/8.0/en/thread-pool.html
The plugin implements a thread pool that increases server performance by efficiently managing statement execution threads for large numbers of client connections. The thread pool addresses several problems of the model that uses one thread per ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-api-definition.html
Most scans are performed in parallel to protect the MySQL Server from receiving too much data from many nodes in parallel; this parameter sets a limit to the total batch size over all nodes. If you plan to deploy a large number of data nodes, it is ... The [mysqld] and [api] sections in the config.ini file define the behavior of the MySQL servers (SQL nodes) and other applications (API nodes) used to access cluster ...
https://dev.mysql.com/doc/refman/8.0/en/group-by-modifiers.html
The GROUP BY clause permits a WITH ROLLUP modifier that causes summary output to include extra rows that represent higher-level (that is, super-aggregate) summary operations. In this case, each time there is a change in value in any but the last ...