Network profile

Patrick

Reputation

3,819

3.8k
3.2k
2.5k

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

182	How can I optimize a mysqldump of a large database?
42	In MySQL, does the order of the columns in a WHERE clause affect query performance?
39	How long is “too long” for MySQL Connections to sleep?
28	MySQL InnoDB crash post-mortem
8	Changed max_allowed_packet and still receiving 'Packet Too Large' error

View more →

Reputation (3,819)

+70	How can I optimize a mysqldump of a large database?
+20	In MySQL, does the order of the columns in a WHERE clause affect query performance?
+10	What are the main differences between InnoDB and MyISAM?
+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

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

Accounts (16)

	Database Administrators	3,819 rep	7 gold badges24 silver badges25 bronze badges
	Stack Overflow	3,005 rep	1 gold badge26 silver badges43 bronze badges
	Software Engineering	2,922 rep	2 gold badges17 silver badges24 bronze badges
	Motor Vehicle Maintenance & Repair	2,552 rep	1 gold badge22 silver badges25 bronze badges
	Christianity	2,111 rep	2 gold badges15 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