Jump to content

Постоянные, безостановочные обращения к диску от mysqld

ryancoolround
ryancoolround
in Invision Community 4 Support

Featured Replies

Posted
comment_212513

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

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

213321.png

  • Цитата
    • Link to comment
    https://ipbmafia.ru/topic/28131-postoyannye-bezostanovochnye-obrasheniya-k-disku-ot-mysqld/
    Share on other sites
    comment_212515

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

    general_log_file = /path_to/general.log
    general_log = 1

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

    SET global general_log = 1;

  • Цитата

  • Полезно: 1

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

    SET global general_log = 1;

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

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

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

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

  • Цитата
    • Author
    comment_212521
    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

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

  • Цитата
    comment_212522

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

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

  • Цитата

    • Join the conversation

    You can post now and register later. If you have an account, sign in now to post with your account.
    Note: Your post will require moderator approval before it will be visible.

    Guest
    Ответить в этой теме...
    Go to topic listing

    Последние посетители 0

    • No registered users viewing this page.