--
Este mensaje le ha llegado mediante el servicio de correo electronico
que ofrece Infomed para respaldar el cumplimiento de las misiones del Sistem
a Nacional de Salud. La persona que envia este correo asume el compromiso de
usar el servicio a tales fines y cumplir con las regulaciones establecidas
Infomed: http://www.sld.cu/
Tomasz, can you grep old logging for an upload entry of File:Olympic
Highway - Moorong.jpg (uploaded 16 jul 2009
<http://commons.wikimedia.org/w/index.php?title=File:Olympic_Highway_-_Mooro…>)
or File:Renoir, Pierre-Auguste - The Two Sisters, On the Terrace.jpg (14
jul 2009
<http://commons.wikimedia.org/w/index.php?title=File:Renoir,_Pierre-Auguste_…>,
not the one for 15 jul 2009) ?
Dumps prior to 20090804 are not publicly available. The objective is to
look for evidence about the disappeared upload logs of those files (bug
20744).
It'd be something like gzip -d <
commonswiki-200907*-pages-logging.xml.gz|grep -A 10 -B 10 Moorong.jpg
Presence of Olympic Highway - Moorong.jpg into image.sql would also be
interesting.
> For example, I had to manually increase the number of
> threads for 7ZIP to speed it up, as you can see. It will
Sorry, I meant PIGZ :-). Fire fingers.
F.
> > _______________________________________________
> > Xmldatadumps-l mailing list
> > Xmldatadumps-l(a)lists.wikimedia.org
> > https://lists.wikimedia.org/mailman/listinfo/xmldatadumps-l
> >
>
>
>
>
Greetings,
I am trying to import the French wiki (full history xml) on a Ubuntu machine
with quad-core trendy CPU and 16 GB RAM. The import query is the following:
java -Xmn256M -Xms396M -Xmx512M -XX:+DisableExplicitGC -verbose:gc
-XX:NewSize=32m -XX:MaxNewSize=64m -XX:SurvivorRatio=6 -XX:+UseParallelGC
-XX:GCTimeRatio=9 -XX:AdaptiveSizeDecrementScaleFactor=1 -jar mwdumper.jar
--format=sql:1.5 frwiki-20090810-pages-meta-history.xml.bz2 | mysql -u wiki
-p frwikiLatest
I have disabled the autocommit for mysql, disabled foreign key checks and
unique checks. I have set the pool size, buffer log size, and the buffer
size to large values as recommended for mysql good performance.
After around 3 minutes of running the above command, I have got:
6 pages (0.083/sec), 1,000 revs (13.889/sec)
8 pages (0.038/sec), 2,000 revs (9.378/sec)
13 pages (0.041/sec), 3,000 revs (9.458/sec)
The source file is on its own physical disk and the mysql data folder is on
another physical disks. Both disks are very fast.
*Any suggestions on how to improve the speed?
*
another issue is that the InnoDB (page, revision, text) do not show the
number of the records although the size of the table is non-zero. I think
the might be related to disable keys query.
*Is that correct?
*
bilal