https://dev.mysql.com/date-and-time-literals.html
A DATETIME or TIMESTAMP value can include a trailing fractional seconds part in up to microseconds (6 digits) precision. A trailing fractional seconds part is recognized in the 'D hh:mm:ss.fraction', 'hh:mm:ss.fraction', 'hhmmss.fraction', and ...
https://dev.mysql.com/server-system-variables.html
In MySQL 8.0, timestamp is a DOUBLE rather than BIGINT because its value includes a microseconds part. The MySQL server maintains many system variables that configure its operation. System variables can be set at server startup using options on the ...
https://dev.mysql.com/statement-histogram-summary-tables.html
The Performance Schema maintains statement event summary tables that contain information about minimum, maximum, and average statement latency (see Section 26.12.17.3, “Statement Summary Tables”). To permit assessment at a more fine-grained ...
https://dev.mysql.com/replication-features-fractional-seconds.html
MySQL 8.0 permits fractional seconds for TIME, DATETIME, and TIMESTAMP values, with up to microseconds (6 digits) precision.
https://dev.mysql.com/server-error-reference.html
Error number: MY-011039; Symbol: ER_MICROSECOND_TIMER_IS_NOT_AVAILABLE; SQLSTATE: HY000 Message: The MICROSECOND timer is not available. The MySQL server writes some error messages to its error log, and sends others to client programs. Example ...
https://dev.mysql.com/optimizing-innodb-logging.html
Consider the following guidelines for optimizing redo logging: Make your redo log files big, even as big as the buffer pool. When InnoDB has written the redo log files full, it must write the modified contents of the buffer pool to disk in a ...
https://dev.mysql.com/fractional-seconds.html
MySQL 8.0 has fractional seconds support for TIME, DATETIME, and TIMESTAMP values, with up to microseconds (6 digits) precision: To define a column that includes a fractional seconds part, use the syntax type_name(fsp), where type_name is TIME, ...
https://dev.mysql.com/sys-format-time.html
Depending on the size of the value, the units part is ps (nanoseconds), ns (nanoseconds), us (microseconds), ms (milliseconds), s (seconds), m (minutes), h (hours), d (days), or w (weeks). Note As of MySQL 8.0.16, format_time() is deprecated and ...
https://dev.mysql.com/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 ...
https://dev.mysql.com/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 ...
