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/optimizing-innodb-bulk-data-loading.html
For optimal performance when loading data into an InnoDB FULLTEXT index, follow this set of steps: Define a column FTS_DOC_ID at table creation time, of type BIGINT UNSIGNED NOT NULL, with a unique index named FTS_DOC_ID_INDEX. For example: CREATE ... These performance tips supplement the general guidelines for fast inserts in Section 8.2.4.1, “Optimizing INSERT ...
https://dev.mysql.com/doc/refman/5.7/en/static-format.html
NULL columns require additional space in the row to record whether their values are NULL. Each NULL column takes one bit extra, rounded up to the nearest byte. The expected row length in bytes for static-sized rows is calculated using the following ...It is used when the table contains no variable-length columns (VARCHAR, VARBINARY, BLOB, or ...
https://dev.mysql.com/doc/refman/5.7/en/sys-ps-trace-thread.html
Use NULL to collect data for the default of 60 seconds. Dumps all Performance Schema data for an instrumented thread to a .dot formatted graph file (for the DOT graph description language). Each result set returned from the procedure should be used ...
https://dev.mysql.com/doc/refman/5.7/en/using-innodb-tables.html
row *************************** Name: t1 Engine: InnoDB Version: 10 Row_format: Dynamic Rows: 0 Avg_row_length: 0 Data_length: 16384 Max_data_length: 0 Index_length: 0 Data_free: 0 Auto_increment: NULL Create_time: 2021-02-18 12:18:28 Update_time: ... InnoDB tables are created using the CREATE TABLE statement; for example: CREATE TABLE t1 (a INT, b CHAR (20), PRIMARY KEY (a)) ENGINE=InnoDB; The ENGINE=InnoDB clause is not required when InnoDB is defined as the default storage engine, which it is by ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-programs-ndb-select-all.html
Usage ndb_select_all -c connection_string tbl_name -d db_name [> file_name] Options that can be used with ndb_select_all are shown in the following table. --connect-string Command-Line Format --connect-string=connection_string Type String Default ...
https://dev.mysql.com/doc/refman/5.7/en/charset-collation-coercibility.html
For example, this statement performs a comparison between the column x and the string literal 'Y': SELECT x FROM T WHERE x = 'Y'; If x and 'Y' have the same collation, there is no ambiguity about the collation to use for the comparison. For example, ... In the great majority of statements, it is obvious what collation MySQL uses to resolve a comparison ...
https://dev.mysql.com/doc/refman/5.7/en/federated-create-server.html
If you are creating a number of FEDERATED tables on the same server, or if you want to simplify the process of creating FEDERATED tables, you can use the CREATE SERVER statement to define the server connection parameters, just as you would with the ...If you specify only the connection name without a table name, the table name of the local table is used ...
https://dev.mysql.com/doc/refman/5.7/en/federated-create-connection.html
To use the first method, you must specify the CONNECTION string after the engine type in a CREATE TABLE statement. For example: CREATE TABLE federated_table ( id INT(20) NOT NULL AUTO_INCREMENT, name VARCHAR(32) NOT NULL DEFAULT '', other INT(20) ...In the example, the remote table is on the server remote_host, using port ...
https://dev.mysql.com/doc/refman/5.7/en/set.html
A SET is a string object that can have zero or more values, each of which must be chosen from a list of permitted values specified when the table is created. For example, a column specified as SET('one', 'two') NOT NULL can have any of these ...SET ...
https://dev.mysql.com/doc/refman/5.7/en/information-schema-parameters-table.html
The PARAMETER_NAME and PARAMETER_MODE values are NULL because the return value has no name and the mode does not apply. The PARAMETERS table provides information about parameters for stored routines (stored procedures and stored functions), and ...