[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