Network profile

Patrick

Reputation

3,929

3.9k
3.4k
2.8k

2018
2019
2020
2021

Top tag

mysql

Next privilege

5,000 Rep.

Approve tag wiki edits

Badges

7

25

25

Newest

Yearling

Next badge

0/1

Impact

0 posts edited

1 helpful flag

16 votes cast

Questions (13)

Votes Activity Newest

189	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?
41	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,929)

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

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 relational-theory
16 innodb × 6	8 erd
9 myisam	7 primary-key
8 database-design × 2	4 feature-comparison
8 tree	4 null

View more →

Bookmarks (1)

Votes Activity Newest Views Added

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

Accounts (16)

	Database Administrators	3,929 rep	7 gold badges25 silver badges25 bronze badges
	Stack Overflow	3,027 rep	2 gold badges27 silver badges44 bronze badges
	Software Engineering	2,922 rep	2 gold badges19 silver badges24 bronze badges
	Motor Vehicle Maintenance & Repair	2,572 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 × 10	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