Jump to content

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

Featured Replies

Posted

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

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

  • Author

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.

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.

  • Author

OK thanks :)

Archived

This topic is now archived and is closed to further replies.

Recently Browsing 0

  • No registered users viewing this page.