<html>
<head>
<meta content="text/html; charset=ISO-8859-1"
http-equiv="Content-Type">
</head>
<body bgcolor="#FFFFFF" text="#000000">
On 06/13/2012 09:39 AM, Jean-Marie Le Bechec wrote:<br>
<br>
Hi,<br>
unfortunately not.<br>
But the strange thing is that fortunately it's not more so
cpu-hungry/time-consuming. Having done absolutely nothing.<br>
Not quick as expected, but not so long, far better than when i wrote
that email.<br>
I can't explain why ...<br>
<br>
Best regards,<br>
Paolo Tealdi<br>
<br>
<blockquote cite="mid:4FD843C0.8090606@inp-toulouse.fr" type="cite">
<meta content="text/html; charset=ISO-8859-1"
http-equiv="Content-Type">
Hi,<br>
<br>
have you find a solution to improve the loading time of the web
admin
interface for create subjects ? And yes, presenting the subjects
tree
page seems to be very very CPU-hungry on mysql (<span
id="result_box" class="short_text" lang="en"><span class="hps">see
below)</span></span><big>.</big><br>
<br>
I use EPrints 3.2.4 (Victoria Sponge) on VMware<br>
<br>
free -m :<br>
total used free shared buffers
cached<br>
Mem: 3948 3923 25 0
84
2207<br>
-/+ buffers/cache: 1630 2318<br>
Swap: 5951 145 5806<br>
<br>
I see (example), mysqladmin processlist --verbose:<br>
<br>
| 355 | oatao | localhost | oatao | Query | 0 | Sending data
|
SELECT `eprint`.`eprintid` FROM `eprint`, (SELECT
`eprint`.`eprintid`
AS `eprintid` FROM `eprint`, (SELECT `eprint`.`eprintid` AS
`eprintid`
FROM `eprint`, `eprint_instit` AS `eprint_instit`,
`subject_ancestors`
AS `subject_ancestors` WHERE
`eprint`.`eprintid`=`eprint_instit`.`eprintid` AND
`eprint_instit`.`instit`=`subject_ancestors`.`subjectid` AND
(`subject_ancestors`.`ancestors` = 'ENSCCF_FR') UNION SELECT
`eprint`.`eprintid` AS `eprintid` FROM `eprint`,
`eprint_divisions` AS
`eprint_divisions`, `subject_ancestors` AS `subject_ancestors`
WHERE
`eprint`.`eprintid`=`eprint_divisions`.`eprintid` AND
`eprint_divisions`.`divisions`=`subject_ancestors`.`subjectid` AND
(`subject_ancestors`.`ancestors` = 'ENSCCF_FR') UNION SELECT
`eprint`.`eprintid` AS `eprintid` FROM `eprint`, `eprint_subjects`
AS
`eprint_subjects`, `subject_ancestors` AS `subject_ancestors`
WHERE
`eprint`.`eprintid`=`eprint_subjects`.`eprintid` AND
`eprint_subjects`.`subjects`=`subject_ancestors`.`subjectid` AND
(`subject_ancestors`.`ancestors` = 'ENSCCF_FR')) AS
`or_47170576395216`
WHERE `eprint`.`eprintid`=`or_47170576395216`.`eprintid`) AS
`and_47170580199520_0` WHERE
`eprint`.`eprintid`=`and_47170580199520_0`.`eprintid` AND
`eprint`.`eprint_status` = 'archive' GROUP BY `eprint`.`eprintid`
|<br>
<br>
and top (<span id="result_box" class="short_text" lang="en"><span
class="hps">when I load</span> <span class="hps">the web
admin
subject page</span><span class="hps">)</span></span>:<br>
<br>
Tasks: 128 total, 1 running, 127 sleeping, 0 stopped, 0
zombie<br>
Cpu(s): 45.8%us, 9.0%sy, 0.0%ni, 44.4%id, 0.7%wa, 0.2%hi,
0.0%si,
0.0%st<br>
Mem: 4043732k total, 4017324k used, 26408k free, 87124k
buffers<br>
Swap: 6094840k total, 148544k used, 5946296k free, 2257256k
cached<br>
<br>
PID USER PR NI VIRT RES SHR S %CPU %MEM
TIME+
COMMAND
<br>
3790 mysql 15 0 378m 82m 3232 S <b> <big>101.5</big></b>
2.1
307:53.77
mysqld
<br>
28982 apache 16 0 468m 138m 6132 S 6.3
3.5 4:22.45
httpd
<br>
28983 apache 16 0 460m 129m 6112 S 2.3
3.3 4:19.75 httpd<br>
....<br>
<br>
Thanks...<br>
<br>
Jean-Marie<br>
<pre class="moz-signature" cols="72">--
***********************************************
Jean Marie Le Bechec
Service Commun de la Documentation
Responsable ingenierie documentaire
&
Direction du Systeme d'Information
Referent Etudes
Institut National Polytechnique de Toulouse
6 allee Emile Monso - bp 34038 -
31029 Toulouse cedex 4
Tel : 05 34 32 31 16
Mail : <a moz-do-not-send="true" class="moz-txt-link-abbreviated" href="mailto:lebechec@inp-toulouse.fr">lebechec@inp-toulouse.fr</a>
***********************************************
</pre>
<br>
Le 30/08/2011 11:03, Paolo Tealdi a écrit :
<blockquote
cite="mid:EMEW3|ee3b82b99379867372196d1c3f3ea0fen7YA4214eprints-tech-bounces|ecs.soton.ac.uk|4E5CA760.1090409@polito.it"
type="cite">
<pre wrap="">Il 30/08/2011 10.06, Stefano Cecere ha scritto:
Hi Stefano,
i normally use the XML batch interface to import/export subjects (and
the programs are quick enought) , but the web interface can be easy and
confortable (if not so slow), for example, to translate subjects in
italian/english for multilanguage sites.
Best regards,
Paolo Tealdi
</pre>
<blockquote type="cite">
<pre wrap="">Hi Paolo
i managed it with XML import (see my <a moz-do-not-send="true" class="moz-txt-link-freetext" href="http://files.eprints.org/553/">http://files.eprints.org/553/</a> )
ciao
s
On 30/ago/2011, at 09.28, Paolo Tealdi wrote:
</pre>
<blockquote type="cite">
<pre wrap="">Dear all,
On our site (3.2.4) we are noticing that managing the subject tree from
admin web is painfully slow, for all subjets that have sons, both for
subjects with and without records linked.
Creating an btree index on subject_parents.parents doesn't improve.
Presenting the subjects tree page seems to be very CPU-hungry on mysql.
Any hints ?
</pre>
</blockquote>
<pre wrap="">____ ___ __ _ _______________________
Stefano Cecere
Multimedia Archive developer
Centro Studi Umanisti KRUR - Firenze
<a moz-do-not-send="true" class="moz-txt-link-abbreviated" href="mailto:stefano.cecere@krur.com">stefano.cecere@krur.com</a>
*** Options: <a moz-do-not-send="true" class="moz-txt-link-freetext" href="http://mailman.ecs.soton.ac.uk/mailman/listinfo/eprints-tech">http://mailman.ecs.soton.ac.uk/mailman/listinfo/eprints-tech</a>
*** Archive: <a moz-do-not-send="true" class="moz-txt-link-freetext" href="http://www.eprints.org/tech.php/">http://www.eprints.org/tech.php/</a>
*** EPrints community wiki: <a moz-do-not-send="true" class="moz-txt-link-freetext" href="http://wiki.eprints.org/">http://wiki.eprints.org/</a>
</pre>
</blockquote>
<pre wrap="">
</pre>
</blockquote>
</blockquote>
<br>
<br>
<pre class="moz-signature" cols="72">--
Ing. Paolo Tealdi Area IT - Politecnico Torino
Telefono/Phone : +39-011-0906714 , FAX : +39-011-0906799
Indirizzo/Address : C.so Duca degli Abruzzi, 24 - 10129 Torino - ITALY
Skype : tealdi.paolo
Please consider your environmental responsibility before printing this e-mail </pre>
</body>
</html>