переход на рекомендуемую java ничего не дал
в результате наблюдения за работой биллинга выяснилось что такие зависания имеют временный характер - предположил что связаны с работой базы данных
биллинг начинает тормозить когда приходит большое количество UPDATE на базу данных (в моем случае `show process list` показывает около 1200 записей)
Код:
36 2388204 bill localhost:55014 bgbilling Query 1 update INSERT INTO bgs_query_log_201109 (dtime, uid, ip, cid, action, query, mid_aid, c_title, u_name, m_ti
37 2388542 bill localhost:55352 bgbilling Sleep 1 NULL
38 2388552 bill localhost:55362 bgbilling Sleep 1 NULL
39 2394197 bill localhost:39393 bgbilling Sleep 6197 NULL
40 2398636 bill localhost:36273 bgbilling Query 1 Locked UPDATE session_detail_2_201109 SET amount=amount + 110884 WHERE session_id=653517 AND sid=23 AND dt
41 2399802 bill localhost:34952 bgbilling Query 3 Locked UPDATE session_detail_2_201109 SET amount=amount + 54 WHERE session_id=656716 AND sid=16 AND dtime=
42 2400060 bill localhost:35210 bgbilling Query 1 Locked UPDATE session_detail_2_201109 SET amount=amount + 62 WHERE session_id=641124 AND sid=16 AND dtime=
43 2400075 bill localhost:35225 bgbilling Query 3 Locked UPDATE LOW_PRIORITY log_session_2_201109 SET session_stop='2011-09-29 16:13:49', session_time=TIME_T
44 2400723 bill localhost:35880 bgbilling Query 3 Locked UPDATE session_detail_2_201109 SET amount=amount + 63 WHERE session_id=654251 AND sid=16 AND dtime=
45 2400777 bill localhost:35934 bgbilling Query 1 Locked UPDATE session_detail_2_201109 SET amount=amount + 32651 WHERE session_id=655366 AND sid=23 AND dti
46 2400925 bill localhost:36086 bgbilling Query 3 Locked UPDATE session_detail_2_201109 SET amount=amount + 30842084 WHERE session_id=659788 AND sid=23 AND
47 2401014 bill localhost:36181 bgbilling Query 3 Locked UPDATE session_detail_2_201109 SET amount=amount + 9580113 WHERE session_id=660067 AND sid=24 AND d
48 2401073 bill localhost:36242 bgbilling Sleep 3 NULL
49 2401130 bill localhost:36301 bgbilling Query 1 Locked UPDATE session_detail_2_201109 SET amount=amount + 62 WHERE session_id=654347 AND sid=16 AND dtime=
50 2401299 bill localhost:36479 bgbilling Query 3 Locked UPDATE session_detail_2_201109 SET amount=amount + 59 WHERE session_id=654727 AND sid=16 AND dtime=
51 2401384 bill localhost:36568 bgbilling Query 1 Locked INSERT INTO session_detail_2_201109 (session_id, sid, cid, dtime, amount) VALUES (662127, 5, 658, '2
52 2401398 bill localhost:36586 bgbilling Query 3 Locked UPDATE session_detail_2_201109 SET amount=amount + 653 WHERE session_id=649602 AND sid=25 AND dtime
53 2401417 bill localhost:36606 bgbilling Query 3 Locked UPDATE session_detail_2_201109 SET amount=amount + 19625 WHERE session_id=652931 AND sid=25 AND dti
54 2401426 bill localhost:36615 bgbilling Query 3 Locked UPDATE session_detail_2_201109 SET amount=amount + 59 WHERE session_id=658217 AND sid=16 AND dtime=
55 2401428 bill localhost:36617 bgbilling Query 3 Locked UPDATE session_detail_2_201109 SET amount=amount + 57 WHERE session_id=659787 AND sid=16 AND dtime=
56 2401430 bill localhost:36619 bgbilling Query 1 Locked UPDATE session_detail_2_201109 SET amount=amount + 64 WHERE session_id=650215 AND sid=16 AND dtime=
57 2401434 bill localhost:36624 bgbilling Query 3 Locked UPDATE session_detail_2_201109 SET amount=amount + 33 WHERE session_id=653857 AND sid=16 AND dtime=
58 2401440 bill localhost:36631 bgbilling Query 3 Locked UPDATE session_detail_2_201109 SET amount=amount + 59 WHERE session_id=659459 AND sid=16 AND dtime=
59 2401450 bill localhost:36641 bgbilling Query 3 Locked UPDATE session_detail_2_201109 SET amount=amount + 1079700 WHERE session_id=640742 AND sid=23 AND d
60 2401453 bill localhost:36644 bgbilling Query 3 Locked UPDATE session_detail_2_201109 SET amount=amount + 62 WHERE session_id=659595 AND sid=16 AND dtime=
61 2401459 bill localhost:36650 bgbilling Query 3 Locked UPDATE session_detail_2_201109 SET amount=amount + 1037743 WHERE session_id=662039 AND sid=23 AND d
62 2401469 bill localhost:36660 bgbilling Query 1 Locked UPDATE LOW_PRIORITY log_session_2_201109 SET session_stop='2011-09-29 16:13:34', session_time=TIME_T
63 2401478 bill localhost:36668 bgbilling Query 1 Locked UPDATE session_detail_2_201109 SET amount=amount + 58193 WHERE session_id=653119 AND sid=23 AND dti
64 2401483 bill localhost:36673 bgbilling Query 1 Locked UPDATE session_detail_2_201109 SET amount=amount + 3176 WHERE session_id=659115 AND sid=25 AND dtim
65 2401486 bill localhost:36676 bgbilling Query 3 Locked UPDATE session_detail_2_201109 SET amount=amount + 1448 WHERE session_id=655549 AND sid=6 AND dtime
66 2401492 bill localhost:36682 bgbilling Query 3 Locked UPDATE session_detail_2_201109 SET amount=amount + 592819 WHERE session_id=661982 AND sid=24 AND dt
67 2401499 bill localhost:36689 bgbilling Query 1 Locked UPDATE LOW_PRIORITY log_session_2_201109 SET session_stop='2011-09-29 16:13:35', session_time=TIME_T
база данных файлами лежит на отдельном разделе диска ( интерфейс диска еще имеет запас)
data.properties писал(а):
db.maxIdle=1000
db.maxActive=10000
netflow_ipn.properties писал(а):
db.maxActive=600
db.maxIdle=200
my.cnf писал(а):
max_connections = 20000
open_files_limit = 20000
Есть какие нибудь идеи как решить проблему?
Вход
Регистрация
FAQ
Поиск
