Accessing SYS.MEMORYANALYTICS

Follow this procedure to access the SYS.MEMORYANALYTICS virtual table.

If you are viewing memory analytics in a non-production or test deployment system, you must have table data and index entries that are representative of your production environment in order to accurately evaluate the memory footprint. Create the necessary SQL scripts to automate creating your schema and loading data into your tables.

Procedure

Follow these steps to access the SYS.MEMORYANALYTICS table:
  1. Start your distributed system members.
  2. If your schema and data are not already available in the GemFire XD system (as persisted data), run any necessary SQL scripts to create the schema and load table data. For example:
    cd c:\gpxd-dir\quickstart
    gfxd
    gfxd> connect client 'localhost:1527';
    gfxd> run 'create_colocated_schema.sql';
    gfxd> run 'loadTables.sql';
  3. Connect to GemFire XD and query the SYS.MEMORYANALYTICS table to view the memory usage information:
    gfxd
    gfxd> connect client 'localhost:1527';
    gfxd> select * from sys.memoryanalytics;
    
    TABLE_NAME            |INDEX_NAME                                      |INDEX_TYPE
    |ID                             |HOST           |CONSTANT_OVERHEAD|ENTRY_SIZE   |KEY_SIZE     
     |VALUE_SIZE   |VALUE_SIZE_OFFHEAP|TOTAL_SIZE   |NUM_ROWS            |NUM_KEYS_IN_MEMORY  |NUM_VALUES_IN_MEMORY
      |NUM_VALUES_IN_OFFHEAP|MEMORY
    ----------------------------------------------------------------------------------------------------------------
    
    APP.FLIGHTS_HISTORY   |NULL                                            |NULL      
    |192.168.129.188(5231)<v1>:41602|192.168.129.188|1.688            |0.0          |0.0          
     |0.0          |0.0               |1.688        |0                   |0                   |0                   
      |0                    |-     
    
    APP.FLIGHTAVAILABILITY|NULL                                            |NULL      
    |192.168.129.188(5231)<v1>:41602|192.168.129.188|1.688            |33.152       |0.0          
     |4.144        |45.584            |84.568       |518                 |0                   |0                   
      |518                  |-     
    
    APP.FLIGHTAVAILABILITY|6__FLIGHTAVAILABILITY__FLIGHT_ID__SEGMENT_NUMBER|LOCAL     
    |192.168.129.188(5231)<v1>:41602|192.168.129.188|0.152            |3.352        |0.0          
     |3.296        |0.0               |6.8          |53                  |0                   |0                   
      |0                    |-     
    
    APP.MAPS              |NULL                                            |NULL      
    |192.168.129.188(5231)<v1>:41602|192.168.129.188|1.688            |0.0          |0.0          
     |0.0          |0.0               |1.688        |0                   |0                   |0                   
      |0                    |-     
    
    APP.MAPS              |3__MAPS__MAP_ID__MAP_NAME                       |LOCAL     
    |192.168.129.188(5231)<v1>:41602|192.168.129.188|0.152            |0.088        |0.0          
     |0.0          |0.0               |0.24         |0                   |0                   |0                   
      |0                    |-     
    
    APP.FLIGHTS           |NULL                                            |NULL      
    |192.168.129.188(5231)<v1>:41602|192.168.129.188|1.688            |30.352       |0.0          
     |36.314       |0.0               |68.354       |542                 |0                   |542                 
      |0                    |-     
    
    APP.FLIGHTS           |DESTINDEX                                       |LOCAL     
    |192.168.129.188(5231)<v1>:41602|192.168.129.188|0.152            |5.744        |0.0          
     |5.176        |0.0               |11.072       |87                  |0                   |0                   
      |0                    |-     
    
    APP.FLIGHTS           |ORIGINDEX                                       |LOCAL     
    |192.168.129.188(5231)<v1>:41602|192.168.129.188|0.152            |5.976        |0.0          
     |5.168        |0.0               |11.296       |87                  |0                   |0                   
      |0                    |-