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/show-engine.html
The statement has these variants: SHOW ENGINE INNODB STATUS SHOW ENGINE INNODB MUTEX SHOW ENGINE PERFORMANCE_SCHEMA STATUS SHOW ENGINE INNODB STATUS displays extensive information from the standard InnoDB Monitor about the state of the InnoDB ...
https://dev.mysql.com/doc/refman/8.0/en/charset-applications.html
Note If you use ALTER DATABASE to change the database default character set or collation, existing stored routines in the database that use those defaults must be dropped and recreated so that they use the new defaults. For example, to specify the ... For applications that store data using the default MySQL character set and collation (utf8mb4, utf8mb4_0900_ai_ci), no special configuration should be ...If applications require ...
https://dev.mysql.com/doc/refman/8.0/en/spatial-reference-systems.html
For computations on multiple geometry values, all values must have the same SRID or an error occurs. SRID 0 is the default SRID for spatial data in MySQL. MySQL maintains information about available spatial reference systems for spatial data in the ... A spatial reference system (SRS) for spatial data is a coordinate-based system for geographic ...Earth is a bit shorter in its North-South axis than its East-West ...
https://dev.mysql.com/doc/refman/8.0/en/keyring-plugin-installation.html
MySQL provides these keyring plugin choices: keyring_file (deprecated as of MySQL 8.0.34): Stores keyring data in a file local to the server host. keyring_encrypted_file (deprecated as of MySQL 8.0.34): Stores keyring data in an encrypted, ...A ...
https://dev.mysql.com/doc/refman/8.0/en/recovery-from-backups.html
The full backup file is just a set of SQL statements, so restoring it is very easy: $> mysql < backup_sunday_1_PM.sql At this point, the data is restored to its state as of Sunday 1 p.m.. To restore the changes made since then, we must use the ...To ... Now, suppose that we have a catastrophic unexpected exit on Wednesday at 8 ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-ndbinfo-diskpagebuffer.html
The diskpagebuffer table provides statistics about disk page buffer usage by NDB Cluster Disk Data tables. The diskpagebuffer table contains the following columns: node_id The data node ID block_instance Block instance pages_written Number of pages ...Together with the block name, this number can be used to look up a given instance in the threadblocks ...row *************************** node_id: 1 thr_no: 1 block_name: PGMAN thread_name: rep pages_written: 0 pages_written_lcp: 0 pages_read: 1 log_waits: 0 ...
https://dev.mysql.com/doc/refman/8.0/en/spatial-operator-functions.html
If the first argument is 'point_square' or 'end_flat', the points_per_circle argument must not be given or an ER_WRONG_ARGUMENTS error occurs. If the fractional distance argument is outside the range [0.0, 1.0], an ER_DATA_OUT_OF_RANGE error occurs.
https://dev.mysql.com/doc/refman/8.0/en/truncate-table.html
As of MySQL 8.0.21, if the tablespace was created with an earlier version and resides in an unknown directory, InnoDB creates the new tablespace in the default location and writes the following warning to the error log: The DATA DIRECTORY location ...The usual result is “0 rows affected,” which should be interpreted as “no information.” As long as the table definition is valid, the table can be re-created as an empty table with TRUNCATE TABLE, even if the data or index files have become ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-instrument-naming.html
Example names: wait/io/file/myisam/log wait/io/file/mysys/charset wait/lock/table/sql/handler wait/synch/cond/mysys/COND_alarm wait/synch/cond/sql/BINLOG::update_cond wait/synch/mutex/mysys/BITMAP_mutex wait/synch/mutex/sql/LOCK_delete ...Suffixes ...The elements of an instrument name from left to right provide a progression from more general to more ...
https://dev.mysql.com/doc/refman/8.0/en/fulltext-search-mecab.html
The mecab_rc_file option is not recognized by MySQL until the MeCaB parser plugin is installed but it must be set before attempting to install the MeCaB parser plugin. [mysqld] innodb_ft_min_token_size=1 Modify the mecabrc configuration file to ...