edit-icon download-icon

Manage tables

Last Updated: Mar 01, 2018

Create a table

  1. Log on to the Table Store console.

  2. Locate the target instance and click its name, or click Manage in the Actions column to go to the Instance Details page.

  3. Click Create Table.

    Note: Up to 64 tables can be created in an instance.

  4. Enter the required information.

    Note:

    • Each table name must be unique in an instance.
    • If the table is created in a high-performance instance, you must specify the reserved read/write throughput. The reserved throughput can be set to 0 CU. Configuring the reserved read/write throughput does not affect the table’s read/write performance and service capability.
    • If the reserved throughput is configured, billing based on the reserved throughput starts immediately after the table is created.
    • Up to 4 Primary Keys can be set. The configuration and order of the Primary Keys cannot be changed.
    • For more information about table attributes, see Glossary.
  5. Click OK.

If the table does not immediately appear in the Instance Details list, click Refresh.

Update a table

  1. Log on to the Table Store console.

  2. Locate the target instance and click its name, or click Manage in the Actions column to go to the Instance Details page.

  3. Locate the table to be updated in the table list, and click Modify Table Attributes in the Actions column.

  4. Enter the new values.

  5. Click OK.

    The new values take effect immediately.

Delete a table

You cannot recover data within a table once it has been deleted.

  1. Log on to the Table Store console.

  2. Locate the target instance and click its name, or click Manage in the Actions column to go to the Instance Details page.

  3. Locate the table to be deleted in the table list and click Delete in the Actions column.

  4. Click Delete.

Table information and monitoring indicators

You can view basic information and actual usage of your tables on the table management page (table list), including table names, attributes, and latest adjustment times. Additionally, you can view the monitoring indicators of each table, such as the source data size, QPS, the read/write throughputs, and the average response latency. Details about the monitoring indicators are as follows:

  • Source data size: Indicates the size of data saved to Table Store. The size calculated by Table Store may be slightly larger as it includes incremental data. The incremental data includes all column names and values that are saved along with each row of data to Table Store. The unit of data size is MB.

    Note: The shorter the name of a Primary Key column or Attribute column is, the smaller the expansion ratio is.

    • Monitoring latency: 3 hours

    • Collection granularity at metric points: 5 minutes

  • QPS: Indicates the server QPS (unit: PV/s) and is reflected by various operating curves.

    • Monitoring latency: 10 minutes

    • Collection granularity at metric points: 30 seconds

  • Read/Write throughputs: Indicates the actual read and write throughput (measured in CU) which is reflected by various operating curves.

    • Monitoring latency: 30 seconds

    • Collection granularity at metric points: 30 seconds

  • Average response latency: Indicates the latency (measured in ms) of results from the server.

    • Monitoring latency: 30 seconds

    • Collection granularity at metric points: 30 seconds

Procedure

  1. Log on to the Table Store console.

    Note: If a RAM user needs to view monitoring indicators, it must have Alibaba CloudMonitor Read-only Access enabled. To enable this permission, use the primary account to log on to the RAM console and authorize permissions for the selected RAM user. For more information, see Authorization Management - Use case.

  2. Locate the target instance and click its name, or click Manage in the Actions column to go to the Instance Details page.

    • To view basic information: Locate the table to be viewed in the table list and click Manage in the Actions column to go to its Details page.

    • To view monitoring indicators: Click Monitoring Indicators in the left-side navigation pane, and then click the corresponding sub-menu to view the table’s source data size, QPS, the read/write throughputs, and the average response latency.

Thank you! We've received your feedback.