WordPress.org

Forums

Disqus Comment System
Version 2.48 much more CPU than 2.46/2.47 (3 posts)

  1. MulletMidget
    Member
    Posted 4 years ago #

    After upgrading to 2.48 I noticed that the CPU usage went much higher than before.
    I downgraded to version 2.46 and the CPU usage was back to normal again.

  2. hey_suburbia
    Member
    Posted 4 years ago #

    I had a similar problem:

    WordPress Version: 3.0.1
    Disqus Comment System Version: Version 2.48

    I disabled the plugin and my site came back.

    Here is a query when the Disqus plug-in was enabled:

    4 | mickey | localhost | wiinintendo_Wordpress | Query   |   98 | Locked       | SELECT meta_id FROM wp_commentmeta WHERE meta_key = 'dsq_parent_post_id' AND comment_id = 828696     |
    |  115 | mickey | localhost | wiinintendo_Wordpress | Query   |   97 | Locked       | SELECT meta_id FROM wp_commentmeta WHERE meta_key = 'dsq_parent_post_id' AND comment_id = 828695     |
    |  168 | mickey | localhost | wiinintendo_Wordpress | Query   |  103 | Sending data | SELECT comment_id FROM wp_commentmeta WHERE meta_key = 'dsq_post_id' AND meta_value = '37305662' LIM |
    |  169 | mickey | localhost | wiinintendo_Wordpress | Query   |  104 | Sending data | SELECT comment_id FROM wp_commentmeta WHERE meta_key = 'dsq_post_id' AND meta_value = '37305662' LIM |
    |  172 | mickey | localhost | wiinintendo_Wordpress | Query   |  112 | Sending data | SELECT comment_id FROM wp_commentmeta WHERE meta_key = 'dsq_post_id' AND meta_value = '37305662' LIM |
    |  173 | mickey | localhost | wiinintendo_Wordpress | Query   |  101 | Sending data | SELECT comment_id FROM wp_commentmeta WHERE meta_key = 'dsq_post_id' AND meta_value = '37305659' LIM |
    |  249 | mickey | localhost | wiinintendo_Wordpress | Query   |  113 | Sending data | SELECT comment_id FROM wp_commentmeta WHERE meta_key = 'dsq_post_id' AND meta_value = '37305651' LIM |
    |  250 | mickey | localhost | wiinintendo_Wordpress | Query   |  105 | Sending data | SELECT comment_id FROM wp_commentmeta WHERE meta_key = 'dsq_post_id' AND meta_value = '37305651' LIM |
    |  265 | mickey | localhost | wiinintendo_Wordpress | Query   |  114 | Sending data | SELECT comment_id FROM wp_commentmeta WHERE meta_key = 'dsq_post_id' AND meta_value = '37305651' LIM |
    |  367 | mickey | localhost | wiinintendo_Wordpress | Query   |  103 | Sending data | SELECT comment_id FROM wp_commentmeta WHERE meta_key = 'dsq_post_id' AND meta_value = '37305647' LIM |
    |  370 | mickey | localhost | wiinintendo_Wordpress | Query   |  105 | Sending data | SELECT comment_id FROM wp_commentmeta WHERE meta_key = 'dsq_post_id' AND meta_value = '37305647' LIM |
    |  422 | mickey | localhost | wiinintendo_Wordpress | Query   |  114 | Sending data | SELECT comment_id FROM wp_commentmeta WHERE meta_key = 'dsq_post_id' AND meta_value = '37305642' LIM |
    |  426 | mickey | localhost | wiinintendo_Wordpress | Query   |  107 | Sending data | SELECT comment_id FROM wp_commentmeta WHERE meta_key = 'dsq_post_id' AND meta_value = '37305642' LIM |
    |  474 | mickey | localhost | wiinintendo_Wordpress | Query   |  115 | Sending data | SELECT comment_id FROM wp_commentmeta WHERE meta_key = 'dsq_post_id' AND meta_value = '37305636' LIM |
    |  478 | mickey | localhost | wiinintendo_Wordpress | Query   |  106 | Sending data | SELECT comment_id FROM wp_commentmeta WHERE meta_key = 'dsq_post_id' AND meta_value = '37305637' LIM |
    |  479 | mickey | localhost | wiinintendo_Wordpress | Query   |  110 | Sending data | SELECT comment_id FROM wp_commentmeta WHERE meta_key = 'dsq_post_id' AND meta_value = '37305637' LIM |
    |  480 | mickey | localhost | wiinintendo_Wordpress | Query   |  110 | Sending data | SELECT comment_id FROM wp_commentmeta WHERE meta_key = 'dsq_post_id' AND meta_value = '37305637' LIM |
    |  481 | mickey | localhost | wiinintendo_Wordpress | Query   |  108 | Sending data | SELECT comment_id FROM wp_commentmeta WHERE meta_key = 'dsq_post_id' AND meta_value = '37305637' LIM |
    |  482 | mickey | localhost | wiinintendo_Wordpress | Query   |  115 | Sending data | SELECT comment_id FROM wp_commentmeta WHERE meta_key = 'dsq_post_id' AND meta_value = '37305637' LIM |
    |  483 | mickey | localhost | wiinintendo_Wordpress | Query   |  111 | Sending data | SELECT comment_id FROM wp_commentmeta WHERE meta_key = 'dsq_post_id' AND meta_value = '37305637' LIM |
    |  484 | mickey | localhost | wiinintendo_Wordpress | Query   |  104 | Sending data | SELECT comment_id FROM wp_commentmeta WHERE meta_key = 'dsq_post_id' AND meta_value = '37305637' LIM |
    |  485 | mickey | localhost | wiinintendo_Wordpress | Query   |  111 | Sending data | SELECT comment_id FROM wp_commentmeta WHERE meta_key = 'dsq_post_id' AND meta_value = '37305637' LIM |
    |  583 | mickey | localhost | wiinintendo_Wordpress | Query   |  107 | Sending data | SELECT comment_id FROM wp_commentmeta WHERE meta_key = 'dsq_post_id' AND meta_value = '37305634' LIM |
    |  584 | mickey | localhost | wiinintendo_Wordpress | Query   |  105 | Sending data | SELECT comment_id FROM wp_commentmeta WHERE meta_key = 'dsq_post_id' AND meta_value = '37305637' LIM |
    |  589 | mickey | localhost | wiinintendo_Wordpress | Query   |  104 | Sending data | SELECT comment_id FROM wp_commentmeta WHERE meta_key = 'dsq_post_id' AND meta_value = '37305637' LIM |
    |  588 | mickey | localhost | wiinintendo_Wordpress | Query   |  103 | Sending data | SELECT comment_id FROM wp_commentmeta WHERE meta_key = 'dsq_post_id' AND meta_value = '37305637' LIM |
    |  592 | mickey | localhost | wiinintendo_Wordpress | Query   |  105 | Sending data | SELECT comment_id FROM wp_commentmeta WHERE meta_key = 'dsq_post_id' AND meta_value = '37305634' LIM |
    |  705 | mickey | localhost | wiinintendo_Wordpress | Query   |  103 | Sending data | SELECT comment_id FROM wp_commentmeta WHERE meta_key = 'dsq_post_id' AND meta_value = '37305634' LIM |
    |  704 | mickey | localhost | wiinintendo_Wordpress | Query   |  106 | Sending data | SELECT comment_id FROM wp_commentmeta WHERE meta_key = 'dsq_post_id' AND meta_value = '37305634' LIM |
    |  709 | mickey | localhost | wiinintendo_Wordpress | Query   |  107 | Sending data | SELECT comment_id FROM wp_commentmeta WHERE meta_key = 'dsq_post_id' AND meta_value = '37305637' LIM |
    |  712 | mickey | localhost | wiinintendo_Wordpress | Query   |  117 | Sending data | SELECT comment_id FROM wp_commentmeta WHERE meta_key = 'dsq_post_id' AND meta_value = '37305634' LIM |
    |  713 | mickey | localhost | wiinintendo_Wordpress | Query   |  104 | Sending data | SELECT comment_id FROM wp_commentmeta WHERE meta_key = 'dsq_post_id' AND meta_value = '37305634' LIM |
    |  714 | mickey | localhost | wiinintendo_Wordpress | Query   |  112 | Sending data | SELECT comment_id FROM wp_commentmeta WHERE meta_key = 'dsq_post_id' AND meta_value = '37305634' LIM |
    |  715 | mickey | localhost | wiinintendo_Wordpress | Query   |    3 | Locked       | SELECT comment_id FROM wp_commentmeta WHERE meta_key = 'dsq_post_id' AND meta_value = '37305635' LIM |
    |  799 | mickey | localhost | wiinintendo_Wordpress | Query   |  107 | Sending data | SELECT comment_id FROM wp_commentmeta WHERE meta_key = 'dsq_post_id' AND meta_value = '37305634' LIM |
    |  800 | mickey | localhost | wiinintendo_Wordpress | Query   |  106 | Sending data | SELECT comment_id FROM wp_commentmeta WHERE meta_key = 'dsq_post_id' AND meta_value = '37305634' LIM |
    |  866 | mickey | localhost | wiinintendo_Wordpress | Query   |  105 | Sending data | SELECT comment_id FROM wp_commentmeta WHERE meta_key = 'dsq_post_id' AND meta_value = '37305629' LIM |
    |  867 | mickey | localhost | wiinintendo_Wordpress | Query   |  117 | Sending data | SELECT comment_id FROM wp_commentmeta WHERE meta_key = 'dsq_post_id' AND meta_value = '37305629' LIM |
    |  868 | mickey | localhost | wiinintendo_Wordpress | Query   |  111 | Sending data | SELECT comment_id FROM wp_commentmeta WHERE meta_key = 'dsq_post_id' AND meta_value = '37305628' LIM |
    |  869 | mickey | localhost | wiinintendo_Wordpress | Query   |  105 | Sending data | SELECT comment_id FROM wp_commentmeta WHERE meta_key = 'dsq_post_id' AND meta_value = '37305627' LIM |
    |  871 | mickey | localhost | wiinintendo_Wordpress | Query   |  111 | Sending data | SELECT comment_id FROM wp_commentmeta WHERE meta_key = 'dsq_post_id' AND meta_value = '37305629' LIM |
    |  872 | mickey | localhost | wiinintendo_Wordpress | Query   |  110 | Sending data | SELECT comment_id FROM wp_commentmeta WHERE meta_key = 'dsq_post_id' AND meta_value = '37305629' LIM |
    |  873 | mickey | localhost | wiinintendo_Wordpress | Query   |  103 | Sending data | SELECT comment_id FROM wp_commentmeta WHERE meta_key = 'dsq_post_id' AND meta_value = '37305629' LIM |
    |  874 | mickey | localhost | wiinintendo_Wordpress | Query   |  110 | Sending data | SELECT comment_id FROM wp_commentmeta WHERE meta_key = 'dsq_post_id' AND meta_value = '37305629' LIM |
    |  875 | mickey | localhost | wiinintendo_Wordpress | Query   |  114 | Sending data | SELECT comment_id FROM wp_commentmeta WHERE meta_key = 'dsq_post_id' AND meta_value = '37305629' LIM |
    |  876 | mickey | localhost | wiinintendo_Wordpress | Query   |  113 | Sending data | SELECT comment_id FROM wp_commentmeta WHERE meta_key = 'dsq_post_id' AND meta_value = '37305629' LIM |
    |  877 | mickey | localhost | wiinintendo_Wordpress | Query   |  114 | Sending data | SELECT comment_id FROM wp_commentmeta WHERE meta_key = 'dsq_post_id' AND meta_value = '37305629' LIM |
    |  880 | mickey | localhost | wiinintendo_Wordpress | Query   |  112 | Sending data | SELECT comment_id FROM wp_commentmeta WHERE meta_key = 'dsq_post_id' AND meta_value = '37305628' LIM |
    |  882 | mickey | localhost | wiinintendo_Wordpress | Query   |  104 | Sending data | SELECT comment_id FROM wp_commentmeta WHERE meta_key = 'dsq_post_id' AND meta_value = '37305629' LIM |
    |  885 | mickey | localhost | wiinintendo_Wordpress | Query   |  105 | Sending data | SELECT comment_id FROM wp_commentmeta WHERE meta_key = 'dsq_post_id' AND meta_value = '37305629' LIM |
    |  928 | mickey | localhost | wiinintendo_Wordpress | Query   |  114 | Sending data | SELECT comment_id FROM wp_commentmeta WHERE meta_key = 'dsq_post_id' AND meta_value = '37305629' LIM |
    |  929 | mickey | localhost | wiinintendo_Wordpress | Query   |  103 | Sending data | SELECT comment_id FROM wp_commentmeta WHERE meta_key = 'dsq_post_id' AND meta_value = '37305629' LIM |
    | 1012 | mickey | localhost | wiinintendo_Wordpress | Query   |  107 | Sending data | SELECT comment_id FROM wp_commentmeta WHERE meta_key = 'dsq_post_id' AND meta_value = '37305628' LIM |
    | 1013 | mickey | localhost | wiinintendo_Wordpress | Query   |  113 | Sending data | SELECT comment_id FROM wp_commentmeta WHERE meta_key = 'dsq_post_id' AND meta_value = '37305629' LIM |
    | 1014 | mickey | localhost | wiinintendo_Wordpress | Query   |  104 | Sending data | SELECT comment_id FROM wp_commentmeta WHERE meta_key = 'dsq_post_id' AND meta_value = '37305629' LIM |
    | 1015 | mickey | localhost | wiinintendo_Wordpress | Query   |  106 | Sending data | SELECT comment_id FROM wp_commentmeta WHERE meta_key = 'dsq_post_id' AND meta_value = '37305629' LIM |
    | 1016 | mickey | localhost | wiinintendo_Wordpress | Query   |  106 | Sending data | SELECT comment_id FROM wp_commentmeta WHERE meta_key = 'dsq_post_id' AND meta_value = '37305629' LIM |
    | 1017 | mickey | localhost | wiinintendo_Wordpress | Query   |  108 | Sending data | SELECT comment_id FROM wp_commentmeta WHERE meta_key = 'dsq_post_id' AND meta_value = '37305629' LIM |
    | 1085 | mickey | localhost | wiinintendo_Wordpress | Query   |  112 | Sending data | SELECT comment_id FROM wp_commentmeta WHERE meta_key = 'dsq_post_id' AND meta_value = '37305629' LIM |
    | 1090 | mickey | localhost | wiinintendo_Wordpress | Query   |  112 | Sending data | SELECT comment_id FROM wp_commentmeta WHERE meta_key = 'dsq_post_id' AND meta_value = '37305628' LIM |
    | 1160 | mickey | localhost | wiinintendo_Wordpress | Query   |  102 | Sending data | SELECT comment_id FROM wp_commentmeta WHERE meta_key = 'dsq_post_id' AND meta_value = '37305623' LIM |
    | 1166 | mickey | localhost | wiinintendo_Wordpress | Query   |  105 | Sending data | SELECT comment_id FROM wp_commentmeta WHERE meta_key = 'dsq_post_id' AND meta_value = '37305623' LIM |
    | 1167 | mickey | localhost | wiinintendo_Wordpress | Query   |    2 | Locked       | SELECT comment_id FROM wp_commentmeta WHERE meta_key = 'dsq_post_id' AND meta_value = '37305624' LIM |
    | 1170 | mickey | localhost | wiinintendo_Wordpress | Query   |  120 | Sending data | SELECT comment_id FROM wp_commentmeta WHERE meta_key = 'dsq_post_id' AND meta_value = '37305623' LIM |
    | 1276 | mickey | localhost | wiinintendo_Wordpress | Query   |  117 | Sending data | SELECT comment_id FROM wp_commentmeta WHERE meta_key = 'dsq_post_id' AND meta_value = '37305622' LIM |
    | 1281 | mickey | localhost | wiinintendo_Wordpress | Query   |  124 | Sending data | SELECT comment_id FROM wp_commentmeta WHERE meta_key = 'dsq_post_id' AND meta_value = '37305622' LIM |
    | 1282 | mickey | localhost | wiinintendo_Wordpress | Query   |  116 | Sending data | SELECT comment_id FROM wp_commentmeta WHERE meta_key = 'dsq_post_id' AND meta_value = '37305622' LIM |
    | 1284 | mickey | localhost | wiinintendo_Wordpress | Query   |  104 | Sending data | SELECT comment_id FROM wp_commentmeta WHERE meta_key = 'dsq_post_id' AND meta_value = '37305623' LIM |
    | 1285 | mickey | localhost | wiinintendo_Wordpress | Query   |  111 | Sending data | SELECT comment_id FROM wp_commentmeta WHERE meta_key = 'dsq_post_id' AND meta_value = '37305622' LIM |
    | 1371 | mickey | localhost | wiinintendo_Wordpress | Query   |  106 | Sending data | SELECT comment_id FROM wp_commentmeta WHERE meta_key = 'dsq_post_id' AND meta_value = '37305620' LIM |
    | 1448 | mickey | localhost | wiinintendo_Wordpress | Query   |  105 | Sending data | SELECT comment_id FROM wp_commentmeta WHERE meta_key = 'dsq_post_id' AND meta_value = '37305620' LIM |
    | 1457 | mickey | localhost | wiinintendo_Wordpress | Query   |  111 | Sending data | SELECT comment_id FROM wp_commentmeta WHERE meta_key = 'dsq_post_id' AND meta_value = '37305620' LIM |
    | 1460 | mickey | localhost | wiinintendo_Wordpress | Query   |  114 | Sending data | SELECT comment_id FROM wp_commentmeta WHERE meta_key = 'dsq_post_id' AND meta_value = '37305620' LIM |
    | 1468 | mickey | localhost | wiinintendo_Wordpress | Query   |  103 | Sending data | SELECT comment_id FROM wp_commentmeta WHERE meta_key = 'dsq_post_id' AND meta_value = '37305620' LIM |
    | 1469 | mickey | localhost | wiinintendo_Wordpress | Query   |  105 | Sending data | SELECT comment_id FROM wp_commentmeta WHERE meta_key = 'dsq_post_id' AND meta_value = '37305620' LIM |
    | 1470 | mickey | localhost | wiinintendo_Wordpress | Query   |  113 | Sending data | SELECT comment_id FROM wp_commentmeta WHERE meta_key = 'dsq_post_id' AND meta_value = '37305620' LIM |
    | 1545 | mickey | localhost | wiinintendo_Wordpress | Query   |  107 | Sending data | SELECT comment_id FROM wp_commentmeta WHERE meta_key = 'dsq_post_id' AND meta_value = '37305620' LIM |
    | 1549 | mickey | localhost | wiinintendo_Wordpress | Query   |  104 | Sending data | SELECT comment_id FROM wp_commentmeta WHERE meta_key = 'dsq_post_id' AND meta_value = '37305620' LIM |
    | 1548 | mickey | localhost | wiinintendo_Wordpress | Query   |  103 | Sending data | SELECT comment_id FROM wp_commentmeta WHERE meta_key = 'dsq_post_id' AND meta_value = '37305620' LIM |
    | 1547 | mickey | localhost | wiinintendo_Wordpress | Query   |  113 | Sending data | SELECT comment_id FROM wp_commentmeta WHERE meta_key = 'dsq_post_id' AND meta_value = '37305620' LIM |
    | 1546 | mickey | localhost | wiinintendo_Wordpress | Query   |  106 | Sending data | SELECT comment_id FROM wp_commentmeta WHERE meta_key = 'dsq_post_id' AND meta_value = '37305620' LIM |
    | 1553 | mickey | localhost | wiinintendo_Wordpress | Query   |  107 | Sending data | SELECT comment_id FROM wp_commentmeta WHERE meta_key = 'dsq_post_id' AND meta_value = '37305620' LIM |
    | 1552 | mickey | localhost | wiinintendo_Wordpress | Query   |  104 | Sending data | SELECT comment_id FROM wp_commentmeta WHERE meta_key = 'dsq_post_id' AND meta_value = '37305620' LIM |
    | 1555 | mickey | localhost | wiinintendo_Wordpress | Query   |  103 | Sending data | SELECT comment_id FROM wp_commentmeta WHERE meta_key = 'dsq_post_id' AND meta_value = '37305623' LIM |
    | 1556 | mickey | localhost | wiinintendo_Wordpress | Query   |  103 | Sending data | SELECT comment_id FROM wp_commentmeta WHERE meta_key = 'dsq_post_id' AND meta_value = '37305620' LIM |

    Now here is how your MySQL queries look (with the Disqus plugin Disabled):

    +-----+--------+-----------+-----------------------+---------+------+-------+------------------+
    | Id  | User   | Host      | db                    | Command | Time | State | Info             |
    +-----+--------+-----------+-----------------------+---------+------+-------+------------------+
    | 693 | mickey | localhost | wiinintendo_Wordpress | Sleep   |    0 |       | NULL             |
    | 694 | mickey | localhost | wiinintendo_Wordpress | Sleep   |    0 |       | NULL             |
    | 695 | mickey | localhost | wiinintendo_Wordpress | Sleep   |    0 |       | NULL             |
    | 696 | mickey | localhost | wiinintendo_Wordpress | Sleep   |    0 |       | NULL             |
    | 697 | admin  | localhost | NULL                  | Query   |    0 | NULL  | show processlist |
  3. zeeg
    Member
    Plugin Contributor

    Posted 4 years ago #

    It appears there don't seem to be efficient indices on the table. Definitely a slip up on our part.

    Here's a quick fix:

    create index disqus_dupecheck on wp_commentmeta (meta_key, meta_value(11));

    We will be moving away from the comment meta I guess since it's inefficient for querying against values in WordPress.

Topic Closed

This topic has been closed to new replies.

About this Plugin

  • Disqus Comment System
  • Frequently Asked Questions
  • Support Threads
  • Reviews

About this Topic