All About Data, Databases, Data Architecture, Data Analytics, SQL, NoSQL and Big Data
Database Scalability
Database · MySQL · Performance · Scalability
Last month, I blogged about a case involving InnoDB, where all threads acting on InnoDB tables completely stuck for about few hours doing nothing; until we found a way to[...]
Database · MySQL · Performance · Scalability
In MySQL, even though the name read_buffer_size implies that the variable controls only read buffering, but it actually does dual purpose by providing sequential IO buffering for both reads and[...]
Database · MySQL · Performance · Scalability
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
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 · Hardware · MySQL · NoSQL · Scalability
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 · 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[...]
