PDF (US Ltr)
- 43.3Mb
PDF (A4)
- 43.4Mb
Man Pages (TGZ)
- 297.2Kb
Man Pages (Zip)
- 402.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/column-indexes.html
The most common type of index involves a single column, storing copies of the values from that column in a data structure, allowing fast lookups for the rows with the corresponding column values. The B-tree data structure lets the index quickly ...
https://dev.mysql.com/doc/refman/8.0/en/trigger-syntax.html
You must specify the schema name if the trigger is not in the default schema: mysql> DROP TRIGGER test.ins_sum; If you drop a table, any triggers for the table are also dropped. Trigger names exist in the schema namespace, meaning that all triggers ... To create a trigger or drop a trigger, use the CREATE TRIGGER or DROP TRIGGER statement, described in Section 15.1.22, “CREATE TRIGGER Statement”, and Section 15.1.34, “DROP TRIGGER ...
https://dev.mysql.com/doc/refman/8.0/en/merge-table-advantages.html
(10 data file descriptors for each of the 10 clients, and 10 index file descriptors shared among the clients.) Index reads are slower. For example, you can put data from different months into separate tables, compress some of them with myisampack, ... MERGE tables can help you solve the following problems: Easily manage a set of log ...
https://dev.mysql.com/doc/refman/8.0/en/mysqlbinlog-row-events.html
The following examples illustrate how mysqlbinlog displays row events that specify data modifications. Omitting extraneous lines, the output for the row events produced by the preceding statement sequence looks like this: $> mysqlbinlog log_file ... The output contains lines beginning with ###: $> mysqlbinlog -v log_file ...These correspond to events ...# at 218 #080828 15:03:08 server id 1 end_log_pos 258 Write_rows: table id 17 flags: STMT_END_F BINLOG ' ...
https://dev.mysql.com/doc/refman/8.0/en/partitioning-limitations-storage-engines.html
(You must be using MySQL NDB Cluster with the NDB storage engine to create NDB tables.) InnoDB storage engine. CREATE TABLE and ALTER TABLE statements that would cause a user-partitioned NDB table not to meet either or both of the following two ...
https://dev.mysql.com/doc/refman/8.0/en/resignal.html
RESIGNAL makes it possible to both handle an error and return the error information. Otherwise, RESIGNAL is illegal and a RESIGNAL when handler not active error occurs. For example, the condition_value can be an SQLSTATE value, and the value can ...
https://dev.mysql.com/doc/refman/8.0/en/replication-gtids-concepts.html
The MySQL system table mysql.gtid_executed is used to preserve the assigned GTIDs of all the transactions applied on a MySQL server, except those that are stored in a currently active binary log file. No error is raised, and no statement in the ...
https://dev.mysql.com/doc/refman/8.0/en/compilation-problems.html
When CMake starts, it looks for that file and reads its contents if it exists, on the assumption that the information is still correct. However, you may want to remove old object files from previous builds first because they were compiled using ...
https://dev.mysql.com/doc/refman/8.0/en/replication-privilege-checks.html
It does not execute LOAD DATA INFILE instructions, and so does not attempt file operations to access or delete the temporary files associated with data loads (logged as a Format_description_log_event). The account can also be safely used by an ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-ndbinfo-operations-per-fragment.html
Since there are typically two fragment replicas, and assuming that this is so, each fragment_num value should appear twice in the table, on two different data nodes from the same node group. Generally, such a refusal is due to duplicate keys ... The ...In addition, a client may choose to end a scan before all potentially matching rows have been examined; this occurs when using an SQL statement containing a LIMIT or EXISTS clause, for ...