vb.org Archive
Page 2 of 2 1 2
Show 40 post(s) from this thread on one page

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vB3 General Discussions (https://vborg.vbsupport.ru/forumdisplay.php?f=111)
-   -   My Vbulletin is using INNODB and MyISAM at the same time. Is this normal ? (https://vborg.vbsupport.ru/showthread.php?t=154086)

SnapOff Racing 08-04-2008 08:00 PM
Quote:
Originally Posted by nexialys (Post 1591304)
the system is not switched to it... the installer detect your database and flip some tables for the best interest of performances... that's all...
Well I'm the installer and I never flipped any tables around. :confused:

Spank 08-04-2008 08:08 PM
Quote:
Originally Posted by SnapOff Racing (Post 1591398)
Well I'm the installer and I never flipped any tables around. :confused:
Lol, the installer program that installs vbulletin to your server.

SnapOff Racing 08-04-2008 08:29 PM
Quote:
Originally Posted by Spank (Post 1591402)
Lol, the installer program that installs vbulletin to your server.
Oh hahaha. Well let me ask you this then. I just did a fresh install of vb 3.7.2 and about 98% of the tables are all InnoDB. Now as time passes how did they get changed? From upgrades or something? Which is better to run MyISAM or InnoDB?

Marco van Herwaarden 08-05-2008 08:09 AM
There has been no change AFAIK in the recommended storage engine. Unless i missed something we still do recommend MyIsam as storage engine.

Tabes will be created by vBulletin using the default storage engine as set for the database. A few tables that need a specific storage type (some HEAP/In memory tables, and some forced to MyIsam) and will always be created using that storage engine, regardless of the database default.

PS The only thing that changed is that newer MySQL versions (on some Ooperting Systems) now use InnoDB as default for a database unless specified otherwise.

SnapOff Racing 08-05-2008 07:21 PM
Quote:
Originally Posted by Marco van Herwaarden (Post 1591714)
There has been no change AFAIK in the recommended storage engine. Unless i missed something we still do recommend MyIsam as storage engine.

Tabes will be created by vBulletin using the default storage engine as set for the database. A few tables that need a specific storage type (some HEAP/In memory tables, and some forced to MyIsam) and will always be created using that storage engine, regardless of the database default.

PS The only thing that changed is that newer MySQL versions (on some Ooperting Systems) now use InnoDB as default for a database unless specified otherwise.
When you install vbulletin doesn't it specify which engine each table is supposed to use? So when I install a fresh copy of vb it is specifying to use InnoDB and not MyISAM

Adrian Schneider 08-05-2008 07:50 PM
It specifies MyISAM for post content tables.
It specifies MEMORY for the session table.

The rest use your database's default storage engine.

SnapOff Racing 08-06-2008 01:16 AM
Quote:
Originally Posted by SirAdrian (Post 1592144)
It specifies MyISAM for post content tables.
It specifies MEMORY for the session table.

The rest use your database's default storage engine.
Excellent, thank you for clearing that up :)

Marco van Herwaarden 08-06-2008 06:19 AM
And that was exactly the same as what i have posted. ;)

Adrian Schneider 08-07-2008 03:20 AM
And what I wrote in post #2. It's fine though - It can be confusing.

mihai11 08-07-2008 04:12 AM
Quote:
Originally Posted by SirAdrian (Post 1593096)
And what I wrote in post #2. It's fine though - It can be confusing.
  1. But some people said that MyISAM is faster. In this case, is there any point in converting to MyISAM from InnoDB (in order to gain some speed) ?

  2. If MyISAM is faster, why doesn't the default install specify what storage engine to use for each table ? Why let the user configuration decide (depending on MySql version) when the developers could have just used MyISAM as a default ? (not using the database default)


All times are GMT. The time now is 11:45 AM.
Page 2 of 2 1 2
Show 40 post(s) from this thread on one page

Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.

X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.01126 seconds
  • Memory Usage 1,739KB
  • Queries Executed 10 (?)
More Information
Template Usage:
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (6)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (1)pagenav_pagelink
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (10)printthreadbit
  • (1)spacer_close
  • (1)spacer_open 
Phrase Groups Available:
  • global
  • postbit
  • showthread
Included Files:
  • ./printthread.php
  • ./global.php
  • ./includes/init.php
  • ./includes/class_core.php
  • ./includes/config.php
  • ./includes/functions.php
  • ./includes/class_hook.php
  • ./includes/modsystem_functions.php
  • ./includes/class_bbcode_alt.php
  • ./includes/class_bbcode.php
  • ./includes/functions_bigthree.php 
Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • printthread_start
  • pagenav_page
  • pagenav_complete
  • bbcode_fetch_tags
  • bbcode_create
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • printthread_post
  • printthread_complete