MyISAM hack to replace InnoDB Engine Call

This topic is locked, no new messages can be posted
avatar franckster Jan 21. 2007. 4:23 pm #1
Hi,

I've duefully read all the items related to InnoDB & MyISAM in this forum and, as Ilija mentionned more than once, cannot guarantee the results of the following.

My problem was simply that I may be facing some kind of a hardware problem on my OWN, dammit !!, server that causes the InnoDB engine to crash because of some stupid thing happening in the InnoDB log files that the engine cannot get over. As a result, my whole MySQL server crashes, which is some kind of a problem dued to the number of websites I have running on my production server.

So here is my hack to fool ActiveCollab into believing it's got all the required engines, ie InnoDB, to work perfectly. Pls keep in mind I am no MySQL engineer and that I have no idea as to where ActiveCollab is heading without InnoDB. I'm just bypassing the checks Ilija set in ActiveCollab where it looks for InnoDB before installing.

1- Open, in your favorite text ed, the mysql_schema.php file located in /public/install/installation/templates/sql/
2- Search & Replace all the 'innodb' occurences by 'myisam' & save
3- Open the acInstallation.class.php file located in /public/install/installation/
4- Search & Replace all the 'innodb' occurences by 'myisam'
5- On line 213, delete 'myisam' in the 'have_myisam' variable statement,
6- On line 218, change 'return false' to 'return true' and save
7- Upload both files to their respective locations on your server if you have already uploaded all the
ActiveCollab files, or the whole package otherwise.
8- Go through the install process.

Pls note I turned 'DEBUG' to TRUE i/o 'FALSE' on line 125 but have no idea what this is going to do. If your hack doesn't work, this could be the answer.

Pls keep in mind I just searched for text-strings and successfully tried changing the results of a variable to get there and that this won't be a makeshift for a proper install w/ all the required engines.
I'll keep you posted if I find useful info regarding the MyISAM vs InnoDB debate or some more intelligent and safer way to have ActiveCollab run w/o the InnoDB Engine.

Cheers,

Franckster
avatar superjadex12 Jun 29. 2007. 3:08 am #2
I am not an advanced coder by any means, but from what I've read, it would seem that if you did this you may run into optimization problems.

Ilija choose innodb most likely for optimization reasons . As innodb does not have the same structure as MyISAM, you may run into speed/efficiency problems over time, when your database starts getting bigger.

Again, I don't have the proof, and I'm not an advanced coder, but I just wanted to offer a word of caution to those thinking about implementing this hack. Maybe a little more research is in order.

Topic is locked

If you have something important to say about the issues discussed in this post please write at hi@a51dev.com.