MSYSQL version updates to 5.5

OpenEMR Development
1

tmccormi wrote on Tuesday, June 11, 2013:

These are being pushed on current Ubuntu 12.xx releases:

  • mysql-client-5.5 mysql-server-5.5 mysql-server-core-5.5

So far no issues on my sites running this version…

FYI
–Tony

2

tmccormi wrote on Tuesday, June 11, 2013:

http://dev.mysql.com/doc/refman/5.5/en/mysql-nutshell.html

The latest is 5.5.32

Some interesting tidbits:

Default storage engine. The default storage engine for new tables is InnoDB rather than MyISAM. See Section 14.3.1, “InnoDB as the Default MySQL Storage Engine”.

XML. Enhancements to XML functionality, including a new LOAD XML INFILE statement. See Section 13.2.7, “LOAD XML Syntax”.

-Tony

3

yehster wrote on Tuesday, June 11, 2013:

And from section 14.3.1 that Tony’s post refers to:

Starting from MySQL 5.5.5, the default storage engine for new tables is InnoDB. This change applies to newly created tables that don’t specify a storage engine with a clause such as ENGINE=MyISAM. (Given this change of default behavior, MySQL 5.5 might be a logical point to evaluate whether your tables that do use MyISAM could benefit from switching to InnoDB.)

Brady disagreed with my proposal to stop specifying ENGINE type in the creation/upgrade scripts. However, I do think it makes sense to specify InnoDB instead of MyISAM for any new tables going forward.