RE: Converting tables to innoDB

2004-04-21 Thread Dathan Vance Pattishall 
No, there is no reason to covert them to INNODB unless you want an ACID
compliant table format, and have disk space to spare.


MYISAM support a wide variety of mySQL featured, such as full text searches,
a key buffer, and a few other nice things such as a being able to get a row
count in ms time. INNODB is cool for transactions / ACID compliant features
and large amounts of concurrency.

--
DVP

 -Original Message-
 From: Brad Tilley [mailto:[EMAIL PROTECTED]
 Sent: Wednesday, April 21, 2004 2:44 PM
 To: [EMAIL PROTECTED]
 Subject: Converting tables to innoDB
 
 Hello Mysqlers,
 
 I have a few small DB's (less than 10,000 entries per table) that track
 computer inventory in a mid-sized organization. Currently, all of the
 tables
 are MyISAM. Is there any compelling reason to convert these to InnoDB?
 We're
 not having any performance or size issues... everything works great right
 now. I'm just hearing how InnoDB is the only way to go today, any tips on
 whether or not to switch?
 
 Thanks,
 
 Brad
 
 --
 MySQL General Mailing List
 For list archives: http://lists.mysql.com/mysql
 To unsubscribe:
 http://lists.mysql.com/[EMAIL PROTECTED]




--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Converting tables to innoDB

2004-04-21 Thread Paul DuBois 
At 18:43 -0400 4/21/04, Brad Tilley wrote:
Hello Mysqlers,

I have a few small DB's (less than 10,000 entries per table) that track
computer inventory in a mid-sized organization. Currently, all of the tables
are MyISAM. Is there any compelling reason to convert these to InnoDB? We're
not having any performance or size issues... everything works great right
now. I'm just hearing how InnoDB is the only way to go today, any tips on
whether or not to switch?
Ask the people who are telling you that what is the basis for their
statements.  Then you'll be in a better position to assess whether
those statements apply to your own situation.
--
Paul DuBois, MySQL Documentation Team
Madison, Wisconsin, USA
MySQL AB, www.mysql.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]