Anything you guys recommend that I have or turn off. I already turned off

# Set the SQL mode to strict
#sql-mode="STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION"

This fixed my data import crashing problem when using the importer script for UBBthreads 6.5.X

What about this?

# The default storage engine that will be used when create new tables when
default-storage-engine=INNODB

Other then that it seems to be all about cache sizes and memory allocations.

I am just getting used to MySQL 5.0.

Personally, I usually set the default storage engine to MYISAM. If you have a mega high traffic forum site, InnoDB may be better because it only locks the row it's currently using, instead of the entire table, so it may make your forums a little more responsive if you're experiencing slowdowns. But it also uses a lot more disk space and memory to store and access the same amount of data. If your server can handle it, and if you really need it, InnoDB is a good engine. But for average use, MyISAM is pretty good.

---Jamin

On the other hand, how often do you see an INNODB table corrupt?

The UBB.threads create table script specifies MYISAM, so regardless of what your ini defaults to, .threads will be in MYISAM.

hey I installed this out of the box so to speak and it's using the Latin1 character set. Should this be ASCII ?

Doesn't seem to cause any problems yet but wondered if I should change the defaults..

Also is the default setting for myisam this ?

default-storage-engine=MYISAM


thanks for the input..

My MySQL (5.0.22) is in the default language as well. I never changed it. Threads is running fine for me. Were I going to change it I'd go UFT-8 I suspect.

--default-storage-engine=MYISAM

should work for you, yes.