ASTRAPI Posted January 11, 2011 Share Posted January 11, 2011 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 Link to comment Share on other sites More sharing options...
Gary. Posted January 11, 2011 Share Posted January 11, 2011 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 Link to comment Share on other sites More sharing options...
ASTRAPI Posted January 11, 2011 Author Share Posted January 11, 2011 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. Link to comment Share on other sites More sharing options...
Gary. Posted January 11, 2011 Share Posted January 11, 2011 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. Link to comment Share on other sites More sharing options...
ASTRAPI Posted January 12, 2011 Author Share Posted January 12, 2011 OK thanks :) Link to comment Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.