PDF (US Ltr)
- 35.0Mb
PDF (A4)
- 35.1Mb
Man Pages (TGZ)
- 254.9Kb
Man Pages (Zip)
- 359.8Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/innodb-compression-internals.html
These properties make this compression technique unsuitable for use in an update-intensive database system. Unlike compression performed by an application, or compression features of some other database management systems, InnoDB compression applies ... This section describes some internal implementation details about compression for InnoDB ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-programs-ndb-blob-tool.html
If you need to specify a database, use the --database (-d) option. --database=db_name, -d Command-Line Format --database=name Type String Default Value [none] Specify the database to find the table in. This tool can be used to check for and remove ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-programs-ndb-desc.html
Beginning with NDB 7.5.4, you can obtain such information, using the mysql client, from the table_distribution_status, table_fragments, table_info, and table_replicas tables in the ndbinfo database. --context, -x Show additional contextual ...
https://dev.mysql.com/doc/refman/5.7/en/rename-table.html
RENAME can also be used to move a table to a different database. Regardless of the statement used, if the rename operation would move the table to a database located on a different file system, the success of the outcome is platform specific and ...
https://dev.mysql.com/doc/refman/5.7/en/testing-server.html
Use mysqlshow to see what databases exist: $> bin/mysqlshow +--------------------+ | Databases | +--------------------+ | information_schema | | mysql | | performance_schema | | sys | +--------------------+ The list of installed databases may vary, ... After the data directory is initialized and you have started the server, perform some simple tests to make sure that it works ...
https://dev.mysql.com/doc/refman/5.7/en/downgrade-binary-package.html
In-Place Downgrade Logical Downgrade In-Place Downgrade In-place downgrade involves shutting down the new MySQL version, replacing the new MySQL binaries or packages with the old ones, and restarting the old MySQL version on the existing data ...
https://dev.mysql.com/doc/refman/5.7/en/load-xml.html
By default, the <row> element is considered to be the equivalent of a database table row; this can be changed using the ROWS IDENTIFIED BY clause. (Bug #30753708, Bug #98199) The following clauses work essentially the same way for LOAD XML as they ...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/insert.html
You can use REPLACE instead of INSERT to overwrite old rows. REPLACE is the counterpart to INSERT IGNORE in the treatment of new rows that contain unique key values that duplicate old rows: The new rows replace the old rows rather than being ...
https://dev.mysql.com/doc/refman/5.7/en/json.html
For example, the JSON_SET(), JSON_INSERT(), and JSON_REPLACE() functions each take a JSON document, plus one or more path/value pairs that describe where to modify the document and the values to use. Consider this document: mysql> SET @j = '["a", ...
https://dev.mysql.com/doc/refman/5.7/en/pluggable-authentication-system-variables.html
For example, {UA} is replaced with a user name such as "admin", whereas {UD} is replaced with a use full DN such as "uid=admin,ou=People,dc=example,dc=com". For example, {UA} is replaced with a user name such as "admin", whereas {UD} is replaced ...