I assume in the context of this thread that everyone is imagining a world where something to the effect of innodb_file_per_table is a permanent thing? At least thats how I was taking this.
On Nov 15, 2010, at 10:02 AM, Barry Leslie wrote: > 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 _______________________________________________ Mailing list: https://launchpad.net/~drizzle-discuss Post to : [email protected] Unsubscribe : https://launchpad.net/~drizzle-discuss More help : https://help.launchpad.net/ListHelp
