Reputation
Top tag
Next privilege 200 Rep.
See reduced ads
Badges
1 2 14
Newest
 Critic
Impact
~21k people reached

  • 0 posts edited
  • 0 helpful flags
  • 14 votes cast
Apr
17
accepted Mysql: How does circular replication avoid infinite looping of a transaction
Apr
17
comment Mysql: How does circular replication avoid infinite looping of a transaction
Jodrell, Thanq. Shall i hear back on this one small doubt please ? what is the problem that we have in old replication that we would overcome with the introduction of GTID's
Apr
16
asked Mysql: How does circular replication avoid infinite looping of a transaction
Apr
13
awarded  Critic
Mar
23
comment CONCURRENT SELECT's SLOW … LOCK IN SHARE MODE
None of them is inside a transaction. and auto commit is ON. What difference it brings in if all of them are inside different transactions ? Current isolation level is READ-COMMITTED
Mar
23
comment CONCURRENT SELECT's SLOW … LOCK IN SHARE MODE
Rick, Thanks for your time. My SELECT 1 took 3.5 Hours to completed. My main question is not how to speed this up, instead why this SELECT 1 is that much slow ?
Mar
23
revised CONCURRENT SELECT's SLOW … LOCK IN SHARE MODE
added 716 characters in body
Mar
23
awarded  Custodian
Mar
23
reviewed Approve CONCURRENT SELECT's SLOW … LOCK IN SHARE MODE
Mar
23
comment CONCURRENT SELECT's SLOW … LOCK IN SHARE MODE
Rick, There is a primary key on (type) but not on (type, stamp). There is no useful key on (stamp).
Mar
23
asked CONCURRENT SELECT's SLOW … LOCK IN SHARE MODE
Mar
13
awarded  Tumbleweed
Mar
13
accepted What if we skip the slave by counter 1 when it failed at event 1 of a transaction which has events 2 and 3
Mar
12
asked What if we skip the slave by counter 1 when it failed at event 1 of a transaction which has events 2 and 3
Mar
12
comment Can we disable binary logging for one specific session or user in AWS RDS
IGGt, thanks for ur inputs. As per AWS MYSQL RDS, they said they cant disable session level bin logging as it required SUPER privilege. NOTE: AWS RDS doesnt support SUPER privilege.
Mar
12
asked Can we disable binary logging for one specific session or user in AWS RDS
Mar
6
asked What does “Latest Restore Time” says in AWS RDS(Mysql) instances page
Feb
23
accepted How pt-online-schema-change ensures consistency during data copy
Feb
23
comment How pt-online-schema-change ensures consistency during data copy
ur answer is wonderfull Jynus.
Feb
22
revised How pt-online-schema-change ensures consistency during data copy
deleted 25 characters in body