How to watch database additions

All installation and configuration problems and questions

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

How to watch database additions

Postby carpenox » Wed Apr 29, 2020 12:15 am

Is there a perl script I can run with --debugX to watch database additions to find out whats going on during astgui functions to try to debug errors?
Alma Linux 9.3 | Version: 2.14-911a | SVN Version: 3815 | DB Schema Version: 1710 | Asterisk 18.18.1
www.dialer.one -:- 1-833-DIALER-1 -:- https://linktr.ee/CyburDial -:- WhatsApp: +19549477572 -:- Skype: live:carpenox_3
carpenox
 
Posts: 2230
Joined: Wed Apr 08, 2020 2:02 am
Location: Coral Springs, FL

Re: How to watch database additions

Postby williamconley » Fri Jun 19, 2020 1:22 pm

Code: Select all
NEWPASS=RootMySQLPass
watch -n1  "mysql asterisk -p$NEWPASS -e \"select * from information_schema.processlist where command not in ('Sleep') and info not like '%processlist%' and info is not null and STATE not like '%Waiting%'\""


Sorry. Not perl. 8-)
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!)

Re: How to watch database additions

Postby carpenox » Fri Jun 19, 2020 11:28 pm

Bill,

Cool, that'll work. Thanks

Nox
Alma Linux 9.3 | Version: 2.14-911a | SVN Version: 3815 | DB Schema Version: 1710 | Asterisk 18.18.1
www.dialer.one -:- 1-833-DIALER-1 -:- https://linktr.ee/CyburDial -:- WhatsApp: +19549477572 -:- Skype: live:carpenox_3
carpenox
 
Posts: 2230
Joined: Wed Apr 08, 2020 2:02 am
Location: Coral Springs, FL

Re: How to watch database additions

Postby williamconley » Sat Jun 20, 2020 10:55 am

If you want to get really technical, mysql also has a logging feature to log ALL queries. This can be a little bloated, but useful if used sparingly and only when needed to actually be ON.

But if you truly ONLY want "changes in the DB", that's what the binary log is! 8-)
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 Support

Who is online

Users browsing this forum: Google [Bot] and 87 guests