https://community.splunk.com/t5/Splunk-Search/Indexing-mySQL-database/m-p/90743#M182290 <P>perhaps if you did something like this?</P> <P><A href="http://stackoverflow.com/questions/4603272/mysql-count-number-of-rows-in-each-table">http://stackoverflow.com/questions/4603272/mysql-count-number-of-rows-in-each-table</A></P> Wed, 09 Oct 2013 17:38:31 GMT jcoates_splunk 2013-10-09T17:38:31Z https://community.splunk.com/t5/Splunk-Search/Indexing-mySQL-database/m-p/90742#M182289 <P>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?</P> Wed, 09 Oct 2013 17:15:28 GMT https://community.splunk.com/t5/Splunk-Search/Indexing-mySQL-database/m-p/90742#M182289 antlefebvre 2013-10-09T17:15:28Z https://community.splunk.com/t5/Splunk-Search/Indexing-mySQL-database/m-p/90743#M182290 <P>perhaps if you did something like this?</P> <P><A href="http://stackoverflow.com/questions/4603272/mysql-count-number-of-rows-in-each-table">http://stackoverflow.com/questions/4603272/mysql-count-number-of-rows-in-each-table</A></P> Wed, 09 Oct 2013 17:38:31 GMT https://community.splunk.com/t5/Splunk-Search/Indexing-mySQL-database/m-p/90743#M182290 jcoates_splunk 2013-10-09T17:38:31Z https://community.splunk.com/t5/Splunk-Search/Indexing-mySQL-database/m-p/90744#M182291 <P>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.</P> Wed, 09 Oct 2013 17:52:14 GMT https://community.splunk.com/t5/Splunk-Search/Indexing-mySQL-database/m-p/90744#M182291 antlefebvre 2013-10-09T17:52:14Z