January 11, 2011 in Classic self-hosted technical help
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?
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
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.
OK thanks :)
This topic is now archived and is closed to further replies.
Started June 27, 2021
Started Friday at 01:29 AM
Started August 24