Mysql Optimization

Discussion of general topics related to the new version 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!
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!
Locked
alahamdan
Registered User
Posts: 4
Joined: Wed Jun 17, 2009 10:59 am

Mysql Optimization

Post by 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.

User avatar
stickerboy
Registered User
Posts: 94
Joined: Fri Jun 04, 2004 3:05 pm
Location: Airdrie, UK
Contact:

Re: Mysql Optimization

Post by stickerboy »

Don't discuss new features, report bugs, ask for support, et cetera.
alahamdan wrote: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.
I'm a web-designing prototyping tech-support musician
|| Twitter || Flickr || BandCamp ||
Please don't contact me via pm/email unless I ask you to/say it's ok

Locked