space for InnoDB?

[Leeds]

hello,
With innodb, all DBs are stored in the same data file ("innodb_data_file_path"). If I have many DBs, how to know i.e. how much space a particular one is taking?
Is the performance of a small DB impacted if it shares the innodb file with a large one? any idea?
Thanks, -- This message may have been cut off and the rest will only be shown to members. To become a member, click here --

[ishac]

Use SHOW TABLE STATUS to look at the 'data length' and the 'index length' of each table and add these up.

Having a big database in the same ibdata files as a small database should not have any performance effect on the small database -- This message may have been cut off and the rest will only be shown to members. To become a member, click here --