May 26, 2012

Post: SHOW INNODB STATUS walk through

… you get no information what this object is responsible for. You however …connections for MySQL there will be ether not started state if there is no active Innodb transaction for this connectionDatabase pages 258053 Modified db pages 37491 Pending reads 0 Pending writes: LRU 0, flush list 0, single

Post: Cache Performance Comparison

… access same data read from database multiple times. Examining MySQL full query logs from many … but if Unix Socket is used to connect to MySQL MySQL Query Cache will be faster. The…certain object or if you cache on different level (ie single object constructed from multiple query results) MySQL

Post: When would you use SAN with MySQL ?

MySQL if you’re looking for durable transactions the log write latency is triple important compared to other database systems. MySQLMySQL. This works though I do not think it is the best choice. SAN is just another object…it is a single “point” which can …SAN you can always “connect” the storage to …