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

Christoph Feddersen feddersen at herr-der-ringe-film.de
Thu Apr 27 21:43:04 GMT 2006


Sure, it's similar to the one described here:
http://www.symfony-project.com/askeet/21

Or have a look at the phpbb source, I think they use a similar approach.

Mark Wu wrote:
> 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
> 
> _______________________________________________
> 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