Share your my.cnf if you have a 16gb ram server

[ASTRAPI]

Hello

Can anyone share with me the my.cnf settings from an optimized server with more than 600 users online at the same time on a 16gb ram server?

Thank you

[Gary.]

Every server will have it's own my.cnf , Nobody EVER should use another servers settings.

start from nothing and add the basics from the output of mysqltuner.pl

[ASTRAPI]

Ok.

What do you think about this?

Which is better for the invision forum?

concurrent_insert= 1 or 2 ?

1 = (Default) Enables concurrent insert for MyISAM tables that don't have holes
2 = Enables concurrent inserts for all MyISAM tables, even those that have holes.
For a table with a hole, new rows are inserted at the end of the table if it is in use by another thread.
Otherwise, MySQL acquires a normal write lock and inserts the row into the hole.

[Gary.]

Default means no limits - This is where you build your own. If you run the perl mysqltuner.pl on default - It will show what to insert based on the current mysql needs.

No mysql can EVER be built in 10 mins, For a fully tuned mysql it can take several days.

[ASTRAPI]

OK thanks :)