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 1 of 2 1 2
 
Thread Tools Display Modes
  #1  
Old 08-02-2007, 06:55 AM
mihai11 mihai11 is offline
 
Join Date: Dec 2005
Location: Sibiu - Romania
Posts: 199
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default My Vbulletin is using INNODB and MyISAM at the same time. Is this normal ?
Hi,

I just checked to see what database engine my tables are using. To my suprise, not all tables were powered by INNODB, some of them are using MyISAM. Why would VBulletin use both database engines at the same time ?

Note: There also seems to be another type of database-engine called "MEMORY". Most likely, this means that the tables of this type are kept in memory at all times. See the attached image.

Is there a problem with my setup ?

Regards,
Razvan
Attached Images
File Type: png db-engines.png (21.6 KB, 0 views)
Reply With Quote
  #2  
Old 08-02-2007, 06:58 AM
Adrian Schneider's Avatar
Adrian Schneider Adrian Schneider is offline
 
Join Date: Jul 2004
Posts: 2,528
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default
Yes it's normal.

InnoDB is the new default, but MyISAM is used for FULLTEXT searching.

The session table is stored in memory so it is fast - it is accessed the most.
Reply With Quote
  #3  
Old 08-02-2007, 07:46 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
InnoDB is the new default, but MyISAM is used for FULLTEXT searching.
Thanks. It's good to know that everything is OK.

FULLTEXT searching can only be used with MyISAM ? I thought that INNODB is a more advanced db engine (more advanced than MyISAM).
Reply With Quote
  #4  
Old 08-02-2007, 08:14 AM
El_Muerte's Avatar
El_Muerte El_Muerte is offline
 
Join Date: Nov 2001
Posts: 237
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default
the session tables explicitly uses memory
all others use the default table format.

yes, only MyISAM has FULLTEXT
InnoDB is more advanced in many ways, it's more SQL92 and supports various other extra features. FULLTEXT is a MySQL hack, and they only added it to their own table type.
Reply With Quote
  #5  
Old 08-04-2008, 01:30 PM
weinstoc weinstoc is offline
 
Join Date: Apr 2007
Posts: 46
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default
None of our tables are INNODB. I asked about converting some of them for performance reasons (we are experiencing occasionally locking-related slowdowns) and was told by support:
I have seen InnoDB tables cause a lot of problems with vB, so I strongly suggest that you do not make that change.


So which is correct? INNODB or not?

Chuck
Reply With Quote
  #6  
Old 08-04-2008, 01:56 PM
nexialys
Guest
  
Posts: n/a
Default
vBulletin check if your MySQL server can handle these types properly -- on installation ... so maybe you will need to check with your webmaster which type is better if you want to convert them...
Reply With Quote
  #7  
Old 08-04-2008, 02:05 PM
weinstoc weinstoc is offline
 
Join Date: Apr 2007
Posts: 46
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default
Our server has supported INNODB for years. That should not be the issue.

The real question is: why does vbulletin recommend against using INNODB? What are the problems they've seen? Have any of you who have converted seen them as well?

Chuck
Reply With Quote
  #8  
Old 08-04-2008, 02:20 PM
Opserty Opserty is offline
 
Join Date: Apr 2007
Posts: 4,103
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default
Quote:
why does vbulletin recommend against using INNODB?
The best people to answer that would be the developers, you may be better off asking on vBulletin.com with questions regarding default functionality.
Reply With Quote
  #9  
Old 08-04-2008, 04:29 PM
SnapOff Racing SnapOff Racing is offline
 
Join Date: Apr 2006
Posts: 336
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default
Did vBulletin switch to using InnoDB as the default now because I swear older versions used MyISAM as the default engine for almost all tables.
Reply With Quote
  #10  
Old 08-04-2008, 05:46 PM
nexialys
Guest
  
Posts: n/a
Default
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...
Reply With Quote
Reply
Page 1 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:41 AM.

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.04261 seconds
  • Memory Usage 2,262KB
  • 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
  • (2)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
  • (1)postbit_attachment
  • (8)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_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_attachment
  • postbit_display_complete
  • post_thanks_function_can_thank_this_post_start
  • pagenav_page
  • pagenav_complete
  • tag_fetchbit_complete
  • forumrules
  • navbits
  • navbits_complete
  • showthread_complete