Hello
On 2 servers we have more mysql usage on other servers.
In mysqld.log we have couple lines:
What is thise? why fro user root? Please help.
On 2 servers we have more mysql usage on other servers.
In mysqld.log we have couple lines:
HTML:
# Time: 100712 12:31:12
# [email protected]: root[root] @ localhost []
# Query_time: 70 Lock_time: 0 Rows_sent: 494 Rows_examined: 25867
select TABLE_SCHEMA as DB,SUM(DATA_LENGTH)+SUM(INDEX_LENGTH) AS SPACEUSED from information_schema.tables GROUP BY TABLE_SCHEMA;
# Time: 100712 16:31:11
# [email protected]: root[root] @ localhost []
# Query_time: 69 Lock_time: 0 Rows_sent: 494 Rows_examined: 25867
select TABLE_SCHEMA as DB,SUM(DATA_LENGTH)+SUM(INDEX_LENGTH) AS SPACEUSED from information_schema.tables GROUP BY TABLE_SCHEMA;
# Time: 100712 20:31:08
# [email protected]: root[root] @ localhost []
# Query_time: 66 Lock_time: 0 Rows_sent: 494 Rows_examined: 25867
select TABLE_SCHEMA as DB,SUM(DATA_LENGTH)+SUM(INDEX_LENGTH) AS SPACEUSED from information_schema.tables GROUP BY TABLE_SCHEMA;
# Time: 100713 0:31:05
# [email protected]: root[root] @ localhost []
# Query_time: 63 Lock_time: 0 Rows_sent: 494 Rows_examined: 25867
select TABLE_SCHEMA as DB,SUM(DATA_LENGTH)+SUM(INDEX_LENGTH) AS SPACEUSED from information_schema.tables GROUP BY TABLE_SCHEMA;
# Time: 100713 4:31:10
# [email protected]: root[root] @ localhost []
# Query_time: 69 Lock_time: 0 Rows_sent: 494 Rows_examined: 25867
select TABLE_SCHEMA as DB,SUM(DATA_LENGTH)+SUM(INDEX_LENGTH) AS SPACEUSED from information_schema.tables GROUP BY TABLE_SCHEMA;
# Time: 100713 8:31:02
# [email protected]: root[root] @ localhost []
# Query_time: 60 Lock_time: 0 Rows_sent: 494 Rows_examined: 25867
select TABLE_SCHEMA as DB,SUM(DATA_LENGTH)+SUM(INDEX_LENGTH) AS SPACEUSED from information_schema.tables GROUP BY TABLE_SCHEMA;
# Time: 100713 12:31:24
# [email protected]: root[root] @ localhost []
# Query_time: 82 Lock_time: 0 Rows_sent: 494 Rows_examined: 25867
select TABLE_SCHEMA as DB,SUM(DATA_LENGTH)+SUM(INDEX_LENGTH) AS SPACEUSED from information_schema.tables GROUP BY TABLE_SCHEMA;
# Time: 100713 16:31:16
# [email protected]: root[root] @ localhost []
# Query_time: 74 Lock_time: 0 Rows_sent: 494 Rows_examined: 25880
select TABLE_SCHEMA as DB,SUM(DATA_LENGTH)+SUM(INDEX_LENGTH) AS SPACEUSED from information_schema.tables GROUP BY TABLE_SCHEMA;
# Time: 100713 20:31:05
# [email protected]: root[root] @ localhost []
# Query_time: 63 Lock_time: 0 Rows_sent: 495 Rows_examined: 25901
select TABLE_SCHEMA as DB,SUM(DATA_LENGTH)+SUM(INDEX_LENGTH) AS SPACEUSED from information_schema.tables GROUP BY TABLE_SCHEMA;
# Time: 100714 0:31:03
# [email protected]: root[root] @ localhost []
# Query_time: 62 Lock_time: 0 Rows_sent: 495 Rows_examined: 25901
select TABLE_SCHEMA as DB,SUM(DATA_LENGTH)+SUM(INDEX_LENGTH) AS SPACEUSED from information_schema.tables GROUP BY TABLE_SCHEMA;
# Time: 100714 4:31:13
# [email protected]: root[root] @ localhost []
# Query_time: 71 Lock_time: 0 Rows_sent: 495 Rows_examined: 25901
select TABLE_SCHEMA as DB,SUM(DATA_LENGTH)+SUM(INDEX_LENGTH) AS SPACEUSED from information_schema.tables GROUP BY TABLE_SCHEMA;
What is thise? why fro user root? Please help.