MySQL 性能模式函数

名称	描述	引入
FORMAT_BYTES()	将字节计数转换为带单位的值	8.0.16
FORMAT_PICO_TIME()	将以皮秒为单位的时间转换为以单位表示的值	8.0.16
PS_CURRENT_THREAD_ID()	当前线程的性能架构线程ID	8.0.16
PS_THREAD_ID()	给定线程的性能架构线程ID	8.0.16

Argument Value	Result Units	Result Units Indicator
Up to 1023	bytes	bytes
Up to 10242 − 1	kibibytes	KiB
Up to 10243 − 1	mebibytes	MiB
Up to 10244 − 1	gibibytes	GiB
Up to 10245 − 1	tebibytes	TiB
Up to 10246 − 1	pebibytes	PiB
10246 and up	exbibytes	EiB

Argument Value	Result Units	Result Units Indicator
Up to 103 − 1	picoseconds	ps
Up to 106 − 1	nanoseconds	ns
Up to 109 − 1	microseconds	us
Up to 1012 − 1	milliseconds	ms
Up to 60×1012 − 1	seconds	s
Up to 3.6×1015 − 1	minutes	min
Up to 8.64×1016 − 1	hours	h
8.64×1016 and up	days	d

mysql> SELECT FORMAT_BYTES(512), FORMAT_BYTES(18446644073709551615);
+-------------------+------------------------------------+
| FORMAT_BYTES(512) | FORMAT_BYTES(18446644073709551615) |
+-------------------+------------------------------------+
|  512 bytes        | 16.00 EiB                          |
+-------------------+------------------------------------+

mysql> SELECT FORMAT_PICO_TIME(3501), FORMAT_PICO_TIME(188732396662000);
+------------------------+-----------------------------------+
| FORMAT_PICO_TIME(3501) | FORMAT_PICO_TIME(188732396662000) |
+------------------------+-----------------------------------+
| 3.50 ns                | 3.15 min                          |
+------------------------+-----------------------------------+

mysql> SELECT PS_CURRENT_THREAD_ID();
+------------------------+
| PS_CURRENT_THREAD_ID() |
+------------------------+
|                     52 |
+------------------------+
mysql> SELECT PS_THREAD_ID(CONNECTION_ID());
+-------------------------------+
| PS_THREAD_ID(CONNECTION_ID()) |
+-------------------------------+
|                            52 |
+-------------------------------+

mysql> SELECT PS_THREAD_ID(6);
+-----------------+
| PS_THREAD_ID(6) |
+-----------------+
|              45 |
+-----------------+