ursitesion's user avatar
ursitesion's user avatar
ursitesion's user avatar
ursitesion
  • Member for 9 years, 10 months
  • Last seen more than a month ago
61 votes
6 answers
221k views

Why use WHERE 1 or WHERE 1=1?

48 votes
6 answers
153k views

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

16 votes
3 answers
57k views

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

11 votes
3 answers
40k views

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

5 votes
2 answers
20k views

Difference between show status and show global status in mysql

5 votes
1 answer
8k views

MySQL: What is SQL mode and why we use it

4 votes
1 answer
7k views

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

3 votes
1 answer
3k views

How performance schema in mysql 5.6 improve performance?

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

3 votes
1 answer
2k views

Do triggers affect DB performance

2 votes
3 answers
11k views

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

2 votes
1 answer
1k views

What does this mean - ~/.my.cnf

2 votes
3 answers
3k views

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

2 votes
1 answer
73 views

Unable to start mysql

2 votes
1 answer
3k views

InnoDB engine is not loading after tuning parameters

2 votes
1 answer
5k views

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

2 votes
1 answer
1k views

MongoDB: how to create a new database

1 vote
1 answer
434 views

Do threads in cache still use memory?

1 vote
1 answer
4k views

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

1 vote
0 answers
964 views

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

1 vote
0 answers
336 views

MySQl: slow query is not using index in joining

1 vote
2 answers
4k views

MySQL: why assign NULL as default value

1 vote
0 answers
139 views

MySQL: Sometimes query failed to use index

1 vote
1 answer
3k views

Different thread states in query execution

1 vote
1 answer
1k views

MySQL 5.1: Upgrade innodb plugin

1 vote
2 answers
10k views

How to trace a MySQL session like in Oracle

1 vote
1 answer
4k views

MySQL: How index speed up query execution

0 votes
1 answer
535 views

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

0 votes
1 answer
3k views

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

0 votes
1 answer
2k views

MySQL: How turning off the logging affect the performance?