SQL – Adamhuan's Data Center – 【逻辑驱动数据】

SHELL：批量对MySQL某个库执行【*.sql】

脚本：

import_db="$1"
current_dir=`pwd`
sql_file_list=`ls | grep sql`

for item in $sql_file_list
do
    echo "=================="
    echo "Current is: $item"
    echo "Import into: $import_db"
    echo "-----------"
    time mysql -u root -p'****' "$import_db" < $item
    echo "-----------"
    echo "done."
done

import_db="$1"

current_dir=`pwd`

sql_file_list=`ls | grep sql`

for item in $sql_file_list

echo "=================="

echo "Current is: $item"

echo "Import into: $import_db"

echo "-----------"

time mysql -u root -p'****' "$import_db" < $item

echo "-----------"

echo "done."

done

————————————————————————
Done。

发表于： 2017年11月5日 2017年11月5日
作者： Adamhuan
分类： MySQL, SHELL
标签： Linux, MySQL, Shell, SQL, 执行, 批量, 脚本
发表评论: SHELL：批量对MySQL某个库执行【*.sql】

SQL，查询正在执行的事务

SQL：

set linesize 600
col event for a18
col sql_text for a29
col sql_fulltext for a29
col username for a9
col machine for a9
col program for a18
col direct_writes for a18
col terminal for a9
SELECT s.sid,  
      s.serial#,  
      s.event,  
      a.sql_text,  
      a.sql_fulltext,  
      s.username,  
      s.status,  
      s.machine,  
      s.terminal,  
      s.program,  
      a.executions,  
      s.sql_id,  
      p.spid,  
      a.direct_writes  
 FROM (SELECT * FROM v$session WHERE status = 'ACTIVE') s  
 LEFT JOIN v$sqlarea a  
   ON s.sql_id = a.sql_id  
INNER JOIN v$process p  
   ON s.paddr = p.addr  
where sql_text is not null and rownum<2;

set linesize 600

col event for a18

col sql_text for a29

col sql_fulltext for a29

col username for a9

col machine for a9

col program for a18

col direct_writes for a18

col terminal for a9

SELECT s.sid,

s.serial#,

s.event,

a.sql_text,

a.sql_fulltext,

s.username,

s.status,

s.machine,

s.terminal,

s.program,

a.executions,

s.sql_id,

p.spid,

a.direct_writes

FROM (SELECT * FROM v$session WHERE status = 'ACTIVE') s

LEFT JOIN v$sqlarea a

ON s.sql_id = a.sql_id

INNER JOIN v$process p

ON s.paddr = p.addr

where sql_text is not null and rownum<2;

Like This：

SQL> set linesize 600
SQL> col event for a18
SQL> col sql_text for a29
SQL> col sql_fulltext for a29
col username for a9
SQL> SQL> col machine for a9
SQL> col program for a18
SQL> col direct_writes for a18
col terminal for a9
SQL> SQL> SELECT s.sid,  
      s.serial#,  
  2    3        s.event,  
  4        a.sql_text,  
  5        a.sql_fulltext,  
  6        s.username,  
  7        s.status,  
  8        s.machine,  
  9        s.terminal,  
 10        s.program,  
 11        a.executions,  
 12        s.sql_id,  
 13        p.spid,  
 14        a.direct_writes  
 15   FROM (SELECT * FROM v$session WHERE status = 'ACTIVE') s  
 16   LEFT JOIN v$sqlarea a  
 17     ON s.sql_id = a.sql_id  
 18  INNER JOIN v$process p  
 19     ON s.paddr = p.addr  
 20  where sql_text is not null and rownum<2;

       SID    SERIAL# EVENT              SQL_TEXT                      SQL_FULLTEXT                  USERNAME  STATUS   MACHINE   TERMINAL  PROGRAM            EXECUTIONS SQL_ID        SPID                     DIRECT_WRITES
---------- ---------- ------------------ ----------------------------- ----------------------------- --------- -------- --------- --------- ------------------ ---------- ------------- ------------------------ -------------
         7         29 db file sequential DELETE FROM "SXMSPMAST" WHERE DELETE FROM "SXMSPMAST" WHERE SAPSR3    ACTIVE   uxgdc115            dw.sapNXP_DVEBMGS0         16 5zs82knjqrj2r 8716586                     ##########
                       read               "MANDT"=:A0 AND "MSGGUID"=:A  "MANDT"=:A0 AND "MSGGUID"=:A                                        0@uxgdc115 (TNS V1
                                         1 AND "PID"=:A2               1 AND "PID"=:A2                                                      -V3)


SQL>

SQL> set linesize 600

SQL> col event for a18

SQL> col sql_text for a29

SQL> col sql_fulltext for a29

col username for a9

SQL> SQL> col machine for a9

SQL> col program for a18

SQL> col direct_writes for a18

col terminal for a9

SQL> SQL> SELECT s.sid,

s.serial#,

2 3 s.event,

4 a.sql_text,

5 a.sql_fulltext,

6 s.username,

7 s.status,

8 s.machine,

9 s.terminal,

10 s.program,

11 a.executions,

12 s.sql_id,

13 p.spid,

14 a.direct_writes

15 FROM (SELECT * FROM v$session WHERE status = 'ACTIVE') s

16 LEFT JOIN v$sqlarea a

17 ON s.sql_id = a.sql_id

18 INNER JOIN v$process p

19 ON s.paddr = p.addr

20 where sql_text is not null and rownum<2;

SID SERIAL# EVENT SQL_TEXT SQL_FULLTEXT USERNAME STATUS MACHINE TERMINAL PROGRAM EXECUTIONS SQL_ID SPID DIRECT_WRITES

---------- ---------- ------------------ ----------------------------- ----------------------------- --------- -------- --------- --------- ------------------ ---------- ------------- ------------------------ -------------

7 29 db file sequential DELETE FROM "SXMSPMAST" WHERE DELETE FROM "SXMSPMAST" WHERE SAPSR3 ACTIVE uxgdc115 dw.sapNXP_DVEBMGS0 16 5zs82knjqrj2r 8716586 ##########

read "MANDT"=:A0 AND "MSGGUID"=:A "MANDT"=:A0 AND "MSGGUID"=:A 0@uxgdc115 (TNS V1

1 AND "PID"=:A2 1 AND "PID"=:A2 -V3)

SQL>

——————
Done。

SQL：当前会话

SQL：

SET LINESIZE 400
COLUMN spid FORMAT A10
COLUMN username FORMAT A10
COLUMN program FORMAT A45
col machine for a14
SELECT s.inst_id,
       s.sid,
       s.serial#,
       p.spid,
       s.username,
       s.program,
       s.machine
FROM   gv$session s
       JOIN gv$process p ON p.addr = s.paddr AND p.inst_id = s.inst_id
WHERE  s.type != 'BACKGROUND';

SET LINESIZE 400

COLUMN spid FORMAT A10

COLUMN username FORMAT A10

COLUMN program FORMAT A45

col machine for a14

SELECT s.inst_id,

s.sid,

s.serial#,

p.spid,

s.username,

s.program,

s.machine

FROM gv$session s

JOIN gv$process p ON p.addr = s.paddr AND p.inst_id = s.inst_id

WHERE s.type != 'BACKGROUND';

Like this：

SQL> SET LINESIZE 400
SQL> COLUMN spid FORMAT A10
SQL> COLUMN username FORMAT A10
SQL> COLUMN program FORMAT A45
SQL> col machine for a14
SQL> SELECT s.inst_id,
  2         s.sid,
  3         s.serial#,
  4         p.spid,
  5         s.username,
  6         s.program,
  7         s.machine
  8  FROM   gv$session s
  9         JOIN gv$process p ON p.addr = s.paddr AND p.inst_id = s.inst_id
WHERE  s.type != 'BACKGROUND'; 10  

   INST_ID        SID    SERIAL# SPID       USERNAME   PROGRAM                                       MACHINE
---------- ---------- ---------- ---------- ---------- --------------------------------------------- --------------
         1       1156         15 9629       SYS        sqlplus@DC15VM-032 (TNS V1-V3)                DC******2
         1        582         49 10247      VPXADMIN   sqlplus@DC15VM-032 (TNS V1-V3)                DC******2

SQL>

SQL> SET LINESIZE 400

SQL> COLUMN spid FORMAT A10

SQL> COLUMN username FORMAT A10

SQL> COLUMN program FORMAT A45

SQL> col machine for a14

SQL> SELECT s.inst_id,

2 s.sid,

3 s.serial#,

4 p.spid,

5 s.username,

6 s.program,

7 s.machine

8 FROM gv$session s

9 JOIN gv$process p ON p.addr = s.paddr AND p.inst_id = s.inst_id

WHERE s.type != 'BACKGROUND'; 10

INST_ID SID SERIAL# SPID USERNAME PROGRAM MACHINE

---------- ---------- ---------- ---------- ---------- --------------------------------------------- --------------

1 1156 15 9629 SYS sqlplus@DC15VM-032 (TNS V1-V3) DC******2

1 582 49 10247 VPXADMIN sqlplus@DC15VM-032 (TNS V1-V3) DC******2

SQL>

————————————————
Done。

发表于： 2017年8月20日 2017年8月20日
作者： Adamhuan
分类： SQL
标签： kill session, Oracle, Program, SQL, 会话, 用户
发表评论: SQL：当前会话

Oracle SQL：表空间使用率

SQL：

set linesize 400
col tablespace_name for a23
col free_rate for a18
SELECT a.tablespace_name,  
         ROUND (a.total_size) "total_size(MB)",  
         ROUND (a.total_size) - ROUND (b.free_size, 3) "used_size(MB)",  
         ROUND (b.free_size, 3) "free_size(MB)",  
         ROUND (b.free_size / total_size * 100, 2) || '%' free_rate  
  FROM ( SELECT tablespace_name, SUM (bytes) / 1024 / 1024 total_size  
              FROM dba_data_files  
          GROUP BY tablespace_name) a,  
         ( SELECT tablespace_name, SUM (bytes) / 1024 / 1024 free_size  
              FROM dba_free_space  
          GROUP BY tablespace_name) b  
 WHERE a.tablespace_name = b.tablespace_name(+);

set linesize 400

col tablespace_name for a23

col free_rate for a18

SELECT a.tablespace_name,

ROUND (a.total_size) "total_size(MB)",

ROUND (a.total_size) - ROUND (b.free_size, 3) "used_size(MB)",

ROUND (b.free_size, 3) "free_size(MB)",

ROUND (b.free_size / total_size * 100, 2) || '%' free_rate

FROM ( SELECT tablespace_name, SUM (bytes) / 1024 / 1024 total_size

FROM dba_data_files

GROUP BY tablespace_name) a,

( SELECT tablespace_name, SUM (bytes) / 1024 / 1024 free_size

FROM dba_free_space

GROUP BY tablespace_name) b

WHERE a.tablespace_name = b.tablespace_name(+);

Like this：

SQL> run
  1  SELECT a.tablespace_name,
  2           ROUND (a.total_size) "total_size(MB)",
  3           ROUND (a.total_size) - ROUND (b.free_size, 3) "used_size(MB)",
  4           ROUND (b.free_size, 3) "free_size(MB)",
  5           ROUND (b.free_size / total_size * 100, 2) || '%' free_rate
  6    FROM ( SELECT tablespace_name, SUM (bytes) / 1024 / 1024 total_size
  7                FROM dba_data_files
  8            GROUP BY tablespace_name) a,
  9           ( SELECT tablespace_name, SUM (bytes) / 1024 / 1024 free_size
 10                FROM dba_free_space
 11            GROUP BY tablespace_name) b
 12*  WHERE a.tablespace_name = b.tablespace_name(+)

TABLESPACE_NAME          total_size(MB) used_size(MB) free_size(MB) FREE_RATE
------------------------ -------------- ------------- ------------- ------------------
SYSAUX                            24210     13316.875     10893.125 44.99%
UNDOTBS1                          20480       252.312     20227.688 98.77%
CLOUD_INDX                          500             1           499 99.8%
USERS                                 8         1.812         6.188 82.5%
FLASHBACK_ARCH                     2048             1          2047 99.95%
SYSTEM                             3178      1321.125      1856.875 58.43%
VPX                              240640        8210.5      232429.5 96.59%
CLOUD_DATA                         7089      5241.437      1847.563 26.06%

8 rows selected.

SQL>

SQL> run

1 SELECT a.tablespace_name,

2 ROUND (a.total_size) "total_size(MB)",

3 ROUND (a.total_size) - ROUND (b.free_size, 3) "used_size(MB)",

4 ROUND (b.free_size, 3) "free_size(MB)",

5 ROUND (b.free_size / total_size * 100, 2) || '%' free_rate

6 FROM ( SELECT tablespace_name, SUM (bytes) / 1024 / 1024 total_size

7 FROM dba_data_files

8 GROUP BY tablespace_name) a,

9 ( SELECT tablespace_name, SUM (bytes) / 1024 / 1024 free_size

10 FROM dba_free_space

11 GROUP BY tablespace_name) b

12* WHERE a.tablespace_name = b.tablespace_name(+)

TABLESPACE_NAME total_size(MB) used_size(MB) free_size(MB) FREE_RATE

------------------------ -------------- ------------- ------------- ------------------

SYSAUX 24210 13316.875 10893.125 44.99%

UNDOTBS1 20480 252.312 20227.688 98.77%

CLOUD_INDX 500 1 499 99.8%

USERS 8 1.812 6.188 82.5%

FLASHBACK_ARCH 2048 1 2047 99.95%

SYSTEM 3178 1321.125 1856.875 58.43%

VPX 240640 8210.5 232429.5 96.59%

CLOUD_DATA 7089 5241.437 1847.563 26.06%

8 rows selected.

SQL>

——————————————
Done。

发表于： 2017年8月20日 2017年8月20日
作者： Adamhuan
分类： SQL
标签： Oracle, SQL, tablespace, usage, 使用率, 表空间
发表评论: Oracle SQL：表空间使用率

MySQL，统计SCHEMA中，表的数据量

代码：

mysql> select table_name,(data_length+index_length)/1024/1024 as total_mb,table_rows from information_schema.tables where table_schema='zabbix';
+----------------------------+------------+------------+
| table_name                 | total_mb   | table_rows |
+----------------------------+------------+------------+
| acknowledges               | 0.06250000 |          0 |
| actions                    | 0.04687500 |          5 |
| alerts                     | 0.10937500 |          0 |
| application_discovery      | 0.04687500 |          0 |
| application_prototype      | 0.04687500 |          0 |
| application_template       | 0.04687500 |         29 |
| applications               | 0.03125000 |        158 |
| auditlog                   | 0.04687500 |         13 |
| auditlog_details           | 0.03125000 |          0 |
| autoreg_host               | 0.03125000 |          0 |
| conditions                 | 0.03125000 |          6 |
| config                     | 0.04687500 |          0 |
| corr_condition             | 0.03125000 |          0 |
| corr_condition_group       | 0.03125000 |          0 |
| corr_condition_tag         | 0.01562500 |          0 |
| corr_condition_tagpair     | 0.01562500 |          0 |
| corr_condition_tagvalue    | 0.01562500 |          0 |
| corr_operation             | 0.03125000 |          0 |
| correlation                | 0.01562500 |          0 |
| dbversion                  | 0.01562500 |          0 |
| dchecks                    | 0.03125000 |          0 |
| dhosts                     | 0.03125000 |          0 |
| drules                     | 0.04687500 |          0 |
| dservices                  | 0.04687500 |          0 |
| escalations                | 0.01562500 |          0 |
| event_recovery             | 0.04687500 |          3 |
| event_tag                  | 0.03125000 |          0 |
| events                     | 0.04687500 |         22 |
| expressions                | 0.03125000 |          6 |
| functions                  | 0.07812500 |        325 |
| globalmacro                | 0.01562500 |          0 |
| globalvars                 | 0.01562500 |          0 |
| graph_discovery            | 0.03125000 |          3 |
| graph_theme                | 0.03125000 |          2 |
| graphs                     | 0.07812500 |         99 |
| graphs_items               | 0.07812500 |        307 |
| group_discovery            | 0.03125000 |          0 |
| group_prototype            | 0.06250000 |          7 |
| groups                     | 0.03125000 |          6 |
| history                    | 0.26562500 |       2834 |
| history_log                | 0.01562500 |          0 |
| history_str                | 0.03125000 |          4 |
| history_text               | 0.01562500 |          0 |
| history_uint               | 0.03125000 |        334 |
| host_discovery             | 0.04687500 |          2 |
| host_inventory             | 0.01562500 |          0 |
| hostmacro                  | 0.03125000 |          0 |
| hosts                      | 0.10937500 |         41 |
| hosts_groups               | 0.04687500 |         39 |
| hosts_templates            | 0.04687500 |         22 |
| housekeeper                | 0.01562500 |          0 |
| httpstep                   | 0.03125000 |          0 |
| httpstepitem               | 0.04687500 |          0 |
| httptest                   | 0.07812500 |          0 |
| httptestitem               | 0.04687500 |          0 |
| icon_map                   | 0.04687500 |          0 |
| icon_mapping               | 0.04687500 |          0 |
| ids                        | 0.01562500 |         10 |
| images                     | 1.53125000 |        138 |
| interface                  | 0.04687500 |          0 |
| interface_discovery        | 0.03125000 |          0 |
| item_application_prototype | 0.04687500 |          0 |
| item_condition             | 0.03125000 |         22 |
| item_discovery             | 0.04687500 |        143 |
| items                      | 0.43750000 |        713 |
| items_applications         | 0.15625000 |        826 |
| maintenances               | 0.01562500 |          0 |
| maintenances_groups        | 0.04687500 |          0 |
| maintenances_hosts         | 0.04687500 |          0 |
| maintenances_windows       | 0.04687500 |          0 |
| mappings                   | 0.03125000 |        143 |
| media                      | 0.04687500 |          0 |
| media_type                 | 0.03125000 |          3 |
| opcommand                  | 0.03125000 |          0 |
| opcommand_grp              | 0.04687500 |          0 |
| opcommand_hst              | 0.04687500 |          0 |
| opconditions               | 0.03125000 |          0 |
| operations                 | 0.03125000 |         10 |
| opgroup                    | 0.04687500 |          0 |
| opinventory                | 0.01562500 |          0 |
| opmessage                  | 0.03125000 |          8 |
| opmessage_grp              | 0.04687500 |          4 |
| opmessage_usr              | 0.04687500 |          0 |
| optemplate                 | 0.04687500 |          0 |
| problem                    | 0.06250000 |         19 |
| problem_tag                | 0.04687500 |          0 |
| profiles                   | 0.04687500 |         11 |
| proxy_autoreg_host         | 0.01562500 |          0 |
| proxy_dhistory             | 0.01562500 |          0 |
| proxy_history              | 0.01562500 |          0 |
| regexps                    | 0.03125000 |          5 |
| rights                     | 0.04687500 |          0 |
| screen_user                | 0.04687500 |          0 |
| screen_usrgrp              | 0.04687500 |          0 |
| screens                    | 0.04687500 |         12 |
| screens_items              | 0.03125000 |         49 |
| scripts                    | 0.06250000 |          3 |
| service_alarms             | 0.04687500 |          0 |
| services                   | 0.03125000 |          0 |
| services_links             | 0.04687500 |          0 |
| services_times             | 0.03125000 |          0 |
| sessions                   | 0.03125000 |          3 |
| slides                     | 0.04687500 |          0 |
| slideshow_user             | 0.04687500 |          0 |
| slideshow_usrgrp           | 0.04687500 |          0 |
| slideshows                 | 0.04687500 |          0 |
| sysmap_element_url         | 0.03125000 |          0 |
| sysmap_url                 | 0.03125000 |          0 |
| sysmap_user                | 0.04687500 |          0 |
| sysmap_usrgrp              | 0.04687500 |          0 |
| sysmaps                    | 0.07812500 |          0 |
| sysmaps_elements           | 0.09375000 |          0 |
| sysmaps_link_triggers      | 0.04687500 |          0 |
| sysmaps_links              | 0.06250000 |          0 |
| task                       | 0.01562500 |          0 |
| task_close_problem         | 0.01562500 |          0 |
| timeperiods                | 0.01562500 |          0 |
| trends                     | 0.01562500 |         64 |
| trends_uint                | 0.01562500 |         19 |
| trigger_depends            | 0.04687500 |         41 |
| trigger_discovery          | 0.03125000 |          4 |
| trigger_tag                | 0.03125000 |          0 |
| triggers                   | 0.12500000 |        297 |
| users                      | 0.03125000 |          2 |
| users_groups               | 0.04687500 |          2 |
| usrgrp                     | 0.03125000 |          5 |
| valuemaps                  | 0.03125000 |         17 |
+----------------------------+------------+------------+
127 rows in set (0.05 sec)

mysql>

100

101

102

103

104

105

106

107

108

109

110

111

112

113

114

115

116

117

118

119

120

121

122

123

124

125

126

127

128

129

130

131

132

133

134

135

mysql> select table_name,(data_length+index_length)/1024/1024 as total_mb,table_rows from information_schema.tables where table_schema='zabbix';

+----------------------------+------------+------------+

| table_name | total_mb | table_rows |

+----------------------------+------------+------------+

| acknowledges | 0.06250000 | 0 |

| actions | 0.04687500 | 5 |

| alerts | 0.10937500 | 0 |

| application_discovery | 0.04687500 | 0 |

| application_prototype | 0.04687500 | 0 |

| application_template | 0.04687500 | 29 |

| applications | 0.03125000 | 158 |

| auditlog | 0.04687500 | 13 |

| auditlog_details | 0.03125000 | 0 |

| autoreg_host | 0.03125000 | 0 |

| conditions | 0.03125000 | 6 |

| config | 0.04687500 | 0 |

| corr_condition | 0.03125000 | 0 |

| corr_condition_group | 0.03125000 | 0 |

| corr_condition_tag | 0.01562500 | 0 |

| corr_condition_tagpair | 0.01562500 | 0 |

| corr_condition_tagvalue | 0.01562500 | 0 |

| corr_operation | 0.03125000 | 0 |

| correlation | 0.01562500 | 0 |

| dbversion | 0.01562500 | 0 |

| dchecks | 0.03125000 | 0 |

| dhosts | 0.03125000 | 0 |

| drules | 0.04687500 | 0 |

| dservices | 0.04687500 | 0 |

| escalations | 0.01562500 | 0 |

| event_recovery | 0.04687500 | 3 |

| event_tag | 0.03125000 | 0 |

| events | 0.04687500 | 22 |

| expressions | 0.03125000 | 6 |

| functions | 0.07812500 | 325 |

| globalmacro | 0.01562500 | 0 |

| globalvars | 0.01562500 | 0 |

| graph_discovery | 0.03125000 | 3 |

| graph_theme | 0.03125000 | 2 |

| graphs | 0.07812500 | 99 |

| graphs_items | 0.07812500 | 307 |

| group_discovery | 0.03125000 | 0 |

| group_prototype | 0.06250000 | 7 |

| groups | 0.03125000 | 6 |

| history | 0.26562500 | 2834 |

| history_log | 0.01562500 | 0 |

| history_str | 0.03125000 | 4 |

| history_text | 0.01562500 | 0 |

| history_uint | 0.03125000 | 334 |

| host_discovery | 0.04687500 | 2 |

| host_inventory | 0.01562500 | 0 |

| hostmacro | 0.03125000 | 0 |

| hosts | 0.10937500 | 41 |

| hosts_groups | 0.04687500 | 39 |

| hosts_templates | 0.04687500 | 22 |

| housekeeper | 0.01562500 | 0 |

| httpstep | 0.03125000 | 0 |

| httpstepitem | 0.04687500 | 0 |

| httptest | 0.07812500 | 0 |

| httptestitem | 0.04687500 | 0 |

| icon_map | 0.04687500 | 0 |

| icon_mapping | 0.04687500 | 0 |

| ids | 0.01562500 | 10 |

| images | 1.53125000 | 138 |

| interface | 0.04687500 | 0 |

| interface_discovery | 0.03125000 | 0 |

| item_application_prototype | 0.04687500 | 0 |

| item_condition | 0.03125000 | 22 |

| item_discovery | 0.04687500 | 143 |

| items | 0.43750000 | 713 |

| items_applications | 0.15625000 | 826 |

| maintenances | 0.01562500 | 0 |

| maintenances_groups | 0.04687500 | 0 |

| maintenances_hosts | 0.04687500 | 0 |

| maintenances_windows | 0.04687500 | 0 |

| mappings | 0.03125000 | 143 |

| media | 0.04687500 | 0 |

| media_type | 0.03125000 | 3 |

| opcommand | 0.03125000 | 0 |

| opcommand_grp | 0.04687500 | 0 |

| opcommand_hst | 0.04687500 | 0 |

| opconditions | 0.03125000 | 0 |

| operations | 0.03125000 | 10 |

| opgroup | 0.04687500 | 0 |

| opinventory | 0.01562500 | 0 |

| opmessage | 0.03125000 | 8 |

| opmessage_grp | 0.04687500 | 4 |

| opmessage_usr | 0.04687500 | 0 |

| optemplate | 0.04687500 | 0 |

| problem | 0.06250000 | 19 |

| problem_tag | 0.04687500 | 0 |

| profiles | 0.04687500 | 11 |

| proxy_autoreg_host | 0.01562500 | 0 |

| proxy_dhistory | 0.01562500 | 0 |

| proxy_history | 0.01562500 | 0 |

| regexps | 0.03125000 | 5 |

| rights | 0.04687500 | 0 |

| screen_user | 0.04687500 | 0 |

| screen_usrgrp | 0.04687500 | 0 |

| screens | 0.04687500 | 12 |

| screens_items | 0.03125000 | 49 |

| scripts | 0.06250000 | 3 |

| service_alarms | 0.04687500 | 0 |

| services | 0.03125000 | 0 |

| services_links | 0.04687500 | 0 |

| services_times | 0.03125000 | 0 |

| sessions | 0.03125000 | 3 |

| slides | 0.04687500 | 0 |

| slideshow_user | 0.04687500 | 0 |

| slideshow_usrgrp | 0.04687500 | 0 |

| slideshows | 0.04687500 | 0 |

| sysmap_element_url | 0.03125000 | 0 |

| sysmap_url | 0.03125000 | 0 |

| sysmap_user | 0.04687500 | 0 |

| sysmap_usrgrp | 0.04687500 | 0 |

| sysmaps | 0.07812500 | 0 |

| sysmaps_elements | 0.09375000 | 0 |

| sysmaps_link_triggers | 0.04687500 | 0 |

| sysmaps_links | 0.06250000 | 0 |

| task | 0.01562500 | 0 |

| task_close_problem | 0.01562500 | 0 |

| timeperiods | 0.01562500 | 0 |

| trends | 0.01562500 | 64 |

| trends_uint | 0.01562500 | 19 |

| trigger_depends | 0.04687500 | 41 |

| trigger_discovery | 0.03125000 | 4 |

| trigger_tag | 0.03125000 | 0 |

| triggers | 0.12500000 | 297 |

| users | 0.03125000 | 2 |

| users_groups | 0.04687500 | 2 |

| usrgrp | 0.03125000 | 5 |

| valuemaps | 0.03125000 | 17 |

+----------------------------+------------+------------+

127 rows in set (0.05 sec)

mysql>

——————————————
Done。