你当前正在访问 Microsoft Azure Global Edition 技术文档网站。 如果需要访问由世纪互联运营的 Microsoft Azure 中国技术文档网站,请访问 https://docs.azure.cn

Location Based Recommended Action Sessions Result - List

建议操作会话操作结果。

GET https://management.azure.com/subscriptions/{subscriptionId}/providers/Microsoft.DBforMariaDB/locations/{locationName}/recommendedActionSessionsOperationResults/{operationId}?api-version=2018-06-01

URI 参数

名称 必需 类型 说明
locationName
path True

string

位置的名称。

operationId
path True

string

操作标识符。

subscriptionId
path True

string

目标订阅的 ID。

api-version
query True

string

要用于此操作的 API 版本。

响应

名称 类型 说明
200 OK

RecommendationActionsResultList

创建

201 Created

RecommendationActionsResultList

创建

安全性

azure_auth

Azure Active Directory OAuth2 流

类型: oauth2
流向: implicit
授权 URL: https://login.microsoftonline.com/common/oauth2/authorize

作用域

名称 说明
user_impersonation 模拟用户帐户

示例

RecommendedActionSessionResult

示例请求

GET https://management.azure.com/subscriptions/ffffffff-ffff-ffff-ffff-ffffffffffff/providers/Microsoft.DBforMariaDB/locations/WestUS/recommendedActionSessionsOperationResults/aaaabbbb-cccc-dddd-0000-111122223333?api-version=2018-06-01

示例响应

{
  "value": [
    {
      "id": "/subscriptions/ffffffff-ffff-ffff-ffff-ffffffffffff/resourceGroups/testResourceGroupName/providers/Microsoft.Sql/servers/testServerName/advisors/Index/recommendedActions/Index-1",
      "name": "Index-1",
      "type": "Microsoft.DBforMariaDB/servers/advisors/recommendedActions",
      "properties": {
        "advisorName": "Index",
        "sessionId": "c63c2114-e2a4-4c7a-98c1-85577d1a5d50",
        "actionId": 1,
        "createdTime": "2019-05-01T23:43:24Z",
        "expirationTime": "2019-05-08T23:43:24Z",
        "reason": "Column `movies_genres`.`movie_id` appear in Join On clause(s).",
        "recommendationType": "Add",
        "details": {
          "engine": "InnoDB",
          "script": "alter table `movies`.`movies_genres` add index `idx_movie_id` (`movie_id`)",
          "queryIds": "779",
          "indexName": "idx_movie_id",
          "indexType": "BTREE",
          "tableName": "movies_genres",
          "schemaName": "movies",
          "indexColumns": "`movies_genres`.`movie_id`",
          "parentTableName": "movies_genres"
        }
      }
    },
    {
      "id": "/subscriptions/ffffffff-ffff-ffff-ffff-ffffffffffff/resourceGroups/testResourceGroupName/providers/Microsoft.Sql/servers/testServerName/advisors/Index/recommendedActions/Index-2",
      "name": "Index-2",
      "type": "Microsoft.DBforMariaDB/servers/advisors/recommendedActions",
      "properties": {
        "advisorName": "Index",
        "sessionId": "c63c2114-e2a4-4c7a-98c1-85577d1a5d50",
        "actionId": 2,
        "createdTime": "2019-05-01T23:43:24Z",
        "expirationTime": "2019-05-08T23:43:24Z",
        "reason": "Column `movies_genres`.`genre` appear in Group By clause(s).",
        "recommendationType": "Add",
        "details": {
          "engine": "InnoDB",
          "script": "alter table `movies`.`movies_genres` add index `idx_genre` (`genre`)",
          "queryIds": "779",
          "indexName": "idx_genre",
          "indexType": "BTREE",
          "tableName": "movies_genres",
          "schemaName": "movies",
          "indexColumns": "`movies_genres`.`genre`",
          "parentTableName": "movies_genres"
        }
      }
    }
  ]
}
{
  "value": [
    {
      "id": "/subscriptions/ffffffff-ffff-ffff-ffff-ffffffffffff/resourceGroups/testResourceGroupName/providers/Microsoft.Sql/servers/testServerName/advisors/Index/recommendedActions/Index-1",
      "name": "Index-1",
      "type": "Microsoft.DBforMariaDB/servers/advisors/recommendedActions",
      "properties": {
        "advisorName": "Index",
        "sessionId": "c63c2114-e2a4-4c7a-98c1-85577d1a5d50",
        "actionId": 1,
        "createdTime": "2019-05-01T23:43:24Z",
        "expirationTime": "2019-05-08T23:43:24Z",
        "reason": "Column `movies_genres`.`movie_id` appear in Join On clause(s).",
        "recommendationType": "Add",
        "details": {
          "engine": "InnoDB",
          "script": "alter table `movies`.`movies_genres` add index `idx_movie_id` (`movie_id`)",
          "queryIds": "779",
          "indexName": "idx_movie_id",
          "indexType": "BTREE",
          "tableName": "movies_genres",
          "schemaName": "movies",
          "indexColumns": "`movies_genres`.`movie_id`",
          "parentTableName": "movies_genres"
        }
      }
    },
    {
      "id": "/subscriptions/ffffffff-ffff-ffff-ffff-ffffffffffff/resourceGroups/testResourceGroupName/providers/Microsoft.Sql/servers/testServerName/advisors/Index/recommendedActions/Index-2",
      "name": "Index-2",
      "type": "Microsoft.DBforMariaDB/servers/advisors/recommendedActions",
      "properties": {
        "advisorName": "Index",
        "sessionId": "c63c2114-e2a4-4c7a-98c1-85577d1a5d50",
        "actionId": 2,
        "createdTime": "2019-05-01T23:43:24Z",
        "expirationTime": "2019-05-08T23:43:24Z",
        "reason": "Column `movies_genres`.`genre` appear in Group By clause(s).",
        "recommendationType": "Add",
        "details": {
          "engine": "InnoDB",
          "script": "alter table `movies`.`movies_genres` add index `idx_genre` (`genre`)",
          "queryIds": "779",
          "indexName": "idx_genre",
          "indexType": "BTREE",
          "tableName": "movies_genres",
          "schemaName": "movies",
          "indexColumns": "`movies_genres`.`genre`",
          "parentTableName": "movies_genres"
        }
      }
    }
  ]
}

定义

名称 说明
RecommendationAction

表示建议操作。

RecommendationActionsResultList

建议操作的列表。

RecommendationAction

表示建议操作。

名称 类型 说明
id

string

资源的完全限定的资源 ID。 例如 - /subscriptions/{subscriptionId}/resourceGroups/{resourceGroupName}/providers/{resourceProviderNamespace}/{resourceType}/{resourceName}

name

string

资源的名称

properties.actionId

integer

建议操作标识符。

properties.advisorName

string

顾问名称。

properties.createdTime

string

建议操作创建时间。

properties.details

object

建议操作详细信息。

properties.expirationTime

string

建议操作过期时间。

properties.reason

string

建议操作原因。

properties.recommendationType

string

建议操作类型。

properties.sessionId

string

建议操作会话标识符。

type

string

资源类型。 例如“Microsoft.Compute/virtualMachines”或“Microsoft.Storage/storageAccounts”

RecommendationActionsResultList

建议操作的列表。

名称 类型 说明
nextLink

string

用于检索下一页结果的链接。

value

RecommendationAction[]

建议操作顾问的列表。