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! 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 Try article Innodb Performance Optimization Basics
Also check output mysqltuner, mysqlreport and slow logs. thanks guys
more inputs will be appreciated! 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. yups more good yo change innodb to myisam
innodb meybe more faster read but usage big memory
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! 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 Try article Innodb Performance Optimization Basics
Also check output mysqltuner, mysqlreport and slow logs. thanks guys
more inputs will be appreciated! 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. yups more good yo change innodb to myisam
innodb meybe more faster read but usage big memory