What type of tables does vB use?

[TurboFC3S]

In the my.cnf files there are lines for:

Uncomment the following if you are using BDB tables

and

Uncomment the following if you are using Innobase tables

Just curious if vB uses either of those table types and if I should uncomment those entries?

Thanks!

[eva2000]

vB uses mainly MyISAM tables except the sessions table which uses HEAPS table types

[TurboFC3S]

Ok, cool ... another question for ya :-)

I'm sure you get sick of people asking for your configuration advice, but how does this look for this site

http://www.rx7club.com/forum/admin/extended-status.php

Warning: I just restared mysql 8 minutes ago with these settings, so you might want to wait until tomorrow when there's some load on the server before giving advice on my settings. Needless to say, it's a very high traffic server.

I'll attach my variables output as a handy-dandy txt file

[Joe Gronlund]

Originally posted by eva2000
vB uses mainly MyISAM tables except the sessions table which uses HEAPS table types

heard version 3 will use coffee tables.


sorry had to throw that in :D :cool:

[TurboFC3S]

I'm seeing that with my new configuration for MySQL I'm getting a lot more slow queries ... and my queries/second has dropped about 60% as compared to what I got with the basic my-large.cnf configuration.

I'm going to switch back and see if things speed back up. I think I tried to change to many things at once.