Current time: 11-16-2024, 10:00 AM Hello There, Guest! (LoginRegister)


Post Reply 
[SOLVED] InnoDB?
Author Message
HSorgYves Offline
Junior Member
*

Posts: 94
Joined: Feb 2008
Reputation: 0
Post: #1
[SOLVED] InnoDB?
Dear,

Can ispCP use InnoDB as default table engine?

Best Regards,
Yves
(This post was last modified: 04-13-2008 03:45 AM by HSorgYves.)
04-07-2008 12:32 AM
Find all posts by this user Quote this message in a reply
HSorgYves Offline
Junior Member
*

Posts: 94
Joined: Feb 2008
Reputation: 0
Post: #2
RE: InnoDB?
It looks like ispCP specifies its engine; so even when InnoDB is the default table engine for mysql, ispCP does not use it.

Best Regards,
Yves
04-10-2008 09:50 AM
Find all posts by this user Quote this message in a reply
joximu Offline
helper
*****
Moderators

Posts: 7,024
Joined: Jan 2007
Reputation: 92
Post: #3
RE: InnoDB?
yes, the database.sql always specifies "ENGINE=MyISAM" at the end of each create block...
04-10-2008 06:02 PM
Visit this user's website Find all posts by this user Quote this message in a reply
pgentoo Offline
Member
*****
Dev Team

Posts: 326
Joined: Mar 2007
Reputation: 0
Post: #4
RE: InnoDB?
I suppose you could always change this table format later using phpmyadmin... If you really want to run on InnoDB. Or change it in the database.sql script before install...
04-11-2008 03:55 AM
Find all posts by this user Quote this message in a reply
joximu Offline
helper
*****
Moderators

Posts: 7,024
Joined: Jan 2007
Reputation: 92
Post: #5
RE: InnoDB?
I think if one really wants InnoDB then there are reasons for this and if you understand them, then you should also know how to change the tables and you also know what are the differences (pros/cons) of the two DB storage formats.

That's why I don't know what was the idea behind the original posting...
04-11-2008 08:37 AM
Visit this user's website Find all posts by this user Quote this message in a reply
Post Reply 


Forum Jump:


User(s) browsing this thread: 1 Guest(s)