https://wiki.quizz.vn/ 2026-06-26T17:46:01+00:00 https://wiki.quizz.vn/ https://wiki.quizz.vn/lib/exe/fetch.php?media=wiki:dokuwiki.svg text/html 2026-05-26T05:06:06+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.quizz.vn/doku.php?id=mysql:performance-scalability:connection-pool&rev=1779771966&do=diff MySQL Connection Pool Connection Pool is a mechanism that: keeps database connections ready reuses existing connections instead of creating new ones repeatedly Goals: improve performance reduce connection overhead prevent too many DB connections protect MySQL from overload text/html 2026-05-26T05:08:45+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.quizz.vn/doku.php?id=mysql:performance-scalability:index-tuning&rev=1779772125&do=diff Index Tuning Index Tuning is the process of: creating the right indexes removing unnecessary indexes optimizing query performance Goal: make queries faster reduce full table scans reduce CPU and disk I/O improve application response time What is an Index? text/html 2026-05-26T05:10:50+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.quizz.vn/doku.php?id=mysql:performance-scalability:replication&rev=1779772250&do=diff MySQL Replication Replication is a mechanism where: data from a primary (master) database is copied to one or more replica (slave) databases Goal: improve read performance increase availability enable backup / disaster recovery scale database horizontally (read scaling) text/html 2026-05-26T05:11:41+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.quizz.vn/doku.php?id=mysql:performance-scalability:scaling&rev=1779772301&do=diff Database Scaling (MySQL) Scaling means: increasing system capacity to handle more traffic, more data, and more users In MySQL, scaling is mainly split into: Vertical Scaling (Scale Up) Horizontal Scaling (Scale Out) 1. Vertical Scaling (Scale Up)