User Willem Renzema

19 votes

Accepted

Why does this query result in deadlock?

answered Jul 4, 2018 at 11:27

10 votes

Accepted

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

answered Jul 18, 2018 at 4:29

7 votes

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

answered Jun 24, 2017 at 14:58

5 votes

Accepted

MySQL - wait_timeout variable

answered Oct 23, 2017 at 18:36

5 votes

Accepted

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

answered May 3, 2017 at 7:42

5 votes

Anyone understand why this query no longer works?

answered Dec 4, 2018 at 21:01

5 votes

Accepted

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

answered Feb 6, 2019 at 18:44

4 votes

Accepted

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

answered Aug 14, 2019 at 2:48

3 votes

Accepted

How to have a "kinda" unique column

answered Aug 16, 2019 at 16:16

3 votes

Accepted

Why does this MySQL query take 25+ seconds?

answered Jun 16, 2019 at 2:13

3 votes

Accepted

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

answered Sep 15, 2019 at 21:09

3 votes

Mysql GROUP BY is really slow on a simple view

answered Dec 15, 2019 at 12:57

3 votes

Accepted

I need help creating an index for timestamp

answered Oct 9, 2018 at 14:50

3 votes

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

answered Nov 24, 2016 at 9:28

3 votes

Accepted

What indexes to use for GroupWise max

answered Apr 10, 2016 at 21:24

3 votes

Accepted

MySQL - unique constraints design

answered Aug 16, 2013 at 17:33

3 votes

Different behavior between MySQL 5.5 and 5.6

answered Mar 28, 2016 at 10:30

2 votes

Accepted

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

answered Nov 28, 2015 at 5:27

2 votes

Accepted

What does this deadlock report from MySQL mean?

answered Dec 23, 2015 at 11:15

2 votes

Accepted

Column type unknown at creation time

answered Jun 12, 2013 at 13:55

2 votes

MySQL query for 3 consecutive integers between records

answered Oct 22, 2017 at 2:37

2 votes

Accepted

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

answered Apr 4, 2018 at 19:45

2 votes

Accepted

Am I clearing the query cache correctly?

answered May 16, 2018 at 18:47

2 votes

Accepted

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

answered Apr 12 at 4:26

2 votes

I need to remove duplicate values SQL Left Join

answered Sep 21, 2019 at 16:55

1 vote

Accepted

MySQL JOIN query takes too much time to get the result

answered Oct 24, 2019 at 13:52

1 vote

Constant deadlocks on a high load table

answered Nov 20, 2019 at 10:17

1 vote

MySQL query very slow with multiple concurrent users in a short time

answered Dec 4, 2019 at 1:31

1 vote

Accepted

Why Output is wrong after doing the left join as subquery

answered Mar 16, 2019 at 13:41

1 vote

MySQL query is taking a long time

answered Aug 27, 2019 at 13:24

Stack Exchange Network

52 Answers

Why does this query result in deadlock?

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

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

MySQL - wait_timeout variable

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

Anyone understand why this query no longer works?

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

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

How to have a "kinda" unique column

Why does this MySQL query take 25+ seconds?

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

Mysql GROUP BY is really slow on a simple view

I need help creating an index for timestamp

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

What indexes to use for GroupWise max

MySQL - unique constraints design

Different behavior between MySQL 5.5 and 5.6

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

What does this deadlock report from MySQL mean?

Column type unknown at creation time

MySQL query for 3 consecutive integers between records

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

Am I clearing the query cache correctly?

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

I need to remove duplicate values SQL Left Join

MySQL JOIN query takes too much time to get the result

Constant deadlocks on a high load table

MySQL query very slow with multiple concurrent users in a short time

Why Output is wrong after doing the left join as subquery

MySQL query is taking a long time