1. Packages
  2. Tencentcloud Provider
  3. API Docs
  4. getDbbrainTopSpaceSchemas
tencentcloud 1.81.182 published on Monday, Apr 14, 2025 by tencentcloudstack

tencentcloud.getDbbrainTopSpaceSchemas

Explore with Pulumi AI

Use this data source to query detailed information of dbbrain top_space_schemas

Example Usage

import * as pulumi from "@pulumi/pulumi";
import * as tencentcloud from "@pulumi/tencentcloud";

const topSpaceSchemas = tencentcloud.getDbbrainTopSpaceSchemas({
    instanceId: "%s",
    product: "mysql",
    sortBy: "DataLength",
});
Copy
import pulumi
import pulumi_tencentcloud as tencentcloud

top_space_schemas = tencentcloud.get_dbbrain_top_space_schemas(instance_id="%s",
    product="mysql",
    sort_by="DataLength")
Copy
package main

import (
	"github.com/pulumi/pulumi-terraform-provider/sdks/go/tencentcloud/tencentcloud"
	"github.com/pulumi/pulumi/sdk/v3/go/pulumi"
)

func main() {
	pulumi.Run(func(ctx *pulumi.Context) error {
		_, err := tencentcloud.GetDbbrainTopSpaceSchemas(ctx, &tencentcloud.GetDbbrainTopSpaceSchemasArgs{
			InstanceId: "%s",
			Product:    pulumi.StringRef("mysql"),
			SortBy:     pulumi.StringRef("DataLength"),
		}, nil)
		if err != nil {
			return err
		}
		return nil
	})
}
Copy
using System.Collections.Generic;
using System.Linq;
using Pulumi;
using Tencentcloud = Pulumi.Tencentcloud;

return await Deployment.RunAsync(() => 
{
    var topSpaceSchemas = Tencentcloud.GetDbbrainTopSpaceSchemas.Invoke(new()
    {
        InstanceId = "%s",
        Product = "mysql",
        SortBy = "DataLength",
    });

});
Copy
package generated_program;

import com.pulumi.Context;
import com.pulumi.Pulumi;
import com.pulumi.core.Output;
import com.pulumi.tencentcloud.TencentcloudFunctions;
import com.pulumi.tencentcloud.inputs.GetDbbrainTopSpaceSchemasArgs;
import java.util.List;
import java.util.ArrayList;
import java.util.Map;
import java.io.File;
import java.nio.file.Files;
import java.nio.file.Paths;

public class App {
    public static void main(String[] args) {
        Pulumi.run(App::stack);
    }

    public static void stack(Context ctx) {
        final var topSpaceSchemas = TencentcloudFunctions.getDbbrainTopSpaceSchemas(GetDbbrainTopSpaceSchemasArgs.builder()
            .instanceId("%s")
            .product("mysql")
            .sortBy("DataLength")
            .build());

    }
}
Copy
variables:
  topSpaceSchemas:
    fn::invoke:
      function: tencentcloud:getDbbrainTopSpaceSchemas
      arguments:
        instanceId: '%s'
        product: mysql
        sortBy: DataLength
Copy

Using getDbbrainTopSpaceSchemas

Two invocation forms are available. The direct form accepts plain arguments and either blocks until the result value is available, or returns a Promise-wrapped result. The output form accepts Input-wrapped arguments and returns an Output-wrapped result.

function getDbbrainTopSpaceSchemas(args: GetDbbrainTopSpaceSchemasArgs, opts?: InvokeOptions): Promise<GetDbbrainTopSpaceSchemasResult>
function getDbbrainTopSpaceSchemasOutput(args: GetDbbrainTopSpaceSchemasOutputArgs, opts?: InvokeOptions): Output<GetDbbrainTopSpaceSchemasResult>
Copy
def get_dbbrain_top_space_schemas(id: Optional[str] = None,
                                  instance_id: Optional[str] = None,
                                  limit: Optional[float] = None,
                                  product: Optional[str] = None,
                                  result_output_file: Optional[str] = None,
                                  sort_by: Optional[str] = None,
                                  opts: Optional[InvokeOptions] = None) -> GetDbbrainTopSpaceSchemasResult
def get_dbbrain_top_space_schemas_output(id: Optional[pulumi.Input[str]] = None,
                                  instance_id: Optional[pulumi.Input[str]] = None,
                                  limit: Optional[pulumi.Input[float]] = None,
                                  product: Optional[pulumi.Input[str]] = None,
                                  result_output_file: Optional[pulumi.Input[str]] = None,
                                  sort_by: Optional[pulumi.Input[str]] = None,
                                  opts: Optional[InvokeOptions] = None) -> Output[GetDbbrainTopSpaceSchemasResult]
Copy
func GetDbbrainTopSpaceSchemas(ctx *Context, args *GetDbbrainTopSpaceSchemasArgs, opts ...InvokeOption) (*GetDbbrainTopSpaceSchemasResult, error)
func GetDbbrainTopSpaceSchemasOutput(ctx *Context, args *GetDbbrainTopSpaceSchemasOutputArgs, opts ...InvokeOption) GetDbbrainTopSpaceSchemasResultOutput
Copy

> Note: This function is named GetDbbrainTopSpaceSchemas in the Go SDK.

public static class GetDbbrainTopSpaceSchemas 
{
    public static Task<GetDbbrainTopSpaceSchemasResult> InvokeAsync(GetDbbrainTopSpaceSchemasArgs args, InvokeOptions? opts = null)
    public static Output<GetDbbrainTopSpaceSchemasResult> Invoke(GetDbbrainTopSpaceSchemasInvokeArgs args, InvokeOptions? opts = null)
}
Copy
public static CompletableFuture<GetDbbrainTopSpaceSchemasResult> getDbbrainTopSpaceSchemas(GetDbbrainTopSpaceSchemasArgs args, InvokeOptions options)
public static Output<GetDbbrainTopSpaceSchemasResult> getDbbrainTopSpaceSchemas(GetDbbrainTopSpaceSchemasArgs args, InvokeOptions options)
Copy
fn::invoke:
  function: tencentcloud:index/getDbbrainTopSpaceSchemas:getDbbrainTopSpaceSchemas
  arguments:
    # arguments dictionary
Copy

The following arguments are supported:

InstanceId This property is required. string
instance id.
Id string
Limit double
The number of Top libraries to return, the maximum value is 100, and the default is 20.
Product string
Service product type, supported values include: mysql - cloud database MySQL, cynosdb - cloud database CynosDB for MySQL, the default is mysql.
ResultOutputFile string
Used to save results.
SortBy string
The sorting field used to filter the Top library. The optional fields include DataLength, IndexLength, TotalLength, DataFree, FragRatio, TableRows, and PhysicalFileSize (only supported by ApsaraDB for MySQL instances). The default for ApsaraDB for MySQL instances is PhysicalFileSize, and the default for other product instances is TotalLength.
InstanceId This property is required. string
instance id.
Id string
Limit float64
The number of Top libraries to return, the maximum value is 100, and the default is 20.
Product string
Service product type, supported values include: mysql - cloud database MySQL, cynosdb - cloud database CynosDB for MySQL, the default is mysql.
ResultOutputFile string
Used to save results.
SortBy string
The sorting field used to filter the Top library. The optional fields include DataLength, IndexLength, TotalLength, DataFree, FragRatio, TableRows, and PhysicalFileSize (only supported by ApsaraDB for MySQL instances). The default for ApsaraDB for MySQL instances is PhysicalFileSize, and the default for other product instances is TotalLength.
instanceId This property is required. String
instance id.
id String
limit Double
The number of Top libraries to return, the maximum value is 100, and the default is 20.
product String
Service product type, supported values include: mysql - cloud database MySQL, cynosdb - cloud database CynosDB for MySQL, the default is mysql.
resultOutputFile String
Used to save results.
sortBy String
The sorting field used to filter the Top library. The optional fields include DataLength, IndexLength, TotalLength, DataFree, FragRatio, TableRows, and PhysicalFileSize (only supported by ApsaraDB for MySQL instances). The default for ApsaraDB for MySQL instances is PhysicalFileSize, and the default for other product instances is TotalLength.
instanceId This property is required. string
instance id.
id string
limit number
The number of Top libraries to return, the maximum value is 100, and the default is 20.
product string
Service product type, supported values include: mysql - cloud database MySQL, cynosdb - cloud database CynosDB for MySQL, the default is mysql.
resultOutputFile string
Used to save results.
sortBy string
The sorting field used to filter the Top library. The optional fields include DataLength, IndexLength, TotalLength, DataFree, FragRatio, TableRows, and PhysicalFileSize (only supported by ApsaraDB for MySQL instances). The default for ApsaraDB for MySQL instances is PhysicalFileSize, and the default for other product instances is TotalLength.
instance_id This property is required. str
instance id.
id str
limit float
The number of Top libraries to return, the maximum value is 100, and the default is 20.
product str
Service product type, supported values include: mysql - cloud database MySQL, cynosdb - cloud database CynosDB for MySQL, the default is mysql.
result_output_file str
Used to save results.
sort_by str
The sorting field used to filter the Top library. The optional fields include DataLength, IndexLength, TotalLength, DataFree, FragRatio, TableRows, and PhysicalFileSize (only supported by ApsaraDB for MySQL instances). The default for ApsaraDB for MySQL instances is PhysicalFileSize, and the default for other product instances is TotalLength.
instanceId This property is required. String
instance id.
id String
limit Number
The number of Top libraries to return, the maximum value is 100, and the default is 20.
product String
Service product type, supported values include: mysql - cloud database MySQL, cynosdb - cloud database CynosDB for MySQL, the default is mysql.
resultOutputFile String
Used to save results.
sortBy String
The sorting field used to filter the Top library. The optional fields include DataLength, IndexLength, TotalLength, DataFree, FragRatio, TableRows, and PhysicalFileSize (only supported by ApsaraDB for MySQL instances). The default for ApsaraDB for MySQL instances is PhysicalFileSize, and the default for other product instances is TotalLength.

getDbbrainTopSpaceSchemas Result

The following output properties are available:

Id string
InstanceId string
Timestamp double
Timestamp (in seconds) when library space data is collected.
TopSpaceSchemas List<GetDbbrainTopSpaceSchemasTopSpaceSchema>
The returned list of top library space statistics.
Limit double
Product string
ResultOutputFile string
SortBy string
Id string
InstanceId string
Timestamp float64
Timestamp (in seconds) when library space data is collected.
TopSpaceSchemas []GetDbbrainTopSpaceSchemasTopSpaceSchema
The returned list of top library space statistics.
Limit float64
Product string
ResultOutputFile string
SortBy string
id String
instanceId String
timestamp Double
Timestamp (in seconds) when library space data is collected.
topSpaceSchemas List<GetDbbrainTopSpaceSchemasTopSpaceSchema>
The returned list of top library space statistics.
limit Double
product String
resultOutputFile String
sortBy String
id string
instanceId string
timestamp number
Timestamp (in seconds) when library space data is collected.
topSpaceSchemas GetDbbrainTopSpaceSchemasTopSpaceSchema[]
The returned list of top library space statistics.
limit number
product string
resultOutputFile string
sortBy string
id str
instance_id str
timestamp float
Timestamp (in seconds) when library space data is collected.
top_space_schemas Sequence[GetDbbrainTopSpaceSchemasTopSpaceSchema]
The returned list of top library space statistics.
limit float
product str
result_output_file str
sort_by str
id String
instanceId String
timestamp Number
Timestamp (in seconds) when library space data is collected.
topSpaceSchemas List<Property Map>
The returned list of top library space statistics.
limit Number
product String
resultOutputFile String
sortBy String

Supporting Types

GetDbbrainTopSpaceSchemasTopSpaceSchema

DataFree This property is required. double
Fragmentation space (MB).
DataLength This property is required. double
data space (MB).
FragRatio This property is required. double
Fragmentation rate (%).
IndexLength This property is required. double
Index space (MB).
PhysicalFileSize This property is required. double
The sum (MB) of the independent physical file sizes corresponding to all tables in the library. Note: This field may return null, indicating that no valid value can be obtained.
TableRows This property is required. double
Number of lines.
TableSchema This property is required. string
library name.
TotalLength This property is required. double
Total space used (MB).
DataFree This property is required. float64
Fragmentation space (MB).
DataLength This property is required. float64
data space (MB).
FragRatio This property is required. float64
Fragmentation rate (%).
IndexLength This property is required. float64
Index space (MB).
PhysicalFileSize This property is required. float64
The sum (MB) of the independent physical file sizes corresponding to all tables in the library. Note: This field may return null, indicating that no valid value can be obtained.
TableRows This property is required. float64
Number of lines.
TableSchema This property is required. string
library name.
TotalLength This property is required. float64
Total space used (MB).
dataFree This property is required. Double
Fragmentation space (MB).
dataLength This property is required. Double
data space (MB).
fragRatio This property is required. Double
Fragmentation rate (%).
indexLength This property is required. Double
Index space (MB).
physicalFileSize This property is required. Double
The sum (MB) of the independent physical file sizes corresponding to all tables in the library. Note: This field may return null, indicating that no valid value can be obtained.
tableRows This property is required. Double
Number of lines.
tableSchema This property is required. String
library name.
totalLength This property is required. Double
Total space used (MB).
dataFree This property is required. number
Fragmentation space (MB).
dataLength This property is required. number
data space (MB).
fragRatio This property is required. number
Fragmentation rate (%).
indexLength This property is required. number
Index space (MB).
physicalFileSize This property is required. number
The sum (MB) of the independent physical file sizes corresponding to all tables in the library. Note: This field may return null, indicating that no valid value can be obtained.
tableRows This property is required. number
Number of lines.
tableSchema This property is required. string
library name.
totalLength This property is required. number
Total space used (MB).
data_free This property is required. float
Fragmentation space (MB).
data_length This property is required. float
data space (MB).
frag_ratio This property is required. float
Fragmentation rate (%).
index_length This property is required. float
Index space (MB).
physical_file_size This property is required. float
The sum (MB) of the independent physical file sizes corresponding to all tables in the library. Note: This field may return null, indicating that no valid value can be obtained.
table_rows This property is required. float
Number of lines.
table_schema This property is required. str
library name.
total_length This property is required. float
Total space used (MB).
dataFree This property is required. Number
Fragmentation space (MB).
dataLength This property is required. Number
data space (MB).
fragRatio This property is required. Number
Fragmentation rate (%).
indexLength This property is required. Number
Index space (MB).
physicalFileSize This property is required. Number
The sum (MB) of the independent physical file sizes corresponding to all tables in the library. Note: This field may return null, indicating that no valid value can be obtained.
tableRows This property is required. Number
Number of lines.
tableSchema This property is required. String
library name.
totalLength This property is required. Number
Total space used (MB).

Package Details

Repository
tencentcloud tencentcloudstack/terraform-provider-tencentcloud
License
Notes
This Pulumi package is based on the tencentcloud Terraform Provider.