User ursitesion

61 votes

6 answers

221k views

Why use WHERE 1 or WHERE 1=1?

asked Dec 13, 2013 at 11:32

50 votes

6 answers

158k views

Why do we use Group by 1 and Group by 1,2,3 in SQL query?

asked Dec 19, 2014 at 11:56

18 votes

3 answers

59k views

MySQL: Which join is better between left outer join and inner join

asked Aug 4, 2014 at 8:22

12 votes

3 answers

40k views

Is there any command to optimize all MySQL tables one by one automatically?

asked Apr 27, 2014 at 15:48

5 votes

2 answers

21k views

Difference between show status and show global status in mysql

asked Dec 3, 2013 at 11:46

5 votes

1 answer

8k views

MySQL: What is SQL mode and why we use it

asked Jan 23, 2014 at 18:49

4 votes

1 answer

7k views

Difference between [mysql] and [mysqld] in MySQL configuration file

asked Apr 27, 2014 at 11:45

3 votes

1 answer

3k views

How performance schema in mysql 5.6 improve performance?

asked Jul 11, 2014 at 16:37

3 votes

1 answer

2k views

Is there any difference between these two version of MySQL - 5.1.73-community-log Vs 5.1.73-community

asked Apr 23, 2014 at 17:43

3 votes

1 answer

2k views

Do triggers affect DB performance

asked May 6, 2014 at 7:39

2 votes

3 answers

11k views

MySQL: How to avoid case sensitivity in SQL queries when migrate from Windows to Linux?

asked May 8, 2014 at 5:23

2 votes

1 answer

1k views

What does this mean - ~/.my.cnf

asked Apr 24, 2014 at 6:36

2 votes

3 answers

3k views

MySQL: fetch multiple global status and system variable in a single query

asked Dec 13, 2013 at 11:16

2 votes

1 answer

73 views

Unable to start mysql

asked Apr 22, 2014 at 6:43

2 votes

1 answer

3k views

InnoDB engine is not loading after tuning parameters

asked Apr 30, 2014 at 20:39

2 votes

1 answer

5k views

MySQL: What is the most optimized way to use datetime type field in query

asked Dec 23, 2013 at 14:19

2 votes

1 answer

1k views

MongoDB: how to create a new database

asked Sep 4, 2014 at 6:17

1 vote

1 answer

445 views

Do threads in cache still use memory?

asked Oct 1, 2014 at 15:37

1 vote

1 answer

4k views

MySQL: What do we mean by 0 value in in_use column of show open tables statement?

asked Oct 7, 2014 at 10:05

1 vote

0 answers

979 views

Copying a table with its structure, indexes, and associated triggers?

asked Aug 12, 2014 at 7:54

1 vote

0 answers

336 views

MySQl: slow query is not using index in joining

asked Dec 9, 2013 at 17:37

1 vote

2 answers

4k views

MySQL: why assign NULL as default value

asked Dec 17, 2013 at 11:28

1 vote

0 answers

139 views

MySQL: Sometimes query failed to use index

asked Feb 3, 2014 at 13:10

1 vote

1 answer

4k views

Different thread states in query execution

asked Feb 11, 2014 at 17:06

1 vote

1 answer

1k views

MySQL 5.1: Upgrade innodb plugin

asked Mar 21, 2014 at 10:36

1 vote

2 answers

10k views

How to trace a MySQL session like in Oracle

asked Mar 26, 2014 at 15:08

1 vote

1 answer

4k views

MySQL: How index speed up query execution

asked Aug 4, 2014 at 7:21

0 votes

1 answer

548 views

MySQL: What is SQL profiler, does it different for MySQL?

asked Aug 4, 2014 at 14:50

0 votes

1 answer

3k views

Is it possible to uninsall MySQL-5.6 and install MySQL-5.1 on RHEL 5

asked Jul 22, 2014 at 12:12

0 votes

1 answer

2k views

MySQL: How turning off the logging affect the performance?

asked Jul 30, 2014 at 11:53

Stack Exchange Network

46 Questions

Why use WHERE 1 or WHERE 1=1?

Why do we use Group by 1 and Group by 1,2,3 in SQL query?

MySQL: Which join is better between left outer join and inner join

Is there any command to optimize all MySQL tables one by one automatically?

Difference between show status and show global status in mysql

MySQL: What is SQL mode and why we use it

Difference between [mysql] and [mysqld] in MySQL configuration file

How performance schema in mysql 5.6 improve performance?

Is there any difference between these two version of MySQL - 5.1.73-community-log Vs 5.1.73-community

Do triggers affect DB performance

MySQL: How to avoid case sensitivity in SQL queries when migrate from Windows to Linux?

What does this mean - ~/.my.cnf

MySQL: fetch multiple global status and system variable in a single query

Unable to start mysql

InnoDB engine is not loading after tuning parameters

MySQL: What is the most optimized way to use datetime type field in query

MongoDB: how to create a new database

Do threads in cache still use memory?

MySQL: What do we mean by 0 value in in_use column of show open tables statement?

Copying a table with its structure, indexes, and associated triggers?

MySQl: slow query is not using index in joining

MySQL: why assign NULL as default value

MySQL: Sometimes query failed to use index

Different thread states in query execution

MySQL 5.1: Upgrade innodb plugin

How to trace a MySQL session like in Oracle

MySQL: How index speed up query execution

MySQL: What is SQL profiler, does it different for MySQL?

Is it possible to uninsall MySQL-5.6 and install MySQL-5.1 on RHEL 5

MySQL: How turning off the logging affect the performance?