Willem Renzema's user avatar
Willem Renzema's user avatar
Willem Renzema's user avatar
Willem Renzema
  • Member for 10 years, 9 months
  • Last seen this week
19 votes
Accepted

Why does this query result in deadlock?

11 votes
Accepted

Is there a performance benefit to use tinyint instead of int for Primary Key?

7 votes

SUM() ignores GROUP BY and sums up 4 rows instead of 2

5 votes
Accepted

Why is making the LEFT JOIN ON(...AND...) this query slow?

5 votes
Accepted

MySQL - wait_timeout variable

5 votes

Anyone understand why this query no longer works?

5 votes
Accepted

Which columns should be indexed when all may be used in different search queries?

4 votes
Accepted

Cannot login in as root user after MySQL installation (RHEL)

3 votes
Accepted

Why does this MySQL query take 25+ seconds?

3 votes

Mysql GROUP BY is really slow on a simple view

3 votes
Accepted

How to search one bible verse from a source that may contain ranges?

3 votes
Accepted

How to have a "kinda" unique column

3 votes
Accepted

I need help creating an index for timestamp

3 votes

Different behavior between MySQL 5.5 and 5.6

3 votes

How can I enable/disable MySQL slow query logging on Amazon RDS without restarting

3 votes
Accepted

What indexes to use for GroupWise max

3 votes
Accepted

MySQL - unique constraints design

2 votes
Accepted

What does this deadlock report from MySQL mean?

2 votes
Accepted

I get a query error 'unknown column' while the column exists

2 votes
Accepted

Column type unknown at creation time

2 votes
Accepted

Does ACID guarantee locking (semaphore) until the transaction is commited?

2 votes

MySQL query for 3 consecutive integers between records

2 votes
Accepted

Whats the name for columns which purpose is not to identify?

2 votes
Accepted

Am I clearing the query cache correctly?

2 votes

I need to remove duplicate values SQL Left Join

1 vote
Accepted

MySQL JOIN query takes too much time to get the result

1 vote

Constant deadlocks on a high load table

1 vote

MySQL query is taking a long time

1 vote
Accepted

MySQL not using indexes

1 vote
Accepted

Why Output is wrong after doing the left join as subquery