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

[Jon Daley]

 	There is a binary format, I believe, though I don't know if it 
affects the import speed all that much.

On Thu, 27 Apr 2006, 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

**************************************
Jon Daley
http://jon.limedaley.com/

We know about as much about software quality problems as they
knew about the Black Plague in the 1600s. We've seen the
victims' agonies and helped burn the corpses. We don't know
what causes it; we don't really know if there is only one
disease. We just suffer - and keep pouring our sewage
into our water supply.
-- Tom Van Vleck