Splunk Search

Indexing mySQL database

antlefebvre
Communicator

I am attempting to index a mySQL database as searching for me is much easier using the SPL. I currently have a DB Connect tie into the mySQL database. I have been able to connect and index a single table, but there are over 1900 tables. About 500 are empty. I am only looking for tables that are being updated. Does anyone know of a query to get the tables that are actively being written to in the database?

0 Karma

jcoates_splunk
Splunk Employee
Splunk Employee
0 Karma

antlefebvre
Communicator

That is how I was able to determine that 500 tables are empty. But I'm looking in particular for the tables that are actively being written to. Tables that have static values I am uninterested in adding.

0 Karma
Get Updates on the Splunk Community!

Leveraging Detections from the Splunk Threat Research Team & Cisco Talos

  Now On Demand  Stay ahead of today’s evolving threats with the combined power of the Splunk Threat Research ...

New in Splunk Observability Cloud: Automated Archiving for Unused Metrics

Automated Archival is a new capability within Metrics Management; which is a robust usage & cost optimization ...

Calling All Security Pros: Ready to Race Through Boston?

Hey Splunkers, .conf25 is heading to Boston and we’re kicking things off with something bold, competitive, and ...