[Deploying Sakai] How do I can do to debug the space after deleting a resource?

[Steve Swinsburg]

Hi

Files don't actually get deleted on the file system. Their record gets deleted in the db only. 

Cheers
Steve

Sent from my iPhone

On 17/03/2013, at 13:23, PABLO LEYVA HUGO <hpl at correo.azc.uam.mx> wrote:

> Hello List!
> 
>      Sakai 2.7 and 2.8 I have in production. Check records of MySQL tables and notice that if I delete a file resource does not decrease, however when you add a resource, this file grows.
> 
>     A level operating system got the file sizes larger
> 
> 
> [root at localhost sakaiuno]# du -shk *|sort -rn | head
> 1954668 CONTENT_RESOURCE_BODY_BINARY.MYD
> 69704   SAM_MEDIA_T.ibd
> 53080   SAKAI_EVENT.MYD
> 21532   SAM_ITEMTEXT_T.ibd
> 17432   SAM_ITEMMETADATA_T.ibd
> 16404   SST_RESOURCES.ibd
> 14356   SAM_ANSWER_T.ibd
> 13332   SST_EVENTS.ibd
> 13332   SAM_PUBLISHEDITEMTEXT_T.ibd
> 12304   searchbuilderitem.ibd
> 
>    After deleting some appeal was well
> 
> [root at localhost sakaiuno]# du -shk *|sort -rn | head
> 1954668 CONTENT_RESOURCE_BODY_BINARY.MYD
> 69704   SAM_MEDIA_T.ibd
> 53080   SAKAI_EVENT.MYD
> 21532   SAM_ITEMTEXT_T.ibd
> 17432   SAM_ITEMMETADATA_T.ibd
> 16404   SST_RESOURCES.ibd
> 14356   SAM_ANSWER_T.ibd
> 13332   SST_EVENTS.ibd
> 13332   SAM_PUBLISHEDITEMTEXT_T.ibd
> 12304   searchbuilderitem.ibd
> 
>   After adding a resource
> 
> [root at localhost sakaiuno]# du -shk *|sort -rn | head
> 1957508 CONTENT_RESOURCE_BODY_BINARY.MYD
> 69704   SAM_MEDIA_T.ibd
> 53092   SAKAI_EVENT.MYD
> 21532   SAM_ITEMTEXT_T.ibd
> 17432   SAM_ITEMMETADATA_T.ibd
> 16404   SST_RESOURCES.ibd
> 14356   SAM_ANSWER_T.ibd
> 13332   SST_EVENTS.ibd
> 13332   SAM_PUBLISHEDITEMTEXT_T.ibd
> 12304   searchbuilderitem.ibd
> 
>    As shown in the table grew to add new resources, but not reduced by eliminating resource.
> 
>     How do I can do to debug the space after deleting a resource?
> 
>      This to keep my end of the disk space
> 
> Thank you!
> 
>  
> 
> M en C Hugo PabloLeyva
> Profesor Departamento de Sistemas
> UAM Azcapotzalco
> 
> -------------------------------------------------------------------
> 
> Visita la pagina de la UAM Azcapotzalco (http://www.azc.uam.mx).
> 
> 
> Este mensaje y sus anexos pueden contener informacion confidencial. Si usted no es el destinatario de este mensaje, se le notifica que cualquier revision, retransmision, distribucion, copiado u otro uso o acto realizado con base en o relacionado con el contenido de este mensaje y sus anexos, estan prohibidos. Si usted ha recibido este mensaje y sus anexos por error, le suplicamos lo notifique al remitente respondiendo el presente correo electronico y borre el presente y sus anexos de su sistema sin conservar copia de los mismos. Muchas gracias.
> 
> This message and the attachments to it may contain information which is confidential. if your are not the intended recipient(s) for this message, you are on notice that any review, retransmission, dissemination, distribution, copying orother use or taking any action based upon or relative to the information contained in this message and its attachments, is prohibited. If you are not the intended recipient(s) of this message or its attachments, please immediately advise the sender by reply e-mail and delete this message and its attachments from your system without keeping a copy. Thank you.
> 
> 
>                
> 
> _______________________________________________
> production mailing list
> production at collab.sakaiproject.org
> http://collab.sakaiproject.org/mailman/listinfo/production
> 
> TO UNSUBSCRIBE: send email to production-unsubscribe at collab.sakaiproject.org with a subject of "unsubscribe"
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://collab.sakaiproject.org/pipermail/production/attachments/20130317/e2c5d5ef/attachment-0001.html