Форум Сайтостроение Администрирование серверов

Сначала падает база данных, потом и сам сервер, помогает перезагрузка

T

66

todays

24 июня 2015, 03:38

3351

Большая БД, есть таблицы по 10-15млн записей.

/dev/sda6 /tmp 2GB

tmp_table_size=1024M

много join запросов

Пришлось уменьшить

connect_timeout=8

interactive_timeout=12

wait_timeout=12

Ложится сервер mysql

150620 15:29:30 [Note] /usr/sbin/mysqld: ready for connections.

Version: '5.1.61' socket: '/var/lib/mysql/mysql.sock' port: 3306 MySQL Community Server (GPL)

150620 15:53:54 [ERROR] /usr/sbin/mysqld: Disk is full writing '/var/tmp/#sql_7c31_0.MYI' (Errcode: 28). Waiting for someone to free space... (Expect up to 60 secs delay for server to continue after freeing disk space)

150620 15:53:54 [ERROR] /usr/sbin/mysqld: Retry in 60 secs. Message reprinted in 600 secs

150620 15:53:54 [ERROR] /usr/sbin/mysqld: Disk is full writing '/var/tmp/#sql_7c31_5.MYI' (Errcode: 28). Waiting for someone to free space... (Expect up to 60 secs delay for server to continue after freeing disk space)

150620 15:53:54 [ERROR] /usr/sbin/mysqld: Retry in 60 secs. Message reprinted in 600 secs

150620 15:53:54 [ERROR] /usr/sbin/mysqld: Disk is full writing '/var/tmp/#sql_7c31_0.MYI' (Errcode: 28). Waiting for someone to free space... (Expect up to 60 secs delay for server to continue after freeing disk space)

150620 15:53:54 [ERROR] /usr/sbin/mysqld: Retry in 60 secs. Message reprinted in 600 secs

150620 15:53:56 [ERROR] /usr/sbin/mysqld: Disk is full writing '/var/tmp/#sql_7c31_0.MYI' (Errcode: 28). Waiting for someone to free space... (Expect up to 60 secs delay for server to continue after freeing disk space)

150620 15:53:56 [ERROR] /usr/sbin/mysqld: Retry in 60 secs. Message reprinted in 600 secs

150620 15:54:05 [ERROR] /usr/sbin/mysqld: Table '/var/tmp/#sql_7c31_9' is marked as crashed and should be repaired

150620 15:54:05 [ERROR] /usr/sbin/mysqld: Sort aborted

150620 15:54:59 [ERROR] /usr/sbin/mysqld: Table '/var/tmp/#sql_7c31_5' is marked as crashed and should be repaired

150620 15:54:59 [ERROR] /usr/sbin/mysqld: Sort aborted

150620 17:42:20 [ERROR] /usr/sbin/mysqld: Disk is full writing '/var/tmp/#sql_7c31_0.MYI' (Errcode: 28). Waiting for someone to free space... (Expect up to 60 secs delay for server to continue after freeing disk space)

150620 17:42:20 [ERROR] /usr/sbin/mysqld: Retry in 60 secs. Message reprinted in 600 secs

150620 17:42:20 [ERROR] /usr/sbin/mysqld: Disk is full writing '/var/tmp/#sql_7c31_6.MYI' (Errcode: 28). Waiting for someone to free space... (Expect up to 60 secs delay for server to continue after freeing disk space)

150620 17:42:20 [ERROR] /usr/sbin/mysqld: Retry in 60 secs. Message reprinted in 600 secs

150620 17:42:20 [ERROR] /usr/sbin/mysqld: Disk is full writing '/var/tmp/#sql_7c31_0.MYI' (Errcode: 28). Waiting for someone to free space... (Expect up to 60 secs delay for server to continue after freeing disk space)

150620 17:42:20 [ERROR] /usr/sbin/mysqld: Retry in 60 secs. Message reprinted in 600 secs

150620 17:42:20 [ERROR] /usr/sbin/mysqld: Disk is full writing '/var/tmp/#sql_7c31_6.MYI' (Errcode: 28). Waiting for someone to free space... (Expect up to 60 secs delay for server to continue after freeing disk space)

150620 17:42:20 [ERROR] /usr/sbin/mysqld: Retry in 60 secs. Message reprinted in 600 secs

150620 17:42:20 [ERROR] /usr/sbin/mysqld: Disk is full writing '/var/tmp/#sql_7c31_4.MYI' (Errcode: 28). Waiting for someone to free space... (Expect up to 60 secs delay for server to continue after freeing disk space)

150620 17:42:20 [ERROR] /usr/sbin/mysqld: Retry in 60 secs. Message reprinted in 600 secs

150620 17:42:20 [ERROR] /usr/sbin/mysqld: Disk is full writing '/var/tmp/#sql_7c31_6.MYI' (Errcode: 28). Waiting for someone to free space... (Expect up to 60 secs delay for server to continue after freeing disk space)

150620 17:42:20 [ERROR] /usr/sbin/mysqld: Retry in 60 secs. Message reprinted in 600 secs

150620 17:52:20 [ERROR] /usr/sbin/mysqld: Retry in 60 secs. Message reprinted in 600 secs

max_connections=75

max_user_connections=60

озу 96гб

...

В tmp создаются временные таблицы, как я могу их оптимизировать? Увеличить диск тоже нельзя.

K5

209

kgtu5

24 июня 2015, 03:57

#1

вам же четко сказано Disk is full...Waiting for someone to free space

ссылку на переводчик дать?

2

аська 45два48499два записки на работе (http://memoryhigh.ru) помогу с сайтом, удалю вирусы, настрою впс -> отзывы ТУТ (/ru/forum/836248) и ТАМ (http://www.maultalk.com/topic140187.html) !!!всегда проверяйте данные людей, которые сами пишут вам в аську или скайп!!!

UF

28

UnFeeLing

24 июня 2015, 03:59

#2

"Видите ли, на других планетах есть тоже жизнь, только вот где она, мы не знаем."

Версия и дистрибутив ОС?

Полный файл конфигурации настройки в студию.

150620 15:54:59 [ERROR] /usr/sbin/mysqld: Table '/var/tmp/#sql_7c31_5' is marked as crashed and should be repaired
150620 15:54:59 [ERROR] /usr/sbin/mysqld: Sort aborted

Дохнет таблица

150620 15:53:54 [ERROR] /usr/sbin/mysqld: Disk is full writing '/var/tmp/#sql_7c31_0.MYI' (Errcode: 28). Waiting for someone to free space... (Expect up to 60 secs delay for server to continue after freeing disk space)

тут, думаю понятно

364

pupseg

24 июня 2015, 06:19

#3

SHOW VARIABLES LIKE 'tmpdir';

?

1

Качественная помощь в обслуживании серверов. (/ru/forum/661100) Бесплатных консультаций не даю, не помогаю, не обучаю. Минималка от 100$. Как пропатчить KDE-просьба не спрашивать. Есть форумы (http://linux.org.ru) и полезные сайты (http://www.opennet.ru/).