Lately in the MySQL community, we only hear about scalability or performance improvements of storage engines, but nothing about query engine itself. For example, one classic example being InnoDB; if[…]
Database · MySQL · Performance · Scalability
All About Data,Analytics and Databases
Lately in the MySQL community, we only hear about scalability or performance improvements of storage engines, but nothing about query engine itself. For example, one classic example being InnoDB; if[…]
Database · MySQL · Performance · Scalability
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
apple apple-tiger Blackberry boot-camp chiranjeevi Database Dell desktop dual-boot flash-memory fusion General increase-performance-of-vista india innodb iPhone iPhone-problems laptop Mac macbook macbook-pro max-os-x microsoft-vista MySQL mysql-innodb-plugin mysql performance mysqluc2008 office-2007 parallel parallels parallels-readyboost parallels-slow Personal readyboost sql ubuntu virtualization vista-optimization vista-performance vista-tweaks vmware Windows windows-vista Yahoo! Yahoo-mail