Reputation
429
Top tag
Next privilege 500 Rep.
Access review queues
Badges
3 16
Newest
 Yearling
Impact
~69k people reached

Jan
12
asked mongoexport on 2.0.4
Jan
7
comment Any recommendation on my.cnf on aws.large instance?
how about innodb_buffer_pool_instances? This is new in 5.6 onwards. Do we get some real benifits out of it?
Jan
7
asked Any recommendation on my.cnf on aws.large instance?
Jan
3
revised Mysql Percona 5.6 slave lags gradually
fixed
Jan
3
revised Mysql Percona 5.6 slave lags gradually
new update
Jan
3
asked Mysql Percona 5.6 slave lags gradually
Jan
2
awarded  Yearling
Jan
2
accepted Dropping multiple KEYS of a table
Jan
2
comment Dropping multiple KEYS of a table
innodb. I'm going for pt-osc multiple drop together.
Jan
2
comment Dropping multiple KEYS of a table
What will happen to new operations to the table? Where will new records gets stored at the time of copying? Would it take table lock or metadata lock ?
Jan
2
asked Dropping multiple KEYS of a table
Dec
31
comment OOM in mysql-percona
tried with Buffer_pool_size with 180G. I will update after a week.
Dec
31
revised OOM in mysql-percona
added 84 characters in body
Dec
31
asked OOM in mysql-percona
Dec
28
comment What are the optimal mysqldump settings?
Read each arguments and its benefits and choose which would suite you. Also get to know scripting to trigger incase of failures.
Nov
13
comment Mongo Replication with VIP
So the drivers here are application drivers should be written in such a way. @mongo_client = MongoReplicaSetClient.new( ['n1.mydb.net:27017', 'n2.mydb.net:27017', 'n3.mydb.net:27017'] ).db("test").collection("sample") To choose its member. I'm I right?
Nov
2
comment Mongo Replication with VIP
Note: It will open write on secondary, doesn't mean that it will route the requests from application to secondary(NewMaster).
Oct
31
comment Mongo Replication with VIP
I do understand that it is for voting purpose. But when it can decide who should be available for writes and who shouldn't be, I would like to embed a logic that should also route application requests to the winner. Also I don't want to keep the host decision on app end. Kinda doesn't look clean for me.
Oct
31
asked Mongo Replication with VIP
Oct
17
comment I noticed that my MySQL slave's DB size is smaller than the Master's DB
how did you find the size in mysql prompt? data_length+index_length in information_schema.tables? If yes, then first you need to understand concepts of fragmentation and garbage collector.