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/what-is-crashing.html
Use the “copy and paste” method for any output and error messages from programs and log files. If you think the problem is in MySQL, you should also examine MySQL's log files. Use top, df, or a similar program to check whether you are out of ...
https://dev.mysql.com/doc/refman/8.0/en/audit-log-installation.html
To be usable by the server, the plugin library file must be located in the MySQL plugin directory (the directory named by the plugin_dir system variable). The available scripts differ in the file name used to refer to the script: ... This section ...
https://dev.mysql.com/doc/refman/8.0/en/example-storage-engine.html
mysql> CREATE TABLE test (i INT) ENGINE = EXAMPLE; Query OK, 0 rows affected (0.78 sec) mysql> INSERT INTO test VALUES(1),(2),(3); ERROR 1031 (HY000): Table storage engine for 'test' doesn't » have this option mysql> SELECT * FROM test; Empty set ... The EXAMPLE storage engine is a stub engine that does ...
https://dev.mysql.com/doc/refman/8.0/en/myisam-maintenance-schedule.html
For example, you can run a cron job to check important tables once a week, using a line like this in a crontab file: 35 0 * * 0 /path/to/myisamchk --fast --silent /path/to/datadir/*/*.MYI This prints out information about crashed tables so that you ...The -s option (short for --silent) causes myisamchk to run in silent mode, printing messages only when errors ...
https://dev.mysql.com/doc/refman/8.0/en/replication-features-variables.html
To help reduce possible confusion, we recommend that you always use the same setting for the lower_case_table_names system variable on both source and replica, especially when you are running MySQL on platforms with case-sensitive file systems. For ...
https://dev.mysql.com/doc/refman/8.0/en/show-relaylog-events.html
Note Issuing a SHOW RELAYLOG EVENTS with no LIMIT clause could start a very time- and resource-consuming process because the server returns to the client the complete contents of the relay log (including all statements modifying data that have been ... SHOW RELAYLOG EVENTS [IN 'log_name'] [FROM pos] [LIMIT [offset,] row_count] [channel_option] channel_option: FOR CHANNEL channel Shows the events in the relay log of a ...
https://dev.mysql.com/doc/refman/8.0/en/replication-gtids-restrictions.html
When using GTIDs, updates to tables using nontransactional storage engines such as MyISAM cannot be made in the same statement or transaction as updates to tables using transactional storage engines such as InnoDB. To prevent execution of statements ... Because GTID-based replication is dependent on transactions, some features otherwise available in MySQL are not supported when using ...
https://dev.mysql.com/doc/refman/8.0/en/checksum-table.html
You can use this statement to verify that the contents are the same before and after a backup, rollback, or other operation that is intended to put the data back to a known state. During the checksum operation, the table is locked with a read lock ...[QUICK | EXTENDED] CHECKSUM TABLE reports a checksum for the contents of a ...
https://dev.mysql.com/doc/refman/8.0/en/explain-for-connection.html
Because of changes to data (and supporting statistics) it may produce a different result from running EXPLAIN on the equivalent query text. In all cases, you must have sufficient privileges to explain the query on the specified connection. If the ...
https://dev.mysql.com/doc/refman/8.0/en/gis-point-property-functions.html
If an X or Y coordinate argument is provided and the value is -inf, +inf, or NaN, an ER_DATA_OUT_OF_RANGE error occurs. If any geometry argument is not a syntactically well-formed geometry, an ER_GIS_INVALID_DATA error occurs. If a longitude or ...