PDF (US Ltr)
- 35.1Mb
PDF (A4)
- 35.2Mb
Man Pages (TGZ)
- 256.4Kb
Man Pages (Zip)
- 361.2Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/common-errors.html
This section lists some errors that users frequently encounter when running MySQL programs. Although the problems show up when you try to run client programs, the solutions to many of the problems involves changing the configuration of the MySQL ...
https://dev.mysql.com/doc/refman/5.7/en/error-log-filtering.html
The log_error_verbosity system variable controls server verbosity for writing error, warning, and note messages to the error log. Permitted values are 1 (errors only), 2 (errors and warnings), 3 (errors, warnings, and notes), with a default of 3.
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-log-statistics.html
Check whether there are any timed messages to be executed; if so, put these into the job buffer as well. Counters providing information about the state of the cluster are updated at 5-second reporting intervals by the transaction coordinator (TC) ...
https://dev.mysql.com/doc/refman/5.7/en/error-log-rotation.html
If you flush the error log using a FLUSH ERROR LOGS or FLUSH LOGS statment, or a mysqladmin flush-logs command, the server closes and reopens any error log file to which it is writing. To rename an error log file, do so manually before flushing.
https://dev.mysql.com/doc/refman/5.7/en/subquery-errors.html
Incorrect number of rows from subquery: ERROR 1242 (ER_SUBSELECT_NO_1_ROW) SQLSTATE = 21000 Message = "Subquery returns more than 1 row" This error occurs for statements where the subquery must return at most one row but returns multiple rows. If ...
https://dev.mysql.com/doc/refman/5.7/en/faqs-replication.html
When the replication SQL thread executes an event read from the source, it modifies its own time to the event timestamp. (This is why TIMESTAMP is well replicated.) In the Time column in the output of SHOW PROCESSLIST, the number of seconds ...Must ... In the following section, we provide answers to questions that are most frequently asked about MySQL ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-limits.html
Attempting to use an index key prefix length that exceeds the limit returns an error. 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 ...
https://dev.mysql.com/doc/refman/5.7/en/version-tokens-usage.html
The next time the client sends a statement to server 2, its own token list no longer matches the server token list and an error occurs: mysql> UPDATE emp.employee SET salary = salary * 1.1 WHERE id = 4982; ERROR 3136 (42000): Version token mismatch ...Assignment of a server within a certain group can change at any ... Before using Version Tokens, install it according to the instructions ...
https://dev.mysql.com/doc/refman/5.7/en/load-xml.html
Suppose that we have a table named person, created as shown here: USE test; CREATE TABLE person ( person_id INT NOT NULL PRIMARY KEY, fname VARCHAR(40) NULL, lname VARCHAR(40) NULL, created TIMESTAMP ); Suppose further that this table is initially ...The tagname in the optional ROWS IDENTIFIED BY clause must also be given as a literal string, and must be surrounded by angle brackets (< and ...
https://dev.mysql.com/doc/refman/5.7/en/sys-ps-is-instrument-default-timed.html
Returns YES or NO to indicate whether a given Performance Schema instrument is timed by default. Example mysql> SELECT sys.ps_is_instrument_default_timed('memory/innodb/row_log_buf'); ...