All About Data,Analytics and Databases
As this topic came up a few times this week for discussion at various places, I thought of composing a post on Data Scientist vs. Data Analytics Engineer; even though[…]
BigData · Data Analytics · Data Science · Data Warehouse · Database · Hadoop · MySQL
Here is the typical œBig data architecture, that covers most components involved in the data pipeline. More or less, we have the same architecture in production in number of places[…]
BigData · Cloudera · Data Analytics · Data Science · Data Warehouse · Database · ETL · Hadoop · Mapreduce · MySQL · NoSQL · PostgreSQL · Reporting · Scalability
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[…]
Database · Hardware · MySQL · NoSQL · Performance
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 · NoSQL · Performance · Scalability
Even though Data warehouse is picking very rapidly in the last year or so, but few companies who are already made a right mark in the right time could not[…]
Data Warehouse · Database · MySQL · NoSQL · Scalability
Last week I was working on EC2 MySQL server where one of the slave is taking lot of time to catch-up; and only job that is running on that server[…]
BigData · Cloudera · Data Analytics · Data Science · Database · Hadoop · Mapreduce · MySQL · NoSQL · 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
