Database Mangement
The operations on a database include creating a database, viewing the database, monitoring the database, and deleting the database.
Create Database
Time Series Database (TSDB) is a specialized database for storing and managing time series data, providing high-performance, stable and reliable database services for time series data. Time Series Database is especially suitable for Internet of Things (IoT) scenarios.
1.Log in https://cloud.baidu.com, click Management Console in the upper right corner, to quickly enter the console interface.
2.Select Product Service > Time Series Database TSDB, and enter the Database List page.
3.Click Create Database to enter the Create Database page, and enter configuration information, including:
- Database name: Set the database name, consisting of 6 to 40 characters of lowercase letters and numbers.
- Write limit: Currently support 1 to 1000000 million points/per month. For more information, see High-quota Mode.
- Inquiry quota: Each 1,000 data points scanned is counted as one query unit.
- Long data format storage space: It needs to be checked only if the write data is of "string" or "byte" type, and the data points of "string" or "byte" type are still included in the write quota.
- Purchase duration: TSDB is a prepaid product with a minimum of monthly billing available.
4.Click Confirm Order when the configuration is done, to complete the creation of the TSDB database.
5.Return to Database List page.
View Database
View the basic information of the database, upgrade the database, renew and other operations.
1.Select Product Service > Time Series Database TSDB, and enter the Database List page.
2.Click database name, and enter the database Basic Information page.
View Details
View basic, configuration, and payment information about the database. The basic information includes database name, database ID, description and domain name, the configuration information includes writing limit and maximum time series, and the payment information includes payment method, expired time and creation time.
Upgrade Configuration
Click "Upgrade Configuration" to upgrade the billing items.
Renew
Click Renew to renew the current database, and the renewal can be made on a monthly basis.
Monitoring Database
Users can get real-time TSDB's current monitoring information to know the use of the database.
1.Select Product Service > Time Series Database TSDB, and enter the Database List page.
2.Click Monitoring to enter the monitoring page. Alternatively, click database name, and enter the database details page; click Monitoring tab, and enter the monitoring page.
You can see the monitoring information in multiple dimensions. The system generates one piece of monitoring data per minute. Users can get statistics on different dimensions by adjusting "Statistic Units" and "Sampling Cycle". For example, if the "Sampling Cycle" is set to 1 hour, there are 60 pieces of monitoring data during each sampling cycle, and if the "Statistic Units" set an average, each sample point in the image indicates the mean of 60 pieces of monitoring data.
The sampling cycle includes: 1 minute, 5 minutes, 20 minutes, 1 hour, 6 hours, 12 hours and 1 day.
Statistic units include:
- Average: An average of all sampling points during the sampling cycle.
- Sum value: Sum of all sampling points during the sampling cycle.
- Maximum: A maximum of all sampling points during the sampling cycle.
- Minimum: A minimum of all sampling points during the sampling cycle.
- Number of samples: Number of samples during the sampling cycle.
From the monitoring panel, users can get the following information in real time:
- Number of write points
- Query used size
- String/byte type data storage space
- Time series
- Number of write/read requests
- Total storage points
Delete Database
Select the database that needs to be deleted, click Delete, and click OK to delete the selected database.