Derek Downey

9,872 reputation

42256

bio	website	orange-pants.com
	location	Knoxville, TN
	age	30
visits	member for	2 years, 4 months
	seen	3 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.

	9,872 reputation	bio	website	orange-pants.com	visits	member for	2 years, 4 months
42256 badges		location	Knoxville, TN		seen	3 hours ago

summary answers questions tags badges favorites bounties reputation activity

253 Answers

votes activity newest

20	INT(5) vs SMALLINT(5)
15	How can I move a database from one server to another?
14	How do convert a 66,862,521 row table from MyISAM to InnoDB without going offline for several hours?
13	Why is Database Administration so hard?
12	Is MySql's LAST_INSERT_ID() function guaranteed to be correct?

9,872 Reputation

+5	How to safely change MySQL innodb variable 'innodb_log_file_size'?
+10	Challenge. Split database 500 records in two smaller datasets, randomly
+10	Index on a query with order
+10	Advantages and Disadvantages to using ENUM vs Integer types?

19 Questions

votes activity newest

22	How to safely change MySQL innodb variable 'innodb_log_file_size'?
11	What is the difference between MySQL VARCHAR and TEXT data types?
10	PostgreSQL Stored Procedure Performance
9	Is it unwise to run replication on same physical server?
9	Is it common practice to mix InnoDB and MyISAM tables on same server?

131 Tags

679 mysql × 250	49 sql × 15
117 innodb × 44	43 query × 15
62 replication × 33	33 mysql-5.5 × 15
60 performance × 22	32 datatypes × 5
49 database-design × 16	30 myisam × 13

20 Accounts

Database Administrators	9,872 rep	42256
Christianity	1,417 rep	526
Server Fault	1,210 rep	1617
Stack Overflow	721 rep	1311
Area 51	251 rep	3

47 Badges

recent class name

Constituent × 3	Famous Question × 2
Caucus × 3	Nice Question × 3
Enlightened × 3	Notable Question × 4
Nice Answer × 7	Popular Question × 10
Proofreader	Yearling × 2

0 Active bounties

active offered earned

This user has no active bounties

1,240 Votes Cast

all time			by type			month
1,204	up		646	question		4
36	down		594	answer		4

user feed