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/counting-rows.html
Counting the total number of animals you have is the same question as “How many rows are in the pet table?” because there is one record per pet. COUNT(*) counts the number of rows, so the query to count your animals looks like this: mysql> ...
https://dev.mysql.com/doc/refman/8.0/en/example-maximum-row.html
Task: Find the number, dealer, and price of the most expensive article.
https://dev.mysql.com/doc/refman/8.0/en/sorting-rows.html
You may have noticed in the preceding examples that the result rows are displayed in no particular order. It is often easier to examine query output when the rows are sorted in some meaningful way. This means that the order is undefined for columns ...
https://dev.mysql.com/doc/refman/8.0/en/example-maximum-column-group-row.html
Task: For each article, find the dealer or dealers with the most expensive price. Other possibilities for solving the problem are to use an uncorrelated subquery in the FROM clause, a LEFT JOIN, or a common table expression with a window function.
https://dev.mysql.com/doc/refman/8.0/en/innodb-undo-tablespaces.html
In this case, if the file extension size is larger than 16MB, and the previous file extension occurred within the last second, the new undo tablespace is created at a quarter of the size defined by the innodb_max_undo_log_size variable. To handle ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-persistent-stats.html
row *************************** database_name: sakila table_name: actor last_update: 2014-05-28 16:16:44 n_rows: 200 clustered_index_size: 1 sum_of_other_index_sizes: 1 ...mysql> SELECT * FROM innodb_index_stats \G *************************** 1. row ...Increasing innodb_stats_persistent_sample_pages too much, however, could cause ANALYZE TABLE to run ... The persistent optimizer statistics feature improves plan stability by storing statistics to disk and making them persistent across ...
https://dev.mysql.com/doc/refman/8.0/en/group-replication-system-variables.html
group_replication_communication_max_message_size must be less than replica_max_allowed_packet, because the applier thread cannot handle message fragments larger than the maximum permitted packet size. Transactions larger than this size are rolled ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-limits.html
ERROR 1070 (42000): Too many key parts specified; max 16 parts allowed The maximum row size, excluding any variable-length columns that are stored off-page, is slightly less than half of a page for 4KB, 8KB, 16KB, and 32KB page sizes. Although ...
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/replication-features-max-allowed-packet.html
Also, in row-based replication, a single event can be significantly larger than the max_allowed_packet size, because the value of max_allowed_packet only limits each column of the table. If you are replicating large column values (such as might be ... max_allowed_packet sets an upper limit on the size of any single message between the MySQL server and clients, including ...