Database Administrators

Notable Question

 Notable Question
Question with 2,500 views. This badge can be awarded multiple times.

earned this badge 20 times.
MySQL: What do we mean by 0 value in in_use column of show open tables statement?
Awarded Jan 13, 2021 at 23:25
Different thread states in query execution
Awarded Dec 28, 2020 at 9:56
MySQL: fetch multiple global status and system variable in a single query
Awarded Dec 15, 2020 at 22:26
InnoDB engine is not loading after tuning parameters
Awarded Aug 19, 2020 at 11:05
MySQL: why assign NULL as default value
Awarded Dec 4, 2019 at 17:15
How performance schema in mysql 5.6 improve performance?
Awarded Sep 8, 2018 at 6:40
MySQL: How index speed up query execution
Awarded Jun 18, 2018 at 10:08
MySQL: How to fetch nth level child menus of a parent menu
Awarded Apr 2, 2018 at 15:23
MySQL: What is the most optimized way to use datetime type field in query
Awarded Aug 19, 2017 at 3:55
Difference between [mysql] and [mysqld] in MySQL configuration file
Awarded Jul 10, 2017 at 9:09
MySQL: What is SQL mode and why we use it
Awarded Jun 30, 2017 at 21:19
MySQL: How to avoid case sensitivity in SQL queries when migrate from Windows to Linux?
Awarded Nov 4, 2016 at 19:38
Is it possible to uninsall MySQL-5.6 and install MySQL-5.1 on RHEL 5
Awarded Aug 2, 2016 at 11:32
How to trace a MySQL session like in Oracle
Awarded Oct 14, 2015 at 22:27
Difference between show status and show global status in mysql
Awarded Oct 5, 2015 at 14:08
Why do we use Group by 1 and Group by 1,2,3 in SQL query?
Awarded Sep 15, 2015 at 3:59
MySQL 5.1: change datadir variable value in my.cnf
Awarded Aug 19, 2015 at 0:08
MySQL: Which join is better between left outer join and inner join
Awarded Jul 23, 2015 at 20:29
Is there any command to optimize all MySQL tables one by one automatically?
Awarded Mar 12, 2015 at 2:17
Why use WHERE 1 or WHERE 1=1?
Awarded Jun 25, 2014 at 16:28

Others with this badge

Your privacy

By clicking “Accept all cookies”, you agree Stack Exchange can store cookies on your device and disclose information in accordance with our Cookie Policy.