Invision Community 4: SEO, prepare for v5 and dormant account notifications Matt November 11, 2024Nov 11
Posted June 16, 201311 yr Does anyone have a specialized my.cnf settings that they tinkered with? Right now, I have a board with 100,00+ members with 1.8M posts. I'm currently on a dedicated server Intel Xeon E3-1240V2, 16 Gigs of Ram, dual 1TB drives. I'm using Sphinx as my search engine (v 2.0.4). I'm just trying to tinker my settings and I'm curious what others had with similar hardware / board sizes. Thanks, Worthy
June 16, 201311 yr I too would like to know what kind of configuration is available to me int he .cnf file,
June 17, 201311 yr This will create a baseline for you to work with: https://tools.percona.com/wizard
June 18, 201311 yr MySQL Tuner is also great: https://github.com/major/MySQLTuner-perl Only for older versions. 5.1 and prior.
June 18, 201311 yr I've used both MySQL Tuner and Tuning Primer, they can both provide useful tuning information. The rest I've just learned from miscellaneous research and advice from other MariaDB/MySQL users and developers on IRC. There is no universal ideal my.cnf configuration. It's dependent on your specific hardware and your specific workload. I do have a (slightly older) version of my my.cnf posted here though, http://community.invisionpower.com/topic/384522-how-to-set-up-a-secure-ipboard-installation-with-nginx-and-php-fpm/#entry2398613 It's in no way perfect and your mileage may vary, but you're welcome to use it as a reference. (I currently run a forum with 20,000+ members and 500,000+ posts).
Archived
This topic is now archived and is closed to further replies.