Page 1 of 1

Lead search not honoring slave DB?

PostPosted: Fri Sep 29, 2023 4:12 pm
by RBecker
Hey all,
Was looking into some slow queries on our system and noticed some lead search queries in the log that were occurring on our primary DB server. In the System Settings I have the slave DB enabled and the "Search Leads Logs" report (among many others) selected as a report to use the slave DB. I looked at the /vicidial/admin_search_lead.php file and it appears that these queries are being forced back to the main DB whenever it's returned to use the slave DB. Just wondering if there is any legitimate reason for this and why it's included in the first place.

Version 2.14b0.5, build 230421-1739, SVN 3719

Re: Lead search not honoring slave DB?

PostPosted: Fri Jul 26, 2024 10:00 am
by williamconley
Have you confirmed that these are "Search for a Lead" and not other processes? Such as viewing lists and/or campaigns with lists and lead counts? Most normal admin web pages appear to pull only from the Master.