[Plugin: Disqus Comment System] Version 2.48 much more CPU than 2.46/2.47

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 |

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.