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

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


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


More information about the pLog-svn mailing list