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? Link to comment https://forums.phpfreaks.com/topic/100664-solved-myisam-to-innodb/ 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. Link to comment https://forums.phpfreaks.com/topic/100664-solved-myisam-to-innodb/#findComment-514799 Share on other sites More sharing options...
jaymc Posted April 11, 2008 Author Share Posted April 11, 2008 Ha, dont worry, I will ;-) Link to comment https://forums.phpfreaks.com/topic/100664-solved-myisam-to-innodb/#findComment-514845 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. Link to comment https://forums.phpfreaks.com/topic/100664-solved-myisam-to-innodb/#findComment-514854 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? Link to comment https://forums.phpfreaks.com/topic/100664-solved-myisam-to-innodb/#findComment-514858 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. Link to comment https://forums.phpfreaks.com/topic/100664-solved-myisam-to-innodb/#findComment-514974 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 Link to comment https://forums.phpfreaks.com/topic/100664-solved-myisam-to-innodb/#findComment-515806 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. Link to comment https://forums.phpfreaks.com/topic/100664-solved-myisam-to-innodb/#findComment-516703 Share on other sites More sharing options...
jaymc Posted April 14, 2008 Author Share Posted April 14, 2008 Thanks. Link to comment https://forums.phpfreaks.com/topic/100664-solved-myisam-to-innodb/#findComment-516810 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.