Dinesh Kumar's user avatar
Dinesh Kumar's user avatar
Dinesh Kumar's user avatar
Dinesh Kumar
  • Member for 5 years, 8 months
  • Last seen more than a week ago
  • Chennai, Tamil Nadu, India
7 votes
1 answer
3k views

Order of Execution of Set clause in Update Query (Postgres)

5 votes
1 answer
15k views

Performance difference between Text and Varchar in Mysql

5 votes
1 answer
592 views

Standard Behaviour for mix of 'ON-DELETE-CASCADE' and 'ON-DELETE-RESTRICT' constraints in Mysql

5 votes
2 answers
3k views

Gap Locking in Read Committed isolation level in Mysql

4 votes
1 answer
1k views

How locks in Postgres behave when quitting the JVM abnormally

3 votes
1 answer
1k views

Row Locking in Postgres

3 votes
1 answer
330 views

Performance difference in accessing differrent columns in a Postgres Table

3 votes
1 answer
4k views

Are utf8_bin and utf8_general_cs the same?

2 votes
1 answer
473 views

Performance of mysql equi-join observed in HDD and SSD

2 votes
2 answers
1k views

Creating same unique constraint with different names

2 votes
1 answer
116 views

Range Extraction Algorithm for Muti-Part aka Composite Indexes in MySQL

2 votes
1 answer
419 views

Range Optimizer in Mysql: What is an Index dive during Query Optimization?

1 vote
0 answers
763 views

Standard behaviour in executing multiple alter statements in Postgres

1 vote
0 answers
2k views

What does 'innodb_buffer_pool_reads' and 'innodb_buffer_pool_read_requests' actually mean?

1 vote
1 answer
12k views

Deleting multiple tables in a single delete query in Mysql

1 vote
2 answers
2k views

How to understand Composite Primary Key when it comes to storage (in Mysql)?

1 vote
1 answer
482 views

How are page splits determined internally in MySQL?

0 votes
1 answer
105 views

Need some insights on 'index_page' variables in Innodb_Metrics Table

0 votes
2 answers
273 views

No 'Copying to tmp table' state in profiling a mysql query

0 votes
1 answer
305 views

How does DYNAMIC Row format handle NULL storage MYSQL 5.7?

0 votes
1 answer
4k views

Updating Multiple Tables with single Update query [duplicate]

0 votes
1 answer
321 views

Having multiple ResultSets in parallel on same connection.. Will it cause any problem? [Mysql/Postgres] [closed]

0 votes
1 answer
311 views

How many row level locks can I have to same row?

0 votes
0 answers
33 views

When will 'Max_execution_time_set_failed' status variable be incremented in Mysql?

0 votes
2 answers
237 views

Row size limits in Mysql w.r.t to TEXT and BLOB columns