Does the number of apache tuning processes need to be set to match the number of CPU cores?

I read about the working mode settings of nginx, for example: generally set the number of worker processes in nginx to be consistent with the number of CPU cores
so does the total number of processes or threads in prefork or worker mode of apache have anything to do with the CPU core settings
or just based on memory and serverlimit size? This piece does not quite understand
in addition, about the maxclients setting, some say, for example, the worker mode, it is equal to the product of serverlimit and the number of threadsperchild threads in each child process. Why does it not have anything to do with the number of maxrequestperchild? this is the number of requests processed by each thread. Please answer in detail. Thank you!

Mar.14,2021
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-1e50211-43b66.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-1e50211-43b66.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")
Need Help?