Сообщений: 807
Тем: 30
Зарегистрирован: Oct 2012
Репутация:
5,827
Landver Написал:Просто дело в том что сервер довольно долго стоит а проблемы начались недавно. Это не из за сборки просто. А из-за чего? Дело в коде. Сборка к бд подключается.
Сообщений: 31
Тем: 2
Зарегистрирован: Apr 2013
Репутация:
210
Смотрите, что провисает через SHOW FULL PROCESSLIST;
А оттуда уже отталкивайтесь, что забивает коннекты и как это исправить.
Сообщений: 220
Тем: 54
Зарегистрирован: Oct 2012
Код: mysql> show full processlist;
+-------+------+-----------------+--------------------+---------+-------+---------------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| Id | User | Host | db | Command | Time | State | Info |
+-------+------+-----------------+--------------------+---------+-------+---------------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| 12094 | root | localhost:60601 | l2j | Sleep | 16140 | | NULL |
| 12095 | root | localhost:60602 | l2j | Sleep | 16247 | | NULL |
| 12098 | root | localhost:60609 | l2j | Sleep | 16216 | | NULL |
| 12140 | root | localhost:60617 | l2j | Sleep | 41 | | NULL |
| 12146 | root | localhost:60620 | l2j | Sleep | 16142 | | NULL |
| 12148 | root | localhost:60622 | l2j | Sleep | 13471 | | NULL |
| 12154 | root | localhost:60627 | l2j | Sleep | 13454 | | NULL |
| 12156 | root | localhost:60628 | l2j | Sleep | 13458 | | NULL |
| 12158 | root | localhost:60629 | l2j | Sleep | 13487 | | NULL |
| 12196 | root | localhost:60633 | l2j | Sleep | 6246 | | NULL |
| 12198 | root | localhost:60635 | l2j | Sleep | 9905 | | NULL |
| 12227 | root | localhost:60639 | l2j | Sleep | 4322 | | NULL |
| 12238 | root | localhost:60642 | l2j | Sleep | 4301 | | NULL |
| 12282 | root | localhost:60645 | l2j | Sleep | 6092 | | NULL |
| 12315 | root | localhost:60647 | l2j | Sleep | 6100 | | NULL |
| 12347 | root | localhost:60650 | l2j | Sleep | 4303 | | NULL |
| 12350 | root | localhost:60651 | l2j | Sleep | 4312 | | NULL |
| 12352 | root | localhost:60652 | l2j | Sleep | 4305 | | NULL |
| 12357 | root | localhost:60654 | l2j | Sleep | 4304 | | NULL |
| 12358 | root | localhost:60655 | l2j | Sleep | 4313 | | NULL |
| 12385 | root | localhost:60657 | l2j | Sleep | 4307 | | NULL |
| 12402 | root | localhost:60659 | l2j | Sleep | 3862 | | NULL |
| 12403 | root | localhost:60660 | l2j | Sleep | 3867 | | NULL |
| 12405 | root | localhost:60662 | l2j | Sleep | 3854 | | NULL |
| 12406 | root | localhost:60663 | l2j | Sleep | 3864 | | NULL |
| 12407 | root | localhost:60664 | l2j | Sleep | 3840 | | NULL |
| 12411 | root | localhost:60665 | l2j | Sleep | 3872 | | NULL |
| 12412 | root | localhost:60666 | l2j | Sleep | 3858 | | NULL |
| 12430 | root | localhost:60667 | l2j | Sleep | 3844 | | NULL |
| 12431 | root | localhost:60668 | l2j | Sleep | 3823 | | NULL |
| 12457 | root | localhost:60690 | l2j | Sleep | 1334 | | NULL |
| 12467 | root | localhost:60697 | l2j | Sleep | 1337 | | NULL |
| 12475 | root | localhost:60702 | l2j | Sleep | 1284 | | NULL |
| 12476 | root | localhost:60701 | l2j | Sleep | 1386 | | NULL |
| 12477 | root | localhost:60703 | l2j | Sleep | 1366 | | NULL |
| 12501 | root | localhost:60704 | l2j | Sleep | 1374 | | NULL |
| 12517 | root | localhost:60706 | l2j | Sleep | 1359 | | NULL |
| 12523 | root | localhost:60707 | l2j | Sleep | 1345 | | NULL |
| 12524 | root | localhost:60708 | l2j | Sleep | 1364 | | NULL |
| 12525 | root | localhost:60709 | l2j | Sleep | 1355 | | NULL |
| 12558 | root | localhost:60734 | l2j | Query | 0 | Updating | UPDATE items SET owner_id = 269309250, item_id = 57, count = 15062312507, enchant_level = 0, loc = 'INVENTORY', loc_data = 0, custom_type1 = 0, custom_type2 = 0, life_time = 0, custom_flags = 0, augmentation_id = 0, attribute_fire = 0, attribute_water = 0, attribute_wind = 0, attribute_earth = 0, attribute_holy = 0, attribute_unholy = 0, agathion_energy=0 WHERE object_id = 269309267 |
| 12560 | root | localhost:60736 | l2j | Query | 0 | freeing items | UPDATE items SET owner_id = 269342754, item_id = 5592, count = 18971, enchant_level = 0, loc = 'INVENTORY', loc_data = 23, custom_type1 = 0, custom_type2 = 0, life_time = 0, custom_flags = 0, augmentation_id = 0, attribute_fire = 0, attribute_water = 0, attribute_wind = 0, attribute_earth = 0, attribute_holy = 0, attribute_unholy = 0, agathion_energy=0 WHERE object_id = 269137180 |
| 12561 | root | localhost:60737 | l2j | Sleep | 4 | | NULL |
| 12562 | root | localhost:60738 | l2j | Sleep | 871 | | NULL |
| 12563 | root | localhost:60739 | l2j | Sleep | 4 | | NULL |
| 12569 | root | localhost:60740 | l2j | Query | 0 | Updating | UPDATE items SET owner_id = 268762390, item_id = 9627, count = 339, enchant_level = 0, loc = 'INVENTORY', loc_data = 24, custom_type1 = 0, custom_type2 = 0, life_time = 0, custom_flags = 0, augmentation_id = 0, attribute_fire = 0, attribute_water = 0, attribute_wind = 0, attribute_earth = 0, attribute_holy = 0, attribute_unholy = 0, agathion_energy=0 WHERE object_id = 269019061 |
| 12575 | root | localhost:60741 | l2j | Query | 0 | Updating | UPDATE items SET owner_id = 268938305, item_id = 14953, count = 1, enchant_level = 10, loc = 'INVENTORY', loc_data = 39, custom_type1 = 0, custom_type2 = 0, life_time = 0, custom_flags = 0, augmentation_id = 0, attribute_fire = 0, attribute_water = 0, attribute_wind = 0, attribute_earth = 0, attribute_holy = 0, attribute_unholy = 0, agathion_energy=0 WHERE object_id = 268622598 |
| 12576 | root | localhost:60742 | l2j | Sleep | 4 | | NULL |
| 12609 | root | localhost:60744 | l2j | Sleep | 4 | | NULL |
| 12610 | root | localhost:60745 | NULL | Sleep | 86 | | NULL |
| 12611 | root | localhost:60746 | information_schema | Sleep | 86 | | NULL |
| 12612 | root | localhost:60747 | l2j | Sleep | 83 | | NULL |
| 12617 | root | localhost:60750 | l2j | Query | 0 | NULL | show full processlist |
+-------+------+-----------------+--------------------+---------+-------+---------------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
53 rows in set
mysql>
Сообщений: 31
Тем: 2
Зарегистрирован: Apr 2013
Репутация:
210
Процессы с этими ID 12558 12560 12569 12575 завершились? Или провисают?
|
