MySQL 5.6 compability

Rennur

After installing MySQL 5.6 I got this error:

'Aware IM Server:'
Please report the following error message to Awaresoft: Unable to initialise the database tables due to the following exception com.bas.basserver.persistence.PersistenceException Error creating database tables. SQL Exception thrown 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

aware_support

This will be fixed in 5.6

Rennur

MySQL v5.6 hangs after AwareIM 5.6 install and BSV import.

Creating tables is painfully slow until MySQL 5.6 eventually crashes and AwareIM spits out connection error.

INNODB is on.

Is anyone else having any issues with MySQL 5.6.

aware_support

In our own experience MySQL 5.6 has been awful. We don't think it's ready for the big time yet. They have a big problem in their CREATE INDEX implementation - it is painfully slow. This is why Aware IM has all sorts of problems with it as it creates a lot of indexes when a BSV is published.

Exactly the same Aware IM version works without a glitch in MySQL 5.5

We recommend not to upgrade to MySQL 5.6 until they release a patch for this.

Rennur

Thanks for the clarification 🙂

weblike

Hello Support,

How this thing is going with MySql 5.6? It's ok now?

thank you

aware_support

It's not up to us - it's up to MySQL. Feel free to test their latest release.

rocketman

MySQL 5.6 and AwareIM 5.8 tested on Mac - all ok

rocketman

Should have added - not done any benchmarks or anything, just that it installed ok and my main BSV works fine - no hidden gremlins