[mythtv] [mythtv-commits] Ticket #10391: Slow MythTV startup if DB has many tables

Gary Buhrmaster gary.buhrmaster at gmail.com
Wed Feb 29 00:42:53 UTC 2012


On Wed, Feb 29, 2012 at 00:36, Gavin Hurlbut <gjhurlbu at gmail.com> wrote:
> On Tue, Feb 28, 2012 at 2:46 PM,  <noreply at mythtv.org> wrote:
>>  Checking specifically for a few tables (e.g. settings, recorded) would be
>>  a lot faster than enumerating hundreds or thousands of tables?
>
> Maybe I'm dense here, but how did a user get hundreds or thousands of
> tables in a database that we designed?  If they added them there, then
> they should move them to a different database if their actions are
> causing a slowdown.

The select
   select table_name from information_schema.tables where table_type =
'BASE TABLE')
will include all databases and tables in the mysql server.
For a shared database server, that could be a lot of
tables.

My guess is that it really should include a where
   "... AND table_schema='mythconverg'"
to only select appropriate tables, but since I do not
know the intent, that guess could be very very wrong.

Gary


More information about the mythtv-dev mailing list