mysql - 如何在 Hibernate 中使用 MySql 内存存储引擎？

Question

有没有办法告诉 Hibernate 使用 MySql 内存存储引擎？
谢谢。
编辑:我发现 Memory Storage Engine 不支持 InnoDB 等常规 Store Engine 的所有功能。因此没有选项似乎合乎逻辑。

Answer 1

应该有一个属性文件，你可以把你的 URL 放到 MySQL 中

#hibernate.dialect org.hibernate.dialect.MySQLDialect
#hibernate.dialect org.hibernate.dialect.MySQLInnoDBDialect
#hibernate.dialect org.hibernate.dialect.MySQLMyISAMDialect
#hibernate.connection.driver_class com.mysql.jdbc.Driver
#hibernate.connection.url jdbc:mysql:///mysqlURL
#hibernate.connection.username
#hibernate.connection.password

但要注意这一点

When using the MyISAM storage engine, MySQL uses extremely fast table locking that allows multiple readers or a single writer. The biggest problem with this storage engine occurs when you have a steady stream of mixed updates and slow selects on a single table. If this is a problem for certain tables, you can use another storage engine for them.