Database partition

[avi]

Hi all,

We are fatching problem when query the database, it responds very slow.

so i thought to partition the tables like call_log, vicidial_list,recording_log
to get better performance of the database.

Is there any other way to get the better performance of the database, then Please guide me for the same with step wise

Regards
Avi...

[williamconley]

I've not experienced greater speed by moving the databases to another partition except in that while moving a database you could "defragment" the database which would speed it up.

Under what circumstances is it responding slowly? could you tell me how you know it is responding slowly? is this within vicidial or is this when directly accessting the database?

[mflorell]

DB server specs? (CPU/RAM/Drives)

astGUiclient version?

loadavg when system is running with agents?

number of records in call_log/vicidial_log/vicidial_list/recording_log?

[avi]

Hi

we are getting problem when accessing the database directly through the tools or mysql prompt.

and DB server is slackware 2.6.9 -67.ELSmp
RAM is 8 GB


vicidial php version 2.0.4-142
build '71129-2025'

Load avg when 150 agent are login

Mem: 8168208k total, 6287560k used, 1880648k free, 168016k buffers
Swap: 20579256k total, 0k used, 20579256k free, 5567512k cached


Regards
Avi..

[mflorell]

I don't see CPU specs there

I don't see the actual loadavg numbers there

[williamconley]

you need to list the CPU specifications for this box and the actual load average during the time when you are experiencing these difficulties (and also when you are not, if there's a difference).

at 150 agents, ALL the specifications count.

would not be a bad idea to mention whether this is a recent issue or a recurring one or if you have recently increased your load (100 agents last week 150 now could be helpful information).

[avi]

Hi


The load average is : 4.18, 2.95, 2.25 on Dialer
and the database load average is : 2.52, 2.76, 2.53


And CPU specification is model name : Intel(R) Xeon(R) CPU E5310 @ 1.60GHz
stepping : 11
cpu MHz : 1600.060 on database


and model name : Intel(R) Xeon(R) CPU E5310 @ 1.60GHz
stepping : 11
cpu MHz : 1595.982

on Dialer



Please guide me for the same

Regards

[mflorell]

Your Dialer load is too high. Try reducing load or getting a faster machine with more CPU cores.

[rajiv_kuin]

Did i read correctly.... single machine... 140 agents.. oh my god.. but i read somwhere asterisk does not go beyond 4 E1 thats 120 channels...

[williamconley]

asterisk does not go beyond 4 E1 thats 120 channels

1) Where'd you read that?
2) VOIP is not only E1. They are excellent quality, sure, but NOT the only way to get a trunk.

[rajiv_kuin]

But how real it seems to have 150 agents on this kind of server.... i can not even dream of it with my experience so far... if i can log in 40 agents i would sleep well while agents at my center do business for me....

[mflorell]

150 VICIDIAL agents on a single server is too many. You should really distribute those agents across multiple servers to have a reliable running system.