Record · corpus.blog/posts/01a08726-5305-70a2-9d3f-f862cfe7d18b

MySQL Query Optimization at Scale

alvincrespo.hashnode.dev · published 1 August 2025

A record is what was published and who pointed at it. The text of the post is not held here: read it at the source, or at its Wayback capture.

Read the post at alvincrespo.hashnode.dev Wayback capture

0blogs citing

First cited: —
Most recent: —
Rank this month: not ranked
External links: 31
Words captured: 17,298

Cited by

No blog we hold has cited this post yet.

Links from this post

Link

Host

http://github.com/alvincrespo/gaming_achievement_system

github.com

https://dev.mysql.com/doc/refman/9.4/en/window-functions.html

dev.mysql.com

https://dev.mysql.com/doc/refman/8.4/en/server-system-variables.html

dev.mysql.com

https://www.mysqltutorial.org/mysql-window-functions/mysql-row_number-function/

mysqltutorial.org

https://www.stratascratch.com/blog/sql-row_number-function-syntax-and-applications/

stratascratch.com

https://topic.alibabacloud.com/a/talking-about-filesort-from-the-mysql-temporary-table_1_41_32118319.html

topic.alibabacloud.com

https://topic.alibabacloud.com/a/mysql-using-filesort-using-temporary_1_41_30009346.html

topic.alibabacloud.com

https://dev.mysql.com/doc/refman/8.4/en/group-by-optimization.html

dev.mysql.com

https://dev.mysql.com/doc/refman/8.4/en/order-by-optimization.html

dev.mysql.com

https://dev.mysql.com/doc/refman/8.4/en/window-functions-usage.html

dev.mysql.com

https://dev.mysql.com/doc/refman/8.4/en/window-function-descriptions.html

dev.mysql.com

https://dev.mysql.com/doc/dev/mysql-server/latest/classFilesort.html

dev.mysql.com

https://dev.mysql.com/blog-archive/filesort-optimization-in-5-7-3-pack-values-in-the-sort-buffer/

dev.mysql.com

https://dev.mysql.com/blog-archive/removal-of-implicit-and-explicit-sorting-for-group-by/

dev.mysql.com

https://www.geeksforgeeks.org/sql-query-complexity/

geeksforgeeks.org

https://www.geeksforgeeks.org/dsa/analysis-algorithms-big-o-analysis/

geeksforgeeks.org

https://medium.com/@DevChy/introduction-to-big-o-notation-time-and-space-complexity-f747ea5bca58

medium.com

https://stackoverflow.com/questions/38675339/where-can-i-read-about-time-complexity-big-o-notation-of-mysql-queries

stackoverflow.com

https://stackoverflow.com/questions/1347552/what-is-the-big-o-for-sql-select

stackoverflow.com

https://stackoverflow.com/questions/16591044/big-oh-performance-of-an-inner-join-on-two-indexes

stackoverflow.com

https://dba.stackexchange.com/questions/216305/how-can-i-improve-query-performances-using-using-temporary-using-filesort

dba.stackexchange.com

https://dev.to/eidorianavi/an-introduction-to-big-o-notation-424e

dev.to

https://www.simplilearn.com/big-o-notation-in-data-structure-article

simplilearn.com

https://www.percona.com/blog/what-does-using-filesort-mean-in-mysql/

percona.com

https://www.devart.com/dbforge/mysql/studio/mysql-window-functions.html

devart.com

https://www.sqlshack.com/overview-of-the-sql-row-number-function/

sqlshack.com

https://stackoverflow.com/questions/7365983/which-sorting-algorithms-does-mysql-use

stackoverflow.com

https://blog.pythian.com/mysql-tuning-filesorts-and-temporary-tables/

blog.pythian.com

https://mode.com/sql-tutorial/sql-window-functions/

mode.com

https://www.codecademy.com/resources/docs/sql/window-functions/row-number

codecademy.com

https://planetscale.com/blog/how-read-mysql-explains

planetscale.com