173 reputation
113
bio website
location Bangalore, India
age 28
visits member for 2 years, 7 months
seen Dec 20 '13 at 4:59

Sep
28
awarded  Popular Question
Sep
4
accepted How to handle the My SQL DB Master to Master replication when there was a disk space outage
Aug
26
awarded  Popular Question
May
6
awarded  Notable Question
Apr
4
awarded  Popular Question
Mar
28
revised MySQL Slave Lagging Almost Daily -Ver 5.5.17 ( Master & Slave )
added 4518 characters in body
Mar
26
awarded  Scholar
Mar
26
comment MySQL Slave Lagging Almost Daily -Ver 5.5.17 ( Master & Slave )
Thanks Michael for a Brief Explanation. I will have a look at your recommendations.
Mar
24
revised MySQL Slave Lagging Almost Daily -Ver 5.5.17 ( Master & Slave )
deleted 48 characters in body
Mar
24
asked MySQL Slave Lagging Almost Daily -Ver 5.5.17 ( Master & Slave )
Feb
15
awarded  Popular Question
Jan
31
awarded  Popular Question
Jan
24
awarded  Popular Question
Nov
17
comment Load spike in Mysql DB server
Check the Queries which are causing the Deadlocks, this might be a reason, where your server Load bump up.
Nov
15
comment Why does max_used_connections status not get refreshed automatically once it reaches max_connections, even though the Threads_connected falls down
Thanks Michael for the detailed explanation.
Nov
14
comment Why does max_used_connections status not get refreshed automatically once it reaches max_connections, even though the Threads_connected falls down
@DTest what i mean to say is flushing the status is only a partial solution,well in mysql we dont have option to flush specific server status variable,i knew flushing the status will reset all the status variables. if the problem persist still,only option to increase the max_connections.After flushing the status i observed in many situations the max_used_connections dopped down..but when ever it reach to max_connections, it keeps constant without changing. seeking some clarity
Nov
14
revised Why does max_used_connections status not get refreshed automatically once it reaches max_connections, even though the Threads_connected falls down
edited title
Nov
14
asked Why does max_used_connections status not get refreshed automatically once it reaches max_connections, even though the Threads_connected falls down
Nov
11
comment What exactly are iblog files in mysql
@ Uday The space will not be retained on the iblog files until the logbuffer becomes empty. It is a dynamic process, where the log space get occupied and released based on the stalled transaction changes recorded in the log buffer. These log files get occupied completly, when ever you perform some huge data loads, which leads to Innodb errors stating "InnoDB: which exceeds the log group capacity"., which mean Log file size should be bigger to do things. Hope my explanation cleared your doubt.
Oct
30
asked innobackupex is failing while exporting backup