Ok after searching around I am kind of stumped on some stuff. I have mysql and php installed on my unix system but after searching for real world example and the correct syntas in the mysql manuals I have some questions users probably know.
1. If Im using a single database for a gaming forum and know that at any time probably 200-300 users will be logged in at once. I think my computer has the horsepower but should I change the max connects to a conservative number over what I think my max will be? I mean default is 100 but I know more users will log in right away so wouldn't the site be slowing down right away? that is what this means right?
Also if I change this number can I do it to a running version of mysql? Or do I just edit some file where that number resides?(Again I may have just missed this but the documentation I was using for source install really jumped around)
2. For security reasons I would like to lock down users in mysql. I was trying to use grant commands but found the mysql documentation to not explain all the differences like alter, file, drop, etc. I saw some mention of what not to do but this left a bunch of stuff I had no clue about to make a decision on how to lock down my users depending on my situation. Maybe a link to some other site besides the mysql documentation?(unless im retarded and missed the link and searched wrong)
thanks allot!
1. If Im using a single database for a gaming forum and know that at any time probably 200-300 users will be logged in at once. I think my computer has the horsepower but should I change the max connects to a conservative number over what I think my max will be? I mean default is 100 but I know more users will log in right away so wouldn't the site be slowing down right away? that is what this means right?
Also if I change this number can I do it to a running version of mysql? Or do I just edit some file where that number resides?(Again I may have just missed this but the documentation I was using for source install really jumped around)
2. For security reasons I would like to lock down users in mysql. I was trying to use grant commands but found the mysql documentation to not explain all the differences like alter, file, drop, etc. I saw some mention of what not to do but this left a bunch of stuff I had no clue about to make a decision on how to lock down my users depending on my situation. Maybe a link to some other site besides the mysql documentation?(unless im retarded and missed the link and searched wrong)
thanks allot!