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/tuning-trace-purging.html
A user who wants to see the trace of a different substatement can enable or disable tracing for the desired substatement, but this requires editing the routine code, which may not always be possible. Thus, if a statement contains substatements (such ...
https://dev.mysql.com/doc/refman/5.7/en/using-date.html
This makes MySQL very convenient for Web applications where you obtain year, month, and day in three different fields and you want to store exactly what the user inserted (without date validation). You should use this format in UPDATE expressions ...
https://dev.mysql.com/doc/refman/5.7/en/what-is-mysql.html
MySQL Server has a practical set of features developed in close cooperation with our users. MySQL, the most popular Open Source SQL database management system, is developed, distributed, and supported by Oracle Corporation. The MySQL website ...
https://dev.mysql.com/doc/refman/5.7/en/windows-select-server.html
It is necessary to enable this variable explicitly because some users have experienced problems with shutting down the MySQL server when named pipes were used. The following table shows the available servers for Windows in MySQL 5.7. Binary ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-table-import.html
Otherwise, the table must be created on the same MySQL server instance into which it is being imported. If the table was created in an external directory by specifying the DATA DIRECTORY clause in the CREATE TABLE statement, the table that you ...
https://dev.mysql.com/doc/refman/5.7/en/cost-model.html
The primary key for the server_cost table is the cost_name column, so it is not possible to create multiple entries for any cost estimate. The server recognizes these cost_name values for the server_cost table: disk_temptable_create_cost (default ...
https://dev.mysql.com/doc/refman/5.7/en/information-schema-statistics-table.html
However, prefix lengths for index specifications in CREATE TABLE, ALTER TABLE, and CREATE INDEX statements are interpreted as number of characters for nonbinary string types (CHAR, VARCHAR, TEXT) and number of bytes for binary string types (BINARY, ...The STATISTICS table has these columns: TABLE_CATALOG The name of the catalog to which the table containing the index ...
https://dev.mysql.com/doc/refman/5.7/en/show-index.html
However, prefix lengths for index specifications in CREATE TABLE, ALTER TABLE, and CREATE INDEX statements are interpreted as number of characters for nonbinary string types (CHAR, VARCHAR, TEXT) and number of bytes for binary string types (BINARY, ... SHOW {INDEX | INDEXES | KEYS} {FROM | IN} tbl_name [{FROM | IN} db_name] [WHERE expr] SHOW INDEX returns table index ...
https://dev.mysql.com/doc/refman/5.7/en/index-page-merge-threshold.html
Setting MERGE_THRESHOLD for a Table You can set the MERGE_THRESHOLD value for a table using the table_option COMMENT clause of the CREATE TABLE statement. row *************************** INDEX_ID: 91 NAME: id_index TABLE_ID: 68 TYPE: 0 N_FIELDS: 1 ...If the “page-full” percentage for an index page falls below the MERGE_THRESHOLD value when a row is deleted or when a row is shortened by an UPDATE operation, InnoDB attempts to merge the index page with a neighboring index ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-replication-issues.html
Note Every NDB table is implicitly partitioned by key when it is created. This section discusses known problems or issues when using replication with NDB Cluster. A loss of connection can occur either between the source cluster SQL node and the ...