12,127 reputation
43273
bio website
location Knoxville, TN
age 32
visits member for 3 years, 11 months
seen yesterday

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
Nov
26
awarded  Nice Answer
Nov
13
awarded  Nice Question
Nov
4
awarded  Nice Answer
Oct
21
awarded  Nice Question
Sep
30
awarded  Explainer
Sep
5
awarded  Popular Question
Sep
3
awarded  Good Answer
Sep
3
awarded  Popular Question
Aug
13
awarded  Nice Answer
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 :)
Aug
12
comment Restoring data from dumped sql file gives: mysql: unknown option '--innodb_file_per_table
What version of MySQL?
Aug
6
comment MySQL buffer pool usage + high load
Specifically, I am referring to the swapping that might occur to a full innodb_buffer_pool. Read the last update of this answer to see if multiple innodb_buffer_pool_instances makes sense for you: dba.stackexchange.com/a/1185/180
Aug
6
comment MySQL buffer pool usage + high load
Did you notice any swapping leading up to this point? What's swappiness set to?
Jul
19
awarded  Nice Answer
Jul
3
awarded  Favorite Question