=== WHEN === Thu Oct 30 14:39:44 UTC 2025 16:39:44 up 21 days, 17:33, 0 users, load average: 8.37, 12.05, 20.67 === TOP 20 CPU PIDs === PID PPID ELAPSED %CPU %MEM CMD 1747188 1 8-12:37:36 623 15.7 /usr/sbin/mysqld 1566653 3121903 00:05 63.0 0.1 php-fpm: pool antalaktiko_gr 1564374 3121903 00:10 60.7 0.1 php-fpm: pool karasteriou-service_gr 1565095 3121903 00:08 60.0 0.1 php-fpm: pool artinamiracle_gr 1560447 3122181 00:19 58.2 0.2 php-fpm: pool mrservice_gr 1568276 3121495 00:01 58.0 0.1 php-fpm: pool k9security_gr 1562832 3122181 00:14 55.3 0.2 php-fpm: pool mrservice_gr 1560012 3122181 00:20 49.6 0.2 php-fpm: pool mrservice_gr 1562413 3122181 00:15 48.6 0.2 php-fpm: pool mrservice_gr 1565672 3121495 00:07 47.7 0.1 php-fpm: pool emmanouelaeleutheriadou_gr 1562667 3121495 00:14 39.1 0.1 php-fpm: pool pasparts_gr 1565020 3121495 00:09 38.8 0.1 php-fpm: pool emmanouelaeleutheriadou_gr 1565292 3121495 00:08 38.7 0.1 php-fpm: pool endless-view_gr 1560346 3121495 00:19 38.1 0.2 php-fpm: pool partscar_gr 1566322 3121903 00:05 37.0 0.0 php-fpm: pool antalaktiko_gr 1566344 3121495 00:05 37.0 0.1 php-fpm: pool cozydepot_gr 1567288 3121903 00:03 37.0 0.0 php-fpm: pool antalaktiko_gr 1561022 3121495 00:18 36.8 0.1 php-fpm: pool kalogeras-parts_gr 1560207 3121495 00:20 36.2 0.2 php-fpm: pool partscar_gr === MySQL processlist (top 50 by time) === ID USER DB COMMAND TIME Q 5 event_scheduler NULL Daemon 736650 NULL 2557618 arkoudistoolbox_user arkoudistoolbox_db Sleep 2 NULL 13350176 digitalmountains_appuser digitalmountains_app Execute 0 UPDATE orders SET status = 'Τιμολογημένη' WHERE pretty_id = 'ΠΑΡ000113511' 13350464 kaldelis_user kaldelis_db Query 0 SELECT 7w9qGZv1ls_posts.ID\n\t\t\t\t\tFROM 7w9qGZv1ls_posts \n\t\t\t\t\tWHERE 1=1 AND 7w9qGZv1ls_posts.post_type = 'product' AND ((7w9qGZv1ls_posts.post_status = 'publish'))\n\t\t\t\t\tGROUP BY 7w9qGZv1ls_posts.ID\n\t 13350514 mrservice_user mrservice_db Sleep 0 NULL 13350522 kalogerasparts_user kalogerasparts_db Sleep 0 NULL 13350523 antalaktiko_jsonUser antalaktiko_2024 Sleep 0 NULL 13350515 pasparts_user pasparts_db Query 0 SELECT post_id, meta_value FROM rHLlaiPZ_postmeta WHERE meta_key = '_wp_attached_file' AND meta_value = '2019/01/logo.png' 13350516 pasparts_user pasparts_db Sleep 0 NULL 13350500 xanthopouloselas_user xanthopouloselas_db Sleep 0 NULL 13350524 kalogerasparts_user kalogerasparts_db Sleep 0 NULL 13350517 rhodesk9security_user rhodesk9security_db Query 0 SELECT option_value FROM CXlaR_options WHERE option_name = 'wp_debug_data' LIMIT 1 13350525 kaldelis_user kaldelis_db Sleep 0 NULL 13350526 root NULL Query 0 SELECT ID,USER,DB,COMMAND,TIME,LEFT(INFO,200) AS Q FROM INFORMATION_SCHEMA.PROCESSLIST ORDER BY TIME DESC LIMIT 50 13350518 xkgparts_user xkgparts_db Query 0 SELECT option_value FROM SnWEdemcz_options WHERE option_name = 'woocommerce_show_marketplace_suggestions' LIMIT 1 === InnoDB status (truncated) === *************************** 1. row *************************** Type: InnoDB Name: Status: ===================================== 2025-10-30 16:39:44 140256892245760 INNODB MONITOR OUTPUT ===================================== Per second averages calculated from the last 43 seconds ----------------- BACKGROUND THREAD ----------------- srv_master_thread loops: 734551 srv_active, 0 srv_shutdown, 1394 srv_idle srv_master_thread log flush and writes: 0 ---------- SEMAPHORES ---------- OS WAIT ARRAY INFO: reservation count 23669873 OS WAIT ARRAY INFO: signal count 15004568 RW-shared spins 0, rounds 0, OS waits 0 RW-excl spins 0, rounds 0, OS waits 0 RW-sx spins 0, rounds 0, OS waits 0 Spin rounds per wait: 0.00 RW-shared, 0.00 RW-excl, 0.00 RW-sx ------------ TRANSACTIONS ------------ Trx id counter 282488061 Purge done for trx's n:o < 282488060 undo n:o < 0 state: running but idle History list length 32 LIST OF TRANSACTIONS FOR EACH SESSION: ---TRANSACTION 421734421147648, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 421734421148456, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 421734421146840, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 421734421150072, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 421734421146032, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 421734421145224, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 282488060, ACTIVE 0 sec fetching rows mysql tables in use 1, locked 1 5609 lock struct(s), heap size 598136, 102572 row lock(s), undo log entries 1 MySQL thread id 13350176, OS thread handle 140256914384640, query id 1968802833 localhost 127.0.0.1 digitalmountains_appuser updating UPDATE orders SET status = 'Τιμολογημένη' WHERE pretty_id = 'ΠΑΡ000113511' -------- 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 (read 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 (write 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) Pending normal aio reads: [0, 0, 0, 0] , aio writes: [0, 0, 0, 0] , ibuf aio reads: Pending flushes (fsync) log: 0; buffer pool: 0 461322920 OS file reads, 196691567 OS file writes, 80551499 OS fsyncs 1819.00 reads/s, 16384 avg bytes/read, 58.16 writes/s, 26.96 fsyncs/s ------------------------------------- INSERT BUFFER AND ADAPTIVE HASH INDEX ------------------------------------- Ibuf: size 1, free list len 2811, seg size 2813, 2264448 merges merged operations: insert 32639633, delete mark 242596, delete 71816 discarded operations: insert 55, delete mark 0, delete 0 Hash table size 34679, node heap has 4 buffer(s) Hash table size 34679, node heap has 16 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 10 buffer(s) Hash table size 34679, node heap has 2 buffer(s) Hash table size 34679, node heap has 6 buffer(s) 5419.59 hash searches/s, 2410.90 non-hash searches/s --- LOG --- Log sequence number 4455167708015 Log buffer assigned up to 4455167708015 Log buffer completed up to 4455167708015 Log written up to 4455167708015 Log flushed up to 4455167708015 Added dirty pages up to 4455167708015 Pages flushed up to 4455167427369 Last checkpoint at 4455167427369 Log minimum file id is 1360437 Log maximum file id is 1360459 102059597 log i/o's done, 14.98 log i/o's/second ---------------------- BUFFER POOL AND MEMORY ---------------------- Total large memory allocated 0 Dictionary memory allocated 21476573 Buffer pool size 8192 Free buffers 848 Database pages 7261 Old database pages 2660 Modified db pages 99 Pending reads 0 Pending writes: LRU 3, flush list 0, single page 0 Pages made young 637390313, not young 19485922159 5671.42 youngs/s, 57967.48 non-youngs/s Pages read 461326297, created 26859906, written 71564258 1818.99 reads/s, 16.50 creates/s, 37.17 writes/s Buffer pool hit rate 992 / 1000, young-making rate 25 / 1000 not 264 / 1000 Pages read ahead 883.59/s, evicted without access 5.07/s, Random read ahead 0.00/s LRU len: 7261, unzip_LRU len: 0 I/O sum[42513]:cur[112], unzip sum[0]:cur[0] -------------- ROW OPERATIONS -------------- 0 queries inside InnoDB, 0 queries in queue 0 read views open inside InnoDB Process ID=1747188, Main thread ID=140258948753152 , state=sleeping Number of rows inserted 727356098, updated 4450661, deleted 884803, read 75056561166 2910.89 inserts/s, 4.35 updates/s, 0.40 deletes/s, 194950.47 reads/s Number of system rows inserted 49097, updated 446062, deleted 35004, read 423948711 0.00 inserts/s, 0.00 updates/s, 0.00 deletes/s, 187.04 reads/s ---------------------------- END OF INNODB MONITOR OUTPUT ============================ === File I/O (vmstat/iostat) === procs -----------memory---------- ---swap-- -----io---- -system-- ------cpu----- r b swpd free buff cache si so bi bo in cs us sy id wa st 13 0 806536 11915224 67484 37701612 0 0 130 220 0 0 20 7 73 0 0 6 1 806536 11727148 67484 37700296 0 0 756 2353 31650 20086 8 5 87 0 0 11 0 806536 11619624 67484 37701140 0 0 0 3896 28259 23109 7 3 90 0 0