Jay, I did this a few months ago in the my.cnf file: [mysqld] ... set-variable = max_connections=200 Restarted mysql and it worked fine. On Tue, 15 Apr 2003, Jay Kline wrote: > I am running a mysql server that recently has a huge increase in use.. that > is to say I need more than the default 100 max_connections. I tried using > > SET GLOBAL max_connections=200; > > but that gives an SQL error. How do I bump this number up? > I am running this on a RH7.2 box with MySQL server mysql-server-3.23.54a-3.72 > > Jay > > -- > Jay Kline > http://www.slushpupie.com > > _______________________________________________ > TCLUG Mailing List - Minneapolis/St. Paul, Minnesota > http://www.mn-linux.org tclug-list at mn-linux.org > https://mailman.real-time.com/mailman/listinfo/tclug-list > _______________________________________________ TCLUG Mailing List - Minneapolis/St. Paul, Minnesota http://www.mn-linux.org tclug-list at mn-linux.org https://mailman.real-time.com/mailman/listinfo/tclug-list