풀 쿼리 스캔의 악영향

mytop으로 본 풀 쿼리 스캔의 악영향이다.

mysql은 테이블 lock을 기본적으로 하기 때문에, 다리 쿼리들을 블럭시킨다. 만약 풀쿼리가 분마다 들어오고, 기타 쿼리들이 쌓인다면.. 문제는 자명하다..

 

만약 mysql은 다른 서비스와 동작시키지 말아야 하며, 중형서버로 증설하지 않도록 해야 한다.

 

Id      User         Host/IP         DB      Time    Cmd Query or State                                                          --      ----         -------         --      ----    --- ----------                                                          562670    dejava 211.218.152.101  dejavalog       199  Query SELECT projectname, count(projectname) count FROM lgt_logdata WHER   562689    dejava 211.218.152.192  dejavalog       118  Query DELETE FROM lgt_logdata WHERE logid = -1                            562664    dejava   220.73.147.74  dejavalog       110  Query INSERT INTO lgt_logdata (PROJECTNAME, SERVERNAME, USERID, LOGDT, L   562678    dejava 211.218.152.109  dejavalog       107  Query INSERT INTO lgt_logdata (PROJECTNAME, SERVERNAME, USERID, LOGDT, L   562690    dejava   220.73.147.73  dejavalog       104  Query INSERT INTO lgt_logdata (PROJECTNAME, SERVERNAME, USERID, LOGDT, L   562691    dejava   218.145.30.64  dejavalog       102  Query INSERT INTO lgt_logdata (PROJECTNAME, SERVERNAME, USERID, LOGDT, L   562692    dejava   121.156.75.37  dejavalog        94  Query INSERT INTO lgt_logdata (PROJECTNAME, SERVERNAME, USERID, LOGDT, L   562694    dejava 211.218.152.187  dejavalog        75  Query INSERT INTO lgt_logdata (PROJECTNAME, SERVERNAME, USERID, LOGDT, L   562695    dejava   220.73.147.30  dejavalog        61  Query INSERT INTO lgt_logdata (PROJECTNAME, SERVERNAME, USERID, LOGDT, L   562696    dejava  121.156.75.109  dejavalog        53  Query INSERT INTO lgt_logdata (PROJECTNAME, SERVERNAME, USERID, LOGDT, L   562698    dejava 211.218.152.186  dejavalog        34  Query INSERT INTO lgt_logdata (PROJECTNAME, SERVERNAME, USERID, LOGDT, L   562705    dejava   220.73.147.74  dejavalog        13  Query INSERT INTO lgt_logdata (PROJECTNAME, SERVERNAME, USERID, LOGDT, L   562346      root       localhost  dejavalog         0  Query show full processlist