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 :sun:

thanks a lot in advance!

 

[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-mysql-performance-with-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