I was benchmarking my database the other day using mysqlslap, and I ran into a "Out of resources when opening file '/tmp/somefile' (Errcode: 24)" error.
I with a few click on google, I found a solution to a problem, which is to modify: "/etc/security/limits.conf" file, by adding: "mysql soft nofile 24000" and "mysql hard nofile 32000" lines. (REF.: http://www.smilecouple.org/2011/03/01/fix-out-of-resource-problem-with-mysqlhttp://www.smilecouple.org/2011/03/01/fix-out-of-resource-problem-with-mysql)
My question: What are the drawbacks of this solution ? I assume it is something to do with a security, and I got a feeling where it is, but maybe someone has some real-life experience on this ?