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/compatibility.html
MySQL Server was originally designed to work with medium-sized databases (10-100 million rows, or about 100MB per table) on small computer systems. We are not afraid to add extensions to SQL or support for non-SQL features if this greatly increases ... This section describes how MySQL relates to the ANSI/ISO SQL ...
https://dev.mysql.com/doc/refman/8.0/en/cursor-restrictions.html
One limitation of the implementation is that for a large result set, retrieving its rows through a cursor might be slow. A server-side cursor enables a result set to be generated on the server side, but not transferred to the client except for those ... Server-side cursors are implemented in the C API using the mysql_stmt_attr_set() ...
https://dev.mysql.com/doc/refman/8.0/en/optimizing-innodb-storage-layout.html
Once your data reaches a stable size, or a growing table has increased by tens or some hundreds of megabytes, consider using the OPTIMIZE TABLE statement to reorganize the table and compact any wasted space. This operation can be slow if the table ...The reorganized tables require less disk I/O to perform full table ...
https://dev.mysql.com/doc/refman/8.0/en/myisamchk-memory.html
The following formula yields the amount of space required: (largest_key + row_pointer_length) * number_of_rows * 2 You can check the length of the keys and the row_pointer_length with myisamchk -dv tbl_name (see Section 6.6.4.5, “Obtaining Table ...If you are going to use myisamchk on very large tables, you should first decide how much memory you want it to ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-config-example.html
Suppose that all data nodes should use the same data memory size. To configure them all, create an [ndbd default] section that contains a DataMemory line to specify the data memory size. This is not required to configure a viable NDB Cluster, but be ... To support NDB Cluster, you should update my.cnf as shown in the following ...
https://dev.mysql.com/doc/refman/8.0/en/server-option-variable-reference.html
The following table lists all command-line options, system variables, and status variables applicable within mysqld. The table lists command-line options (Cmd-line), options valid in configuration files (Option file), server system variables ...
https://dev.mysql.com/doc/refman/8.0/en/date-and-time-literals.html
Beginning with MySQL 8.0.29, using any character other than the dash (-) as the delimiter raises a warning, as shown here: mysql> SELECT DATE'2012@12@31'; +------------------+ | DATE'2012@12@31' | +------------------+ | 2012-12-31 | ... Standard SQL ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-thread-filtering.html
The threads table contains a row for each server thread. Each row contains information about a thread and indicates whether monitoring is enabled for it. For foreground threads (resulting from client connections), the initial values of the ...For ...
https://dev.mysql.com/doc/refman/8.0/en/archive-storage-engine.html
The ARCHIVE storage engine produces special-purpose tables that store large amounts of unindexed data in a very small footprint. There are several types of insertions that are used: An INSERT statement just pushes rows into a compression buffer, ...
https://dev.mysql.com/doc/refman/8.0/en/index-btree-hash.html
One circumstance under which this occurs is when the optimizer estimates that using the index would require MySQL to access a very large percentage of the rows in the table. For example, the following SELECT statements use indexes: SELECT * FROM ...