Nexus3-运维随记：修订间差异

来自三线的随记
可视化wikitext
小无编辑摘要
小无编辑摘要
 
（未显示同一用户的4个中间版本）
第11行： 第11行：
  select bucket.repository_name as repository,sum(size) as bytes from asset group by bucket.repository_name order by bytes desc limit 10;
  select bucket.repository_name as repository,sum(size) as bytes from asset group by bucket.repository_name order by bytes desc limit 10;


=== Maven 仓库：按 <code>groupId</code> 汇总 ===
=== Maven 仓库：按 <code>groupId</code> 汇总 (AI生成) ===
  SELECT gid, SUM(size) AS bytes, COUNT(*) AS files FROM ( SELECT attributes.maven2.groupId AS gid, size   FROM asset   WHERE bucket IN (SELECT @rid FROM bucket WHERE repository_name = 'upload-snapshot')  AND attributes.maven2.groupId IS NOT NULL ) GROUP BY gid ORDER BY bytes DESC LIMIT 200;
在仓库级别统计
  SELECT gid, SUM(size) AS bytes, COUNT(*) AS files FROM ( SELECT attributes.maven2.groupId AS gid, size FROM asset WHERE bucket IN (SELECT @rid FROM bucket WHERE repository_name = 'upload-snapshot') AND attributes.maven2.groupId IS NOT NULL ) GROUP BY gid ORDER BY bytes DESC LIMIT 200;
 
=== Maven 仓库：按 <code>Name</code>(artifactId) 汇总 (AI生成) ===
在全局下按名字统计并过滤仓库:
  SELECT repo, gid, aid, SUM(size) AS bytes, COUNT(*) AS files FROM ( SELECT bucket.repository_name AS repo, attributes.maven2.groupId AS gid, attributes.maven2.artifactId AS aid, size FROM asset WHERE bucket.repository_name = ''''upload-snapshot'''<nowiki/>' AND attributes.maven2.groupId IS NOT NULL AND attributes.maven2.artifactId IS NOT NULL ) GROUP BY repo, gid, aid ORDER BY bytes DESC LIMIT 200;
 
在全局下按名字统计并且不过滤仓库:
SELECT repo, gid, aid, SUM(size) AS bytes, COUNT(*) AS files FROM ( SELECT bucket.repository_name AS repo, attributes.maven2.groupId AS gid, attributes.maven2.artifactId AS aid, size FROM asset WHERE attributes.maven2.groupId IS NOT NULL AND attributes.maven2.artifactId IS NOT NULL ) GROUP BY repo, gid, aid ORDER BY bytes DESC LIMIT 200;

2025年9月29日 (一) 17:15的最新版本

sonatype nexus3

一些orientdb SQL操作记录

基础登陆

java -jar ./lib/support/nexus-orient-console.jar

CONNECT PLOCAL:/nexus-data/db/component admin admin

按照repository 统计空间占用

select bucket.repository_name as repository,sum(size) as bytes from asset group by bucket.repository_name order by bytes desc limit 10;

Maven 仓库：按 groupId 汇总 (AI生成)

在仓库级别统计 

SELECT gid, SUM(size) AS bytes, COUNT(*) AS files FROM ( SELECT attributes.maven2.groupId AS gid, size FROM asset WHERE bucket IN (SELECT @rid FROM bucket WHERE repository_name = 'upload-snapshot') AND attributes.maven2.groupId IS NOT NULL ) GROUP BY gid ORDER BY bytes DESC LIMIT 200;

Maven 仓库：按 Name(artifactId) 汇总 (AI生成)

在全局下按名字统计并过滤仓库: 

SELECT repo, gid, aid, SUM(size) AS bytes, COUNT(*) AS files FROM ( SELECT bucket.repository_name AS repo, attributes.maven2.groupId AS gid, attributes.maven2.artifactId AS aid, size FROM asset WHERE bucket.repository_name = 'upload-snapshot' AND attributes.maven2.groupId IS NOT NULL AND attributes.maven2.artifactId IS NOT NULL ) GROUP BY repo, gid, aid ORDER BY bytes DESC LIMIT 200;

在全局下按名字统计并且不过滤仓库: 

SELECT repo, gid, aid, SUM(size) AS bytes, COUNT(*) AS files FROM ( SELECT bucket.repository_name AS repo, attributes.maven2.groupId AS gid, attributes.maven2.artifactId AS aid, size FROM asset WHERE attributes.maven2.groupId IS NOT NULL AND attributes.maven2.artifactId IS NOT NULL ) GROUP BY repo, gid, aid ORDER BY bytes DESC LIMIT 200;
取自“https://wiki.sanxian.tech/index.php?title=Nexus3-运维随记&oldid=1678”