"Maren" == Maren S Leizaola leizaola@hk.com writes:
Maren> well the data is several databases will millions of tables... using Maren> mysql, still i wonder if any of the other databases have created Maren> their own file system or monster database into which its stores data Maren> efficiently.
To me, this tells me that you're doing something really really wrong with your DB design. You should have lots of ROWS or COLUMNS in a much much smaller number of tables. I think you need to really explain what you are trying to do here, or get some DB design help.
I personally can't imagine why you need so many tables. It would be easier to just add an index to each set of data to say how it should be grouped. Presto! No need for multiple tables, just more columns in the existing tables.
Once you fix your data design problems, you won't see the disk issues you are currently seeing, where you try to delete many rows (or tables) of data.
John John Stoffel - Senior Staff Systems Administrator - System LSI Group Toshiba America Electronic Components, Inc. - http://www.toshiba.com/taec john.stoffel@taec.toshiba.com - 508-486-1087