Indexing mySQL database

antlefebvre · ‎10-09-2013

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?

jcoates_splunk · ‎10-09-2013

perhaps if you did something like this?

http://stackoverflow.com/questions/4603272/mysql-count-number-of-rows-in-each-table

antlefebvre · ‎10-09-2013

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.

Indexing mySQL database

Join the Splunk Community Slack to learn, troubleshoot, and make connections with fellow Splunk practitioners in real time!

Join Splunk User Groups to connect and learn in-person by region or remotely by topic or industry.

Deep Dive: Accelerate threat investigation with Splunk’s AI Assistant in Security

Announcing Modern Navigation: A New Era of Splunk User Experience

Detection Engineering Office Hours: Real-World Troubleshooting & Q&A

Join the Conversation

Indexing mySQL database

Join the Splunk Community Slack to learn, troubleshoot, and make connections with fellow Splunk practitioners in real time!

Join Splunk User Groups to connect and learn in-person by region or remotely by topic or industry.

Deep Dive: Accelerate threat investigation with Splunk’s AI Assistant in Security

Announcing Modern Navigation: A New Era of Splunk User Experience

Detection Engineering Office Hours: Real-World Troubleshooting & Q&A