my.cnf optimizations

[TechPro]

Could you please recommend me my.cnf optimizations for innodb tables (vbulletin)

also, it has happened to me sometimes while taking backups / restarting the server. some of the innoDB tables go empty.

would appreciate some inputs

thanks a lot in advance!

TechPro Reviewed by TechPro on 16th Oct 2011. my.cnf optimizations Could you please recommend me my.cnf optimizations for innodb tables (vbulletin) also, it has happened to me sometimes while taking backups / restarting the server. some of the innoDB tables go empty. would appreciate some inputs :sun: thanks a lot in advance! Rating: 5

[c0rrupt]

there is no default my.cnf settings... Every server will be different depending on your specs.

Your best bet is to run mysqltuner and make adjustments according to the results.

http://www.howtoforge.com/tuning-mys...ith-mysqltuner

[supportex]

Try article Innodb Performance Optimization Basics
Also check output mysqltuner, mysqlreport and slow logs.

[TechPro]

thanks guys

more inputs will be appreciated!

[bhanuprasad1981]

i suggest skip innodb and convert your vb tables to myisam, if you still want it go with personna,you can get some more info at vbtechsupport site.

[-sky-]

yups more good yo change innodb to myisam
innodb meybe more faster read but usage big memory