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/innodb-enabling-monitors.html
When InnoDB monitors are enabled for periodic output, InnoDB writes the output to mysqld server standard error output (stderr) every 15 seconds, approximately. When this option is used, InnoDB creates a file named innodb_status.pid in the data ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-information-schema-examples-compression-sect.html
Compressing or uncompressing pages has consumed less than a second since the time the statistics were reset, because the columns COMPRESS_TIME and UNCOMPRESS_TIME are zero. This copying of SUM(PAGE_SIZE*RELOCATION_OPS) bytes has consumed less than a ... Example 17.1 Using the Compression Information Schema Tables The following is sample output from a database that contains compressed tables (see Section 17.9, “InnoDB Table and Page Compression”, INNODB_CMP, INNODB_CMP_PER_INDEX, and ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-persistent-stats.html
Statistics recalculation can be delayed by few seconds in some cases. Only two columns are defined for the secondary index (c,d) but there are four n_diff% rows for the secondary index because InnoDB suffixes all nonunique indexes with the primary ... The persistent optimizer statistics feature improves plan stability by storing statistics to disk and making them persistent across server restarts so that the optimizer is more likely to make consistent choices each time for a given ...
https://dev.mysql.com/doc/refman/8.0/en/keyring-okv-plugin.html
There is a 20-second wait for each connection attempt, so the presence of a long list of invalid servers can significantly affect the keyring_okv plugin’s connection time and therefore the server startup time. There is a 20-second wait for each ...
https://dev.mysql.com/doc/refman/8.0/en/lateral-derived-tables.html
A derived table cannot normally refer to (depend on) columns of preceding tables in the same FROM clause. As of MySQL 8.0.14, a derived table may be defined as a lateral derived table to specify that such references are permitted. Nonlateral ...
https://dev.mysql.com/doc/refman/8.0/en/load-data.html
The file can be read from the server host or the client host, depending on whether the LOCAL modifier is given. INTO Statement”.) To write data from a table to a file, use SELECT ... To read the file back into a table, use LOAD DATA. The syntax of ...
https://dev.mysql.com/doc/refman/8.0/en/multiple-windows-command-line-servers.html
For example, the C:\my-opts1.cnf file might be written like this: [mysqld] datadir = C:/mydata1 port = 3307 enable-named-pipe socket = mypipe1 Modify C:\my-opts2.cnf similarly for use by the second server. The procedure for starting a single MySQL ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-event-reports.html
The timestamp value currently resolves to whole seconds only; fractional seconds are not supported. In this section, we discuss the types of event logs provided by NDB Cluster, and the types of events that are logged. NDB Cluster provides two types ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-ndb-api-statistics.html
Ndb_api_wait_meta_request_count_session Ndb_api_wait_meta_request_count_slave [none] Ndb_api_wait_meta_request_count WaitNanosCount Total time (in nanoseconds) spent waiting for some type of signal from the data nodes. On platforms without ... A ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-ndb-innodb-engines.html
The NDB storage engine is implemented using a distributed, shared-nothing architecture, which causes it to behave differently from InnoDB in a number of ways. For those unaccustomed to working with NDB, unexpected behaviors can arise due to its ...