[pLog-svn] r3274 - in plog/trunk: .class/config class/databaseconfig templates/wizard

[Mark Wu]

Hi  Christoph:

Last time you metioned about the we can create the full text index by our
self like VBB does. Do you have any information or reference material about
this?

Mark

> -----Original Message-----
> From: plog-svn-bounces at devel.lifetype.net 
> [mailto:plog-svn-bounces at devel.lifetype.net] On Behalf Of 
> Christoph Feddersen
> Sent: Friday, April 28, 2006 2:04 AM
> To: plog-svn at devel.lifetype.net
> Subject: Re: [pLog-svn] r3274 - in plog/trunk: .class/config 
> class/databaseconfig templates/wizard
> 
> a) remove indices before inserting the data and re-add them 
> afterwards.
> 
> b) if all tables are MyISAM you can just copy the complete 
> data dir of the database (containing the *.MYI, *.MYD, .*frm 
> files). So you don't need to dump anything at all.
> 
> As promised, I'll have a look at the select queries in the 
> code, but with my limited time at the moment, I want to wait 
> until the "big test database" exists.
> 
> Oscar Renalias wrote:
> > I had the same problem this morning. I tried to restore the 
> dump in my 
> > work laptop (an ibm t-40 with a 1.6ghz pentium-m) just to 
> see how fast 
> > the data generation script would work in it, and after 5 
> hours it had 
> > only managed to load about 100.000 records of the 
> lt_articles_comments 
> > table, out of over 200.000. I don't know if there is a 
> better format 
> > for mysql dumps, but if we ever manage to get a dump with 500.000 
> > comments, it's going to take more than 2 days to restore it!
> > 
> > Oscar
> > 
> > On 27 Apr 2006, at 15:37, Jon Daley wrote:
> > 
> >>     Restoring the dump is taking forever.  My machine load 
> is at 16...
> >> I am not sure why it is taking so long - The system is 
> RAID5, but I 
> >> hadn't seen disk writes be a bottleneck before, and it seems to be 
> >> the disk causing the trouble now.
> >>
> >>
> >> On Wed, 26 Apr 2006, Oscar Renalias wrote:
> >>> 2) restore the 450mb dump that I linked to a couple of days ago
> >>> (http://www.lifetype.net/test_dump_20060424.sql.bz2) This is not 
> >>> strictly necessary, but if we want to reach the target of 10.000 
> >>> blogs, you'll get a head start with 5000 blogs already in place.
> >>>
> >>> 3) Run generateData.php from the command line (you will 
> need to move 
> >>> it from the tools/ folder to the root LT folder)
> >>>
> >>> I was using the following command line to run the script from the 
> >>> command line, creating 100 blogs at a time. There is a 
> pause in the 
> >>> end so that I get time to stop the process if needed, instead of 
> >>> interrupting its processing while it's working (I don't want to 
> >>> interrupt it while it's adding data) But you can do it in any way 
> >>> you like :-)
> >>>
> >>> while true; do php generateData.php; echo "-- 5 sec break 
> --";sleep 
> >>> 5;done
> >> _______________________________________________
> >> 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