Go Back   vb.org Archive > vBulletin 3 Discussion > vB3 General Discussions
Reload this Page My Vbulletin is using INNODB and MyISAM at the same time. Is this normal ?
FAQ Community Calendar Today's Posts Search

Reply
Page 2 of 2 1 2
 
Thread Tools Display Modes
  #11  
Old 08-04-2008, 08:00 PM
SnapOff Racing SnapOff Racing is offline
 
Join Date: Apr 2006
Posts: 336
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default
Quote:
Originally Posted by nexialys View Post
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.
Reply With Quote
  #12  
Old 08-04-2008, 08:08 PM
Spank Spank is offline
 
Join Date: Jan 2007
Location: Scotland
Posts: 809
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default
Quote:
Originally Posted by SnapOff Racing View Post
Well I'm the installer and I never flipped any tables around.
Lol, the installer program that installs vbulletin to your server.
Reply With Quote
  #13  
Old 08-04-2008, 08:29 PM
SnapOff Racing SnapOff Racing is offline
 
Join Date: Apr 2006
Posts: 336
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default
Quote:
Originally Posted by Spank View Post
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?
Reply With Quote
  #14  
Old 08-05-2008, 08:09 AM
Marco van Herwaarden Marco van Herwaarden is offline
 
Join Date: Jul 2004
Posts: 25,415
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default
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.
Reply With Quote
  #15  
Old 08-05-2008, 07:21 PM
SnapOff Racing SnapOff Racing is offline
 
Join Date: Apr 2006
Posts: 336
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default
Quote:
Originally Posted by Marco van Herwaarden View Post
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
Reply With Quote
  #16  
Old 08-05-2008, 07:50 PM
Adrian Schneider's Avatar
Adrian Schneider Adrian Schneider is offline
 
Join Date: Jul 2004
Posts: 2,528
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default
It specifies MyISAM for post content tables.
It specifies MEMORY for the session table.

The rest use your database's default storage engine.
Reply With Quote
  #17  
Old 08-06-2008, 01:16 AM
SnapOff Racing SnapOff Racing is offline
 
Join Date: Apr 2006
Posts: 336
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default
Quote:
Originally Posted by SirAdrian View Post
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
Reply With Quote
  #18  
Old 08-06-2008, 06:19 AM
Marco van Herwaarden Marco van Herwaarden is offline
 
Join Date: Jul 2004
Posts: 25,415
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default
And that was exactly the same as what i have posted.
Reply With Quote
  #19  
Old 08-07-2008, 03:20 AM
Adrian Schneider's Avatar
Adrian Schneider Adrian Schneider is offline
 
Join Date: Jul 2004
Posts: 2,528
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default
And what I wrote in post #2. It's fine though - It can be confusing.
Reply With Quote
  #20  
Old 08-07-2008, 04:12 AM
mihai11 mihai11 is offline
 
Join Date: Dec 2005
Location: Sibiu - Romania
Posts: 199
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default
Quote:
Originally Posted by SirAdrian View Post
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)
Reply With Quote
Reply
Page 2 of 2 1 2

« Previous Thread | Next Thread »

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Forum Jump


All times are GMT. The time now is 02:01 PM.

Contact Us - Archive - Top

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.04403 seconds
  • Memory Usage 2,273KB
  • Queries Executed 14 (?)
More Information
Template Usage:
  • (1)SHOWTHREAD
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (1)ad_showthread_beforeqr
  • (1)ad_showthread_firstpost
  • (1)ad_showthread_firstpost_sig
  • (1)ad_showthread_firstpost_start
  • (6)bbcode_quote
  • (1)footer
  • (1)forumjump
  • (1)forumrules
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (1)navbar
  • (3)navbar_link
  • (120)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (1)pagenav_pagelink
  • (10)post_thanks_box
  • (10)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (10)post_thanks_postbit_info
  • (10)postbit
  • (10)postbit_onlinestatus
  • (10)postbit_wrapper
  • (1)spacer_close
  • (1)spacer_open
  • (1)tagbit_wrapper 
Phrase Groups Available:
  • global
  • inlinemod
  • postbit
  • posting
  • reputationlevel
  • showthread
Included Files:
  • ./showthread.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/functions_bigthree.php
  • ./includes/class_postbit.php
  • ./includes/class_bbcode.php
  • ./includes/functions_reputation.php
  • ./includes/functions_post_thanks.php 
Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_postinfo_query
  • fetch_postinfo
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • showthread_start
  • showthread_getinfo
  • forumjump
  • showthread_post_start
  • showthread_query_postids
  • showthread_query
  • bbcode_fetch_tags
  • bbcode_create
  • showthread_postbit_create
  • postbit_factory
  • postbit_display_start
  • post_thanks_function_post_thanks_off_start
  • post_thanks_function_post_thanks_off_end
  • post_thanks_function_fetch_thanks_start
  • post_thanks_function_fetch_thanks_end
  • post_thanks_function_thanked_already_start
  • post_thanks_function_thanked_already_end
  • fetch_musername
  • postbit_imicons
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • postbit_display_complete
  • post_thanks_function_can_thank_this_post_start
  • pagenav_page
  • pagenav_complete
  • tag_fetchbit_complete
  • forumrules
  • navbits
  • navbits_complete
  • showthread_complete