PDF (US Ltr)
- 35.1Mb
PDF (A4)
- 35.2Mb
Man Pages (TGZ)
- 256.4Kb
Man Pages (Zip)
- 361.3Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/system-schema.html
It contains tables that store information required by the MySQL server as it runs. Warning Do not convert MySQL system tables in the mysql database from MyISAM to InnoDB tables. If you do this, MySQL does not restart until you restore the old system ...For more information, see Section 5.1.13, “MySQL Server Time Zone ...
https://dev.mysql.com/doc/refman/5.7/en/using-innodb-tables.html
The row format of a table can also be defined explicitly using the ROW_FORMAT table option in a CREATE TABLE or ALTER TABLE statement. If you create the table, load data, and then run ALTER TABLE to add a primary key later, that operation is much ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-replication-tables.html
This is similar to the information available from the SHOW SLAVE STATUS statement, but representation in table form is more accessible and has usability benefits: SHOW SLAVE STATUS output is useful for visual inspection, but not so much for ...For ...
https://dev.mysql.com/doc/refman/5.7/en/information-schema-partitions-table.html
PARTITION_EXPRESSION The expression for the partitioning function used in the CREATE TABLE or ALTER TABLE statement that created the table's current partitioning scheme. Each row in this table corresponds to an individual partition or subpartition ...PARTITION_ORDINAL_POSITION All partitions are indexed in the same order as they are defined, with 1 being the number assigned to the first ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-ndbinfo-memory-per-fragment.html
memory_per_fragment Table: Notes memory_per_fragment Table: Examples The memory_per_fragment table provides information about the usage of memory by individual fragments. See the Notes later in this section to see how you can use this to find out ...This is true as long as all data nodes are running and connected to the cluster; for a data node that is missing, there are no rows for the fragment replicas that it ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-what-is-new-7-5.html
New columns added to such tables use the new defaults for these (possibly overridden by ndb_default_column_format), and existing columns are changed to use these as well, provided that the ALTER TABLE statement performing this operation specifies ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-memcached-internals.html
InnoDB API functions access the InnoDB tables directly, and are mostly DML operations with the exception of TRUNCATE TABLE. The following table outlines how memcached commands are mapped to DML or DDL operations. The cache_policies table, ... InnoDB ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-create-table-external.html
Be sure of the directory location you choose, as the DATA DIRECTORY clause cannot be used with ALTER TABLE to change the location later. Using the DATA DIRECTORY clause to create a table in an external directory is an alternative to using symbolic ... There are different reasons for creating InnoDB tables externally; that is, creating tables outside of the data ...
https://dev.mysql.com/doc/refman/5.7/en/load-xml.html
To write data from a table to an XML file, you can invoke the mysql client with the --xml and -e options from the system shell, as shown here: $> mysql --xml -e 'SELECT * FROM mydb.mytable' > file.xml To read the file back into a table, use LOAD XML. 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 ...
https://dev.mysql.com/doc/refman/5.7/en/table-size-limit.html
If the pointer size is too small for an existing table, you can change the options with ALTER TABLE to increase a table's maximum permissible size. ALTER TABLE tbl_name MAX_ROWS=1000000000 AVG_ROW_LENGTH=nnn; You have to specify AVG_ROW_LENGTH only ... The effective maximum table size for MySQL databases is usually determined by operating system constraints on file sizes, not by MySQL internal ...