PDF (US Ltr)
- 43.2Mb
PDF (A4)
- 43.3Mb
Man Pages (TGZ)
- 295.2Kb
Man Pages (Zip)
- 400.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/query-log.html
However, when using row-based binary logging, updates are sent as row changes rather than SQL statements, and thus these statements are never written to the query log when binlog_format is ROW. See Section 19.2.1.1, “Advantages and Disadvantages ... The general query log is a general record of what mysqld is ...
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 ...
https://dev.mysql.com/doc/refman/8.0/en/optimizing-queries-myisam.html
It is normally not useful to split a table into different tables just because the rows become large. The only cases where splitting up a table makes an appreciable difference is if it is a MyISAM table using dynamic row format that you can change to ...This updates a value for each index part that indicates the average number of rows that have the same ... Some general tips for speeding up queries on MyISAM tables: To help MySQL better ...
https://dev.mysql.com/doc/refman/8.0/en/group-by-handling.html
For example, if name is a primary key, its value determines the value of address because each group has only one value of the primary key and thus only one row. In particular, it is unlikely you would group on a single primary key column because ...
https://dev.mysql.com/doc/refman/8.0/en/keywords.html
At some point, you might upgrade to a higher version, so it is a good idea to have a look at future reserved words, too. Certain keywords, such as SELECT, DELETE, or BIGINT, are reserved and require special treatment for use as identifiers such as ...
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/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 ...