• If you are still using CentOS 7.9, it's time to convert to Alma 8 with the free centos2alma tool by Plesk or Plesk Migrator. Please let us know your experiences or concerns in this thread:
    CentOS2Alma discussion
  • Inviting everyone to the UX test of a new security feature in the WP Toolkit
    For WordPress site owners, threats posed by hackers are ever-present. Because of this, we are developing a new security feature for the WP Toolkit. If the topic of WordPress website security is relevant to you, we would be grateful if you could share your experience and help us test the usability of this feature. We invite you to join us for a 1-hour online session via Google Meet. Select a convenient meeting time with our friendly UX staff here.

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