Author: reschke
Date: Wed May 23 14:12:03 2018
New Revision: 1832104
URL: http://svn.apache.org/viewvc?rev=1832104&view=rev
Log:
JCR-7149: RDBDocumentStore.getStats() for Derby (ported to 1.8)
Modified:
jackrabbit/oak/branches/1.8/ (props changed)
jackrabbit/oak/branches/1.8/oak-store-document/src/main/java/org/apache/jackrabbit/oak/plugins/document/rdb/RDBDocumentStoreDB.java
Propchange: jackrabbit/oak/branches/1.8/
------------------------------------------------------------------------------
--- svn:mergeinfo (original)
+++ svn:mergeinfo Wed May 23 14:12:03 2018
@@ -1,3 +1,3 @@
/jackrabbit/oak/branches/1.0:1665962
-/jackrabbit/oak/trunk:1820660-1820661,1820729,1820734,1820859,1820861,1820878,1820888,1820947,1821130,1821140-1821141,1821240,1821249,1821258,1821325,1821358,1821361-1821362,1821370,1821375,1821393,1821477,1821487,1821516,1821665,1821668,1821681,1822121,1822201,1822207,1822723,1822808,1822850,1822934,1823135,1823163,1823169,1823172,1824196,1824198,1824962,1825362,1825381,1825442,1825448,1825466,1825470-1825471,1825475,1825523,1825525,1825619-1825621,1825651,1825654,1825992,1826079,1826090,1826096,1826237,1826338,1826516,1826532,1826640,1826932,1826957,1827472,1827486,1827977,1829569,1829987,1830019,1830160,1830748,1831374
+/jackrabbit/oak/trunk:1820660-1820661,1820729,1820734,1820859,1820861,1820878,1820888,1820947,1821027,1821130,1821140-1821141,1821240,1821249,1821258,1821325,1821358,1821361-1821362,1821370,1821375,1821393,1821477,1821487,1821516,1821665,1821668,1821681,1822121,1822201,1822207,1822723,1822808,1822850,1822934,1823135,1823163,1823169,1823172,1824196,1824198,1824962,1825362,1825381,1825442,1825448,1825466,1825470-1825471,1825475,1825523,1825525,1825619-1825621,1825651,1825654,1825992,1826079,1826090,1826096,1826237,1826338,1826516,1826532,1826640,1826932,1826957,1827472,1827486,1827977,1829569,1829987,1830019,1830160,1830748,1831374
/jackrabbit/trunk:1345480
Modified:
jackrabbit/oak/branches/1.8/oak-store-document/src/main/java/org/apache/jackrabbit/oak/plugins/document/rdb/RDBDocumentStoreDB.java
URL:
http://svn.apache.org/viewvc/jackrabbit/oak/branches/1.8/oak-store-document/src/main/java/org/apache/jackrabbit/oak/plugins/document/rdb/RDBDocumentStoreDB.java?rev=1832104&r1=1832103&r2=1832104&view=diff
==============================================================================
---
jackrabbit/oak/branches/1.8/oak-store-document/src/main/java/org/apache/jackrabbit/oak/plugins/document/rdb/RDBDocumentStoreDB.java
(original)
+++
jackrabbit/oak/branches/1.8/oak-store-document/src/main/java/org/apache/jackrabbit/oak/plugins/document/rdb/RDBDocumentStoreDB.java
Wed May 23 14:12:03 2018
@@ -73,6 +73,56 @@ public enum RDBDocumentStoreDB {
public String checkVersion(DatabaseMetaData md) throws SQLException {
return RDBJDBCTools.versionCheck(md, 10, 11, description);
}
+
+ @Override
+ public Map<String, String>
getAdditionalStatistics(RDBConnectionHandler ch, String catalog, String
tableName) {
+ Map<String, String> result = new HashMap<String, String>();
+ Connection con = null;
+
+ try {
+ con = ch.getROConnection();
+ try (PreparedStatement stmt = con.prepareStatement("SELECT T.*
FROM TABLE (SYSCS_DIAG.SPACE_TABLE(?,?)) AS T")) {
+ stmt.setString(1, catalog.toUpperCase(Locale.ENGLISH));
+ stmt.setString(2, tableName.toUpperCase(Locale.ENGLISH));
+ try (ResultSet rs = stmt.executeQuery()) {
+ long totalSize = 0;
+ long totalIndexSize = 0;
+ int nindexes = 0;
+ while (rs.next()) {
+ String conglomerateName =
rs.getString("CONGLOMERATENAME");
+ int isIndex = rs.getInt("ISINDEX");
+ long numAllocatedPages =
rs.getLong("NUMALLOCATEDPAGES");
+ long numFreePages = rs.getLong("NUMFREEPAGES");
+ long numUnfilledPages =
rs.getLong("NUMUNFILLEDPAGES");
+ int pageSize = rs.getInt("PAGESIZE");
+ String raw = "NUMALLOCATEDPAGES=" +
numAllocatedPages + ", NUMFREEPAGES=" + numFreePages
+ + ", NUMUNFILLEDPAGES=" + numUnfilledPages
+ ", PAGESIZE=" + pageSize;
+ long size = pageSize * (numAllocatedPages +
numFreePages);
+ if (isIndex == 0) {
+ result.put("_data", raw);
+ result.put("storageSize", Long.toString(size));
+ } else {
+ result.put(conglomerateName + "._data", raw);
+ result.put("indexSizes." + conglomerateName,
Long.toString(size));
+ totalIndexSize += size;
+ nindexes += 1;
+ }
+ totalSize += pageSize * (numAllocatedPages +
numFreePages);
+ }
+ result.put("totalSize", Long.toString(totalSize));
+ result.put("totalIndexSize",
Long.toString(totalIndexSize));
+ result.put("nindexes", Long.toString(nindexes));
+ }
+ }
+ con.commit();
+ } catch (SQLException ex) {
+ LOG.debug("while getting diagnostics", ex);
+ } finally {
+ ch.closeConnection(con);
+ }
+
+ return result;
+ }
},
POSTGRES("PostgreSQL") {
@@ -908,6 +958,8 @@ public enum RDBDocumentStoreDB {
* (Transact-SQL)</a>, <a href=
*
"https://docs.microsoft.com/en-us/sql/relational-databases/system-stored-procedures/sp-spaceused-transact-sql";>sp_spaceused
* (Transact-SQL)</a>
+ * <li>{@link #DERBY} - Derby Reference Manual: <a href=
+ *
"http://db.apache.org/derby/docs/10.14/ref/rrefsyscsdiagspacetable.html";>SYSCS_DIAG.SPACE_TABLE
diagnostic table function</a>
* </ul>
*/
public String getAdditionalDiagnostics(RDBConnectionHandler ch, String
tableName) {
