Я последние несколько дней (Как установил Ubuntu) наблюдаю постоянные, безостановочные, ни на секунду, обращения к диску. Сначала я подумал что это логи, я их выключил. Затем я дважды увеличил innodb_buffer_pool_size, не помогло.
Стояла Centos, я не наблюдал такой проблемы, может она и была, но она меня не раздражала.

Кто то может помочь чем то?

А про директиву general_log уже говорили?

general_log_file = /path_to/general.log
general_log = 1

Или можно в сессии включить

SET global general_log = 1;

21 минуту назад, Desti said:

SET global general_log = 1;

Спасибо, теперь я хоть какое то представление имею.

22 минуты назад, ryancoolround said:

Спасибо, теперь я хоть какое то представление имею.

Что там полезного показано?

10 минут назад, Respected said:

Что там полезного показано?

2024-10-22T17:29:40.270012Z    191 Close stmt
2024-10-22T17:29:40.270235Z    191 Prepare  /*::IPS\Theme\Cache\class_core_front_profile::profile:61*/ 
SELECT 
    core_badges.*, 
    core_member_badges.member, 
    core_member_badges.badge, 
    core_member_badges.datetime, 
    core_member_badges.rule, 
    core_member_badges.action_log, 
    core_member_badges.actor, 
    core_member_badges.recognize 
FROM 
    `core_member_badges` AS `core_member_badges`  
LEFT JOIN 
    `core_badges` AS `core_badges` 
ON 
    core_member_badges.badge = core_badges.id 
WHERE 
    `member` = ? 
ORDER BY 
    datetime DESC 
LIMIT 5

2024-10-22T17:29:40.270384Z    191 Prepare  /*::IPS\Theme\Cache\class_core_front_profile::profile:61*/ 
SELECT 
    core_badges.*, 
    core_member_badges.member, 
    core_member_badges.badge, 
    core_member_badges.datetime, 
    core_member_badges.rule, 
    core_member_badges.action_log, 
    core_member_badges.actor, 
    core_member_badges.recognize 
FROM 
    `core_member_badges` AS `core_member_badges`  
LEFT JOIN 
    `core_badges` AS `core_badges` 
ON 
    core_member_badges.badge = core_badges.id 
WHERE 
    `member` = ? 
ORDER BY 
    datetime DESC 
LIMIT 5

2024-10-22T17:29:40.270408Z    191 Execute  /*::IPS\Theme\Cache\class_core_front_profile::profile:61*/ 
SELECT 
    core_badges.*, 
    core_member_badges.member, 
    core_member_badges.badge, 
    core_member_badges.datetime, 
    core_member_badges.rule, 
    core_member_badges.action_log, 
    core_member_badges.actor, 
    core_member_badges.recognize 
FROM 
    `core_member_badges` AS `core_member_badges`  
LEFT JOIN 
    `core_badges` AS `core_badges` 
ON 
    core_member_badges.badge = core_badges.id 
WHERE 
    `member` = 1 
ORDER BY 
    datetime DESC 
LIMIT 5

2024-10-22T17:29:40.271097Z    191 Prepare  /*::IPS\Theme\Cache\class_core_front_profile::profile:61*/ 
SELECT 
    core_badges.*, 
    core_member_badges.member, 
    core_member_badges.badge, 
    core_member_badges.datetime, 
    core_member_badges.rule, 
    core_member_badges.action_log, 
    core_member_badges.actor, 
    core_member_badges.recognize 
FROM 
    `core_member_badges` AS `core_member_badges`  
LEFT JOIN 
    `core_badges` AS `core_badges` 
ON 
    core_member_badges.badge = core_badges.id 
WHERE 
    `member` = ? 
ORDER BY 
    datetime DESC 
LIMIT 5

2024-10-22T17:29:40.271223Z    191 Prepare  /*::IPS\Theme\Cache\class_core_front_profile::profile:61*/ 
SELECT 
    core_badges.*, 
    core_member_badges.member, 
    core_member_badges.badge, 
    core_member_badges.datetime, 
    core_member_badges.rule, 
    core_member_badges.action_log, 
    core_member_badges.actor, 
    core_member_badges.recognize 
FROM 
    `core_member_badges` AS `core_member_badges`  
LEFT JOIN 
    `core_badges` AS `core_badges` 
ON 
    core_member_badges.badge = core_badges.id 
WHERE 
    `member` = ? 
ORDER BY 
    datetime DESC 
LIMIT 5

2024-10-22T17:29:40.271238Z    191 Execute  /*::IPS\Theme\Cache\class_core_front_profile::profile:61*/ 
SELECT 
    core_badges.*, 
    core_member_badges.member, 
    core_member_badges.badge, 
    core_member_badges.datetime, 
    core_member_badges.rule, 
    core_member_badges.action_log, 
    core_member_badges.actor, 
    core_member_badges.recognize 
FROM 
    `core_member_badges` AS `core_member_badges`  
LEFT JOIN 
    `core_badges` AS `core_badges` 
ON 
    core_member_badges.badge = core_badges.id 
WHERE 
    `member` = 1 
ORDER BY 
    datetime DESC 
LIMIT 5

2024-10-22T17:29:40.271749Z    191 Prepare  /*::IPS\core\Achievements\_Badge::awardDescription:100*/ 
SELECT 
    word_key, 
    word_default, 
    word_custom 
FROM 
    `core_sys_lang_words` AS `core_sys_lang_words` 
WHERE 
    lang_id = ? 
AND 
    (word_key LIKE 'core_award_subject_badge_%' OR word_key LIKE 'core_award_other_badge_%')

2024-10-22T17:29:40.271838Z    191 Prepare  /*::IPS\core\Achievements\_Badge::awardDescription:100*/ 
SELECT 
    word_key, 
    word_default, 
    word_custom 
FROM 
    `core_sys_lang_words` AS `core_sys_lang_words` 
WHERE 
    lang_id = ? 
AND 
    (word_key LIKE 'core_award_subject_badge_%' OR word_key LIKE 'core_award_other_badge_%')

2024-10-22T17:29:40.271853Z    191 Execute  /*::IPS\core\Achievements\_Badge::awardDescription:100*/ 
SELECT 
    word_key, 
    word_default, 
    word_custom 
FROM 
    `core_sys_lang_words` AS `core_sys_lang_words` 
WHERE 
    lang_id = 28 
AND 
    (word_key LIKE 'core_award_subject_badge_%' OR word_key LIKE 'core_award_other_badge_%')

2024-10-22T17:29:40.273654Z    191 Close stmt
2024-10-22T17:29:40.274939Z    191 Close stmt
2024-10-22T17:29:40.275266Z    191 Close stmt
2024-10-22T17:29:40.275481Z    191 Prepare  /*::IPS\Dispatcher\_Front::finish:155*/ 
SELECT 
    * 
FROM 
    `core_widget_areas` AS `core_widget_areas` 
WHERE 
    app = ? 
AND 
    module = ? 
AND 
    controller = ?

2024-10-22T17:29:40.275575Z    191 Execute  /*::IPS\Dispatcher\_Front::finish:155*/ 
SELECT 
    * 
FROM 
    `core_widget_areas` AS `core_widget_areas` 
WHERE 
    app = 'core' 
AND 
    module = 'members' 
AND 
    controller = 'profile'

2024-10-22T17:29:40.275861Z    191 Close stmt
2024-10-22T17:29:40.277203Z    191 Prepare  /*::IPS\core\Alerts\_Alert::getNextAlertForMember:835*/ 
SELECT 
    * 
FROM 
    `core_alerts` AS `core_alerts` 
WHERE 
    alert_enabled = ? 
AND 
    alert_start < ? 
AND 
    (alert_end = 0 OR alert_end > ?) 
AND 
    (alert_recipient_type = ? OR (alert_recipient_type = ? AND alert_recipient_user IS NULL)) 
AND 
    alert_id NOT IN (
        SELECT 
            seen_alert_id 
        FROM 
            `core_alerts_seen` AS `core_alerts_seen` 
        WHERE 
            seen_member_id IS NULL
    ) 
ORDER BY 
    alert_start ASC

2024-10-22T17:29:40.277354Z    191 Prepare  /*::IPS\core\Alerts\_Alert::getNextAlertForMember:835*/ 
SELECT 
    * 
FROM 
    `core_alerts` AS `core_alerts` 
WHERE 
    alert_enabled = ? 
AND 
    alert_start < ? 
AND 
    (alert_end = 0 OR alert_end > ?) 
AND 
    (alert_recipient_type = ? OR (alert_recipient_type = ? AND alert_recipient_user IS NULL)) 
AND 
    alert_id NOT IN (
        SELECT 
            seen_alert_id 
        FROM 
            `core_alerts_seen` AS `core_alerts_seen` 
        WHERE 
            seen_member_id IS NULL
    ) 
ORDER BY 
    alert_start ASC

2024-10-22T17:29:40.277396Z    191 Execute  /*::IPS\core\Alerts\_Alert::getNextAlertForMember:835*/ 
SELECT 
    * 
FROM 
    `core_alerts` AS `core_alerts` 
WHERE 
    alert_enabled = 1 
AND 
    alert_start < 1697993417 
AND 
    (alert_end = 0 OR alert_end > 1697993417) 
AND 
    (alert_recipient_type = 1 OR (alert_recipient_type = 0 AND alert_recipient_user IS NULL)) 
AND 
    alert_id NOT IN (
        SELECT 
            seen_alert_id 
        FROM 
            `core_alerts_seen` AS `core_alerts_seen` 
        WHERE 
            seen_member_id IS NULL
    ) 
ORDER BY 
    alert_start ASC

В том то и дело, я не могу понять, полезно это или нет.

Первым делом после переезда на 5.х отключу нахрен эти бэджи.

А вообще отключить пользователей от форума, посмотреть, что происходит в статике, т.е. понять, кто инициатор.