m.amiri
July 24th, 2012, 20:37
سلام
دوستان از زمانی که mysql رو آپدیت کردم این مشکل به وجود اوده
هر چند ساعت mysql قطع میشه و باید رست بدم تا بیاد بالا و مجددا باز down میشه!
log رو فعال کردم که این چیز هارو واسم گزارش میکنه!
# Time: 120724 6:47:27
# User@Host: root[root] @ localhost []
# Query_time: 2.399547 Lock_time: 0.000082 Rows_sent: 305 Rows_examined: 305
SET timestamp=1343126847;
SHOW DATABASES;
# Time: 120724 6:52:47
# User@Host: farshopc[farshopc] @ localhost []
# Query_time: 2.065175 Lock_time: 0.000054 Rows_sent: 0 Rows_examined: 1
use farshopc_far3shop;
SET timestamp=1343127167;
update toc_sessions set expiry = '1343128605', value = 'fpJBfjjmodgHARxPocVTKCp$
# Time: 120724 7:15:28
# User@Host: eximstats[eximstats] @ localhost []
# Query_time: 6.630819 Lock_time: 3.883619 Rows_sent: 0 Rows_examined: 0
use eximstats;
SET timestamp=1343128528;
INSERT INTO sends (mailtime,msgid,processed,domain,email,user,size,h ost,ip,aut$
# Time: 120724 7:15:39
# User@Host: eximstats[eximstats] @ localhost []
# Query_time: 1.592632 Lock_time: 0.000074 Rows_sent: 0 Rows_examined: 0
SET timestamp=1343128539;
INSERT INTO sends (mailtime,msgid,processed,domain,email,user,size,h ost,ip,aut$
# Time: 120724 7:16:01
# User@Host: eximstats[eximstats] @ localhost []
# Query_time: 12.692025 Lock_time: 0.000000 Rows_sent: 0 Rows_examined: 0
SET timestamp=1343128561;
INSERT DELAYED INTO smtp (mailtime,msgid,email,processed,transport_method,t rans$
# Time: 120724 7:16:03
# User@Host: eximstats[eximstats] @ localhost []
# Query_time: 1.205440 Lock_time: 0.000000 Rows_sent: 0 Rows_examined: 0
SET timestamp=1343128563;
INSERT DELAYED INTO smtp (mailtime,msgid,email,processed,transport_method,t rans$
# Time: 120724 7:16:21
# User@Host: eximstats[eximstats] @ localhost []
# Query_time: 5.207947 Lock_time: 2.408780 Rows_sent: 1 Rows_examined: 1
SET timestamp=1343128581;
select domain from sends where msgid='1StcUT-0002Sb-Tm';
# Time: 120724 7:17:25
# User@Host: eximstats[eximstats] @ localhost []
# Query_time: 1.410031 Lock_time: 0.000107 Rows_sent: 0 Rows_examined: 0
SET timestamp=1343128645;
INSERT INTO sends (mailtime,msgid,processed,domain,email,user,size,h ost,ip,aut$
# Time: 120724 7:19:22
# User@Host: shekafne_forum[shekafne_forum] @ localhost []
# Query_time: 1.109743 Lock_time: 0.000021 Rows_sent: 0 Rows_examined: 1
use shekafne_forum;
SET timestamp=1343128762;
UPDATE user
SET lastactivity = 1343128674
WHERE userid = 58;
# Time: 120724 7:26:38
# User@Host: eximstats[eximstats] @ localhost []
# Query_time: 5.231481 Lock_time: 3.109011 Rows_sent: 0 Rows_examined: 0
use eximstats;
SET timestamp=1343129198;
INSERT INTO sends (mailtime,msgid,processed,domain,email,user,size,h ost,ip,aut$
# Time: 120724 7:30:01
# User@Host: eximstats[eximstats] @ localhost []
# Query_time: 3.143780 Lock_time: 0.000000 Rows_sent: 0 Rows_examined: 0
SET timestamp=1343129401;
INSERT DELAYED INTO smtp (mailtime,msgid,email,processed,transport_method,t rans$
# Time: 120724 7:37:05
# User@Host: loplop_gg[loplop_gg] @ localhost []
# Query_time: 1.328877 Lock_time: 0.000023 Rows_sent: 612 Rows_examined: 612
use loplop_data88;
SET timestamp=1343129825;
SELECT * FROM nuke_stories WHERE(ihome='0');
# Time: 120724 7:37:28
# User@Host: noorolar_masoud[noorolar_masoud] @ localhost []
# Query_time: 2.203355 Lock_time: 0.000064 Rows_sent: 1 Rows_examined: 780
use noorolar_noorolarz;
SET timestamp=1343129848;
SELECT SQL_CALC_FOUND_ROWS wp_posts.* FROM wp_posts WHERE 1=1 AND wp_posts.p$
# Time: 120724 8:14:24
# User@Host: chatuir_number[chatuir_number] @ localhost []
# Query_time: 11.560396 Lock_time: 0.027366 Rows_sent: 8482 Rows_examined: 37$
use chatuir_fashion;
SET timestamp=1343132064;
SELECT `En_And_Fa` FROM `fulldictionary` WHERE `En_And_Fa` LIKE '%di%' ORDER BY$
# Time: 120724 8:35:45
# User@Host: eximstats[eximstats] @ localhost []
# Query_time: 1.280211 Lock_time: 0.000000 Rows_sent: 0 Rows_examined: 242
use eximstats;
SET timestamp=1343133345;
update smtp INNER JOIN sends ON (sends.msgid=smtp.msgid) set smtp.processed=1 w$
/usr/sbin/mysqld, Version: 5.5.24-cll (MySQL Community Server (GPL)). started w$
Tcp port: 0 Unix socket: (null)
Time Id Command Argument
قابل ذکر هم هست که از توی whm هم میخوام mysql رو ریست کنم خطای زیر رو میده اما ری استارتش با موفقیت انجام میشه...
mysqld_safe (/bin/sh /usr/bin/mysqld_safe --datadir=/var/lib/mysql --pid-file=/var/lib/mysql/server.domain.com.pid) running as root with PID 7691 (process table check method) mysqld (/usr/sbin/mysqld --basedir=/usr --datadir=/var/lib/mysql --plugin-dir=/usr/lib/mysql/plugin --user=mysql --log-error=/var/lib/mysql/server.domain.com.err --pid-file=/var/lib/mysql/server.domain.com.pid) running as mysql with PID 7865 (pidfile check method)
فشاری هم روی سرور دیده نمیشه و لود هم زیر 1 هست.
دوستان ممنون میشم نظر بدن
با تشکر
دوستان از زمانی که mysql رو آپدیت کردم این مشکل به وجود اوده
هر چند ساعت mysql قطع میشه و باید رست بدم تا بیاد بالا و مجددا باز down میشه!
log رو فعال کردم که این چیز هارو واسم گزارش میکنه!
# Time: 120724 6:47:27
# User@Host: root[root] @ localhost []
# Query_time: 2.399547 Lock_time: 0.000082 Rows_sent: 305 Rows_examined: 305
SET timestamp=1343126847;
SHOW DATABASES;
# Time: 120724 6:52:47
# User@Host: farshopc[farshopc] @ localhost []
# Query_time: 2.065175 Lock_time: 0.000054 Rows_sent: 0 Rows_examined: 1
use farshopc_far3shop;
SET timestamp=1343127167;
update toc_sessions set expiry = '1343128605', value = 'fpJBfjjmodgHARxPocVTKCp$
# Time: 120724 7:15:28
# User@Host: eximstats[eximstats] @ localhost []
# Query_time: 6.630819 Lock_time: 3.883619 Rows_sent: 0 Rows_examined: 0
use eximstats;
SET timestamp=1343128528;
INSERT INTO sends (mailtime,msgid,processed,domain,email,user,size,h ost,ip,aut$
# Time: 120724 7:15:39
# User@Host: eximstats[eximstats] @ localhost []
# Query_time: 1.592632 Lock_time: 0.000074 Rows_sent: 0 Rows_examined: 0
SET timestamp=1343128539;
INSERT INTO sends (mailtime,msgid,processed,domain,email,user,size,h ost,ip,aut$
# Time: 120724 7:16:01
# User@Host: eximstats[eximstats] @ localhost []
# Query_time: 12.692025 Lock_time: 0.000000 Rows_sent: 0 Rows_examined: 0
SET timestamp=1343128561;
INSERT DELAYED INTO smtp (mailtime,msgid,email,processed,transport_method,t rans$
# Time: 120724 7:16:03
# User@Host: eximstats[eximstats] @ localhost []
# Query_time: 1.205440 Lock_time: 0.000000 Rows_sent: 0 Rows_examined: 0
SET timestamp=1343128563;
INSERT DELAYED INTO smtp (mailtime,msgid,email,processed,transport_method,t rans$
# Time: 120724 7:16:21
# User@Host: eximstats[eximstats] @ localhost []
# Query_time: 5.207947 Lock_time: 2.408780 Rows_sent: 1 Rows_examined: 1
SET timestamp=1343128581;
select domain from sends where msgid='1StcUT-0002Sb-Tm';
# Time: 120724 7:17:25
# User@Host: eximstats[eximstats] @ localhost []
# Query_time: 1.410031 Lock_time: 0.000107 Rows_sent: 0 Rows_examined: 0
SET timestamp=1343128645;
INSERT INTO sends (mailtime,msgid,processed,domain,email,user,size,h ost,ip,aut$
# Time: 120724 7:19:22
# User@Host: shekafne_forum[shekafne_forum] @ localhost []
# Query_time: 1.109743 Lock_time: 0.000021 Rows_sent: 0 Rows_examined: 1
use shekafne_forum;
SET timestamp=1343128762;
UPDATE user
SET lastactivity = 1343128674
WHERE userid = 58;
# Time: 120724 7:26:38
# User@Host: eximstats[eximstats] @ localhost []
# Query_time: 5.231481 Lock_time: 3.109011 Rows_sent: 0 Rows_examined: 0
use eximstats;
SET timestamp=1343129198;
INSERT INTO sends (mailtime,msgid,processed,domain,email,user,size,h ost,ip,aut$
# Time: 120724 7:30:01
# User@Host: eximstats[eximstats] @ localhost []
# Query_time: 3.143780 Lock_time: 0.000000 Rows_sent: 0 Rows_examined: 0
SET timestamp=1343129401;
INSERT DELAYED INTO smtp (mailtime,msgid,email,processed,transport_method,t rans$
# Time: 120724 7:37:05
# User@Host: loplop_gg[loplop_gg] @ localhost []
# Query_time: 1.328877 Lock_time: 0.000023 Rows_sent: 612 Rows_examined: 612
use loplop_data88;
SET timestamp=1343129825;
SELECT * FROM nuke_stories WHERE(ihome='0');
# Time: 120724 7:37:28
# User@Host: noorolar_masoud[noorolar_masoud] @ localhost []
# Query_time: 2.203355 Lock_time: 0.000064 Rows_sent: 1 Rows_examined: 780
use noorolar_noorolarz;
SET timestamp=1343129848;
SELECT SQL_CALC_FOUND_ROWS wp_posts.* FROM wp_posts WHERE 1=1 AND wp_posts.p$
# Time: 120724 8:14:24
# User@Host: chatuir_number[chatuir_number] @ localhost []
# Query_time: 11.560396 Lock_time: 0.027366 Rows_sent: 8482 Rows_examined: 37$
use chatuir_fashion;
SET timestamp=1343132064;
SELECT `En_And_Fa` FROM `fulldictionary` WHERE `En_And_Fa` LIKE '%di%' ORDER BY$
# Time: 120724 8:35:45
# User@Host: eximstats[eximstats] @ localhost []
# Query_time: 1.280211 Lock_time: 0.000000 Rows_sent: 0 Rows_examined: 242
use eximstats;
SET timestamp=1343133345;
update smtp INNER JOIN sends ON (sends.msgid=smtp.msgid) set smtp.processed=1 w$
/usr/sbin/mysqld, Version: 5.5.24-cll (MySQL Community Server (GPL)). started w$
Tcp port: 0 Unix socket: (null)
Time Id Command Argument
قابل ذکر هم هست که از توی whm هم میخوام mysql رو ریست کنم خطای زیر رو میده اما ری استارتش با موفقیت انجام میشه...
mysqld_safe (/bin/sh /usr/bin/mysqld_safe --datadir=/var/lib/mysql --pid-file=/var/lib/mysql/server.domain.com.pid) running as root with PID 7691 (process table check method) mysqld (/usr/sbin/mysqld --basedir=/usr --datadir=/var/lib/mysql --plugin-dir=/usr/lib/mysql/plugin --user=mysql --log-error=/var/lib/mysql/server.domain.com.err --pid-file=/var/lib/mysql/server.domain.com.pid) running as mysql with PID 7865 (pidfile check method)
فشاری هم روی سرور دیده نمیشه و لود هم زیر 1 هست.
دوستان ممنون میشم نظر بدن
با تشکر