Mysql Optimization

[alahamdan]

Hello

I know this is not a support board, ad im sorry for posting here, but im in a real trouble.

In fact i have a post waiting a reply in phpbb support forum here: http://www.phpbb.com/community/viewtopi ... &t=1975925

But looks like no one is looking, so i would like a question here please:

My mysql keep crashing, i have a relatively big active phpbb and its using innodb database, im trying to optimize the my.ini (im on windows Xeon Quad core with 8G ram), i found hundreds of articles describing it but all saying:

IF YOU HAVE A HIGH NUMBER OF X INCREASE VALUE Y TO WHATEVER!

How can i determine if im having high number of any thing? no article describe that.

I would really appreciate if some one can tell me where to start, like to write some commands in mysql command line, to uunderstand current situation and usage and to know what should be increased, im in this pain since 1 week, server keep crashing.

I wish some one can help.

[stickerboy]

Don't discuss new features, report bugs, ask for support, et cetera.

I know this is not a support board

As you already have a topic opened on phpBB.com, please keep to that one. It can and will cause great confusion if people start replying to both


Kenny.