Posts Topics Forums Images
Search videos from message boards Videos Search messages from microblogs Microblogs Search messages from imdb.com Imdb Search messages from yuku.com Yuku Search messages from lefora.com (free forums) Lefora
My account: Login | Sign Up
Loading... 

Thread: MyISAM vs innoDB
Started 4 months, 1 week ago by dr_lucas
Hi, My osC DB storage engine is currently MyISAM and I read a lot of good things about the innoDB storage engine, which seems to be quite better than the MyISAM engine. I got innoDB available on my host. The questions are - which one is better for osC? Are there any disadvantages to converting my osC tables to innoDB? Will my osC store lose any functionality or is it safe to convert? TIA...
Site: osCommerce Community Support Forums  osCommerce Community Support Forums - site profile
Forum: General Support  General Support - forum profile
Total authors: 3 authors
Total thread posts: 8 posts
Thread activity: no new posts during last week
Domain info for: oscommerce.com

Other posts in this thread:

MrPhil replied 4 months, 1 week ago
I don't think you're going to gain any functionality that osC can make use of. InnoDB supports foreign keys, which osC doesn't use. I don't know what else is gained with InnoDB, and have no idea if reliability, stability, or performance should be any better than with MyISAM. I would doubt that you'd lose any capabilities (that osC needs), but I can't speak with any authority on that. If I...
Size: 779 bytes
Customize:  Customize "<b>Reply 1</b>: MyISAM vs innoDB :: General Support :: osCommerce Community Support Forums"

dr_lucas replied 4 months, 1 week ago
Thanks, Phil, this info is taken from Wikipedia: QUOTE 1. InnoDB recovers from a crash or other unexpected shutdown by replaying its logs. MyISAM must fully scan and repair or rebuild any indexes or possibly tables which had been updated but not fully flushed to disk. Since the InnoDB approach is approximately fixed time while the MyISAM time grows with the size of the data files, ...
Size: 3,897 bytes
Customize:  Customize "<b>Reply 2</b>: MyISAM vs innoDB :: General Support :: osCommerce Community Support Forums"

dr_lucas replied 4 months, 1 week ago
To clarify my post even more: What I do care about is improving performance and reliability without losing any functionality. Here is another post I read on mysql.com recommending InnoDB for osC: http://forums.mysql.com/read.php?34,56892,58170#ms g-58170 Any more opinions for or against it?
Size: 508 bytes
Customize:  Customize "<b>Reply 3</b>: MyISAM vs innoDB :: General Support :: osCommerce Community Support Forums"

MrPhil replied 4 months, 1 week ago
In the referenced post, Michal is wrong when he says InnoDB should be used instead of MyISAM. osCommerce isn't architected to use transaction and constraint (e.g., foreign keys) features found in InnoDB. Looking at the Wiki article, it sounds like you might get some performance improvements with InnoDB. I have no first-hand experience with that engine, so I can't tell you for sure. It ...
Size: 1,454 bytes
Customize:  Customize "<b>Reply 4</b>: MyISAM vs innoDB :: General Support :: osCommerce Community Support Forums"

dr_lucas replied 4 months, 1 week ago
QUOTE (MrPhil @ Aug 9 2009, 12:39 AM) In the referenced post, Michal is wrong when he says InnoDB should be used instead of MyISAM. osCommerce isn't architected to use transaction and constraint (e.g., foreign keys) features found in InnoDB. Looking at the Wiki article, it sounds like you might get some performance improvements with InnoDB. I have no first-hand experience with ...
Size: 3,642 bytes
Customize:  Customize "<b>Reply 5</b>: MyISAM vs innoDB :: General Support :: osCommerce Community Support Forums"

dr_lucas replied 4 months, 1 week ago
Any more opinions?
Size: 121 bytes
Customize:  Customize "<b>Reply 6</b>: MyISAM vs innoDB :: General Support :: osCommerce Community Support Forums"

ecartz replied 4 months, 1 week ago
You should use MyISAM for product tables and other places where you need full text search, which InnoDB does not have. If you use InnoDB for the order tables, you should modify the queries to take advantage of transactions (primarily in the checkout_process.php file) and foreign key constraints. Without those modifications, InnoDB won't be more reliable than MyISAM. Note that some ...
Size: 1,120 bytes
Customize:  Customize "<b>Reply 7</b>: MyISAM vs innoDB :: General Support :: osCommerce Community Support Forums"

 

Top contributing authors

Name
Posts
dr_lucas
5
user's latest post:
MyISAM vs innoDB
Published (2009-08-10 18:09:00)
Any more opinions?
MrPhil
2
user's latest post:
MyISAM vs innoDB
Published (2009-08-08 17:39:00)
In the referenced post, Michal is wrong when he says InnoDB should be used instead of MyISAM. osCommerce isn't architected to use transaction and constraint (e.g., foreign keys) features found in InnoDB. Looking at the Wiki article, it sounds like you might get some performance improvements with InnoDB. I have no first-hand experience with that engine, so I can't tell you for sure. It sounds like the tradeoff for better performance...
ecartz
1
user's latest post:
MyISAM vs innoDB
Published (2009-08-11 02:50:00)
You should use MyISAM for product tables and other places where you need full text search, which InnoDB does not have. If you use InnoDB for the order tables, you should modify the queries to take advantage of transactions (primarily in the checkout_process.php file) and foreign key constraints. Without those modifications, InnoDB won't be more reliable than MyISAM. Note that some tables will have trouble with foreign key constraints....

Related threads on other sites:

MyISAM vs InnoDB vs Falcon http://tinyurl.com/y3x934...  Twitter / cylarez - site profile cylarez - forum profile MyISAM vs InnoDB vs Falcon http://tinyurl.com/y3x934 8:47 AM Apr 8th from twhirl
MyISAM vs InnoDB vs Falcon http://tinyurl.com/y3x934 8:47 AM Apr 8th from twhirl
MyISAM vs InnoDB vs HEAP  IBResource.ru Forums - site profile Флейм - forum profile MyISAM vs InnoDB vs HEAP
MyISAM vs InnoDB vs HEAP
MYSQL: utf8_general_ci vs latin1_swedish_ci, MYISAM vs...  Webmaster Forum - site profile Coding Forum - forum profile MYSQL: utf8_general_ci vs latin1_swedish_ci, MYISAM vs InnoDB
MYSQL: utf8_general_ci vs latin1_swedish_ci, MYISAM vs InnoDB
MyISAM vs. Innodb vs. both  Dev Shed Forums - Open Source web development - site profile MySQL Help - forum profile MyISAM vs. Innodb vs. both
MyISAM vs. Innodb vs. both
Help with creating table MyISAM vs InnoDB  http://www.phpfreaks.com - site profile @phpfreaks.com - forum profile Help with creating table MyISAM vs InnoDB
Help with creating table MyISAM vs InnoDB
MyISAM vs InnoDB - use case  http://www.phpfreaks.com - site profile MySQL Help - forum profile MyISAM vs InnoDB - use case
MyISAM vs InnoDB - use case
MyISAM vs InnoDB in MySQL  Webmaster-Talk.com Webmaster Forum - Web Design, Coding, SEO Forums - site profile The Database Forum - forum profile MyISAM vs InnoDB in MySQL
MyISAM vs InnoDB in MySQL
Reading up on MyISAM vs InnoDB. Really don't know as much...  Twitter / pr1001 - site profile pr1001 - forum profile Reading up on MyISAM vs InnoDB. Really don't know as much as I should... 1:09 AM Apr 8th from im
Reading up on MyISAM vs InnoDB. Really don't know as much as I should... 1:09 AM Apr 8th from im
MyISAM VS Innodb - Dev Shed  Dev Shed Forums - Open Source web development - site profile MySQL Help - forum profile MyISAM VS Innodb - Dev Shed
MyISAM VS Innodb - Dev Shed
MyISAM vs InnoDB? Which one is better and u prefer?  Dev Shed Forums - Open Source web development - site profile MySQL Help - forum profile MyISAM vs InnoDB? Which one is better and u prefer?
MyISAM vs InnoDB? Which one is better and u prefer?
Thread profile page for "MyISAM vs innoDB" on http://www.oscommerce.com. This report page is a snippet summary view from a single thread "MyISAM vs innoDB", located on the Message Board at http://www.oscommerce.com. This thread profile page shows the thread statistics for: Total Authors, Total Thread Posts, and Thread Activity