Fabian H
Basic Pleskian
In order to speed up my database I logged all queries not using indexes.
There are many queries from plesk, like this:
So, is Plesk really not using indexes within its database queries?
There are many queries from plesk, like this:
Code:
# Time: 211217 16:22:36
# User@Host: admin[admin] @ localhost []
# Thread_id: 99564 Schema: psa QC_hit: No
# Query_time: 0.000300 Lock_time: 0.000088 Rows_sent: 120 Rows_examined: 120
# Rows_affected: 0 Bytes_sent: 5115
use psa;
SET timestamp=1639754556;
select param, val from misc;
# User@Host: admin[admin] @ localhost []
# Thread_id: 99564 Schema: psa QC_hit: No
# Query_time: 0.000105 Lock_time: 0.000049 Rows_sent: 1 Rows_examined: 1
# Rows_affected: 0 Bytes_sent: 113
SET timestamp=1639754556;
SELECT `SchemaVersions`.* FROM `SchemaVersions` LIMIT 1;
# User@Host: admin[admin] @ localhost []
# Thread_id: 99564 Schema: psa QC_hit: No
# Query_time: 0.000213 Lock_time: 0.000090 Rows_sent: 0 Rows_examined: 0
# Rows_affected: 0 Bytes_sent: 11
SET timestamp=1639754556;
DELETE FROM `SessionContexts` WHERE (`sessionId` IN (SELECT `sessions`.`sess_id` FROM `sessions` WHERE (`modified` + `lifetime` < 1639754556)));