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
All About Data,Analytics and Databases
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
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
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
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
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
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
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
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