执行以下命令,查看当前执行操作,定位效率低的查询。
show full processlist
*************************** 1. row ***************************
Id: 16193
User: rdsAdmin
Host: localhost
db: NULL
Command: Query
Time: 0
State: starting
Info: show full processlist
Memory_used: 16424
Memory_used_by_query: 8208
CPU_time: 294611
Trx_Executed_Time: 0
logical_page_read: 0
disk_page_read: 0
iops_limit_count: 0
*************************** 2. row ***************************
Id: 16246
User: root
Host: ********
db: test04_1
Command: Query
Time: 36
State: creating table
Info: create table test04_1.table_test_7(a int, b varchar(21632))
Memory_used: 151378
Memory_used_by_query: 8208
CPU_time: 128329
Trx_Executed_Time: 0
logical_page_read: 57
disk_page_read: 0
iops_limit_count: 0
*************************** 3. row ***************************
Id: 16247
User: root
Host: ********
db: test01_1
Command: Query
Time: 36
State: creating table
Info: create table test01_1.table_test_7(a int, b varchar(21632))
Memory_used: 151378
Memory_used_by_query: 8208
CPU_time: 127529
Trx_Executed_Time: 0
logical_page_read: 0
disk_page_read: 0
iops_limit_count: 0
*************************** 4. row ***************************
Id: 16261
User: root
Host: ********
db: test05_1
Command: Query
Time: 16
State: creating table
Info: create table test05_1.table_test_6(a int, b varchar(21632))
Memory_used: 151378
Memory_used_by_query: 8208
CPU_time: 150650
Trx_Executed_Time: 0
logical_page_read: 0
disk_page_read: 0
iops_limit_count: 0
*************************** 5. row ***************************
Id: 16262
User: root
Host: ********
db: test_1
Command: Query
Time: 14
State: creating table
Info: create table test_1.table_test_5838(a int, b varchar(21632))
Memory_used: 151376
Memory_used_by_query: 8208
CPU_time: 179596
Trx_Executed_Time: 0
logical_page_read: 0
disk_page_read: 0
iops_limit_count: 0
*************************** 6. row ***************************
Id: 16266
User: root
Host: ********
db: test02_1
Command: Query
Time: 8
State: creating table
Info: create table test02_1.table_test_9(a int, b varchar(21632))
Memory_used: 151378
Memory_used_by_query: 8208
CPU_time: 154582
Trx_Executed_Time: 0
logical_page_read: 0
disk_page_read: 0
iops_limit_count: 0
*************************** 7. row ***************************
Id: 16269
User: root
Host: ********
db: test03_1
Command: Query
Time: 6
State: creating table
Info: create table test03_1.table_test_11(a int, b varchar(21632))
Memory_used: 151378
Memory_used_by_query: 8208
CPU_time: 153918
Trx_Executed_Time: 0
logical_page_read: 0
disk_page_read: 0
iops_limit_count: 0
7 rows in set (0.00 sec)