May 22, 2012

Comment: How FLUSH TABLES WITH READ LOCK works with Innodb Tables

Peter, Why not use similar patch as in Google Patches II, where InnoDB file writes can be altogether disabled using a…

Comment: Introducing percona-patches for 5.1

… have a server on Ubuntu Hardy with the following installed: ii libmysqlclient15off 5.0.90-percona-b21.hardy.3 MySQL database client library ii libpercona-xtradb-client-dev 5.1.45-xtradb-1.0.6-10-80.hardy.24 Percona SQL database development files ii libpercona-xtradb-client16 5.1.45-xtradb-1.0.6…

Comment: MySQL Server Memory Usage

… 2 x 4MB cache (2.0Ghz) 2 X 250GB SATA II HDD 12 GB DDR3 RAM My question is: how much…

Comment: When does Innodb Start Transaction ?

….35.4 Isolation levels of SQL-transactions” in the “part II – foundations”. Isolation levels are defined in terms of phenomena – “dirty…

Comment: HandlerSocket on SSD

Peter, He was using 1 quad-port NIC (Broadcom NetXtreme II BCM5709) and used 3 ports of it. He also said…

Comment: FusionIO 320GB MLC benchmarks

… the other to a regular old internal Intel mobo SATA II connector. I’ve honestly had serious performance or reliability issues…

Post: Tokyo Tyrant - The Extras Part II : The Performance Wall

Continuing my look at Tokyo Tyrant/Cabinet and addressing some of the concerns I have seen people have brought up this is post #2. #2.  As your data grows does  Tokyo Cabinet slow down? Yes your performance can degrade. One obvious performance decrease with a larger dataset  is you start to …

Comment: Quick comparison of MyISAM, Infobright, and MonetDB

… such a simple way to find out, but dpkg says: ii monetdb5-server 5.14.2-20090924 MonetDB database server version…

Comment: Heikki Tuuri answers to Innodb questions, Part II

[...] Heikki Tuuri answers to Innodb questions, Part II | MySQL Performance Blog – [...]

Comment: MySQL Prepared Statements

… building HUGE sites. If you’re building amazon.com part II, then you’ll have to go with the way that…