PDF (US Ltr)
- 35.0Mb
PDF (A4)
- 35.1Mb
Man Pages (TGZ)
- 254.9Kb
Man Pages (Zip)
- 359.9Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/mysqlshow.html
The mysqlshow client can be used to quickly see which databases exist, their tables, or a table's columns or indexes. Invoke mysqlshow like this: mysqlshow [options] [db_name [tbl_name [col_name]]] If no database is given, a list of database names ...The same information can be obtained by using those statements ...
https://dev.mysql.com/doc/refman/5.7/en/server-options.html
--ignore-db-dir=dir_name Command-Line Format --ignore-db-dir=dir_name Deprecated Yes Type Directory name This option tells the server to ignore the given directory name for purposes of the SHOW DATABASES statement or INFORMATION_SCHEMA tables. When ...
https://dev.mysql.com/doc/refman/5.7/en/system-schema.html
Warning Do not convert MySQL system tables in the mysql database from MyISAM to InnoDB tables. It contains tables that store information required by the MySQL server as it runs. If you do this, MySQL does not restart until you restore the old system ...
https://dev.mysql.com/doc/refman/5.7/en/innochecksum.html
In this example, an innodb checksum is rewritten to replace an invalid checksum: innochecksum --no-check --write innodb ../data/test/tab1.ibd --allow-mismatches, -a Command-Line Format --allow-mismatches=# Type Integer Default Value 0 Minimum Value ...This tool reads an InnoDB tablespace file, calculates the checksum for each page, compares the calculated checksum to the stored checksum, and reports mismatches, which indicate damaged ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-locks-set.html
FROM is a consistent read, reading a snapshot of the database and setting no locks unless the transaction isolation level is set to SERIALIZABLE. REPLACE is done like an INSERT if there is no collision on a unique key. Otherwise, an exclusive ... A ...
https://dev.mysql.com/doc/refman/5.7/en/symbolic-links-to-tables.html
The data file and index file can be moved elsewhere and replaced in the data directory by symlinks. (Bug #32167) myisamchk does not replace a symlink with the data file or index file. This is an extremely good reason not to run mysqld as the root ...
https://dev.mysql.com/doc/refman/5.7/en/charset-unicode-sets.html
For supplementary characters in general collations, the weight is the weight for 0xfffd REPLACEMENT CHARACTER. This section describes the collations available for Unicode character sets and their differentiating properties. MySQL supports multiple ...
https://dev.mysql.com/doc/refman/5.7/en/generated-column-index-optimizations.html
row *************************** id: 1 select_type: SIMPLE table: t1 partitions: NULL type: range possible_keys: gc key: gc key_len: 5 ref: NULL rows: 1 filtered: 100.00 Extra: Using index condition In effect, the optimizer has replaced the ...For ...
https://dev.mysql.com/doc/refman/5.7/en/merge-table-problems.html
Because the MERGE engine cannot enforce uniqueness over the set of underlying tables, REPLACE does not work as expected. The two key facts are: REPLACE can detect unique key violations only in the underlying table to which it is going to write ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-install-linux-rpm.html
This section covers the steps necessary to install the correct executables for each type of NDB Cluster node using RPM packages supplied by Oracle. As an alternative to the method described in this section, Oracle provides MySQL Repositories for ...