MySQL limitations

Question

When using MySQL 5.1 Enterprise after many years of using other database products, such as Sybase, Infomix, DB2; I am facing what MySQL just does not do. For example, it can only generate an EXPLAIN query plan for SELECT queries.

What other things should I observe?

Answer 1

You can take a look at the long list here: MySQL Gotchas

Answer 2

Full external connection. But you can still make the right outer join with the outer join.

Answer 3

, , , MySQL . ! , , int, ( ) .

MySQL JDBC , , ( OutOfMemory). , , :

Statement sx = c.createStatement(java.sql.ResultSet.TYPE_FORWARD_ONLY,java.sql.ResultSet.CONCUR_READ_ONLY);
sx.setFetchSize(Integer.MIN_VALUE);

, JDBC , , , ORM? , . , , ORM- - .

- , URL- JDBC. , .

Answer 4

Answer 5

. - . .

Answer 6

- CHECK!