Brett's user avatar
Brett's user avatar
Brett's user avatar
Brett
  • Member for 10 years, 1 month
  • Last seen more than 1 year ago
  • Perth, Australia
4 votes
1 answer
819 views

InnoDB & Isolation Levels - Aren't repeatable reads a bad thing?

4 votes
1 answer
4k views

Cannot access MySQL database after moving files in data directory

3 votes
1 answer
1k views

Is there any reason not to use foreign keys in MySQL?

2 votes
0 answers
577 views

Is not having 'named' timezone support common in MySQL?

2 votes
2 answers
157 views

Optimizing index creation

2 votes
1 answer
189 views

Correct way to write this query?

2 votes
1 answer
61 views

Is there any way you can tell MySQL to set value to 0 if value for unsigned column is < 0?

1 vote
1 answer
36 views

Do queries called from within a transaction but found within another method act the same?

1 vote
0 answers
309 views

Improving database design for category based site

0 votes
0 answers
35 views

Which of these two queries is better - can be optimized more?

0 votes
1 answer
1k views

Restoring old MySQL database settings

0 votes
1 answer
882 views

Am I clearing the query cache correctly?

0 votes
1 answer
96 views

Is it beneficial to include ORDER BY fields in the list of SELECT fields? [closed]