Reputation
12,605
Top tag
Next privilege 15,000 Rep.
Protect questions
Badges
4 37 76
Newest
 Good Answer
Impact
~1.2m people reached

1d
answered MariaDB/InnoDB: What to do on “Locks in Status-Log but no locked table found”
Apr
16
awarded  Good Answer
Apr
10
comment Dynamic change to innodb_flush_log_at_trx_commit
@Pacerier In general, changing any GLOBAL dynamic variable that has a corresponding SESSION variable won't affect currently connected sessions.
Mar
18
answered MongoDb Upgrade from 2.6 to 3.0 Issue
Mar
18
answered MySQL running fine while data files (disk) are not present. Data folder nowhere to be found
Feb
13
awarded  Enlightened
Feb
13
awarded  Nice Answer
Feb
11
awarded  Nice Question
Feb
8
awarded  Enlightened
Feb
8
awarded  Nice Answer
Jan
28
awarded  Notable Question
Jan
5
awarded  Yearling
Dec
15
comment MYSQL binary log file not capturing in slave machine
log_slave_updates=1; then restart.
Dec
12
answered MYSQL binary log file not capturing in slave machine
Dec
11
comment MySQL Latest Deadlock Explanation
I wouldn't recommend removing the unique constraint, no. Instead find a proper way to handle deadlocks For starters, you should be re-applying transactions that result in deadlock. Beyond that, depending on your environment, there are settings that might make sense to disable gap locking
Dec
11
answered MySQL Latest Deadlock Explanation
Dec
11
answered Database structure setup
Nov
26
awarded  Nice Answer
Nov
13
awarded  Nice Question
Nov
4
awarded  Nice Answer