I have a single InnoDB database that's currently holding about 20GB (with about 95% of that in a single table).
All of this database is contained inside a single InnoDB tablespace file. In the last 12 months, the only command
I've thrown at it by hand was "ALTER TABLE messageblks TYPE = InnoDB", and only because I wanted to
see how long it would take.
Hope this helps!
Regards,
Chris
Nicolas Ross wrote:
Hi !
Our db server has about 140+ db's for a total of about 1.5 gigs of data.
Some while ago, for a specific DB, I did testing using transaction tables with bdb. This was a bad experience. I ran into some problems and I had to convert back to myisam.
One thing I don't like about innobd and bdb is that all the data of all db's are all stored in one (or many) file in the base directory compared to myisam tables where data resides in the db directory.
Is innodb stable enough to use un mass production environement ?
Nicolas
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
