简介：everything in life is random! (personal and work)

原站：http://venublog.com

“Venu Anuganti Blog”的内容更新

累计：34 篇（自 2009-07-20 起）

更新：约1篇/月，最后更新363 天前

Venu Anuganti Blog

MySQL At Scale – Zynga Games

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, poker, frontierville, fishville, petville and treasure island etc are. zynga launched yet another new game today called cityville along with series of acquisitions (lat... (303 天前)

http://inezha.com/w/r5xv5nb

Venu Anuganti Blog

Why Kickfire is a fail in MySQL Data warehouse

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 take the market share that easily due to number of reasons. even though am not a marketing guy to go over, but some of the [...]... (303 天前)

http://inezha.com/w/nxeniv4

Venu Anuganti Blog

MapReduce – DBInputFormat – Serialization on reade

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 is mapreduce job to access innodb tables for read-only meta data. and debugging it further, noticed that every access to database server is serialized with [...]... (303 天前)

http://inezha.com/w/989o1vw

Venu Anuganti Blog

Random Pauses In MySQL – File Handle Serialization

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 get around and make the threads to run and do the actual work. there are few more cases where the server can get into pause [...]... (303 天前)

http://inezha.com/w/brwy7ve

Venu Anuganti Blog

How read_buffer_size Impacts Write Buffering and Wri

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 writes. in case of write buffering, it groups the sequential writes until read_buffer_size(it is min(read_buffer_size, 8k)); and then actually does the physical write once ... (303 天前)

http://inezha.com/w/tgd46v6

Venu Anuganti Blog

Autocommit, Implicit Commit and Open Transactions

if you have any open transaction(s); and if there is any statement that causes implicit commit, especially ddl statements; then the current active transaction will be committed and transaction will be closed automatically. here is the list of statements that causes implicit commit in mysql. but other day; we had an issue in production as [...]... (303 天前)

http://inezha.com/w/xammlvn

Venu Anuganti Blog

InnoDB In a Complete Locked Mode

today morning, we had a weird issue in one of the staging olap server (etl); where all the innodb threads were locked and waiting on a signal condition for about 3-4 hours without performing any work related to innodb until we noticed it. processlist indicates every thread is in active state mode like sending data, [...]... (303 天前)

http://inezha.com/w/ysw65vg

相关订阅源