• Plesk Uservoice will be deprecated by October. Moving forward, all product feature requests and improvement suggestions will be managed through our new platform Plesk Productboard.
    To continue sharing your ideas and feedback, please visit features.plesk.com

Question Plesk not using indexes in database?

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:
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)));
So, is Plesk really not using indexes within its database queries?
 
Back
Top