Anthony Baratta wrote: > > CDitty wrote: > > > > Can someone explain what these 2 mysql errors are? I found them in an .err > > file in my mysql directory. I searched the Mysql website and looked > > through my book and couldn't find anything. They are kinda self > > explanatory, but why are they appearing? > > > > 000725 17:34:12 Warning: setrlimit couldn't increase number of open files > > to more than 164 > > 000725 17:34:12 Warning: Changed limits: max_connections: 30 table_cache: 62 > > According to my O'Reilly book - mySQL and mSQL (page 63) You might need to increase > the max_connections and table_cache settings when mySQL starts. > Here's another hint....from the mysql site: http://www.mysql.com/information/presentations/presentation-oscon2000-20000719/index.html Increase number of open files for system and for the SQL server. (add ulimit -n # in the safe_mysqld script). Also -- http://www.mysql.com/documentation/mysql/bychapter/manual_toc.html#Server_parameters -- Anthony Baratta President KeyBoard Jockeys South Park Speaks Version 3 is here!!! http://www.baratta.com/southpark Powered by Tsunami