Reading agent_log table for my own report

[macaruchi]

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

[mflorell]

Yes, that can cause a delay. I would recommend setting up a slave database server to run your report queries from.

[macaruchi]

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 ?

[williamconley]

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.