=== TIMESTAMP / HOST === Mon Nov 10 09:11:36 EET 2025 d3.kareklas.gr === BASIC CONCURRENCY === +-----------------+------+ | Threads_running | 14 | +-----------------+------+ +-------------------+------+ | Threads_connected | 17 | +-------------------+------+ === TOP ACTIVE SESSIONS (non-sleeping) === +----------+--------------------------+----------------------+--------+------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------+ | 5 | event_scheduler | NULL | 804428 | Waiting on empty queue | NULL | | 14329663 | homemania_user | homemania_database | 110 | executing | SELECT object_id, term_taxonomy_id FROM Tikme_term_relationships INNER JOIN Tikme_posts ON object_id = ID WHERE term_taxonomy_id IN (67153,68163,69246,69243,691 | | 14330617 | homemania_user | homemania_database | 102 | executing | SELECT object_id, term_taxonomy_id FROM Tikme_term_relationships INNER JOIN Tikme_posts ON object_id = ID WHERE term_taxonomy_id IN (67153,68163,69246,69243,691 | | 14332984 | karagiannoudis_user | karagiannoudis_db | 3 | executing | SELECT wpbe_posts.* FROM wpbe_posts LEFT JOIN wpbe_postmeta ON ( wpbe_posts.ID = wpbe_postmeta.post_id AND wpbe_postmeta.meta_key = '_sku' ) LEFT JOIN | | 14332979 | karagiannoudis_user | karagiannoudis_db | 3 | executing | SELECT wpbe_posts.* FROM wpbe_posts LEFT JOIN wpbe_postmeta ON ( wpbe_posts.ID = wpbe_postmeta.post_id AND wpbe_postmeta.meta_key = '_sku' ) LEFT JOIN | | 14332982 | karagiannoudis_user | karagiannoudis_db | 3 | executing | SELECT wpbe_posts.* FROM wpbe_posts LEFT JOIN wpbe_postmeta ON ( wpbe_posts.ID = wpbe_postmeta.post_id AND wpbe_postmeta.meta_key = '_sku' ) LEFT JOIN | | 14332975 | karagiannoudis_user | karagiannoudis_db | 3 | executing | SELECT wpbe_posts.* FROM wpbe_posts LEFT JOIN wpbe_postmeta ON ( wpbe_posts.ID = wpbe_postmeta.post_id AND wpbe_postmeta.meta_key = '_sku' ) LEFT JOIN | | 14332974 | kaldelis_user | kaldelis_db | 1 | executing | SELECT object_id, term_taxonomy_id FROM 7w9qGZv1ls_term_relationships INNER JOIN 7w9qGZv1ls_posts ON object_id = ID WHERE term_taxonomy_id IN (22089,22311,22396 | | 14330145 | digitalmountains_appuser | digitalmountains_app | 0 | updating | UPDATE orders SET status = 'Τιμολογημένη' WHERE pretty_id = 'ΠΑΡ000040500' | | 14332994 | kaldelis_user | kaldelis_db | 0 | executing | SELECT wpml_translations.translation_id, wpml_translations.element_id, wpml_translations.language_code, wpml_translations.source_language_code, wpml_translation | | 14333004 | kaldelis_user | kaldelis_db | 0 | executing | SELECT wpml_translations.translation_id, wpml_translations.element_id, wpml_translations.language_code, wpml_translations.source_language_code, wpml_translation | | 14333012 | root | NULL | 0 | executing | SELECT ID,USER,DB,TIME,STATE,LEFT(INFO,160) AS q FROM information_schema.PROCESSLIST WHERE COMMAND <> 'Sleep' ORDER BY TIME DESC LIMIT 4 | | 14330710 | digitalmountains_appuser | digitalmountains_app | 0 | updating | UPDATE orders SET status = 'Τιμολογημένη' WHERE pretty_id = 'ΠΑΡ000002726' | | 7361479 | arkoudistoolbox_user | arkoudistoolbox_db | 0 | executing | Select status from smartenize where ref_id ='6de9d305-7dc8-4137-b3e1-4567fb46d14d' | | 14332999 | kaldelis_user | kaldelis_db | 0 | executing | SELECT 7w9qGZv1ls_posts.ID FROM 7w9qGZv1ls_posts WHERE 1=1 AND 7w9qGZv1ls_posts.post_parent = 0 AND ( 7w9qGZv1ls_posts.ID NOT IN ( SELECT | +----------+--------------------------+----------------------+--------+------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------+ === WORST STATEMENTS (sys.statement_analysis) === sys.statement_analysis not available. === HOT TABLES (reads/writes) === sys.schema_table_statistics not available. === TEMP TABLE / SORT PRESSURE (snapshot) === +--------------------+-----------+ | Created_tmp_tables | 251198571 | +--------------------+-----------+ +-------------------------+-------+ | Created_tmp_disk_tables | 12865 | +-------------------------+-------+ +-------------------+---------+ | Created_tmp_files | 3617068 | +-------------------+---------+ +-------------------+---------+ | Sort_merge_passes | 3188681 | +-------------------+---------+ +-----------+-----------+ | Sort_scan | 425249273 | +-----------+-----------+ +------------+------+ | Sort_range | 0 | +------------+------+ === BUFFER POOL EFFECTIVENESS === +----------------------------------+--------------+ | Innodb_buffer_pool_read_requests | 129966331204 | +----------------------------------+--------------+ +--------------------------+-----------+ | Innodb_buffer_pool_reads | 427954789 | +--------------------------+-----------+ +-------------------------+-----------+ | innodb_buffer_pool_size | 134217728 | +-------------------------+-----------+ +------------------------------+------+ | innodb_buffer_pool_instances | 1 | +------------------------------+------+ === LOCK WAITS / LONG TRANSACTIONS === === CONNECTION CHURN / TABLE CACHE === +-------------+----------+ | Connections | 14333019 | +-------------+----------+ +------------------+------+ | Aborted_connects | 306 | +------------------+------+ +---------------+----------+ | Opened_tables | 51249104 | +---------------+----------+ +----------------------------+------+ | table_open_cache | 4000 | | table_open_cache_instances | 16 | +----------------------------+------+ +----------------------------+------------+ | Table_open_cache_hits | 5286908274 | | Table_open_cache_misses | 51248254 | | Table_open_cache_overflows | 51242174 | +----------------------------+------------+ === HANDLER HINTS (scans if rnd_next is high) === +-----------------------+--------------+ | Handler_read_first | 30963576 | | Handler_read_key | 159127487992 | | Handler_read_last | 1593866 | | Handler_read_next | 705625255502 | | Handler_read_prev | 662758531 | | Handler_read_rnd | 22199197141 | | Handler_read_rnd_next | 133993641290 | +-----------------------+--------------+ +---------------+-------------+ | Handler_write | 71652816427 | +---------------+-------------+ === BIGGEST TABLES (by size) === +---------------------------+-----------------------------------+-------+----------+ | cozydepot_db2 | NelP4Rf9i_actionscheduler_actions | 36.45 | 71292451 | | cozydepot_db2 | NelP4Rf9i_actionscheduler_logs | 9.52 | 71264206 | | antalaktiko_notifications | notifications_set_legacy | 2.30 | 43525692 | | mrservice_test | wp_wfhoover | 2.16 | 10877076 | | mrservice_db | jsvRE5Y_wfhoover | 2.10 | 9807424 | | homemania_db2 | Tikme_postmeta | 1.39 | 12224037 | | homemania_database | Tikme_postmeta | 1.39 | 12224037 | | arkoudistoolbox_db | at_woocommerce_sessions | 1.36 | 52175 | | homemania_database | Tikme_yoast_indexable | 0.99 | 2837053 | | arkoudistoolbox_db | smartenize | 0.61 | 9650 | | carsprofitparts_db | cpp_postmeta | 0.54 | 2885125 | | geotheo_geotheog_ocar462 | ocpf_session | 0.54 | 7372865 | | antalaktiko_ndb | ant_postmeta | 0.42 | 1423576 | | kaldelis_db | 7w9qGZv1ls_postmeta | 0.41 | 1615987 | | ntampoudis_db | nt_postmeta | 0.41 | 1302610 | +---------------------------+-----------------------------------+-------+----------+ === PER USER/HOST LATENCY (find chatty tenants) === sys.user_summary not available. sys.host_summary not available. === INNODB STATUS KEY LINES === 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 Purge done for trx's n:o < 303887657 undo n:o < 0 state: running but idle History list length 6 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 Ibuf: size 1, free list len 2811, seg size 2813, 190539 merges Log sequence number 4528993427488 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 0 read views open inside InnoDB