Optimal MYSQL.ini settings

[Auron]

lm currently in the process of reinstalling a dedicated server l run, however lm looking for optimal settings for the mysql.ini

the site l run is pretty large and is very database intensive, the community has over 10,000 members and just as many posts, we also run a few other forums which arnt as active however we require reasonable settings to allow for the server to tick over on its usual low load (we had mysql issues eating at the ram and processing speed)

the server is a:
Opteron 170 - 2.0 Ghz with 2GB of ram

[Marco van Herwaarden]

Please use the vB.com Server Configuration (http://www.vbulletin.com/forum/forumdisplay.php?f=14) forum such questions.

[Auron]

l have, but doesnt this forum state "Forum and Server Management" as well? thought ld get opinions of more ppl by posting here as well as lm sure that some ppl that post here dont specifically post there, some might not even visit hence why l assumed it ok to ask such a question here.

[Marco van Herwaarden]

As stated in the forum description, please read the announcement (https://vborg.vbsupport.ru/announcement.php?f=232&a=38) before posting.

Clearly stated that for such questions you should use the vB.com forums.