<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html; charset=ISO-8859-1"
http-equiv="Content-Type">
</head>
<body text="#000000" bgcolor="#ffffff">
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 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 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 class="moz-txt-link-abbreviated" href="mailto:stefano.cecere@krur.com">stefano.cecere@krur.com</a>
*** Options: <a 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 class="moz-txt-link-freetext" href="http://www.eprints.org/tech.php/">http://www.eprints.org/tech.php/</a>
*** EPrints community wiki: <a class="moz-txt-link-freetext" href="http://wiki.eprints.org/">http://wiki.eprints.org/</a>
</pre>
</blockquote>
<pre wrap="">
</pre>
</blockquote>
</body>
</html>