Patrick

less info

network profile

811 reputation

11019

bio	website	techore.com
	location	Atlanta, GA
	age	32
visits	member for	2 years, 4 months
	seen	May 14 at 18:27
stats	profile views	39

PHP web developer for sharecare, maker of medical Q&A sites.

summary answers questions tags badges favorites bounties reputation activity

12 Questions

votes activity newest

43	How can I optimize a mysqldump of a large database?
10	In MySQL, does the order of the columns in a WHERE clause affect query performance?
7	MySQL InnoDB crash post-mortem
7	Alternative Database Tools for Web Admin
6	How long is “too long” for MySQL Connections to sleep?

view more

811 Reputation

+15	How long is “too long” for MySQL Connections to sleep?
+15	How can I optimize a mysqldump of a large database?
+10	Can I use a foreign key index as a shortcut to getting a row count in an INNODB table?
+5	MySQL InnoDB crash post-mortem

view more

5 Answers

votes activity newest

7	What are the main differences between InnoDB and MyISAM?
6	What's a good way to add a PRIMARY KEY to a large InnoDB table?
3	How to structure a model to properly and efficiently represent tree-like data on relational databases?
2	Securing DB passwords
2	When to use NULL and when to use an empty string?

24 Tags

15 mysql × 13	3 tree
13 innodb × 6	3 relational
7 myisam	3 erd
6 primary-key	2 security × 2
3 database-design	2 null

view more

13 Accounts

	Motor Vehicle Maintenance & Repair	1,621 rep	719
	Stack Overflow	1,528 rep	820
	Programmers	1,085 rep	515
	Super User	930 rep	718
	Database Administrators	811 rep	11019

20 Badges

recent class name

Notable Question × 4	Famous Question
Favorite Question	Caucus
Popular Question × 6	Nice Question × 2
Yearling × 2	Taxonomist
Custodian	Good Question

view more

0 Active bounties

active offered earned

This user has no active bounties

14 Votes Cast

all time			by type
14	up		0	question
0	down		14	answer

Technology			Life / Arts	Culture / Recreation	Science	Other
Stack Overflow Server Fault Super User Web Applications Ask Ubuntu Webmasters Game Development TeX - LaTeX	Programmers Unix & Linux Ask Different (Apple) WordPress Answers Geographic Information Systems Electrical Engineering Android Enthusiasts IT Security	Database Administrators Drupal Answers SharePoint User Experience Mathematica more (14)	Photography Science Fiction & Fantasy Seasoned Advice (cooking) Home Improvement more (13)	English Language & Usage Skeptics Mi Yodeya (Judaism) Travel Arqade (gaming) Bicycles Role-playing Games more (22)	Mathematics Cross Validated (stats) Theoretical Computer Science Physics more (7)	Stack Apps Meta Stack Overflow Area 51 Stack Overflow Careers

site design / logo © 2013 stack exchange inc; user contributions licensed under cc-wiki with attribution required

rev 2013.5.17.690

Database Administrators Stack Exchange works best with JavaScript enabled