MyISAM versus InnoDB question

[applejack]

My server currently uses MyISAM but I am intending to update to MySQL 5.5+ which uses InnoDB as the default. I did actually do this but MySQL was getting overloaded but this may be because I hadn't run mysql_upgrade so I downgraded it to as before.

From what I understand it isn't necessary to convert existing databases to InnoDB but is it preferable (and please correct me if I am wrong). Also any general pros and cons for MyISAM versus InnoDB and in particular with running CMSMS.

I would also appreciate it if someone could post their mysqld variables settings so I can take a look and compare.

The server has i7 CPU 930 @ 2.80GHz , 8 cores and 16GB of RAM, RAID 1, one Terrabyte each drive.

Thanks in advance.

[faglork]

I have the same problem ... I need to update servers.

Cheers,
Alex

[applejack]

Alex

Download this perl script and run it to test your mysql setup which I did after posting. Very useful.

https://github.com/major/MySQLTuner-perl

Also see

http://www.hardwaresecrets.com/article/ ... ver/1747/6
https://fak3r.com/2009/02/18/howto-conf ... mycnf-fil/

[chandra]

CMSMS needs MyIsam formated tables.

There were some changes in the past to ensure CMSMS get what it needs .

http://www.cmsmadesimple.org/2012/12/An ... ernandina/

Some people also reported a particular slowness when installing CMSMS in Windows environments due to some tables being created in the InnoDB format rather than the MyISAM format. Though technically not a CMSMS issue, we have now made modifications so that, by default, all tables are created in MyISAM format for new installations.

I'm using some installations with 'mysqli' inside config.php - without any trouble.

[applejack]

Re: CMSMS needs MyIsam formated tables.

We'll that kind of saws it up, thanks for the heads up. Do you know therefore if it is best to set it as the default engine ?

[chandra]

Wount open a flame war about databases but in my opinion currently only MyIsam make sense cause one of the main goals of InnoDB (=transactions) is not supported by CMSMS.

Make a look to current /lib/adodb.functions.php, line 51

Code: Select all

  $str = 'pear:date:extend';

The same in CMSMS 1.9.4.3, line 76

Code: Select all

	$dbinstance =& ADONewConnection($config['dbms'], 'pear:date:extend:transaction');

As you can see the param for calling transactions was killed.