New answers tagged

0

max_connections and ulimit and SSDs have virtually no relationship to each other. ulimit is an upper bound (unnecessarily low at 1024) on the number of files that can be open in any 'process'. (mysqld is a 'process'.) It does relate to table_open_cache, which is now set dynamically based on ulimit. (In older versions, it was not automatically set.) ...


0

If the SSD you are talking is "Solid State Drive", it will only act as an ordinary drive with faster read and write. That is the reason why servers are being migrated to SSD drives for critical parts of it. Increasing the max_connection will also increase CPU and Memory Usage. I won't recommend a limit of 3000. About the issue with kernel limit of open ...



Top 50 recent answers are included