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