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/binary-log.html
A binary log file may become larger than max_binlog_size if you are using large transactions because a transaction is written to the file in one piece, never split between files. These two variables can be used for tuning binlog_cache_size to a ...
https://dev.mysql.com/doc/refman/8.0/en/range-optimization.html
Use of index statistics is less accurate than index dives but permits faster row estimation for large value lists. The range access method uses a single index to retrieve a subset of table rows that are contained within one or several index value ...The following sections describe conditions under which the optimizer uses range ...
https://dev.mysql.com/doc/refman/8.0/en/option-defaults-equals.html
Examining the last few lines of this file shows the reason: $> tail /usr/local/mysql/var/tonfisk.err 2013-09-24T15:36:22.278034Z 0 [ERROR] Too many arguments (first extra is 'my-errors'). mysql> SELECT USER(); +---------------+ | USER() | ...Due to ...
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/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/performance-schema-event-tables.html
The _current table for each event type contains one row per thread, so there is no system variable for configuring its maximum size. Typical autosized values are 10 rows per thread for _history tables, and 10,000 rows total for _history_long tables.
https://dev.mysql.com/doc/refman/8.0/en/innodb-best-practices.html
While you don't want to commit too often, you also don't want to issue huge batches of INSERT, UPDATE, or DELETE statements that run for hours without committing. To get exclusive write access to a set of rows, use the SELECT ... FOR UPDATE syntax ...Specify a primary key for every table using the most frequently queried column or columns, or an auto-increment value if there is no obvious primary ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-error-handling.html
You can make them less likely by doing as little work as possible between the first change to data during a transaction and the commit, so the locks are held for the shortest possible time and for the smallest possible number of rows. InnoDB ...
https://dev.mysql.com/doc/refman/8.0/en/myisam-crash-recovery.html
myisamchk works by creating a copy of the .MYD data file row by row. Normally the use of two --quick options is useful only if you have too little free disk space to perform a normal repair. This section describes how to check for and deal with ...
https://dev.mysql.com/doc/refman/8.0/en/show-create-database.html
If the SHOW statement includes an IF NOT EXISTS clause, the output too includes such a clause. row *************************** Database: test Create Database: CREATE DATABASE `test` /*!40100 DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci ... SHOW CREATE {DATABASE | SCHEMA} [IF NOT EXISTS] db_name Shows the CREATE DATABASE statement that creates the named ...