Network profile

Patrick

Reputation

3,869

3.9k
3.2k
2.6k

2017
2018
2019
2020

Top tag

mysql

Next privilege

5,000 Rep.

Approve tag wiki edits

Badges

7

24

25

Newest

Yearling

Next badge

0/1

Impact

0 posts edited

1 helpful flag

16 votes cast

Questions (13)

Votes Activity Newest

184	How can I optimize a mysqldump of a large database?
43	In MySQL, does the order of the columns in a WHERE clause affect query performance?
40	How long is “too long” for MySQL Connections to sleep?
28	MySQL InnoDB crash post-mortem
9	What does COUNT(1) actually count? [duplicate]

View more →

Reputation (3,869)

+10	In MySQL, does the order of the columns in a WHERE clause affect query performance?
+20	How can I optimize a mysqldump of a large database?
+10	What does COUNT(1) actually count?
+10	How long is “too long” for MySQL Connections to sleep?

View more →

Answers (5)

Votes Activity Newest

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

Tags (25)

18 mysql × 14	8 erd
16 innodb × 6	8 tree
9 myisam	7 primary-key
8 database-design × 2	4 feature-comparison
8 relational-theory	4 null

View more →

Bookmarks (1)

Votes Activity Newest Views Added

103	Where are some useful SQL puzzles to teach SQL in a workplace?

Accounts (16)

	Database Administrators	3,869 rep	7 gold badges24 silver badges25 bronze badges
	Stack Overflow	3,027 rep	1 gold badge26 silver badges44 bronze badges
	Software Engineering	2,922 rep	2 gold badges18 silver badges24 bronze badges
	Motor Vehicle Maintenance & Repair	2,562 rep	1 gold badge22 silver badges25 bronze badges
	Christianity	2,121 rep	2 gold badges16 silver badges15 bronze badges

Badges (23)

Recent Class Name

Yearling × 9	Great Question
Good Question × 4	Popular Question × 9
Stellar Question	Nice Question × 4
Notable Question × 8	Curious
Famous Question × 5	Favorite Question

View more →

Active bounties (0)

Active Offered Earned

This user has no active bounties

Votes cast (16)

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

Database Administrators Stack Exchange works best with JavaScript enabled