Show Posts
1
Running QueueMetrics / Queuemetrics suggested configurations
« on: April 20, 2012, 10:27:23 »
Hi All.
I'm new to this forum, and first of all would like to say hello to everybody
I have a issue with queuemetrics, and i do believe that it's a MySQL configuration issue. It's not be who installed it and done all the configurations, people before me done it. And as I don't know MySQL very good i can't configure it in the right way.
So...My server specs:
2x Intel(R) Xeon(R) CPU E5640 @ 2.67GHz
16GB RAM ( don't know DDR2 or DDR3 )
Queuemetrics version: Loway QueueMetrics - 12.1.2
I do believe that server is powerful enough to hold call center of 200 agents and couple more other departments who use queuemetrics to run reports. So in total, at peek time, there might be around 300-320 people using queuemetrics at the time.
My Issue is, that around 1PM till 5PM we have to restart queuemetrics nearly every 15-20 minutes because it starts to run terrible slow. People can't add queues to themselves, can't unpause or pause because, as i said above, it's terrible slow.
I do believe that it's a database issue because configurations that we have now are:
These are the only settings i could find as MySQL have been started with these settings.
/etc/my.cnf is empty so rest of the settings must be default anyway.
What do you think what could be the reason why we have to restart queuemetrics so many times during the day?
Thanks.
I'm new to this forum, and first of all would like to say hello to everybody
I have a issue with queuemetrics, and i do believe that it's a MySQL configuration issue. It's not be who installed it and done all the configurations, people before me done it. And as I don't know MySQL very good i can't configure it in the right way.
So...My server specs:
2x Intel(R) Xeon(R) CPU E5640 @ 2.67GHz
16GB RAM ( don't know DDR2 or DDR3 )
Queuemetrics version: Loway QueueMetrics - 12.1.2
I do believe that server is powerful enough to hold call center of 200 agents and couple more other departments who use queuemetrics to run reports. So in total, at peek time, there might be around 300-320 people using queuemetrics at the time.
My Issue is, that around 1PM till 5PM we have to restart queuemetrics nearly every 15-20 minutes because it starts to run terrible slow. People can't add queues to themselves, can't unpause or pause because, as i said above, it's terrible slow.
I do believe that it's a database issue because configurations that we have now are:
Code: [Select]
--key_buffer_size=4096M
--table_cache=1024
--sort_buffer_size=4M
--read_buffer_size=1MThese are the only settings i could find as MySQL have been started with these settings.
/etc/my.cnf is empty so rest of the settings must be default anyway.
What do you think what could be the reason why we have to restart queuemetrics so many times during the day?
Thanks.