Previous Thread
Next Thread
Print Thread
Hop To
#1908 07/25/2006 7:35 AM
Joined: Jun 2006
Posts: 464
Likes: 1
M
Addict
Addict
M Offline
Joined: Jun 2006
Posts: 464
Likes: 1
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.




Happy Customer !!!
Mors #1910 07/25/2006 9:16 AM
Joined: Jun 2006
Posts: 46
J
newbie
newbie
J Offline
Joined: Jun 2006
Posts: 46
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


"Those who would give up essential liberty to purchase a little temporary safety, deserve neither liberty nor safety."
Jamin #1937 07/25/2006 6:50 PM
Joined: Jul 2006
Posts: 2,143
Pooh-Bah
Pooh-Bah
Joined: Jul 2006
Posts: 2,143
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.


This thread for sale. Click here! [Linked Image from navaho.infopop.cc]
Joined: Jun 2006
Posts: 464
Likes: 1
M
Addict
Addict
M Offline
Joined: Jun 2006
Posts: 464
Likes: 1
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..


Happy Customer !!!
Mors #1940 07/25/2006 7:36 PM
Joined: Jul 2006
Posts: 2,143
Pooh-Bah
Pooh-Bah
Joined: Jul 2006
Posts: 2,143
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.


This thread for sale. Click here! [Linked Image from navaho.infopop.cc]

Link Copied to Clipboard
ShoutChat
Comment Guidelines: Do post respectful and insightful comments. Don't flame, hate, spam.
Recent Topics
spam issues
by ECNet - 03/19/2024 11:45 PM
Looking for a forum
by azr - 03/15/2024 11:26 PM
Editing Links in Post
by Outdoorking - 03/15/2024 9:31 AM
Question on barkrowler and the like
by Mors - 02/29/2024 6:51 PM
Member Permissions Help
by domspeak - 02/27/2024 6:31 PM
Who's Online Now
1 members (Ruben), 476 guests, and 111 robots.
Key: Admin, Global Mod, Mod
Random Gallery Image
Latest Gallery Images
Los Angeles
Los Angeles
by isaac, August 6
3D Creations
3D Creations
by JAISP, December 30
Artistic structures
Artistic structures
by isaac, August 29
Stones
Stones
by isaac, August 19
Powered by UBB.threads™ PHP Forum Software 8.0.0
(Preview build 20230217)