DTest

Knoxville, TN

Age: 33

Derek Downey is a DevOps consultant with Pythian and is excited about helping teams work together efficiently and effectively. He is especially interested in automation and tooling to simplify operations of infrastructure on-premise and within cloud/virtualized environments.

Prior to moving into DevOps, Derek was a Principal Consultant for the OpenSource technology group at Pythian, interacting daily with some of the brightest minds in the Relational Database and NoSQL world, as well as researching new technologies and methods for maintaining MySQL environments for the myriad of use-cases required by Pythian's clientele.

18h
awarded Notable Question
Feb
3
reviewed No Action Needed Unused Indexes Best Practices
Feb
3
reviewed No Action Needed Mariadb uses all /tmp space
Feb
3
reviewed Leave Open Enforce NOT NULL for set of columns with a CHECK constraint only for new rows
Jan
30
awarded Nice Answer
Jan
20
comment MySQL Slave database size >> Master Database
More likely, it is the way the applications utilize the environments is the cause of the discrepancy. Some causes can be "fixed" by updating the replication configuration, others require application changes.
Jan
20
answered MySQL Slave database size >> Master Database
Jan
20
answered MySQL: Why is ibdata file growing? How can we shrink it?
Jan
20
reviewed Close Postgresql cannot drop trigger
Jan
19
reviewed Close How to export Data from ListBox to text file?
Jan
19
reviewed Close Select Max in stored procedure
Jan
19
reviewed Close Postgresql Encryption by middleware
Jan
19
reviewed Close SQL design for hierarchical structure where parent unit should not exist without subunits
Jan
19
reviewed Leave Open How do I write this query?
Jan
19
reviewed Close Displaying Distinct Max Value autonumber rows from tables in MySql
Jan
19
comment Displaying Distinct Max Value autonumber rows from tables in MySql
what do you mean by 'maximim value of sno column'? Do you mean maximum value for each fir_sno?
Jan
16
reviewed Leave Open Update multiple rows with different columns
Jan
14
reviewed Close Remove parent and child rows if child or parent fits criteria
Jan
14
reviewed Leave Open How to transpose rows to column in datatabse
Jan
11
awarded Notable Question
1 2 3 4 5