PDF (US Ltr)
- 35.1Mb
PDF (A4)
- 35.2Mb
Man Pages (TGZ)
- 256.4Kb
Man Pages (Zip)
- 361.2Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/pluggable-storage-common-layer.html
A MySQL pluggable storage engine is the component in the MySQL database server that is responsible for performing the actual data I/O operations for a database as well as enabling and enforcing certain feature sets that target a specific ...From a ...
https://dev.mysql.com/doc/refman/5.7/en/xml-functions.html
Table 12.16 XML Functions Name Description ExtractValue() Extract a value from an XML string using XPath notation UpdateXML() Return replaced XML fragment This section discusses XML and related functionality in MySQL. See Section 4.5.1, “mysql ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-what-is-new-7-6.html
NDB 7.6 adds two tables to the ndbinfo information database to provide information about cluster nodes; these tables are listed here: config_nodes: This table the node ID, process type, and host name for each node listed in an NDB cluster's ... New ...
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/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/updating-yum-repo.html
For supported Yum-based platforms (see Section 2.5.1, “Installing MySQL on Linux Using the MySQL Yum Repository”, for a list), you can perform an in-place upgrade for MySQL (that is, replacing the old version and then running the new version ...
https://dev.mysql.com/doc/refman/5.7/en/version-tokens-usage.html
Suppose that a management application communicates with a set of servers that are queried by clients to access employee and product databases (named emp and prod, respectively). All servers are permitted to process data retrieval statements, but ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-programs-ndb-size-pl.html
This is a Perl script that can be used to estimate the amount of space that would be required by a MySQL database if it were converted to use the NDBCLUSTER storage engine. However, it does need to access the MySQL server on which the database to ...Unlike the other utilities discussed in this section, it does not require access to an NDB Cluster (in fact, there is no reason for it to do ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-command-options.html
This option is on by default, which enables database, table, and column name completion. (Default value is 0.) --database=db_name, -D db_name Command-Line Format --database=dbname Type String The database to use. --one-database, -o Command-Line ...
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 ...