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/mysql-cluster-programs-ndb-select-count.html
ndb_select_count prints the number of rows in one or more NDB tables. With a single table, the result is equivalent to that obtained by using the MySQL statement SELECT COUNT(*) FROM tbl_name. Usage ndb_select_count [-c connection_string] -ddb_name ...--connect-retries Command-Line Format --connect-retries=# Type Integer Default Value 12 Minimum Value 0 Maximum Value 12 Number of times to retry connection before giving ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-troubleshooting-datadict.html
See Section 17.6.1.4, “Moving or Copying InnoDB Tables” for information about creating clean backups. On the new MySQL instance, recreate the table in a database of the same name. Information about table definitions is stored in the InnoDB data ...If you move data files around, dictionary data can become ...
https://dev.mysql.com/doc/refman/8.0/en/sys-statements-with-temp-tables.html
memory_tmp_tables The total number of internal in-memory temporary tables created by occurrences of the statement. disk_tmp_tables The total number of internal on-disk temporary tables created by occurrences of the statement. These views list ...db ...
https://dev.mysql.com/doc/refman/8.0/en/fulltext-search-mecab.html
Creating a FULLTEXT Index that uses the MeCab Parser To create a FULLTEXT index that uses the mecab parser, specify WITH PARSER ngram with CREATE TABLE, ALTER TABLE, or CREATE INDEX. For InnoDB tables, minimum token size is defined by the ... The ...
https://dev.mysql.com/doc/refman/8.0/en/fido-pluggable-authentication.html
Table 8.27 Plugin and Library Names for FIDO Authentication Plugin or File Plugin or File Name Server-side plugin authentication_fido Client-side plugin authentication_fido_client Library file authentication_fido.so, authentication_fido_client.so ...
https://dev.mysql.com/doc/refman/8.0/en/except.html
As with UNION and INTERSECT, either query block can make use of any of SELECT, TABLE, or VALUES. query_expression_body EXCEPT [ALL | DISTINCT] query_expression_body [EXCEPT [ALL | DISTINCT] query_expression_body] [...] query_expression_body: See ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-consumer-filtering.html
For example, if you do not care about historical event information, disable the history consumers: UPDATE performance_schema.setup_consumers SET ENABLED = 'NO' WHERE NAME LIKE '%history%'; The consumer settings in the setup_consumers table form a ...
https://dev.mysql.com/doc/refman/8.0/en/audit-log-installation.html
Create the database first; its name should not exceed 64 characters. For example: mysql> CREATE DATABASE IF NOT EXISTS database-name; Next, run the script using the alternative database name. $> mysql -u root -p -D database-name < ... This section ...
https://dev.mysql.com/doc/refman/8.0/en/charset-unicode-conversion.html
Tables created with these row formats enable you to index a maximum of 1024 or 768 characters for utf8mb3 or utf8mb4 columns, respectively. In terms of table content, conversion from utf8mb3 to utf8mb4 presents no problems: For a BMP character, ...
https://dev.mysql.com/doc/refman/8.0/en/drop-tablespace.html
DROP [UNDO] TABLESPACE tablespace_name [ENGINE [=] engine_name] This statement drops a tablespace that was previously created using CREATE TABLESPACE. Only undo tablespaces created using CREATE UNDO TABLESPACE syntax can be dropped. If it is not ...