106 reputation
4
bio website rishavrastogi.com
location Hyderabad, India
age 28
visits member for 2 years, 6 months
seen Nov 20 at 7:53

Ruby on Rails, Javascript Developer from India.

I blog here http://phyxius.posterous.com

http://twitter.com/rishavrastogi


Jun
12
awarded  Tumbleweed
Jun
11
asked Increased query_cache_size, Queries slowed drastically on increased traffic
Jun
5
asked Percona slower than vanilla Mysql 5.6
Apr
29
comment Why does that query cause lock wait timeouts?
@Rolando - Any idea how to avoid such error. We get these often in our database, exactly similar errors. Any idea how to work around them ?
Apr
10
comment When and why can this kind of deadlock occur?
So how do we situations like these, do we not use the secondary index, which in this case is the user_id index ?
Jun
11
awarded  Student
Jun
9
comment “Mysql server has gone away” debugging methods
I just changed the connect_timeout in mysql and socket_timeout in php, will continue to monitor. The issue is the site continues to work fine with the same mysql server, while the background job fails continously, I suspect its related to multiple child threads having stale connections to mysql.Thanks for that link though, much appreciated.
Jun
9
awarded  Supporter
Jun
9
comment “Mysql server has gone away” debugging methods
Thanks, already looked at those, not getting Error 2020 (CR_NET_PACKET_TOO_LARGE) , just getting Error 2006, mysql server has gone away.
Jun
9
asked “Mysql server has gone away” debugging methods
Jun
9
awarded  Autobiographer