Search
Close
AI Search
Classic Search
 Search Phrase:
 Search Type:
Advanced search options
 Search in Forums:
 Search in date period:

 Sort Search Results by:

AI Assistant
Notifications
Clear all

What are these queries for and how to disable them?

4 Posts
2 Users
0 Reactions
4,825 Views
(@mirakuru)
Eminent Member
Joined: 9 years ago
Posts: 24
Topic starter
Translate
English
Spanish
French
German
Italian
Portuguese
Russian
Chinese
Japanese
Korean
Arabic
Hindi
Dutch
Polish
Turkish
Vietnamese
Thai
Swedish
Danish
Finnish
Norwegian
Czech
Hungarian
Romanian
Greek
Hebrew
Indonesian
Malay
Ukrainian
Bulgarian
Croatian
Slovak
Slovenian
Serbian
Lithuanian
Latvian
Estonian
  [#1227]

I have millions of queries without indexes, and wanted to know what are they doing and if it's possible to disable a function to stop them, these are some examples:

SELECT `phrase_key` FROM `wp_wc_phrases` WHERE `phrase_key` LIKE 'wc_be_the_first_text';
# Query_time: 0.000205  Lock_time: 0.000039 Rows_sent: 101  Rows_examined: 101
SET timestamp=1490659590;
SELECT `phrase_key`, `phrase_value` FROM `wp_wc_phrases`;
# Time: 170328 0:06:31 # Query_time: 0.000411 Lock_time: 0.000152 Rows_sent: 1 Rows_examined: 101 SET timestamp=1490659591; SELECT `phrase_key` FROM `wp_wc_phrases` WHERE `phrase_key` LIKE 'wc_be_the_first_text'; # Query_time: 0.000162 Lock_time: 0.000038 Rows_sent: 101 Rows_examined: 101 SET timestamp=1490659591; SELECT `phrase_key`, `phrase_value` FROM `wp_wc_phrases`; # Query_time: 0.000558 Lock_time: 0.000198 Rows_sent: 0 Rows_examined: 0

 



   
Quote
 Tom
(@tomson)
Famed Member Admin
Joined: 11 years ago
Posts: 4245
Translate
English
Spanish
French
German
Italian
Portuguese
Russian
Chinese
Japanese
Korean
Arabic
Hindi
Dutch
Polish
Turkish
Vietnamese
Thai
Swedish
Danish
Finnish
Norwegian
Czech
Hungarian
Romanian
Greek
Hebrew
Indonesian
Malay
Ukrainian
Bulgarian
Croatian
Slovak
Slovenian
Serbian
Lithuanian
Latvian
Estonian
 

I don't think they are millions. Each comment form has it's own a few phrases and it gets from DB. wpDiscuz phrases are stored in DB and it loads them before showing the form.

You can try use PO/MO files instead of phrase system by enabling according option in Dashboard > Comments > Settings admin page.



   
ReplyQuote
(@mirakuru)
Eminent Member
Joined: 9 years ago
Posts: 24
Topic starter
Translate
English
Spanish
French
German
Italian
Portuguese
Russian
Chinese
Japanese
Korean
Arabic
Hindi
Dutch
Polish
Turkish
Vietnamese
Thai
Swedish
Danish
Finnish
Norwegian
Czech
Hungarian
Romanian
Greek
Hebrew
Indonesian
Malay
Ukrainian
Bulgarian
Croatian
Slovak
Slovenian
Serbian
Lithuanian
Latvian
Estonian
 

I logged it for about 5 minutes and there were a thousand.
I disabled it, i hope it stops those queries.
Not good for busy sites.



   
ReplyQuote
 Tom
(@tomson)
Famed Member Admin
Joined: 11 years ago
Posts: 4245
Translate
English
Spanish
French
German
Italian
Portuguese
Russian
Chinese
Japanese
Korean
Arabic
Hindi
Dutch
Polish
Turkish
Vietnamese
Thai
Swedish
Danish
Finnish
Norwegian
Czech
Hungarian
Romanian
Greek
Hebrew
Indonesian
Malay
Ukrainian
Bulgarian
Croatian
Slovak
Slovenian
Serbian
Lithuanian
Latvian
Estonian
 

Do you have thousands of visitors per sec? This is the only way to get so many queries. Have you turned on the PO/MO file usage mentioned above?



   
ReplyQuote
Share:
Scroll to top