Hello, I am new to this list and MySQL. I am very excited about this open source community. I can definitely see MySQL becoming to database servers, what Apache has become to web servers. I am currently developing a mission critical manufacturing web application in Java and I am leaning towards using MySQL as the back-end DB. Since MySQL has gotten excellent reviews as far as stability, speed, and ease of use--and my application does not require foreign key restraints or lots of bells and whistles --I decided it was worth a shot. My only concern from the onset was that it wasn't transactionally safe. I can't have the DB lose data if the server goes down. I have learned that InnoDB provides this functionality on top of MySQL, but the interrelation between the two is very unclear to me. I haven't found a good FAQ for explaining what InnoDB does and how it does it with MySQL. I've only found information in the 'do this, this and this to make this work' style. I am never sure if I am working with InnoDB or MySQL or both. I don't feel like I can really commit to this DB until I get a good grasp of the complexity of this relationship. So far I have set up the InnoDB data files and directories and have MySQL up and running. I set my my.ini file with 'default-table-type=innodb' and my innodb information. Everything seems great--I can create tables, do all my select statements, etc.. Everything seems easy as pie, but I can't shake the concern that I am not understanding InnoDB. So what I am wondering--am I creating transactionally safe tables in the innodb format every time I create a new table? Do I no longer have to worry about innodb? WHat about these ibdata1 and ibdata2 files I created? I am assuming these hold transactional information. SHould I be worried about whats in there? Will these fill up with data and outgrow their pre-defined size? I just feel like I am missing something. If anyone can point me to a good low-level FAQ or book that might explain to me about what exactly going on with this I would be grateful. I have been to the Innodb.com site. Great tutorial, but It leaves me with lots of questions--especially in regards to coordination with MySQL. Best Regards to all, Aaron
--------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
