Derek Downey

less info
meta site favicon meta user | stack exchange network profile network profile
9,882 reputation
42256
bio website orange-pants.com
location Knoxville, TN
age 30
visits member for 2 years, 4 months
seen 11 hours ago
stats profile views 635

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.


1,563 Actions

suggestions reviews revisions comments badges posts accepts all
1d
 awarded  Constituent
May
13
 awarded  Caucus
May
3
 reviewed Leave Open Daily and Differential Backups
May
3
 comment Does MySQL 5.6 support fan-in replication?
it looks like you need to update to the 3rd edition ;)
May
3
 answered Index on a query with order
May
2
 comment Trigger not firing when deleting a record from stored procedure MySql
That's interesting. It might be doing something funky since it is MyISAM, which doesn't support transactions (which you use in the stored procedure). Could you test to see if it works outside the START TRANSACTION...COMMIT block, but still within the stored procedure?
May
2
 reviewed No Action Needed How to retrieve the definition behind statistics added to tables
May
2
 reviewed Reviewed How do I selectively purge MySQL table rows using a list of coloum values?
May
2
 comment How do I selectively purge MySQL table rows using a list of coloum values?
This will do it, but fair warning that this will be very slow depending on what OP's definition of 'large' is.
May
2
 reviewed Leave Open Indexes file damaged, was on ramdisk
May
2
 reviewed Leave Open CPU column 5x higher on one machine vs another?
May
2
 reviewed Close Oracle Connection Manager Configuration
May
2
 reviewed Close Trying to write a function that doesn't require dbo. prefix
May
2
 reviewed Leave Open Shrinking the log file does not reduce size
May
2
 reviewed Approve suggested edit on MariaDB and XtraDB/InnoDB plugins
May
2
 reviewed Reject suggested edit on Breaking Semisynchronous Replication in MySQL 5.5
May
2
 reviewed Reject suggested edit on “freeing items” taking forever on inserts, updates and deletes
May
2
 reviewed Approve suggested edit on Does Pt-table-checksum point out rows that are different from that of the Master
May
2
 answered Trigger not firing when deleting a record from stored procedure MySql
May
1
 answered Challenge. Split database 500 records in two smaller datasets, randomly
1 2 3 4 5 … 79