Invision Community 4: SEO, prepare for v5 and dormant account notifications Matt November 11, 2024Nov 11
Posted January 11, 201114 yr 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
January 11, 201114 yr 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
January 11, 201114 yr 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.
January 11, 201114 yr 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.
Archived
This topic is now archived and is closed to further replies.