Difference between revisions of "User:Pavila"
From OpenKM Documentation
m |
|||
Line 1: | Line 1: | ||
OpenKM Core developer. | OpenKM Core developer. | ||
+ | |||
+ | '''Application with CLOSE_WAIT''' | ||
+ | <source lang="bash"> | ||
+ | sudo netstat -tonp | grep CLOSE_WAIT | ||
+ | </source> | ||
'''File descriptors used by Tomcat''' | '''File descriptors used by Tomcat''' | ||
<source lang="bash"> | <source lang="bash"> | ||
− | lsof -p $(ps -ef | grep java | grep tomcat | awk '{ print $2 }') | wc -l | + | sudo lsof -p $(ps -ef | grep java | grep tomcat | awk '{ print $2 }') | wc -l |
</source> | </source> | ||
Revision as of 09:21, 25 October 2012
OpenKM Core developer.
Application with CLOSE_WAIT
sudo netstat -tonp | grep CLOSE_WAIT
File descriptors used by Tomcat
sudo lsof -p $(ps -ef | grep java | grep tomcat | awk '{ print $2 }') | wc -l
Show charset and locale configuration
import java.util.*;
import java.nio.charset.*;
print("Charset: " + Charset.defaultCharset()+"<br/>");
print("Locale: " + Locale.getDefault()+"<br/>");
If you have problems read How to set up a clean UTF-8 environment in Linux.
Find duplicates - HSQL
select nd.uuid, nd.name, ndv.checksum from NodeDocument nd, NodeDocumentVersion ndv where nd.uuid = ndv.parent and ndv.checksum in
(select ndv.checksum from NodeDocumentVersion ndv where ndv.current = true group by ndv.checksum having count(ndv.checksum) > 1)
order by ndv.checksum, nd.name;
Find duplicates - SQL
select NBS_UUID, NBS_NAME, NDV_CHECKSUM from OKM_NODE_BASE, OKM_NODE_DOCUMENT_VERSION where NBS_UUID = NDV_PARENT and NDV_CHECKSUM in
(select NDV_CHECKSUM from OKM_NODE_DOCUMENT_VERSION where NDV_CURRENT='T' group by NDV_CHECKSUM having count(NDV_CHECKSUM) > 1)
order by NDV_CHECKSUM, NBS_NAME;
Find documents with assigned roles
select count(*) from NodeDocument nd where size(nd.rolePermissions) > 0; -- Slower
select count(*) from NodeDocument nd where exists elements(nd.rolePermissions); -- Faster
Find documents with a keyword
from NodeDocument nd where 'xxx' in elements(nd.keywords);
Find documents with a role
from NodeDocument nd left join nd.rolePermissions as rolePerms where index(rolePerms) = 'ROLE_USER';
TO DO
- http://doc.ubuntu.com/ubuntu/serverguide/C/libvirt.html
- http://yoadminsis.blogspot.com/2010/05/kvm-y-libvirt-bin-en-kubuntu-lucid-lynx.html
- http://www.eslomas.com/index.php/archives/2008/10/06/migrando-de-xen-a-kvm-en-ubuntu/