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/numeric-type-syntax.html
MySQL can handle BIGINT in the following cases: When using integers to store large unsigned values in a BIGINT column. This means that if you multiply two big integers (or results from functions that return integers), you may get unexpected results ... For integer data types, M indicates the minimum display ...
https://dev.mysql.com/doc/refman/8.0/en/what-is-mysql.html
Since computers are very good at handling large amounts of data, database management systems play a central role in computing, as standalone utilities, or as parts of other applications. The logical model, with objects such as databases, tables, ...
https://dev.mysql.com/doc/refman/8.0/en/group-replication-throttling.html
In order to avoid large jumps in throughput once the queue size goes beyond the threshold, the throughput is only allowed to grow by the same 10% per period after that. Therefore, metrics acquired from all members are the basis for calculating the ... Based on the metrics gathered across all servers in the group, a throttling mechanism kicks in and decides whether to limit the rate a member is able to execute/commit new ...
https://dev.mysql.com/doc/refman/8.0/en/slow-query-log.html
The slow query log consists of SQL statements that take more than long_query_time seconds to execute and require at least min_examined_row_limit rows to be examined. Note If you specify the TABLE log destination, see Log Tables and “Too many open ...The slow query log can be used to find queries that take a long time to execute and are therefore candidates for ...
https://dev.mysql.com/doc/refman/8.0/en/blackhole-storage-engine.html
The BLACKHOLE storage engine acts as a “black hole” that accepts data but throws it away and does not store it. Suppose that your application requires replica-side filtering rules, but transferring all binary log data to the replica first ...To ...
https://dev.mysql.com/doc/refman/8.0/en/entering-queries.html
mysql shows how many rows were returned and how long the query took to execute, which gives you a rough idea of server performance. (For brevity, the “rows in set” line is sometimes not shown in the remaining examples in this chapter.) Keywords ... Make sure that you are connected to the server, as discussed in the previous ...
https://dev.mysql.com/doc/refman/8.0/en/myisam-storage-engine.html
For the case of a key longer than 250 bytes, a larger key block size than the default of 1024 bytes is used. Dynamic-sized rows are much less fragmented when mixing deletes with updates and inserts. Table 18.2 MyISAM Storage Engine Features Feature ... MyISAM is based on the older (and no longer available) ISAM storage engine but has many useful ...
https://dev.mysql.com/doc/refman/8.0/en/information-schema-tables-table.html
For InnoDB tables, the row count is only a rough estimate used in SQL optimization. (This is also true if the InnoDB table is partitioned.) AVG_ROW_LENGTH The average row length. Specifically, it is the clustered index size, in pages, multiplied by ...The information_schema_stats_expiry system variable defines the period of time before cached table statistics ...
https://dev.mysql.com/doc/refman/8.0/en/show-processlist.html
The SHOW PROCESSLIST statement is very useful if you get the “too many connections” error message and want to find out what is going on. row *************************** Id: 1 User: system user Host: db: NULL Command: Connect Time: 1030455 State: ... SHOW [FULL] PROCESSLIST Important The INFORMATION SCHEMA implementation of SHOW PROCESSLIST is deprecated and subject to removal in a future MySQL ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-memory-summary-tables.html
Allocating a single byte one million times is not the same as allocating one million bytes a single time; tracking both sizes and counts can expose the difference. row *************************** EVENT_NAME: memory/sql/TABLE COUNT_ALLOC: 1381 ...