1. Packages
  2. Tencentcloud Provider
  3. API Docs
  4. getDbbrainTopSpaceSchemas
tencentcloud 1.81.189 published on Wednesday, Apr 30, 2025 by tencentcloudstack

tencentcloud.getDbbrainTopSpaceSchemas

Explore with Pulumi AI

tencentcloud logo
tencentcloud 1.81.189 published on Wednesday, Apr 30, 2025 by tencentcloudstack

    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",
    });
    
    import pulumi
    import pulumi_tencentcloud as tencentcloud
    
    top_space_schemas = tencentcloud.get_dbbrain_top_space_schemas(instance_id="%s",
        product="mysql",
        sort_by="DataLength")
    
    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
    	})
    }
    
    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",
        });
    
    });
    
    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());
    
        }
    }
    
    variables:
      topSpaceSchemas:
        fn::invoke:
          function: tencentcloud:getDbbrainTopSpaceSchemas
          arguments:
            instanceId: '%s'
            product: mysql
            sortBy: DataLength
    

    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>
    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]
    func GetDbbrainTopSpaceSchemas(ctx *Context, args *GetDbbrainTopSpaceSchemasArgs, opts ...InvokeOption) (*GetDbbrainTopSpaceSchemasResult, error)
    func GetDbbrainTopSpaceSchemasOutput(ctx *Context, args *GetDbbrainTopSpaceSchemasOutputArgs, opts ...InvokeOption) GetDbbrainTopSpaceSchemasResultOutput

    > 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)
    }
    public static CompletableFuture<GetDbbrainTopSpaceSchemasResult> getDbbrainTopSpaceSchemas(GetDbbrainTopSpaceSchemasArgs args, InvokeOptions options)
    public static Output<GetDbbrainTopSpaceSchemasResult> getDbbrainTopSpaceSchemas(GetDbbrainTopSpaceSchemasArgs args, InvokeOptions options)
    
    fn::invoke:
      function: tencentcloud:index/getDbbrainTopSpaceSchemas:getDbbrainTopSpaceSchemas
      arguments:
        # arguments dictionary

    The following arguments are supported:

    InstanceId 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 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 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 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 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 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 double
    Fragmentation space (MB).
    DataLength double
    data space (MB).
    FragRatio double
    Fragmentation rate (%).
    IndexLength double
    Index space (MB).
    PhysicalFileSize 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 double
    Number of lines.
    TableSchema string
    library name.
    TotalLength double
    Total space used (MB).
    DataFree float64
    Fragmentation space (MB).
    DataLength float64
    data space (MB).
    FragRatio float64
    Fragmentation rate (%).
    IndexLength float64
    Index space (MB).
    PhysicalFileSize 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 float64
    Number of lines.
    TableSchema string
    library name.
    TotalLength float64
    Total space used (MB).
    dataFree Double
    Fragmentation space (MB).
    dataLength Double
    data space (MB).
    fragRatio Double
    Fragmentation rate (%).
    indexLength Double
    Index space (MB).
    physicalFileSize 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 Double
    Number of lines.
    tableSchema String
    library name.
    totalLength Double
    Total space used (MB).
    dataFree number
    Fragmentation space (MB).
    dataLength number
    data space (MB).
    fragRatio number
    Fragmentation rate (%).
    indexLength number
    Index space (MB).
    physicalFileSize 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 number
    Number of lines.
    tableSchema string
    library name.
    totalLength number
    Total space used (MB).
    data_free float
    Fragmentation space (MB).
    data_length float
    data space (MB).
    frag_ratio float
    Fragmentation rate (%).
    index_length float
    Index space (MB).
    physical_file_size 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 float
    Number of lines.
    table_schema str
    library name.
    total_length float
    Total space used (MB).
    dataFree Number
    Fragmentation space (MB).
    dataLength Number
    data space (MB).
    fragRatio Number
    Fragmentation rate (%).
    indexLength Number
    Index space (MB).
    physicalFileSize 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 Number
    Number of lines.
    tableSchema String
    library name.
    totalLength 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.
    tencentcloud logo
    tencentcloud 1.81.189 published on Wednesday, Apr 30, 2025 by tencentcloudstack