We have two ubuntu 8.04 servers. With the database server I set the table_cache to 1000 however when I restart mysql the status only shows 257 and the open files limit says 1024 I adjusted ulimit by doing ulimit -n 8192 and then restarting mysql; this seemed to do the tick however after a few hours I did ulimit -n and saw it had returned back to 1024 Bit of a worry. I edited the /etc/security/limi
![setting ulimit and ubuntu 8.04](https://cdn-ak-scissors.b.st-hatena.com/image/square/1d7824625a3ecbc3a39062b14aaa9db8a44aa022/height=288;version=1;width=512/https%3A%2F%2Fcdn.sstatic.net%2FSites%2Fserverfault%2FImg%2Fapple-touch-icon%402.png%3Fv%3D9b1f48ae296b)