DTest

Knoxville, TN

orange-pants.com

Age: 32

I started my professional career as a PHP application developer. A few years later, as the company I worked for grew, I started migrating into the server world. Now I find myself as the DBA and beginner Server Admin.

4h
awarded Popular Question
Apr
24
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.
Apr
7
awarded Notable Question
Apr
5
awarded Notable Question
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
Mar
5
awarded Popular Question
Feb
18
awarded Famous Question
Feb
13
awarded Enlightened
Feb
13
awarded Nice Answer
Feb
11
awarded Nice Question
Jan
28
awarded Notable Question
Jan
5
awarded Yearling
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
1 2 3 4 5