[pLog-svn] Weird 1.1 installation problem

Mark Wu markplace at gmail.com
Fri Mar 31 05:42:36 GMT 2006


Hi Oscar:

Maybe we can support different table type very easily in current install
wizard:

1. Add a new array element like into table
$Tables["articles"]["MYSQL"] = "TYPE=MyISAM";

2. Then we change the line 705 in wizard.php

$upperName = $dict->upperName;
$sqlarray = $dict->CreateTableSQL( $this->_dbPrefix.$name, $table, array(
"$upperName" => $table[$name][$upperName] ) );

I never test it, but I think it should work..

Mark

> -----Original Message-----
> From: plog-svn-bounces at devel.lifetype.net 
> [mailto:plog-svn-bounces at devel.lifetype.net] On Behalf Of 
> Oscar Renalias
> Sent: Friday, March 31, 2006 1:30 PM
> To: plog-svn at devel.lifetype.net
> Subject: Re: [pLog-svn] Weird 1.1 installation problem
> 
> oh, you already implemented support for myisam :) I will give 
> it a try later on, thanks!
> 
> Oscar
> 
> On 3/31/06, Oscar Renalias <oscar at renalias.net> wrote:
> > I will look into that.
> >
> > At this point, we can even consider creating some tables as 
> InnoDB and 
> > some tables as MyISAM... Since we're so concerned about 
> performance, 
> > this might be a good moment to start with this.
> >
> > Oscar
> >
> > On 3/30/06, Mark Wu <markplace at gmail.com> wrote:
> > > Yes, the best thing of innoDB is "it is row locking", so for big 
> > > blog hosting, it really  help a lot...
> > >
> > > But, the problem of innoDB is "it does not support 
> fulltext index" 
> > > .. :(
> > >
> > > Mark
> > >
> > > > -----Original Message-----
> > > > From: plog-svn-bounces at devel.lifetype.net
> > > > [mailto:plog-svn-bounces at devel.lifetype.net] On Behalf Of Jon 
> > > > Daley
> > > > Sent: Friday, March 31, 2006 3:56 AM
> > > > To: plog-svn at devel.lifetype.net
> > > > Subject: Re: [pLog-svn] Weird 1.1 installation problem
> > > >
> > > >       I have not tried the new installation mechanism.
> > > > We probably should be smart about which tables are which.  I 
> > > > forget the list of pros and cons, except that innodb does row 
> > > > locking instead of table locking.
> > > >
> > > >
> > > > On Fri, 31 Mar 2006, Mark Wu wrote:
> > > > > Hi Oscar & Jon:
> > > > >
> > > > > it seems the $sql generate by datadictionary will not
> > > > specify any db type...
> > > > >
> > > > > So, mysql will use innoDB as the default type. (I am using
> > > > mysql 4.1
> > > > > in
> > > > > windows)
> > > > >
> > > > > And innoDB does not allow FULLTEXT index at this moment.
> > > > >
> > > > > Maybe we need to add TYPE=MyISAM in the  end of table 
> creation sql.
> > > > >
> > > > > Do you has the sam situation? Or you can install successful 
> > > > > without any problem?
> > > > >
> > > > > Mark
> > > > >
> > > > >
> > > > >
> > > >
> > > > **************************************
> > > > Jon Daley
> > > > http://jon.limedaley.com/
> > > >
> > > > Faith is a simple trust in a personal redeemer.
> > > > The simpler our trust in Christ for all things, the 
> surer our peace.
> > > > -- William Adams
> > > > _______________________________________________
> > > > pLog-svn mailing list
> > > > pLog-svn at devel.lifetype.net
> > > > http://devel.lifetype.net/mailman/listinfo/plog-svn
> > >
> > > _______________________________________________
> > > pLog-svn mailing list
> > > pLog-svn at devel.lifetype.net
> > > http://devel.lifetype.net/mailman/listinfo/plog-svn
> > >
> >
> _______________________________________________
> pLog-svn mailing list
> pLog-svn at devel.lifetype.net
> http://devel.lifetype.net/mailman/listinfo/plog-svn



More information about the pLog-svn mailing list