All About Data, Databases, Data Architecture, Data Analytics, SQL, NoSQL and Big Data
Database · Hardware · MySQL · Network · NoSQL · Performance
Today, one of the MySQL database server response time has been increased within the pool of servers and noticed it was returning the query in 0.20 secs (randomly) as opposed[...]
Data Warehouse · Database · Performance · PostgreSQL · Scalability
If you using slony for PostgreSQL replication for more than one node (multiple replicas or cascading); then occasionally you might experience delays in replication if any one node is lagging[...]
Database · MySQL · NoSQL · Performance · Scalability · Zynga
Recently am part of Zynga‘s database team as I was pretty much impressed with company’s database usage. As everyone knows how popular Zynga games like Farmville, Cafe World, Mafia Wars,[...]
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[...]
