博客
关于我
强烈建议你试试无所不能的chatGPT,快点击我
New in Mysql 5.5
阅读量:2494 次
发布时间:2019-05-11

本文共 1392 字,大约阅读时间需要 4 分钟。

这几点看上去还是蛮有诱惑力的:

1Improved scalability on multi-core CPUs

2I/O subsystem changes enable more effective use of available I/O capacity.

3The default storage engine for new tables is InnoDB rather than MyISAM.

4Support for an interface for semisynchronous replication: A commit performed on the master side blocks before returning to the session that performed the transaction until at least one slave acknowledges that it has received and logged the events for the transaction.

The slave acknowledges receipt of a transaction's events only after the events have been written to its relay log and flushed to disk.

INNODB相关

1、Native Asynchronous I/O for Linux

2、Multiple Buffer Pool Instances

3、Multiple Rollback Segments

4、InnoDB 1.1 revolve around better isolation of threads and mutex contention.

Improved Log Sys Mutex Separate Flush List Mutex(not use with buffer pool as before)

5、 InnoDB Stats in Performance Schema

The has been part of MySQL 5.5 for a while now. InnoDB 1.1 is instrumented for the first time for Performance Schema monitoring, with statistics available for InnoDB-specific mutexes, rw-locks, threads, and I/O operations. The data is structured so that you can see everything, or filter to see just the InnoDB items.

详见

[@more@]

来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/668365/viewspace-1048258/,如需转载,请注明出处,否则将追究法律责任。

转载于:http://blog.itpub.net/668365/viewspace-1048258/

你可能感兴趣的文章