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.

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
Dec
1
awarded Yearling
Nov
30
awarded Notable Question
Nov
26
awarded Nice Answer
Nov
25
awarded Yearling
Nov
25
awarded Yearling
Nov
13
awarded Nice Question
Sep
30
awarded Explainer
Sep
22
awarded Famous Question
Sep
21
awarded Popular Question
Sep
5
awarded Popular Question
Sep
3
awarded Good Answer
Aug
25
awarded Popular Question
Aug
23
awarded Yearling
Aug
23
awarded Yearling
Aug
13
comment Restoring data from dumped sql file gives: mysql: unknown option '--innodb_file_per_table
Hmph, I swear I looked at [mysql] vs [mysqld]. Ah, I did...but you edited it earlier in the process...Oh well, glad you figured it out :)
1 2 3 4 5