MySQL :: MySQL 9.7 Reference Manual

Search Results

Displaying 41 to 49 of 49 total results

« Previous
1
2
3
4
5
Next »

28.4.7 The INFORMATION_SCHEMA INNODB_CMPMEM and INNODB_CMPMEM_RESET Tables

https://dev.mysql.com/doc/refman/9.7/en/information-schema-innodb-cmpmem-table.html

RELOCATION_TIME The total time in microseconds used for relocating blocks of size PAGE_SIZE. The INNODB_CMPMEM and INNODB_CMPMEM_RESET tables provide status information on compressed pages within the InnoDB buffer pool. The INNODB_CMPMEM and ...

17.8.8 Configuring Spin Lock Polling

https://dev.mysql.com/doc/refman/9.7/en/innodb-performance-spin_lock_polling.html

In the 100MHz Pentium era, an innodb_spin_wait_delay unit was calibrated to be equivalent to one microsecond. InnoDB mutexes and rw-locks are typically reserved for short intervals. On a multi-core system, it can be more efficient for a thread to ...

17.8.4 Configuring Thread Concurrency for InnoDB

https://dev.mysql.com/doc/refman/9.7/en/innodb-performance-thread_concurrency.html

Once the number of executing threads reaches this limit, additional threads sleep for a number of microseconds, set by the configuration parameter innodb_thread_sleep_delay, before being placed into the queue. InnoDB uses operating system threads ...

17.8.9 Purge Configuration

https://dev.mysql.com/doc/refman/9.7/en/innodb-purge-configuration.html

The innodb_max_purge_lag_delay variable specifies the maximum delay in microseconds for the delay imposed when the innodb_max_purge_lag threshold is exceeded. InnoDB does not physically remove a row from the database immediately when you delete it ...

11.3 Keywords and Reserved Words

https://dev.mysql.com/doc/refman/9.7/en/keywords.html

Certain keywords, such as SELECT, DELETE, or BIGINT, are reserved and require special treatment for use as identifiers such as table and column names. This may also be true for the names of built-in functions. Some keywords which are otherwise ...

25.6.15.15 The ndbinfo cpudata_1sec Table

https://dev.mysql.com/doc/refman/9.7/en/mysql-cluster-ndbinfo-cpudata-1sec.html

The cpudata_1sec table provides data about CPU usage per second over the last 20 seconds.

8.4.7.4 Audit Log Component File Format

https://dev.mysql.com/doc/refman/9.7/en/audit-log-component-file-formats.html

Example: "query": "DELETE FROM t1" query_time The query execution time in microseconds (if the longlong data type is selected) or seconds (if the double data type is selected). The MySQL server calls the audit log component to write an audit record ...

25.6.15.17 The ndbinfo cpudata_50ms Table

https://dev.mysql.com/doc/refman/9.7/en/mysql-cluster-ndbinfo-cpudata-50ms.html

The cpudata_50ms table provides data about CPU usage per 50-millisecond interval over the last second.

25.6.15.61 The ndbinfo tc_time_track_stats Table

https://dev.mysql.com/doc/refman/9.7/en/mysql-cluster-ndbinfo-tc-time-track-stats.html

The tc_time_track_stats table provides time-tracking information obtained from the DBTC block (TC) instances in the data nodes, through API nodes access NDB. Each TC instance tracks latencies for a set of activities it undertakes on behalf of API ...