Nexus3-运维随记：修订间差异
来自三线的随记
（创建页面，内容为“sonatype nexus3 === 按照repository 统计空间占用 === java -jar ./lib/support/nexus-orient-console.jar CONNECT PLOCAL:/nexus-data/db/component admin admin select bucket.repository_name as repository,sum(size) as bytes from asset group by bucket.repository_name order by bytes desc limit 10;”） |
小无编辑摘要 |
||
| 第8行： | 第8行： | ||
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> 汇总 === | |||
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; | |||
2025年9月26日 (五) 19:27的版本
sonatype nexus3
按照repository 统计空间占用
java -jar ./lib/support/nexus-orient-console.jar CONNECT PLOCAL:/nexus-data/db/component admin admin 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 汇总
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;
