[show full processlist:]

После рассылки сообщений MySQL начинает жрать проц на полную, отваливаются сессии PPPoE. Раньше такого не наблюдалось.
show full processlist:

Код:

Id	User	Host	db	Command	Time	State	Info
2	root	localhost	bill	Query	5	Locked	INSERT into dblogin (mid,act,time) VALUES ( NAME_CONST('usr_id',2335),47,unix_timestamp())
3	root	localhost	bill	Query	3	Locked	INSERT into dblogin (mid,act,time) VALUES\n    ((SELECT id FROM users WHERE name= NAME_CONST('login',_cp1251'andrey' COLLATE 'cp1251_general_ci') LIMIT 1),47,unix_timestamp())
4	root	localhost	bill	Query	5	Copying to tmp table	SELECT SQL_CALC_FOUND_ROWS field_value INTO usrAdvID FROM dopdata WHERE\n        revision IN (SELECT rev FROM rev_users WHERE template_num=1 AND\n                     id IN (SELECT id FROM users WHERE id= NAME_CONST('_mid',668) OR mid= NAME_CONST('_mid',668))) AND\n        field_alias= NAME_CONST('alias_name',_cp1251'_mac' COLLATE 'cp1251_general_ci') AND field_value= NAME_CONST('stationId',_cp1251'00:e0:4d:56:87:14' COLLATE 'cp1251_general_ci')
5	root	localhost	bill	Query	5	statistics	SELECT id,ip INTO usr_id,usr_ip FROM users WHERE name= NAME_CONST('login',_cp1251'pst' COLLATE 'cp1251_general_ci')
6	root	localhost	bill	Query	5	update	INSERT into dblogin (mid,act,time) VALUES ( NAME_CONST('usr_id',1351),47,unix_timestamp())
19	bill_kernel	localhost	bill	Sleep	8		NULL
23	bill_kernel	localhost	bill	Query	6	statistics	SELECT field_alias,field_value FROM dopdata WHERE parent_type=0 AND template_num=1 AND parent_id=1464 AND revision=(SELECT MAX(revision) FROM dopdata WHERE parent_type=0 AND template_num=1 AND parent_id=1464)
24	bill_kernel	localhost	bill	Query	6	Sending data	SELECT field_alias,field_value FROM dopdata WHERE parent_type=0 AND template_num=1 AND parent_id=1489 AND revision=(SELECT MAX(revision) FROM dopdata WHERE parent_type=0 AND template_num=1 AND parent_id=1489)
25	bill_kernel	localhost	bill	Sleep	4		NULL
29	bill_kernel	localhost	bill	Query	5	Locked	UPDATE users SET auth='on' WHERE id=547 LIMIT 1
56285	bill_kernel	localhost	bill	Sleep	155		NULL
56360	bill_kernel	localhost	bill	Sleep	156		NULL
56362	bill_kernel	localhost	bill	Sleep	148		NULL
58766	bill_www	localhost	bill	Query	19	Sending data	SELECT pays.id AS pid, time, coment, category  FROM `pays`, `m_confirm` WHERE (pays.mid = '1629' && category = 490 || `category` =496) && (SELECT COUNT(m_confirm.id) FROM `m_confirm` WHERE m_confirm.Mid='1629' && mess=pays.id )=0 GROUP BY pays.id LIMIT 1
58767	bill_www	localhost	bill	Query	19	Sending data	SELECT pays.id AS pid, time, coment, category  FROM `pays`, `m_confirm` WHERE (pays.mid = '2123' && category = 490 || `category` =496) && (SELECT COUNT(m_confirm.id) FROM `m_confirm` WHERE m_confirm.Mid='2123' && mess=pays.id )=0 GROUP BY pays.id LIMIT 1
58769	bill_www	localhost	bill	Query	19	Sending data	SELECT pays.id AS pid, time, coment, category  FROM `pays`, `m_confirm` WHERE (pays.mid = '2123' && category = 490 || `category` =496) && (SELECT COUNT(m_confirm.id) FROM `m_confirm` WHERE m_confirm.Mid='2123' && mess=pays.id )=0 GROUP BY pays.id LIMIT 1
58770	bill_www	localhost	bill	Query	19	Sending data	SELECT pays.id AS pid, time, coment, category  FROM `pays`, `m_confirm` WHERE (pays.mid = '2123' && category = 490 || `category` =496) && (SELECT COUNT(m_confirm.id) FROM `m_confirm` WHERE m_confirm.Mid='2123' && mess=pays.id )=0 GROUP BY pays.id LIMIT 1
58771	bill_www	localhost	bill	Query	19	Sending data	SELECT pays.id AS pid, time, coment, category  FROM `pays`, `m_confirm` WHERE (pays.mid = '2123' && category = 490 || `category` =496) && (SELECT COUNT(m_confirm.id) FROM `m_confirm` WHERE m_confirm.Mid='2123' && mess=pays.id )=0 GROUP BY pays.id LIMIT 1
58772	bill_www	localhost	bill	Query	19	Sending data	SELECT pays.id AS pid, time, coment, category  FROM `pays`, `m_confirm` WHERE (pays.mid = '2123' && category = 490 || `category` =496) && (SELECT COUNT(m_confirm.id) FROM `m_confirm` WHERE m_confirm.Mid='2123' && mess=pays.id )=0 GROUP BY pays.id LIMIT 1
58773	bill_www	localhost	bill	Query	19	Sending data	SELECT pays.id AS pid, time, coment, category  FROM `pays`, `m_confirm` WHERE (pays.mid = '1629' && category = 490 || `category` =496) && (SELECT COUNT(m_confirm.id) FROM `m_confirm` WHERE m_confirm.Mid='1629' && mess=pays.id )=0 GROUP BY pays.id LIMIT 1
58774	bill_www	localhost	bill	Query	17	Sending data	SELECT pays.id AS pid, time, coment, category  FROM `pays`, `m_confirm` WHERE (pays.mid = '1629' && category = 490 || `category` =496) && (SELECT COUNT(m_confirm.id) FROM `m_confirm` WHERE m_confirm.Mid='1629' && mess=pays.id )=0 GROUP BY pays.id LIMIT 1
58775	bill_www	localhost	bill	Query	17	Sending data	SELECT pays.id AS pid, time, coment, category  FROM `pays`, `m_confirm` WHERE (pays.mid = '2123' && category = 490 || `category` =496) && (SELECT COUNT(m_confirm.id) FROM `m_confirm` WHERE m_confirm.Mid='2123' && mess=pays.id )=0 GROUP BY pays.id LIMIT 1
58776	bill_www	localhost	bill	Query	17	Sending data	SELECT pays.id AS pid, time, coment, category  FROM `pays`, `m_confirm` WHERE (pays.mid = '2123' && category = 490 || `category` =496) && (SELECT COUNT(m_confirm.id) FROM `m_confirm` WHERE m_confirm.Mid='2123' && mess=pays.id )=0 GROUP BY pays.id LIMIT 1
58777	bill_www	localhost	bill	Query	17	Sending data	SELECT pays.id AS pid, time, coment, category  FROM `pays`, `m_confirm` WHERE (pays.mid = '2281' && category = 490 || `category` =496) && (SELECT COUNT(m_confirm.id) FROM `m_confirm` WHERE m_confirm.Mid='2281' && mess=pays.id )=0 GROUP BY pays.id LIMIT 1
58778	bill_www	localhost	bill	Query	17	Sending data	SELECT pays.id AS pid, time, coment, category  FROM `pays`, `m_confirm` WHERE (pays.mid = '2281' && category = 490 || `category` =496) && (SELECT COUNT(m_confirm.id) FROM `m_confirm` WHERE m_confirm.Mid='2281' && mess=pays.id )=0 GROUP BY pays.id LIMIT 1
58779	bill_www	localhost	bill	Query	17	Sending data	SELECT pays.id AS pid, time, coment, category  FROM `pays`, `m_confirm` WHERE (pays.mid = '2281' && category = 490 || `category` =496) && (SELECT COUNT(m_confirm.id) FROM `m_confirm` WHERE m_confirm.Mid='2281' && mess=pays.id )=0 GROUP BY pays.id LIMIT 1
58780	bill_www	localhost	bill	Query	16	Sending data	SELECT pays.id AS pid, time, coment, category  FROM `pays`, `m_confirm` WHERE (pays.mid = '2281' && category = 490 || `category` =496) && (SELECT COUNT(m_confirm.id) FROM `m_confirm` WHERE m_confirm.Mid='2281' && mess=pays.id )=0 GROUP BY pays.id LIMIT 1
58781	bill_www	localhost	bill	Query	16	Sending data	SELECT pays.id AS pid, time, coment, category  FROM `pays`, `m_confirm` WHERE (pays.mid = '2281' && category = 490 || `category` =496) && (SELECT COUNT(m_confirm.id) FROM `m_confirm` WHERE m_confirm.Mid='2281' && mess=pays.id )=0 GROUP BY pays.id LIMIT 1
58782	bill_www	localhost	bill	Query	16	Sending data	SELECT pays.id AS pid, time, coment, category  FROM `pays`, `m_confirm` WHERE (pays.mid = '2281' && category = 490 || `category` =496) && (SELECT COUNT(m_confirm.id) FROM `m_confirm` WHERE m_confirm.Mid='2281' && mess=pays.id )=0 GROUP BY pays.id LIMIT 1
58783	bill_www	localhost	bill	Query	16	Sending data	SELECT pays.id AS pid, time, coment, category  FROM `pays`, `m_confirm` WHERE (pays.mid = '2281' && category = 490 || `category` =496) && (SELECT COUNT(m_confirm.id) FROM `m_confirm` WHERE m_confirm.Mid='2281' && mess=pays.id )=0 GROUP BY pays.id LIMIT 1
58784	bill_www	localhost	bill	Query	16	Sending data	SELECT pays.id AS pid, time, coment, category  FROM `pays`, `m_confirm` WHERE (pays.mid = '2281' && category = 490 || `category` =496) && (SELECT COUNT(m_confirm.id) FROM `m_confirm` WHERE m_confirm.Mid='2281' && mess=pays.id )=0 GROUP BY pays.id LIMIT 1
58786	bill_www	localhost	bill	Query	16	Sending data	SELECT pays.id AS pid, time, coment, category  FROM `pays`, `m_confirm` WHERE (pays.mid = '2281' && category = 490 || `category` =496) && (SELECT COUNT(m_confirm.id) FROM `m_confirm` WHERE m_confirm.Mid='2281' && mess=pays.id )=0 GROUP BY pays.id LIMIT 1
58788	bill_www	localhost	bill	Query	15	Sending data	SELECT pays.id AS pid, time, coment, category  FROM `pays`, `m_confirm` WHERE (pays.mid = '2281' && category = 490 || `category` =496) && (SELECT COUNT(m_confirm.id) FROM `m_confirm` WHERE m_confirm.Mid='2281' && mess=pays.id )=0 GROUP BY pays.id LIMIT 1
58789	bill_www	localhost	bill	Query	15	Sending data	SELECT pays.id AS pid, time, coment, category  FROM `pays`, `m_confirm` WHERE (pays.mid = '2281' && category = 490 || `category` =496) && (SELECT COUNT(m_confirm.id) FROM `m_confirm` WHERE m_confirm.Mid='2281' && mess=pays.id )=0 GROUP BY pays.id LIMIT 1
58790	bill_www	localhost	bill	Query	15	Sending data	SELECT pays.id AS pid, time, coment, category  FROM `pays`, `m_confirm` WHERE (pays.mid = '2281' && category = 490 || `category` =496) && (SELECT COUNT(m_confirm.id) FROM `m_confirm` WHERE m_confirm.Mid='2281' && mess=pays.id )=0 GROUP BY pays.id LIMIT 1
58791	bill_www	localhost	bill	Query	15	Sending data	SELECT pays.id AS pid, time, coment, category  FROM `pays`, `m_confirm` WHERE (pays.mid = '2281' && category = 490 || `category` =496) && (SELECT COUNT(m_confirm.id) FROM `m_confirm` WHERE m_confirm.Mid='2281' && mess=pays.id )=0 GROUP BY pays.id LIMIT 1
58792	bill_www	localhost	bill	Query	15	Sending data	SELECT pays.id AS pid, time, coment, category  FROM `pays`, `m_confirm` WHERE (pays.mid = '2281' && category = 490 || `category` =496) && (SELECT COUNT(m_confirm.id) FROM `m_confirm` WHERE m_confirm.Mid='2281' && mess=pays.id )=0 GROUP BY pays.id LIMIT 1
58794	bill_www	localhost	bill	Query	15	Sending data	SELECT pays.id AS pid, time, coment, category  FROM `pays`, `m_confirm` WHERE (pays.mid = '2281' && category = 490 || `category` =496) && (SELECT COUNT(m_confirm.id) FROM `m_confirm` WHERE m_confirm.Mid='2281' && mess=pays.id )=0 GROUP BY pays.id LIMIT 1
58795	bill_www	localhost	bill	Query	15	Sending data	SELECT pays.id AS pid, time, coment, category  FROM `pays`, `m_confirm` WHERE (pays.mid = '2281' && category = 490 || `category` =496) && (SELECT COUNT(m_confirm.id) FROM `m_confirm` WHERE m_confirm.Mid='2281' && mess=pays.id )=0 GROUP BY pays.id LIMIT 1
58796	bill_www	localhost	bill	Query	15	Sending data	SELECT pays.id AS pid, time, coment, category  FROM `pays`, `m_confirm` WHERE (pays.mid = '2123' && category = 490 || `category` =496) && (SELECT COUNT(m_confirm.id) FROM `m_confirm` WHERE m_confirm.Mid='2123' && mess=pays.id )=0 GROUP BY pays.id LIMIT 1
58797	bill_www	localhost	bill	Query	15	Sending data	SELECT pays.id AS pid, time, coment, category  FROM `pays`, `m_confirm` WHERE (pays.mid = '2123' && category = 490 || `category` =496) && (SELECT COUNT(m_confirm.id) FROM `m_confirm` WHERE m_confirm.Mid='2123' && mess=pays.id )=0 GROUP BY pays.id LIMIT 1
58798	bill_www	localhost	bill	Query	14	Sending data	SELECT pays.id AS pid, time, coment, category  FROM `pays`, `m_confirm` WHERE (pays.mid = '2123' && category = 490 || `category` =496) && (SELECT COUNT(m_confirm.id) FROM `m_confirm` WHERE m_confirm.Mid='2123' && mess=pays.id )=0 GROUP BY pays.id LIMIT 1
58799	bill_www	localhost	bill	Query	14	Sending data	SELECT pays.id AS pid, time, coment, category  FROM `pays`, `m_confirm` WHERE (pays.mid = '2123' && category = 490 || `category` =496) && (SELECT COUNT(m_confirm.id) FROM `m_confirm` WHERE m_confirm.Mid='2123' && mess=pays.id )=0 GROUP BY pays.id LIMIT 1
58800	bill_www	localhost	bill	Query	14	Sending data	SELECT pays.id AS pid, time, coment, category  FROM `pays`, `m_confirm` WHERE (pays.mid = '1648' && category = 490 || `category` =496) && (SELECT COUNT(m_confirm.id) FROM `m_confirm` WHERE m_confirm.Mid='1648' && mess=pays.id )=0 GROUP BY pays.id LIMIT 1
58801	bill_www	localhost	bill	Query	14	Sending data	SELECT pays.id AS pid, time, coment, category  FROM `pays`, `m_confirm` WHERE (pays.mid = '1648' && category = 490 || `category` =496) && (SELECT COUNT(m_confirm.id) FROM `m_confirm` WHERE m_confirm.Mid='1648' && mess=pays.id )=0 GROUP BY pays.id LIMIT 1
58802	bill_www	localhost	bill	Query	14	Sending data	SELECT pays.id AS pid, time, coment, category  FROM `pays`, `m_confirm` WHERE (pays.mid = '1648' && category = 490 || `category` =496) && (SELECT COUNT(m_confirm.id) FROM `m_confirm` WHERE m_confirm.Mid='1648' && mess=pays.id )=0 GROUP BY pays.id LIMIT 1
58803	bill_www	localhost	bill	Query	14	Sending data	SELECT pays.id AS pid, time, coment, category  FROM `pays`, `m_confirm` WHERE (pays.mid = '1648' && category = 490 || `category` =496) && (SELECT COUNT(m_confirm.id) FROM `m_confirm` WHERE m_confirm.Mid='1648' && mess=pays.id )=0 GROUP BY pays.id LIMIT 1
58804	bill_www	localhost	bill	Query	14	Sending data	SELECT pays.id AS pid, time, coment, category  FROM `pays`, `m_confirm` WHERE (pays.mid = '1648' && category = 490 || `category` =496) && (SELECT COUNT(m_confirm.id) FROM `m_confirm` WHERE m_confirm.Mid='1648' && mess=pays.id )=0 GROUP BY pays.id LIMIT 1
58805	bill_www	localhost	bill	Query	14	Sending data	SELECT pays.id AS pid, time, coment, category  FROM `pays`, `m_confirm` WHERE (pays.mid = '1648' && category = 490 || `category` =496) && (SELECT COUNT(m_confirm.id) FROM `m_confirm` WHERE m_confirm.Mid='1648' && mess=pays.id )=0 GROUP BY pays.id LIMIT 1
58807	bill_www	localhost	bill	Query	14	Sending data	SELECT pays.id AS pid, time, coment, category  FROM `pays`, `m_confirm` WHERE (pays.mid = '1648' && category = 490 || `category` =496) && (SELECT COUNT(m_confirm.id) FROM `m_confirm` WHERE m_confirm.Mid='1648' && mess=pays.id )=0 GROUP BY pays.id LIMIT 1
58808	bill_www	localhost	bill	Query	14	Sending data	SELECT pays.id AS pid, time, coment, category  FROM `pays`, `m_confirm` WHERE (pays.mid = '1648' && category = 490 || `category` =496) && (SELECT COUNT(m_confirm.id) FROM `m_confirm` WHERE m_confirm.Mid='1648' && mess=pays.id )=0 GROUP BY pays.id LIMIT 1
58810	bill_www	localhost	bill	Query	14	Sending data	SELECT pays.id AS pid, time, coment, category  FROM `pays`, `m_confirm` WHERE (pays.mid = '1648' && category = 490 || `category` =496) && (SELECT COUNT(m_confirm.id) FROM `m_confirm` WHERE m_confirm.Mid='1648' && mess=pays.id )=0 GROUP BY pays.id LIMIT 1
58811	bill_www	localhost	bill	Query	14	Sending data	SELECT pays.id AS pid, time, coment, category  FROM `pays`, `m_confirm` WHERE (pays.mid = '1648' && category = 490 || `category` =496) && (SELECT COUNT(m_confirm.id) FROM `m_confirm` WHERE m_confirm.Mid='1648' && mess=pays.id )=0 GROUP BY pays.id LIMIT 1
58812	bill_www	localhost	bill	Query	14	Sending data	SELECT pays.id AS pid, time, coment, category  FROM `pays`, `m_confirm` WHERE (pays.mid = '1648' && category = 490 || `category` =496) && (SELECT COUNT(m_confirm.id) FROM `m_confirm` WHERE m_confirm.Mid='1648' && mess=pays.id )=0 GROUP BY pays.id LIMIT 1
58813	bill_www	localhost	bill	Query	14	Sending data	SELECT pays.id AS pid, time, coment, category  FROM `pays`, `m_confirm` WHERE (pays.mid = '1648' && category = 490 || `category` =496) && (SELECT COUNT(m_confirm.id) FROM `m_confirm` WHERE m_confirm.Mid='1648' && mess=pays.id )=0 GROUP BY pays.id LIMIT 1
58815	bill_www	localhost	bill	Query	14	Sending data	SELECT pays.id AS pid, time, coment, category  FROM `pays`, `m_confirm` WHERE (pays.mid = '1648' && category = 490 || `category` =496) && (SELECT COUNT(m_confirm.id) FROM `m_confirm` WHERE m_confirm.Mid='1648' && mess=pays.id )=0 GROUP BY pays.id LIMIT 1
58816	bill_www	localhost	bill	Query	14	Sending data	SELECT pays.id AS pid, time, coment, category  FROM `pays`, `m_confirm` WHERE (pays.mid = '1648' && category = 490 || `category` =496) && (SELECT COUNT(m_confirm.id) FROM `m_confirm` WHERE m_confirm.Mid='1648' && mess=pays.id )=0 GROUP BY pays.id LIMIT 1
58817	bill_www	localhost	bill	Query	14	Sending data	SELECT pays.id AS pid, time, coment, category  FROM `pays`, `m_confirm` WHERE (pays.mid = '1648' && category = 490 || `category` =496) && (SELECT COUNT(m_confirm.id) FROM `m_confirm` WHERE m_confirm.Mid='1648' && mess=pays.id )=0 GROUP BY pays.id LIMIT 1
58819	bill_www	localhost	bill	Query	14	Sending data	SELECT pays.id AS pid, time, coment, category  FROM `pays`, `m_confirm` WHERE (pays.mid = '1648' && category = 490 || `category` =496) && (SELECT COUNT(m_confirm.id) FROM `m_confirm` WHERE m_confirm.Mid='1648' && mess=pays.id )=0 GROUP BY pays.id LIMIT 1
........лимит 20000 знаков.......
59047	root	localhost	NULL	Query	0	NULL	show full processlist

Что можно предпринять?

UPD: Как один из вариантов можно почистить m_confirm в которой 11000 строк?

Да сегодня заметил опечатку. Но все равно скрипт не отрабатывает всех:

29.10.2014 09:11:09 Автоматической рассылкой отправлено 99 сообщений о потенциальной задолженности

вернул как делал ранее:

29.10.2014 09:19:35 Автоматической рассылкой отправлено 290 сообщений о потенциальной задолженности

Спасибо. Исправил.

Сделал топорно, но я не силен в Perl

Код:

if ($p1->{'next_paket'}!='') { $packet = 'next_paket' } else { $packet = 'paket' };

$money_param2={
              paket => $p1->{$packet},

Скрипт не учитывает тот случай когда у абонента заказана смена пакета в сл. месяце. Помогите реализовать или может кто-то сделал уже?

Что-то я у себя в базе этой процедуры не наблюдаю... 50.32.6

Попробуй на локале спросить, хотя там наверно каждый свое болото будет хвалить...

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

[у]

Убил нодену вернул старый фаер, нашел две ошибки 1 nodeny, 2 регестрация на данном форуме, обе исправляю!!

А я нашел еще две, обе исправляю - убил msn

1. Знать державну мову должны все граждане Украины!
2. Разговаривать каждый вправе на любом языке, лишь бы его понимали другие.

Это только мое мнение, никому его не навязываю. Прекрасно понимаю оба языка, хотя разговариваю на русском.

P.S. Но если идем на мультик в кинотеатр, то только с укр. дубляжом

а как переделать, чтобы показывало загрузку канала в кбит/с например. я так понимаю надо разделить на кол-во секунд в каждом конкретном срезе?

[stimels]

stimels уже выкладывал http://forum.nodeny.com.ua/index.php?topic=39.msg17026#msg17026

У меня получилось добавить нули в платежный код так:
В файле Smain.pl

Код:

 $account="$Mid$csum";

заменить на

Код:

 $account=sprintf("%05d", "$Mid$csum");

яндекс помог.

Вот черт, искал по "платежный код" и эта тема не нашлась. Спасибо! Плюсанул

Воскрешу темку.
Как добавить недостающие нули для ППК чтоб было 5 цифр? В перле очень не силен