睿

MySQL的默认配置文件以节省资源为初衷，在资源有限、查询简单、数据集小的情况下运行良好，在查询复杂、数据集大时，配置文件需量身定制。引言Before you start changing configuration settings, you should keep in mind the fact that “more is not always better”. You might have 16-20 GB of RAM, but that doesn’t mean that you should

在many-to-one中设置not-found="ignore"

（1）改变dialect为org.hibernate.dialect.MySQLInnoDBDialect或org.hibernate.dialect.MySQL5InnoDBDialect for MySQL5（2）在MySQL设置文件my.cnf中新增default_table_type=INNODB