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.
Mysql Optimization
Forum rules
Discussion of general topics related to the new release and its place in the world. Don't discuss new features, report bugs, ask for support, et cetera. Don't use this to spam for other boards or attack those boards!
Discussion of general topics related to the new release and its place in the world. Don't discuss new features, report bugs, ask for support, et cetera. Don't use this to spam for other boards or attack those boards!
- stickerboy
- Registered User
- Posts: 94
- Joined: Fri Jun 04, 2004 3:05 pm
- Location: Scotland
- Contact:
Re: Mysql Optimization
Don't discuss new features, report bugs, ask for support, et cetera.
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 bothalahamdan wrote:I know this is not a support board
Kenny.
I'm a web-designing code-decrypting tech-support musician
|| Twitter || Flickr || phpBB Snippets ||
Formerly known as cherokee red
|| Twitter || Flickr || phpBB Snippets ||
Formerly known as cherokee red