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

[Jon Daley]

 	That might work, though you have to be able to shutdown the 
database before copying the files, so that might help things once we get 
the dump created.
  On Fri, 28 Apr 2006, Mark Wu wrote:

> Maybe we can just zip the mysql database folder (as I know different
> database has different folders ) ...
>
> Not so sure.
>
> 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, April 28, 2006 12:01 AM
>> To: plog-svn at devel.lifetype.net
>> Subject: Re: [pLog-svn] r3274 - in plog/trunk: .
>> class/configclass/databaseconfig templates/wizard
>>
>>  	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
>> _______________________________________________
>> 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/

I want to get quoted. I think I say enough stuff to get quoted.
-- JoAnn Paul