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/mysql-cluster-programs-ndb-mgm.html
Advanced users can also employ this API for programming dedicated management processes to perform tasks similar to those performed by ndb_mgm. Its value lies in providing a set of commands for checking the cluster's status, starting backups, and ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-compression-usage.html
The system tablespace (space 0, the .ibdata files) can contain user-created tables, but it also contains internal system data, which is never compressed. Creating a Compressed Table in File-Per-Table Tablespace To create a compressed table in a ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-information-schema-system-tables.html
Traditionally, you would get this type of information using the techniques from Section 14.18, “InnoDB Monitors”, setting up InnoDB monitors and parsing the output from the SHOW ENGINE INNODB STATUS statement. The first index is GEN_CLUST_INDEX, ... You can extract metadata about schema objects managed by InnoDB using InnoDB INFORMATION_SCHEMA system ...
https://dev.mysql.com/doc/refman/5.7/en/declare-handler.html
To detect this condition, you can set up a handler for it or for a NOT FOUND condition. statement can be a simple statement such as SET var_name = value, or a compound statement written using BEGIN and END (see Section 13.6.1, “BEGIN ... It can ...
https://dev.mysql.com/doc/refman/5.7/en/information-schema-optimization.html
Applications that monitor databases may make frequent use of INFORMATION_SCHEMA tables. Note Comparison behavior for database and table names in INFORMATION_SCHEMA queries might differ from what you expect. 1) Try to use constant lookup values for ...Certain types of queries for INFORMATION_SCHEMA tables can be optimized to execute more ...The ENGINE (storage engine) value can be determined by ...
https://dev.mysql.com/doc/refman/5.7/en/federated-create-server.html
For reference, the format of the CONNECTION string is as follows: scheme://user_name[:password]@host_name[:port_num]/db_name/tbl_name Description CONNECTION string CREATE SERVER option mysql.servers column Connection scheme scheme wrapper_name ...
https://dev.mysql.com/doc/refman/5.7/en/create-server.html
CREATE SERVER server_name FOREIGN DATA WRAPPER wrapper_name OPTIONS (option [, option] ...) option: { HOST character-literal | DATABASE character-literal | USER character-literal | PASSWORD character-literal | SOCKET character-literal | OWNER ...
https://dev.mysql.com/doc/refman/5.7/en/column-count-limit.html
The maximum row size for an InnoDB table, which applies to data stored locally within a database page, is slightly less than half a page for 4KB, 8KB, 16KB, and 32KB innodb_page_size settings. InnoDB restricts row size (for data stored locally ...
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 ...For ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-information-schema-fulltext_index-tables.html
Before querying any of them, set the value of the innodb_ft_aux_table system variable to the name (including the database name) of the table that contains the FULLTEXT index (for example, test/articles). YourSQL','In the following database ...