Reading agent_log table for my own report

Any and all non-support discussions

Moderators: gerski, enjay, williamconley, Op3r, Staydog, gardo, mflorell, MJCoate, mcargile, Kumba, Michael_N

Reading agent_log table for my own report

Postby macaruchi » Thu Jan 12, 2017 5:56 pm

Hi!
I have created a report to read each 10sec from agent_log for stats , this report is in a webpage for my customer, now I am feeling a delay in AGC Interface - system delay, now I know Maria lock when I do a SELECT to this table so keeping selecting from this table can be the cause of this delay ?

Any ideas ?

TIA
*------------------
ViciBox 7.0.4 | Version:2.14-704a | SVN Version: 3078| DB Schema Version:1566| BUILD: 190312-0928 | 2 Processors 8 Core | 32 GB Ram | 1 Tera HD
macaruchi
 
Posts: 131
Joined: Wed Sep 21, 2016 8:11 pm

Re: Reading agent_log table for my own report

Postby mflorell » Thu Jan 12, 2017 6:22 pm

Yes, that can cause a delay. I would recommend setting up a slave database server to run your report queries from.
mflorell
Site Admin
 
Posts: 18335
Joined: Wed Jun 07, 2006 2:45 pm
Location: Florida

Re: Reading agent_log table for my own report

Postby macaruchi » Thu Jan 12, 2017 9:58 pm

I can use the same server into another database and use this DB just for reports ? It doenst matter has 2 DB in the same server ?
*------------------
ViciBox 7.0.4 | Version:2.14-704a | SVN Version: 3078| DB Schema Version:1566| BUILD: 190312-0928 | 2 Processors 8 Core | 32 GB Ram | 1 Tera HD
macaruchi
 
Posts: 131
Joined: Wed Sep 21, 2016 8:11 pm

Re: Reading agent_log table for my own report

Postby williamconley » Sat Jan 14, 2017 9:46 pm

macaruchi wrote:I can use the same server into another database and use this DB just for reports ? It doenst matter has 2 DB in the same server ?

If you know how, yes.

We've also set up systems that merely copy specific tables into a new DB at intervals to avoid the overhead of replication. If you've ever had a DB lose replication in the middle of a workday, and automatically try to pull a full data set to rebuild the replication link, you'll understand the concept. lol

It's also useful to archive the original tables to avoid huge data sets as well as indexing the requested data for speed of retrieval.
Vicidial Installation and Repair, plus Hosting and Colocation
Newest Product: Vicidial Agent Only Beep - Beta
http://www.PoundTeam.com # 352-269-0000 # +44(203) 769-2294
williamconley
 
Posts: 20018
Joined: Wed Oct 31, 2007 4:17 pm
Location: Davenport, FL (By Disney!)


Return to General Discussion

Who is online

Users browsing this forum: No registered users and 67 guests