Database thread pool application thread pool what is the difference and how to configure it.

problem description

recently, I have been optimizing the related business of the system

learn that you can improve the performance of db through thread pooling

here comes the problem

mysql has its own thread pool. You can add parameters such as group by configuration to achieve the function of thread pool

and the db connection tool in web applications also has the function of thread pool

for example, sqlachemy in python comes with db pool, and can set size and so on

the question arises, whether these two things are the same thing
or whether the two are separate, so in the actual production environment, whether to set both or just one of them can be set.

Thank you here

MySQL Query : SELECT * FROM `codeshelper`.`v9_news` WHERE status=99 AND catid='6' ORDER BY rand() LIMIT 5
MySQL Error : Disk full (/tmp/#sql-temptable-64f5-1e822cf-bb6.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")
MySQL Errno : 1021
Message : Disk full (/tmp/#sql-temptable-64f5-1e822cf-bb6.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")
Need Help?