2008-06-05
全文显示

mysql query cache

关键字: mysql query cache transaction
1. works with Transactions http://www.mysqlperformanceblog.com/2008/01/29/how-mysql-query-cache-works-with-transactions/ 写道 The result set can be retrieved from query cache (for statements both inside and outside of transactions) until there is a statement inside transactions which modifie ...
2008-05-21
全文显示

InnoDB transaction model

关键字: transaction mysql innodb
At first, lst's understand some technologies used in mysql transaction model: 1. Next-Key Locking http://dev.mysql.com/doc/refman/5.0/en/innodb-next-key-locking.html 写道 InnoDB performs the row-level locking in such a way that when it searches or scans an index of a table, it sets shared or ex ...