jaymc Posted April 11, 2008 Share Posted April 11, 2008 I have done a lot of research on innodb and have pretty much decided to convert my tables to this engine from myisam Main reasons is to allow for real time backups with locking the tables, better crash recovery and to avoid tables being locked for other queries if a big query is running My database is around 1GB at the moment and I do want to do everything I can to improve performance Can anyone come in the last minute and give some negative feedback on innodb that might make me pull out of this change over? Quote Link to comment Share on other sites More sharing options...
AP81 Posted April 11, 2008 Share Posted April 11, 2008 You shouldn't run into any problems here. Just make sure you stop the SQL service and do a full backup prior to converting the table engine. Quote Link to comment Share on other sites More sharing options...
jaymc Posted April 11, 2008 Author Share Posted April 11, 2008 Ha, dont worry, I will ;-) Quote Link to comment Share on other sites More sharing options...
fenway Posted April 11, 2008 Share Posted April 11, 2008 Just be very careful -- indexing is handled fundmentally different in InnoDB, so queries will perform differently too. At some point auto_increment was funny too, maybe this has been fixed. Quote Link to comment Share on other sites More sharing options...
jaymc Posted April 11, 2008 Author Share Posted April 11, 2008 Yeh read about the auto increment, think that only occurs if you have maybe 10 concurrent writes to the same table, it can trip over itself Indexes and queries effected? What do you mean.. is there anything I should prepare for or keep an eye on after doing this, query wise? Quote Link to comment Share on other sites More sharing options...
fenway Posted April 11, 2008 Share Posted April 11, 2008 Yeh read about the auto increment, think that only occurs if you have maybe 10 concurrent writes to the same table, it can trip over itself I'm hoping you've read this. Indexes and queries effected? What do you mean.. is there anything I should prepare for or keep an eye on after doing this, query wise? Give this a good read. Quote Link to comment Share on other sites More sharing options...
jaymc Posted April 13, 2008 Author Share Posted April 13, 2008 Yeh read about the auto increment, think that only occurs if you have maybe 10 concurrent writes to the same table, it can trip over itself I'm hoping you've read this. I have and dont see anything that should particulary be something I need to be worried about? Apart from the MAX query when mysql is restarted Unless I missed something, it looks like the conversion should be pretty painless? Thanks Quote Link to comment Share on other sites More sharing options...
fenway Posted April 14, 2008 Share Posted April 14, 2008 Yes, mostly painless, just keep an eye on your queries for a while. Quote Link to comment Share on other sites More sharing options...
jaymc Posted April 14, 2008 Author Share Posted April 14, 2008 Thanks. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.