I run a football website. It is on a dedicated server running Free BSD. The main focus of the site is a Message Board (phpbb). Anyhow when we approach 100 users things seem to crawl. CPU utilizations seems fine (less than 20%) - P4 2.8ghz. RAM seems high, only 1 gig so it goes to swap all the time.

Anyhow after doing a ton of reading (Linux - MYSQL are brand new to me) I think I have found that the default MYSQL setting is limited to 100 connections. So this makes sense.

I was told to edit \etc\my.cnf. After figuring out SSH and PICO I have just realized that this file does not exist on my server. I used to Locate command but my.cnf is nowhere to be found.

My question is can I just add it and put in the max_connections - variable?

Any help or thoughts would be GREATLY appreciated. Thanks!

In the default mysql installation there is no my.cnf. There are my-small.cnf, my-medium.cnf, my-large.cnf etc. You pick the one that fit your needs, you modify it and then you copy it as my.cnf under /etc.

Usually MySQL installs with several examples of a my.cnf file and they are usually called something like my-huge.cnf, my-large.cnf, my-medium.cnf and my-small.cnf. You might want to search for those and copy one of them to my.cnf and then edit it. You could just add a my.cnf file, but you would run the risk of hosing up some of the other settings. You're really better off finding an example of my.cnf (maybe on the MySQL site?) and editing that.

And my apologies in advance if this is offensive, but you do know that FreeBSD isn't Linux, don't you?

Thanks for the my.cnf info.

No I didn't know that. Like I mentioned this is ALL Brand new to me. I run a football site that is exploding. First time I tried anything like this. I am learning as I go!!!