Taking too long to update database

[mtancoff]

We´re using Dual Xeon with 1GB RAM.

Vicidial version is 2.01

Asterisk version is 1.2

Our problem is that the agent console is taking too long to update the database (i.e. when the agent logouts, the record in vicidial_live_agents take like 1 minute to get deleted)

This get´s fixed for a while if I reinstall DBD::mysql.

Any suggestions?

Thanx!!

This is the result of TOP


top - 18:05:12 up 4:23, 7 users, load average: 1.88, 1.87, 1.68
Tasks: 124 total, 4 running, 120 sleeping, 0 stopped, 0 zombie
Cpu(s): 18.8% us, 8.8% sy, 0.0% ni, 25.5% id, 46.8% wa, 0.2% hi, 0.0% si
Mem: 1034484k total, 378664k used, 655820k free, 3024k buffers
Swap: 779144k total, 144k used, 779000k free, 224996k cached

PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ COMMAND
3274 root 18 0 3328 656 452 R 18 0.1 0:01.04 soxmix
24215 root 15 0 33452 11m 5516 S 3 1.1 1:32.83 asterisk
3581 root 17 0 7424 4292 1808 S 3 0.4 0:00.09 AST_send_action
2710 mysql 15 0 129m 21m 3968 S 2 2.1 2:56.67 mysqld
48 root 15 0 0 0 0 S 2 0.0 1:29.53 kswapd0
24921 root 16 0 12476 6928 2680 S 1 0.7 0:39.70 AST_update.pl
8734 asterisk 16 0 18544 8244 5256 S 1 0.8 0:07.15 httpd
17693 asterisk 16 0 18160 7784 5232 S 1 0.8 0:04.47 httpd
8188 asterisk 16 0 18088 7760 5228 S 1 0.8 0:08.00 httpd
9514 asterisk 16 0 18276 7908 5232 S 1 0.8 0:06.93 httpd
13714 asterisk 16 0 18156 7780 5232 S 1 0.8 0:05.64 httpd
16301 asterisk 16 0 18336 7924 5228 R 1 0.8 0:04.85 httpd
31959 root 15 0 0 0 0 S 1 0.0 0:00.71 pdflush
3652 root 15 0 11640 5836 2592 S 0 0.6 0:21.89 AST_VDauto_dial
3667 root 16 0 10816 6504 2568 S 0 0.6 0:30.01 AST_VDadapt.pl
2882 root 16 0 9672 5020 2580 S 0 0.5 0:04.66 AST_VDremote_ag
24265 root 15 0 12020 6752 2672 S 0 0.7 0:02.77 AST_manager_lis
24297 root 15 0 10064 4980 2580 S 0 0.5 0:08.31 AST_manager_sen
8671 asterisk 16 0 18276 7888 5232 S 0 0.8 0:07.53 httpd
9515 asterisk 16 0 18276 7884 5232 S 0 0.8 0:06.92 httpd
16301 asterisk 16 0 18092 7760 5228 D 0 0.8 0:04.83 httpd
17685 asterisk 16 0 18548 8244 5252 S 0 0.8 0:04.09 httpd
17694 asterisk 16 0 18136 7772 5228 S 0 0.8 0:04.54 httpd
23713 root 16 0 3052 996 760 R 0 0.1 0:01.71 top
1 root 15 0 1988 552 472 S 0 0.1 0:00.73 init
2 root RT 0 0 0 0 S 0 0.0 0:00.19 migration/0
3 root 34 19 0 0 0 S 0 0.0 0:00.01 ksoftirqd/0
4 root RT 0 0 0 0 S 0 0.0 0:00.18 migration/1
5 root 34 19 0 0 0 S 0 0.0 0:00.00 ksoftirqd/1
6 root 5 -10 0 0 0 S 0 0.0 0:00.01 events/0
7 root 5 -10 0 0 0 S 0 0.0 0:00.01 events/1
8 root 6 -10 0 0 0 S 0 0.0 0:00.00 khelper
9 root 5 -10 0 0 0 S 0 0.0 0:00.00 kblockd/0
10 root 5 -10 0 0 0 S 0 0.0 0:00.00 kblockd/1
11 root 15 0 0 0 0 S 0 0.0 0:00.05 khubd
49 root 14 -10 0 0 0 S 0 0.0 0:00.00 aio/0
50 root 5 -10 0 0 0 S 0 0.0 0:00.00 aio/1

[mflorell]

Not sure why you posted top output. Reinstalling DBD::mysql should not have anything to do with agents logging out of the PHP-based agent interface.

Are the agents logging out properly with the LOGOUT link at the top of the vicidial.php screen?

If an agent closes their window without logging out, the AST_VDauto_dial.pl script will time them out after a minute or so.

[mtancoff]

Yes the agent logouts with the log-out link, and the database takes a long time to delete that record from vicidial_live_agents

[mflorell]

What is the status of the record before the agent clicks logout?

What is the status of the record after the agent clicks logout?

Does the random field keep updating after clicking LOGOUT?

[mtancoff]

What the loadavg shoul be in order to vicidial work correctly?

thanx!

[mflorell]

How many CPUs do you have?

Are they single core, or multi-core?