Patrick

Member for 12 years, 3 months
Last seen more than a month ago

Twitter
techore.com
Atlanta, GA

Summary

Reputation

4,179

4.2k
3.8k
3.5k

2020
2021
2022
2023

Top tag

mysql

Next privilege

5,000 Rep.

Approve tag wiki edits

Badges

7

27

27

Newest

Yearling

Next badge

0/1

Excavator

Questions

View all 13 questions

Score Activity Newest Views

203

How can I optimize a mysqldump of a large database?

Jan 3, 2011

49

In MySQL, does the order of the columns in a WHERE clause affect query performance?

Mar 17, 2011

42

How long is "too long" for MySQL Connections to sleep?

Mar 3, 2011

29

MySQL InnoDB crash post-mortem

Sep 28, 2012

10

What does COUNT(1) actually count?

May 8, 2012

Answers

Score Activity Newest

10

What are the main differences between InnoDB and MyISAM?

Jan 3, 2011

8

How to structure a model to properly and efficiently represent tree-like data on relational databases?

Jan 3, 2011

7

What's a good way to add a PRIMARY KEY to a large InnoDB table?

Feb 1, 2011

4

When to use NULL and when to use an empty string?

Jan 4, 2011

2

Securing DB passwords

Jan 4, 2011

Tags

View all 25 tags

mysql

19

Score

14

posts

innodb

17

Score

6

posts

myisam

10

Score

1

post

database-design

8

Score

2

posts

tree

8

Score

1

post

Reputation

This user has no recent positive reputation changes.

Badges

View all badges

7

gold badges

Stellar Question

Apr 19, 2018
Great Question

Feb 27, 2016
Famous Question

× 5

Mar 22, 2016

27

silver badges

Beta

Jan 10, 2011
Favorite Question

Feb 18, 2013
Taxonomist

Jan 22, 2012

27

bronze badges

Quorum

Jan 4, 2011
Curious

Jul 2, 2014
Citizen Patrol

Apr 23, 2011

Accounts

View all 17 accounts

Database Administrators

4,179
7
27
27

3,134
3
30
46

Software Engineering

2,922
2
21
24

Motor Vehicle Maintenance & Repair

2,620
1
25
25

2,211
2
18
16

Active bounties (0)

Active Offered Earned

This user has no active bounties

Votes cast

16

upvotes

16

answer votes