11,557 reputation
43165
bio website
location Knoxville, TN
age 31
visits member for 3 years, 6 months
seen 20 hours ago

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.


Jul
19
awarded  Nice Answer
Jul
3
awarded  Favorite Question
Jul
2
awarded  Curious
Jun
27
comment Audit DML operations on MySQL Tables
what version of MySQL?
Jun
26
awarded  Nice Question
Jun
12
awarded  Notable Question
Jun
7
awarded  Notable Question
Jun
6
reviewed Leave Closed Search, filter and group across all columns in a tall and wide dataset quickly
Jun
6
reviewed Approve suggested edit on ZLM 7.3, postgres database must be vacuumed within x transactions
Jun
4
reviewed Leave Closed Split a very large SQL table to multiple smaller tables
Jun
4
comment Only “grant usage”, but can still select, drop, create?
Any entries in mysql.db for the user?
Jun
4
answered percona xtrabackup to backup mysql database
Jun
4
reviewed Close Split a very large SQL table to multiple smaller tables
Jun
4
comment Refactoring IN Subquery, Avoiding Query in a Loop
'ALL' in this case is just for the outer SELECT that you're doing a GROUP BY, hence the 'tempory table;filesort' It's not as bad as you think. If you could post the SHOW CREATE TABLE statements for divisionfsk, participant and eb tables, that would be helpful.
Jun
4
answered MySQL Database replication for high availability
Jun
3
reviewed Approve suggested edit on Backup failed due to lack of hard drive space…how?
Jun
3
reviewed Close Script to Output Tables to CSV Showing Heading Only Once
Jun
2
reviewed Close SQL Server “TOP 101” much slower than “TOP 100”
Jun
2
reviewed Close How to Find All SQL Server database back list in my system?
Apr
15
comment Fan-In replication 4 Master -> 1 slave
+1 for mariadb 10.0GA and tungsten.