Derek Downey

less info
meta site favicon meta user | stack exchange network profile network profile
10,023 reputation
42256
bio website orange-pants.com
location Knoxville, TN
age 30
visits member for 2 years, 5 months
seen 15 hours ago
stats profile views 666

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.


256 Answers

newest activity votes
19
INT(5) vs SMALLINT(5)
jan 7 '11 at 4:39
15
How can I move a database from one server to another?
sep 18 '11 at 23:58
14
How do convert a 66,862,521 row table from MyISAM to InnoDB without going offline for several hours?
jan 9 '11 at 21:55
13
Is MySql's LAST_INSERT_ID() function guaranteed to be correct?
jul 19 '12 at 18:07
13
Why is Database Administration so hard?
may 24 '11 at 13:53
11
Why don't my .my.cnf settings work?
may 19 '11 at 16:00
10
Is it possible to have passwords configured per database or per host in .my.cnf
aug 23 '11 at 13:30
9
Advantages and Disadvantages to using ENUM vs Integer types?
oct 19 '11 at 16:20
7
When to use views in MySQL?
apr 11 '12 at 19:44
7
Write a slow query to test slow query logging?
nov 11 '11 at 17:04
7
How do you identify InnoDB table corruption?
sep 30 '11 at 0:45
7
Modify DEFINER on Many Views
jul 26 '11 at 19:05
7
How much will using a varchar(15) PK affect my tables performance?
may 6 '11 at 14:01
6
How do you calculate mysql max_connections variable?
feb 15 '11 at 17:42
6
does max_connect_errors not check Aborted_connects?
nov 14 at 19:24
6
how to use a different tmp dir for INTO OUTFILE select with MySQL?
aug 28 at 14:56
6
What's the latest on MySQL Proxy?
apr 19 '12 at 13:22
6
Which version of MySQL should I use?
jan 19 '12 at 17:17
6
Query runs a long time in some newer MySQL versions
oct 5 '11 at 13:08
6
Deleting all duplicates
sep 16 '11 at 13:46
6
Should fields that aren't needed often be kept in separate tables?
sep 15 '11 at 20:29
6
Would it be sensible to create a MySQL user for each user account of a web application?
jun 16 '11 at 15:03
6
How do I show the binlog_format on a MySQL server?
may 12 '11 at 15:03
6
Avoiding temporary tables while sorting by a column in a different table
apr 12 '11 at 16:27
5
How to categorize rows by SUM of a column in mysql?
dec 17 at 18:37
5
Error 1046 Mariadb: No database selected
oct 19 at 14:31
5
How does mysql decide if concurrent insert is possible for a MyISAM table?
jul 11 '12 at 22:01
5
MySQL console: Ctrl+C driving me nuts
jul 9 '12 at 15:20
5
How should I interpret the “lock time” within mysql slow query log?
feb 21 '12 at 15:14
5
Usage of RESTRICT or No ACTION in FOREIGN KEY Constraints
feb 21 '12 at 14:54
1 2 3 4 5 … 9