Open Source RDBMS - Seamless, Scalable, Stable and Free

한국어 | Login |Register

Versions available for this page: CUBRID 8.4.3 |  CUBRID 9.0.0 | 

Starting Service and Monitoring

Starting CUBRID SHARD

Start the CUBRID SHARD as shown below:

sh> cubrid shard start

@ cubrid shard start

++ cubrid shard start: success

sh>

Retrieving the CUBRID SHARD Status

Retrieve the CUBRID SHARD status as follows to check the parameter and the status of the process.

sh> cubrid shard status

@ cubrid shard status

% shard1  - shard_cas [21265,45511] /home1/cubrid_user/SHARD/log/broker//shard1.err

 JOB QUEUE:0, AUTO_ADD_APPL_SERVER:ON, SQL_LOG_MODE:ALL:100000, SLOW_LOG:ON

 LONG_TRANSACTION_TIME:60.00, LONG_QUERY_TIME:60.00, SESSION_TIMEOUT:300

 KEEP_CONNECTION:ON, ACCESS_MODE:RW, MAX_QUERY_TIMEOUT:0

----------------------------------------------------------------

PROXY_ID SHARD_ID   CAS_ID   PID   QPS   LQS PSIZE STATUS       

----------------------------------------------------------------

       1        0        1 21272     0     0 53292 IDLE         

       1        1        1 21273     0     0 53292 IDLE         

       1        2        1 21274     0     0 53292 IDLE         

       1        3        1 21275     0     0 53292 IDLE

 

sh> cubrid shard status -f

@ cubrid shard status

% shard1  - shard_cas [21265,45511] /home1/cubrid_user/SHARD/log/broker//shard1.err

 JOB QUEUE:0, AUTO_ADD_APPL_SERVER:ON, SQL_LOG_MODE:ALL:100000, SLOW_LOG:ON

 LONG_TRANSACTION_TIME:60.00, LONG_QUERY_TIME:60.00, SESSION_TIMEOUT:300

 KEEP_CONNECTION:ON, ACCESS_MODE:RW, MAX_QUERY_TIMEOUT:0

----------------------------------------------------------------------------------------------------------------------------------------------------------

PROXY_ID SHARD_ID   CAS_ID   PID   QPS   LQS PSIZE STATUS          LAST ACCESS TIME               DB             HOST   LAST CONNECT TIME    SQL_LOG_MODE

----------------------------------------------------------------------------------------------------------------------------------------------------------

       1        0        1 21272     0     0 53292 IDLE         2012/02/29 15:00:24    shard1@HostA           HostA 2012/02/29 15:00:25               -

       1        1        1 21273     0     0 53292 IDLE         2012/02/29 15:00:24    shard1@HostB           HostB 2012/02/29 15:00:25               -

       1        2        1 21274     0     0 53292 IDLE         2012/02/29 15:00:24    shard1@HostC           HostC 2012/02/29 15:00:25               -

       1        3        1 21275     0     0 53292 IDLE         2012/02/29 15:00:24    shard1@HostD           HostD 2012/02/29 15:00:25               -