PDF (US Ltr)
- 43.2Mb
PDF (A4)
- 43.3Mb
Man Pages (TGZ)
- 295.2Kb
Man Pages (Zip)
- 400.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-ndb-cluster-tables.html
The following table shows all Performance Schema tables relating to the NDBCLUSTER storage engine. Table 29.3 Performance Schema NDB Tables Table Name Description ndb_sync_excluded_objects NDB objects which cannot be synchronized ...This is done by ...
https://dev.mysql.com/doc/refman/8.0/en/ansi-diff-foreign-keys.html
row *************************** Table: shirt Create Table: CREATE TABLE `shirt` ( `id` smallint(5) unsigned NOT NULL auto_increment, `style` enum('t-shirt','polo','dress') NOT NULL, `color` enum('red','blue','orange','white','black') NOT NULL, ...If ...For example, if you define a RESTRICT type constraint, and there is a child row with several parent rows, InnoDB does not permit the deletion of any of the parent ...
https://dev.mysql.com/doc/refman/8.0/en/mysqlimport.html
Here is a sample session that demonstrates use of mysqlimport: $> mysql -e 'CREATE TABLE imptest(id INT, n VARCHAR(30))' test $> ed a 100 Max Sydow 101 Count Dracula . Invoke mysqlimport like this: mysqlimport [options] db_name textfile1 [textfile2 ... The mysqlimport client provides a command-line interface to the LOAD DATA SQL ...
https://dev.mysql.com/doc/refman/8.0/en/condition-filtering.html
In join processing, prefix rows are those rows passed from one table in a join to the next. In general, the optimizer attempts to put tables with low prefix counts early in the join order to keep the number of row combinations from increasing ...
https://dev.mysql.com/doc/refman/8.0/en/intersect.html
query_expression_body INTERSECT [ALL | DISTINCT] query_expression_body [INTERSECT [ALL | DISTINCT] query_expression_body] [...] query_expression_body: See Section 15.2.14, “Set Operations with UNION, INTERSECT, and EXCEPT” INTERSECT limits the ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-consumer-configurations.html
The consumer settings in the setup_consumers table form a hierarchy from higher levels to lower. The setup_consumers table contains the following hierarchy of values: global_instrumentation thread_instrumentation events_waits_current ...The ...
https://dev.mysql.com/doc/refman/8.0/en/information-schema-innodb-datafiles-table.html
If a file-per-table tablespace is created in a location outside the MySQL data directory, the path value is a fully qualified directory path. The INNODB_DATAFILES table provides data file path information for InnoDB file-per-table and general ...
https://dev.mysql.com/doc/refman/8.0/en/information-schema-tp-thread-state-table.html
For example, if an application uses this query: SELECT * FROM INFORMATION_SCHEMA.TP_THREAD_STATE; The application should use this query instead: SELECT * FROM performance_schema.tp_thread_state; The TP_THREAD_STATE table has one row per thread ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-programs-ndb-drop-table.html
Usage ndb_drop_table -c connection_string tbl_name -d db_name Options that can be used with ndb_drop_table are shown in the following table. --database, -d Command-Line Format --database=name Type String Default Value TEST_DB Name of the database in ...--connect-retries Command-Line Format --connect-retries=# Type Integer Default Value 12 Minimum Value 0 Maximum Value 12 Number of times to retry connection before giving ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-mutex-instances-table.html
When some code creates a mutex, a row is added to the mutex_instances table. The mutex_instances table lists all the mutexes seen by the Performance Schema while the server executes. The mutex_instances table has these columns: NAME The instrument ...A mutex is a synchronization mechanism used in the code to enforce that only one thread at a given time can have access to some common ...