myisam信息详情

myisam发音

意思翻译

n.一种数据库引擎

相似词语短语

red pomyihang───红衣航

mummying───木乃伊

myis small───很小

Geomyidae───n.囊鼠科;[脊椎]衣囊鼠科;地鼠科

双语使用场景

Data integrity Our MySQL database tables were based on the non-transactional MyISAM engine.───数据完整性我们的MySQL数据库表格基于非事务性MyISAM引擎。

The key buffer stores index blocks for MyISAM tables.───关键字缓冲区保存了myisam表的索引块。

In a simple situation, the default MyISAM engine would do as well.───在简单的情况下,默认的MyISAM引擎就足够了。

InnoDB tends to be a more complicated storage engine and can be slower than MyISAM for most small applications.───InnoDB的趋势会是一个非常复杂的存储引擎,对于一些小的应用,它会比MyISAM还慢。

The only locking mechanism used in MyISAM is the table level locking, which translates that it is not suitable for high-usage environments.───MyISAM中只有一种锁定机制,即表级锁定,因此不适用于访问比较频繁的环境。

For the MyISAM storage engine using mysqlhotcopy, most of this logging is not applicable.───对于使用mysqlhotcopy的MyISAM存储引擎,大多数日志特性是不可用的。

The example application was built using the default MyISAM table type, and the developers tried to enforce data integrity at the code level.───应用程序样例使用了默认的MyISAM表类型,而开发人员试图在代码层采用数据集成。

If you're using MyISAM seriously you can also add the size of Operation System cache you would like MySQL to use for your table.───如果你大量地使用MyISAM表,那么你也可以增加操作系统的缓存空间使得MySQL也能用得着。

英语使用场景

Though inherently non-ACID by nature, MyISAM storage engine backup and recovery can be exercised to the level of version recovery without the data integrity promise.

myisampack.exe Compresses MyISAM table Use VALUE COMPRESSION in create table statement to use the space saving row format at the column or table level to reduce space required for a table.

In fact, it's limited to MyISAM tables — a table format that doesn't support foreign keys and, thus, may be of limited use.

Set up to 30 - 40 % of available memory if you use MyISAM tables exclusively.