Notifications
Clear all
Topic starter
28/03/2017 4:15 am
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
28/03/2017 7:27 am
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.
Topic starter
28/03/2017 3:34 pm
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.
28/03/2017 10:23 pm
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?