Hi, You are assuming there is a 1 to 1 relation between tables and files. Don't the file(s) that the data is stored in belong to the storage engine in which case it is the engine that decides how the file is called? What happens if an engine stores the table data in multiple files or stored multiple tables in one file?
Barry On 11/12/10 8:03 PM, "Tim Soderstrom" <[email protected]> wrote: > > On Nov 12, 2010, at 9:11 PM, Diego Medina wrote: > >> On Fri, Nov 12, 2010 at 9:06 PM, Joe Schneider <[email protected]> wrote: >>> unless there was also a >>> file in the database directory that listed each table name / filename pair. >>> I could then look at said file to correlate that with my filesize data. >>> >> >> Tim Soderstrom suggested having this information on the >> DATA_DICTIONARY, so it would be accessible by a sql query > > The only problem I see is how Drizzle handles large numbers of databases or > tables. MySQL breaks down after a while and running i_s queries can even > exhaust the amount of RAM on the server :) I know Drizzle improves on that i_s > and d_d (I think?) but may be something to consider. > > > _______________________________________________ > Mailing list: https://launchpad.net/~drizzle-discuss > Post to : [email protected] > Unsubscribe : https://launchpad.net/~drizzle-discuss > More help : https://help.launchpad.net/ListHelp ------------------------------------------------------------------------- Barry Leslie SNAP Innovation Softwareentwicklung GmbH Senior Software Engineer Tel: (001) 250 884 1820 Fax: (001) 250 595 4460 Email: [email protected] Web: www.PrimeBase.org SNAP Innovation Softwareentwicklung GmbH, D-22765 Hamburg, Max-Brauer-Allee 50, Germany Amtsgericht Hamburg HRB 61066, Geschäftsführer: Ulrich Zimmer, Paul McCullagh ------------------------------------------------------------------------- _______________________________________________ Mailing list: https://launchpad.net/~drizzle-discuss Post to : [email protected] Unsubscribe : https://launchpad.net/~drizzle-discuss More help : https://help.launchpad.net/ListHelp
