1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
| ------------
TRANSACTIONS
------------
Trx id counter 59630574
Purge done for trx's n:o < 59630571 undo n:o < 0 state: running
History list length 50
LIST OF TRANSACTIONS FOR EACH SESSION:
---TRANSACTION 59630573, ACTIVE 75919 sec inserting
mysql tables in use 1, locked 1
1 lock struct(s), heap size 1128, 0 row lock(s)
MariaDB thread id 39, OS thread handle 140079423436480, query id 20591 NAS_Synology 192.168.10.232 SBFspotUser Update
INSERT IGNORE INTO Inverters VALUES(3005988527,'SB3.6-1AV-41 527','Sunny Boy 3.6','04.01.15.R',0,0,0,0,0,0,'','',0)
---TRANSACTION (0x7f66d81c6880), ACTIVE 76438 sec starting index read
mysql tables in use 1, locked 0
0 lock struct(s), heap size 1128, 0 row lock(s)
MariaDB thread id 26, OS thread handle 140079553328832, query id 19824 NAS_Synology 192.168.10.232 home-assistant Statistics
SELECT states_meta.metadata_id, states_meta.entity_id
FROM states_meta
WHERE states_meta.entity_id IN ('input_select.washing_machine_state_machine')
Trx read view will not see trx with id >= 59630573, sees < 59630390
---TRANSACTION (0x7f66d81c5d80), ACTIVE 65229 sec starting index read
mysql tables in use 1, locked 0
0 lock struct(s), heap size 1128, 0 row lock(s)
MariaDB thread id 24, OS thread handle 140079423690432, query id 36239 PC_werkkmr 192.168.10.201 dev Sending data
SELECT x.* FROM `home-assistant`.schema_changes x
LIMIT 0, 200
Trx read view will not see trx with id >= 59630574, sees < 59630390
---TRANSACTION (0x7f66d81c4780), not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION (0x7f66d81c3c80), ACTIVE 76437 sec starting index read
mysql tables in use 1, locked 0
0 lock struct(s), heap size 1128, 0 row lock(s)
MariaDB thread id 9, OS thread handle 140079554090688, query id 19826 NAS_Synology 192.168.10.232 home-assistant Statistics
SELECT states_meta.metadata_id, states_meta.entity_id
FROM states_meta
WHERE states_meta.entity_id IN ('input_select.washing_machine_state_machine')
Trx read view will not see trx with id >= 59630573, sees < 59630390
---TRANSACTION (0x7f66d81c3180), ACTIVE 76436 sec starting index read
mysql tables in use 1, locked 0
0 lock struct(s), heap size 1128, 0 row lock(s)
MariaDB thread id 8, OS thread handle 140079687550656, query id 19829 NAS_Synology 192.168.10.232 home-assistant Statistics
SELECT states_meta.metadata_id, states_meta.entity_id
FROM states_meta
WHERE states_meta.entity_id IN ('input_select.dryer_state_machine')
Trx read view will not see trx with id >= 59630573, sees < 59630390
---TRANSACTION (0x7f66d81c2680), ACTIVE 76437 sec starting index read
mysql tables in use 1, locked 0
0 lock struct(s), heap size 1128, 0 row lock(s)
MariaDB thread id 7, OS thread handle 140079687804608, query id 19828 NAS_Synology 192.168.10.232 home-assistant Statistics
SELECT states_meta.metadata_id, states_meta.entity_id
FROM states_meta
WHERE states_meta.entity_id IN ('input_select.dryer_state_machine')
Trx read view will not see trx with id >= 59630573, sees < 59630390
---TRANSACTION 59630390, ACTIVE 86678 sec fetching rows
mysql tables in use 2, locked 2
124478 lock struct(s), heap size 12083320, 2987245 row lock(s)
MariaDB thread id 5, OS thread handle 140079888877248, query id 418 NAS_Synology 192.168.10.232 home-assistant copy to tmp table
ALTER TABLE state_attributes MODIFY attributes_id BIGINT NOT NULL AUTO_INCREMENT
--------
FILE I/O
--------
Pending flushes (fsync): 0
3820464 OS file reads, 2484150 OS file writes, 89079 OS fsyncs
0.00 reads/s, 0 avg bytes/read, 0.00 writes/s, 0.00 fsyncs/s
---
LOG
---
Log sequence number 1298633634812
Log flushed up to 1298633634812
Pages flushed up to 1298633394058
Last checkpoint at 1298633394058
----------------------
BUFFER POOL AND MEMORY
----------------------
Total large memory allocated 50331648
Dictionary memory allocated 182616
Buffer pool size 993
Free buffers 0
Database pages 256
Old database pages 0
Modified db pages 255
Percent of dirty pages(LRU & free pages): 99.222
Max dirty pages percent: 90.000
Pending reads 0
Pending writes: LRU 0, flush list 0
Pages made young 110780, not young 3202335
0.00 youngs/s, 0.00 non-youngs/s
Pages read 3820428, created 130742, written 2424980
0.00 reads/s, 0.00 creates/s, 0.00 writes/s
No buffer pool page gets since the last printout
Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
LRU len: 256, unzip_LRU len: 0
I/O sum[0]:cur[0], unzip sum[0]:cur[0]
--------------
ROW OPERATIONS
--------------
5 read views open inside InnoDB
state: sleeping
----------------------------
END OF INNODB MONITOR OUTPUT
============================ |