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.

Why Splunk Customers Should Attend Cisco Live 2026 Las Vegas

What Is the Name of the USB Key Inserted by Bob Smith? (BOTS Hint, Not the Answer)

Automating Threat Operations and Threat Hunting with Recorded Future

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.

Why Splunk Customers Should Attend Cisco Live 2026 Las Vegas

What Is the Name of the USB Key Inserted by Bob Smith? (BOTS Hint, Not the Answer)

Automating Threat Operations and Threat Hunting with Recorded Future