In the last post choosing about the right type; there is a case about quoting the tuple values; that I forgot to mention which is pretty much a common mistake[…]
Database · MySQL · Performance
Category: MySQL
Choosing the right data type makes a big difference
Today evening one of my friend asked me in the IM to look into one of his production server where a query was taking ~11 seconds to run on 20[…]
Database · MySQL · Performance
MySQL 5.5 – A Community Winner
Ever since MySQL 5.5 beta has been announced by Edward Screven, Oracle’s chief corporate architect; there is lot of positive buzz (here, here, …) about the performance and scalability improvements[…]
Database · MySQL · Performance · Scalability
RAID Controllers Cache Management – Missing Features
We all know how important hardware RAID controllers are in today’s data storage performance especially when dealing with large data sets. If we look at the trend from now to[…]
Database · Hardware · MySQL · Performance
Data Store, Software and Hardware – What is best
Other day we had a small discussion about data stores and hardware; and which one drives the other when it comes to data storage solution, rather it is a hard[…]
Database · Hardware · MySQL · NoSQL · Scalability
CAP Theorem, Eventual Consistency, NoSQL
Very nice and interesting post from Michael Stonebraker explaining how errors dictate CAP Theorem (Consistency, Availability and Partition-tolerance); as only one objective from the CAP can be achieved during normal[…]
Database · MySQL · NoSQL · Scalability
Dell MD1120 Storage Array Performance
Here is some file IO performance numbers from DELL MD1120 SAS storage array. Last year I did the same test with HP P800 storage array and numbers were impressive. But[…]
Database · Hardware · MySQL · Scalability
Hyper Threading Performance
Its been a while anyone talked about Intel’s Hyper-Threading performance when it comes to databases. There were enough posts about disabling Hyper-Threading completely when it comes to MySQL/InnoDB workloads way[…]
Database · MySQL · NoSQL · Scalability