Ideal my.cnf settings?

[BostonBob]

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

[wmarcy]

I too would like to know what kind of configuration is available to me int he .cnf file,

[Ohio Riders]

This will create a baseline for you to work with: https://tools.percona.com/wizard

[Dmanatr]

MySQL Tuner is also great: https://github.com/major/MySQLTuner-perl

[Ohio Riders]

MySQL Tuner is also great: https://github.com/major/MySQLTuner-perl

Only for older versions. 5.1 and prior.

[Makoto]

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).