Database problems

[eliasferreyra]

hello i was having a server crash and database i repair them but when i login
the phone take arround 30 seconds to ring and sometimes more time

what could be the problem?

[mflorell]

run mtop and see what the bottleneck is.

[eliasferreyra]

this

from

/usr/local/bin/mtop --dbuser=root --seconds=3


ID USER HOST DB TIME COMMAND STATE INFO
7532 root localhost Query show
---




and the admin page give me mysql error too many conections

but the sofphone rings very late but if i login and put the seccion id 86000.. manual the dialer works fine
help







and why does it happend

on screen -r


7518.ASTlisten (Detached)
5115.ASTupdate (Detached)
31333.ASTupdate (Detached)
6182.ASTlisten (Detached)
12752.ASTlisten (Detached)
27938.ASTupdate (Detached)
22657.ASTlisten (Detached)
22014.ASTlisten (Detached)
29777.ASTlisten (Detached)
31051.ASTlisten (Detached)
5911.ASTlisten (Detached)
5626.ASTupdate (Detached)
26191.ASTlisten (Detached)
15093.ASTlisten (Detached)
22561.ASTupdate (Detached)
27559.ASTupdate (Detached)
22215.ASTlisten (Detached)
25875.ASTupdate (Detached)
23398.ASTVDadapt (Detached)
25211.ASTVDadapt (Detached)
25892.ASTupdate (Detached)
20979.ASTlisten (Detached)
17192.ASTupdate (Detached)
363.ASTlisten (Detached)
21130.ASTlisten (Detached)
9546.ASTupdate (Detached)
25194.ASTupdate (Detached)
5641.ASTVDadapt (Detached)
25707.ASTlisten (Detached)
22119.ASTlisten (Detached)
18559.ASTlisten (Detached)
30054.ASTlisten (Detached)
24183.ASTVDadapt (Detached)
20181.ASTlisten (Detached)
16397.ASTlisten (Detached)
5168.ASTupdate (Detached)
5121.ASTlisten (Detached)
23029.ASTupdate (Detached)
6715.ASTlisten (Detached)
25890.ASTVDadapt (Detached)
10538.ASTlisten (Detached)
22269.ASTupdate (Detached)
8309.ASTlisten (Detached)
22282.ASTlisten (Detached)
22724.ASTlisten (Detached)
29735.ASTlisten (Detached)
27741.ASTupdate (Detached)
18202.ASTlisten (Detached)
30655.ASTlisten (Detached)
28655.ASTVDadapt (Detached)
20511.ASTlisten (Detached)
4543.ASTupdate (Detached)
19014.ASTupdate (Detached)
21763.ASTVDadapt (Detached)
3322.ASTlisten (Detached)
6140.ASTVDadapt (Detached)
20630.ASTlisten (Detached)
19855.ASTlisten (Detached)
9394.ASTlisten (Detached)
23383.ASTupdate (Detached)
16837.ASTVDadapt (Detached)
27388.ASTupdate (Detached)
19274.ASTlisten (Detached)
11473.ASTupdate (Detached)
7553.ASTupdate (Detached)
32373.ASTupdate (Detached)
15873.ASTlisten (Detached)
12602.ASTlisten (Detached)
32628.ASTVDadapt (Detached)
2601.ASTVDadapt (Detached)
22303.ASTupdate (Detached)
9561.ASTVDadapt (Detached)
25881.ASTlisten (Detached)
11643.ASTlisten (Detached)
27574.ASTVDadapt (Detached)
24168.ASTupdate (Detached)
12292.ASTlisten (Detached)
23502.ASTlisten (Detached)
32368.ASTlisten (Detached)
3081.ASTupdate (Detached)
2586.ASTupdate (Detached)
18077.ASTlisten (Detached)
22902.ASTlisten (Detached)
16831.ASTlisten (Detached)
28646.ASTlisten (Detached)
29487.ASTVDadapt (Detached)
30148.ASTlisten (Detached)
22419.ASTVDadapt (Detached)
28908.ASTlisten (Detached)
11055.ASTlisten (Detached)
28977.ASTupdate (Detached)
5793.ASTupdate (Detached)
8568.ASTlisten (Detached)
28335.ASTlisten (Detached)
2020.ASTlisten (Detached)
31930.ASTlisten (Detached)
6311.ASTupdate (Detached)
28371.ASTupdate (Detached)
29478.ASTlisten (Detached)
22113.ASTupdate (Detached)
11848.ASTlisten (Detached)
24010.ASTlisten (Detached)
17732.ASTlisten (Detached)
10010.ASTlisten (Detached)
22597.ASTlisten (Detached)
30638.ASTlisten (Detached)
26384.ASTlisten (Detached)
23246.ASTlisten (Detached)
11060.ASTlisten (Detached)
32403.ASTVDadapt (Detached)
29224.ASTlisten (Detached)
19283.ASTVDadapt (Detached)
1149.ASTVDadapt (Detached)
24619.ASTlisten (Detached)
11063.ASTupdate (Detached)
8837.ASTVDadapt (Detached)
3953.asterisk (Detached)
1511.ASTupdate (Detached)
27122.ASTlisten (Detached)
16821.ASTupdate (Detached)
31536.ASTlisten (Detached)
10734.ASTVDadapt (Detached)
23511.ASTVDadapt (Detached)
31228.ASTlisten (Detached)
19268.ASTupdate (Detached)
9957.ASTlisten (Detached)
3722.ASTlisten (Detached)
21681.ASTlisten (Detached)
19372.ASTVDadapt (Detached)
31810.ASTVDadapt (Detached)
10719.ASTupdate (Detached)
16843.ASTVDadapt (Detached)
11488.ASTVDadapt (Detached)
28811.ASTlisten (Detached)
22209.ASTupdate (Detached)
30933.ASTlisten (Detached)
23035.ASTlisten (Detached)
13308.ASTlisten (Detached)
8193.ASTlisten (Detached)
20229.ASTupdate (Detached)
3088.ASTlisten (Detached)
30366.ASTlisten (Detached)
14569.ASTlisten (Detached)
3023.ASTlisten (Detached)
21754.ASTlisten (Detached)
7216.ASTVDadapt (Detached)
16283.ASTlisten (Detached)
18721.ASTlisten (Detached)
23791.ASTlisten (Detached)
3017.ASTupdate (Detached)
32380.ASTupdate (Detached)
28324.ASTlisten (Detached)
26995.ASTlisten (Detached)
26113.ASTlisten (Detached)
32609.ASTupdate (Detached)
5632.ASTlisten (Detached)
23624.ASTlisten (Detached)
28113.ASTlisten (Detached)
13036.ASTlisten (Detached)
15384.ASTlisten (Detached)
7870.ASTlisten (Detached)
25202.ASTlisten (Detached)
6127.ASTlisten (Detached)
29227.ASTlisten (Detached)
2592.ASTlisten (Detached)
11479.ASTlisten (Detached)
4029.ASTlisten (Detached)
22754.ASTupdate (Detached)
3838.ASTfastlog (Detached)
27565.ASTlisten (Detached)
23099.ASTlisten (Detached)
21884.ASTlisten (Detached)
25284.ASTlisten (Detached)
26548.ASTlisten (Detached)
16828.ASTlisten (Detached)
3658.ASTlisten (Detached)
4926.ASTlisten (Detached)
31799.ASTlisten (Detached)
2385.ASTlisten (Detached)
27403.ASTVDadapt (Detached)
22410.ASTlisten (Detached)
19357.ASTupdate (Detached)
26841.ASTlisten (Detached)
24174.ASTlisten (Detached)
10725.ASTlisten (Detached)
25453.ASTlisten (Detached)
19962.ASTlisten (Detached)
8827.ASTlisten (Detached)
15636.ASTlisten (Detached)
12746.ASTupdate (Detached)
32391.ASTlisten (Detached)
7175.ASTlisten (Detached)
27394.ASTlisten (Detached)
13926.ASTlisten (Detached)
3033.ASTVDadapt (Detached)
16822.ASTupdate (Detached)
8245.ASTupdate (Detached)
21878.ASTupdate (Detached)
7199.ASTupdate (Detached)
5598.ASTlisten (Detached)
5183.ASTVDadapt (Detached)
22224.ASTVDadapt (Detached)
6121.ASTupdate (Detached)
4654.ASTlisten (Detached)
17518.ASTlisten (Detached)
4380.ASTupdate (Detached)
21893.ASTVDadapt (Detached)
23966.ASTlisten (Detached)
10575..localhost (Dead ???)
5174.ASTlisten (Detached)
27117.ASTupdate (Detached)
10334.ASTlisten (Detached)
4149.ASTlisten (Detached)
24822.ASTlisten (Detached)
847.ASTlisten (Detached)
31498.ASTlisten (Detached)
25030.ASTlisten (Detached)
4273.ASTlisten (Detached)
22404.ASTupdate (Detached)
8898.ASTlisten (Detached)
27896.ASTlisten (Detached)

[mflorell]

Wow, something is certainly wrong.

have you tried raising the my.cnf max_connections to 300 or higher?

what is the loadavg of the server when this happens?

Do you regularly reboot the server?

[eliasferreyra]

yeah i reboot , but after 20 minutes the problem continues

and i uprise the my.cnf max_connections to 500 and 900

but the proble is the same

after 45 minutes with only 2 agents i receive the message too many conections on the web

and if i execute the script ADMIN_keepalive.pl
i receive shild 17 error

[mflorell]

Have you checked all of your database tables for corruption?

[eliasferreyra]

yeah , but if you have any sugection please giveme any
y use mysqlcheck -r asterisk
and myisamchk

but nothin