Fix for newer mysql versions
Hello, I'm trying to switch to a newer version of MySQL for the following reasons: Much improved performance (2-3x as many hosts without bogging down the server in my case) and the option for compressed log archives. I wish to have a single version of MySQL for all services on the server, rather than multiple databases (terrible performance) or suffering an older version (4.17 in EA's case). In fact InnoDB would be faster than MyISAM for all tables in the newer version (it's now the default).
However, there's one trivial problem: Eventlog Analyzer crashes shortly after startup when trying to CREATE TABLE, because it uses incorrect TYPE= (innodb or myisam) at the end of the line, instead of the correct ENGINE=. It's been deprecated since 4.0 and removed since 5.2. I see that in the error logs repeatedly before it shuts down:
syntax error or access violation message from server: "you have an error in your sql syntax; check the manual that corresponds to your mysql server version for the right syntax to use near 'type=innodb' at line 1"|java.sql.SQLException: Syntax error or access violation message from server: "You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'TYPE=InnoDB' at line 1"
See this link: http://www.openrdf.org/issues/browse/SES-660
However, there's one trivial problem: Eventlog Analyzer crashes shortly after startup when trying to CREATE TABLE, because it uses incorrect TYPE= (innodb or myisam) at the end of the line, instead of the correct ENGINE=. It's been deprecated since 4.0 and removed since 5.2. I see that in the error logs repeatedly before it shuts down:
syntax error or access violation message from server: "you have an error in your sql syntax; check the manual that corresponds to your mysql server version for the right syntax to use near 'type=innodb' at line 1"|java.sql.SQLException: Syntax error or access violation message from server: "You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'TYPE=InnoDB' at line 1"
See this link: http://www.openrdf.org/issues/browse/SES-660