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

Oscar Renalias oscar at renalias.net
Thu Apr 27 15:57:11 GMT 2006


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
>



More information about the pLog-svn mailing list