User Patrick - Database Administrators Stack Exchange

Patrick

Member for 13 years, 3 months
Last seen more than 1 year ago

Twitter
techore.com
Atlanta, GA

13 Questions

Score Activity Newest Views

207 votes

7 answers

300k views

How can I optimize a mysqldump of a large database?

asked Jan 3, 2011 at 21:13

49 votes

6 answers

45k views

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

asked Mar 17, 2011 at 20:56

43 votes

1 answer

144k views

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

asked Mar 3, 2011 at 20:37

29 votes

4 answers

17k views

MySQL InnoDB crash post-mortem

asked Sep 28, 2012 at 2:54

10 votes

1 answer

47k views

What does COUNT(1) actually count? [duplicate]

asked May 8, 2012 at 16:43

8 votes

6 answers

2k views

Alternative Database Tools for Web Admin [closed]

asked Jan 4, 2011 at 3:03

8 votes

3 answers

9k views

Changed max_allowed_packet and still receiving 'Packet Too Large' error

asked Jan 26, 2011 at 2:51

6 votes

2 answers

482 views

different login credentials based on user

asked Jan 5, 2011 at 16:28

6 votes

1 answer

5k views

MySQL INNODB SELECT query hanging on copying to tmp table

asked Feb 22, 2011 at 16:50

3 votes

3 answers

1k views

Storing a large number of small size entries in MySQL

asked Jan 27, 2011 at 14:59

3 votes

2 answers

557 views

Can I use a foreign key index as a shortcut to getting a row count in an INNODB table?

asked Nov 29, 2012 at 6:14

2 votes

1 answer

4k views

How to update mysql my.cnf without getting error?

asked Feb 11, 2012 at 22:09

1 vote

2 answers

230 views

What is proper database design for a drupal table with an order field?

asked May 29, 2013 at 20:07