Page 1 of 1

Index to vicidial_agent_log

PostPosted: Fri Jun 05, 2009 4:10 am
by ekaftan
Hi,

I need to monitor in real time the pause code of the agents. So far (in 2.0.4, I've not upgraded yet) the only place I can find it is in the table vicidial_agent_log.

Can I add a couple of indexes to that table to be able to search for a particular agent, or is there a risk of too much mysql io?

Is there another place where the pause code is stored? Did something change in 2.0.5 that would make this easier for me?

Thanks.

PostPosted: Sat Jun 06, 2009 6:59 am
by mflorell
Pause code is only stored in vicidial_agent_log.

An index on that field of that table should be fine.

I would strongly recommend upgrading to 2.0.5(2.0.5.1rc1 actually), there are a lot of bugs fixed related to pause codes in that update.