SHOW GLOBAL STATUS;

какая-то портянка, ниче не понятно

Innodb status

нет такого в SHOW GLOBAL STATUS;

=====================================
2021-10-14 04:24:21 0x7f97b445a700 INNODB MONITOR OUTPUT
=====================================
Per second averages calculated from the last 1 seconds
-----------------
BACKGROUND THREAD
-----------------
srv_master_thread loops: 7987 srv_active, 0 srv_shutdown, 99 srv_idle
srv_master_thread log flush and writes: 0
----------
SEMAPHORES
----------
OS WAIT ARRAY INFO: reservation count 45035
OS WAIT ARRAY INFO: signal count 37398
RW-shared spins 8981, rounds 12107, OS waits 3136
RW-excl spins 37061, rounds 829489, OS waits 10574
RW-sx spins 1428, rounds 36932, OS waits 623
Spin rounds per wait: 1.35 RW-shared, 22.38 RW-excl, 25.86 RW-sx
------------
TRANSACTIONS
------------
Trx id counter 11871740
Purge done for trx's n:o < 11871118 undo n:o < 0 state: running but idle
History list length 20
LIST OF TRANSACTIONS FOR EACH SESSION:
---TRANSACTION 421764972413352, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 421764972415064, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 421764972409072, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 421764972414208, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 421764972409928, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 421764972415920, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 421764972416776, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 421764972412496, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 421764972411640, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 421764972408216, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 421764972407360, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 421764972406504, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
--------
FILE I/O
--------
I/O thread 0 state: waiting for completed aio requests (insert buffer thread)
I/O thread 1 state: waiting for completed aio requests (log thread)
I/O thread 2 state: waiting for completed aio requests (read thread)
I/O thread 3 state: waiting for completed aio requests (read thread)
I/O thread 4 state: waiting for completed aio requests (read thread)
I/O thread 5 state: waiting for completed aio requests (read thread)
I/O thread 6 state: waiting for completed aio requests (write thread)
I/O thread 7 state: waiting for completed aio requests (write thread)
I/O thread 8 state: waiting for completed aio requests (write thread)
I/O thread 9 state: waiting for completed aio requests (write thread)
Pending normal aio reads: [0, 0, 0, 0] , aio writes: [0, 0, 0, 0] ,
ibuf aio reads:, log i/o's:, sync i/o's:
Pending flushes (fsync) log: 0; buffer pool: 0
35554 OS file reads, 645211 OS file writes, 594303 OS fsyncs
0.00 reads/s, 0 avg bytes/read, 2.00 writes/s, 2.00 fsyncs/s
-------------------------------------
INSERT BUFFER AND ADAPTIVE HASH INDEX
-------------------------------------
Ibuf: size 1, free list len 2316, seg size 2318, 9 merges
merged operations:
insert 8, delete mark 7, delete 6
discarded operations:
insert 0, delete mark 0, delete 0
Hash table size 34679, node heap has 3 buffer(s)
Hash table size 34679, node heap has 3 buffer(s)
Hash table size 34679, node heap has 3 buffer(s)
Hash table size 34679, node heap has 4 buffer(s)
Hash table size 34679, node heap has 1 buffer(s)
Hash table size 34679, node heap has 1 buffer(s)
Hash table size 34679, node heap has 5 buffer(s)
Hash table size 34679, node heap has 9 buffer(s)
37.96 hash searches/s, 164.84 non-hash searches/s
---
LOG
---
Log sequence number          30640043560
Log buffer assigned up to    30640043560
Log buffer completed up to   30640043560
Log written up to            30640043560
Log flushed up to            30640043560
Added dirty pages up to      30640043560
Pages flushed up to          30639951211
Last checkpoint at           30639951211

612607 log i/o's done, 2.00 log i/o's/second
----------------------
BUFFER POOL AND MEMORY
----------------------
Total large memory allocated 137363456
Dictionary memory allocated 1792231
Buffer pool size   8192
Free buffers       1024
Database pages     7139
Old database pages 2615
Modified db pages  351
Pending reads      0
Pending writes: LRU 0, flush list 0, single page 0
Pages made young 1959, not young 71908
0.00 youngs/s, 0.00 non-youngs/s
Pages read 34039, created 2961, written 25042
0.00 reads/s, 0.00 creates/s, 0.00 writes/s
Buffer pool hit rate 1000 / 1000, young-making rate 0 / 1000 not 0 / 1000
Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
LRU len: 7139, unzip_LRU len: 0
I/O sum[0]:cur[0], unzip sum[0]:cur[0]
--------------
ROW OPERATIONS
--------------
0 queries inside InnoDB, 0 queries in queue
0 read views open inside InnoDB
Process ID=1, Main thread ID=140289575413504 , state=sleeping
Number of rows inserted 279009, updated 3207, deleted 268873, read 2137206
0.00 inserts/s, 0.00 updates/s, 0.00 deletes/s, 202.80 reads/s
Number of system rows inserted 61, updated 378, deleted 37, read 47692
0.00 inserts/s, 0.00 updates/s, 0.00 deletes/s, 0.00 reads/s
----------------------------
END OF INNODB MONITOR OUTPUT
============================

такая же портянка, ниче не понять

Пхп тут не нужен

htop

ДД, есть таблица в которой нужно удалить все БИН у тех у кого есть определенная категория, как можно удалить этот бин со всех остальных таблиц, если в них не указана категория?

DELETE t1, t2 FROM t1 INNER JOIN t2 INNER JOIN t3
WHERE t1.id=t2.id AND t2.id=t3.id;

Thx

Всем привет! Подкажите, пж, есть таблица дата, товар, цена. Нужно сделать столбец, использую цену, если изменение цены было меньше 5%, то брать предыдущую, если нет то эту. Сравнивать с самой первой ценой, до 1 изменения в 5%, потом уже с этой ценой и тд. Использовать lag, не достаточно

И? В чем вопрос?

вопрос в том, как это сделать)

Курсором

А можно подробнее

Периодически выполняю запрос,сначала висит state 'sending data',потом меняется на 'storing result in query cache',а в воркбенче получаю lost connect server during query. Таблица в три поля,один из которых mediumblob

27 тыс записей