Nerver use this plugin!

  • tanviet

    (@tanviet)


    7 years ago

    This is very bad plugin, Do not use it if you do not want your website to be slow.

    Each visit, this plugin will insert to wp_postmeta table one row. This causes the wp_postmeta table to increase the number of rows over time. Table wp_postmeta is important because every regular WordPress query is joined to this table.

    Do not use it if you do not want your website to be slow!

    Example:

    MariaDB [xxxxx]select * from wp_postmeta order by meta_id desc limit 10;
    +———+———+—————————+————+
    | meta_id | post_id | meta_key | meta_value |
    +———+———+—————————+————+
    | 138843 | 3466 | _count-views_day-20171118 | 1 |
    | 138842 | 10266 | _count-views_day-20171118 | 1 |
    | 138841 | 3436 | _count-views_day-20171118 | 1 |
    | 138840 | 8485 | _count-views_day-20171118 | 1 |
    | 138839 | 9338 | _count-views_day-20171118 | 1 |
    | 138838 | 4667 | _count-views_day-20171118 | 1 |
    | 138837 | 3144 | _count-views_day-20171118 | 2 |
    | 138836 | 4425 | _count-views_day-20171118 | 1 |
    | 138835 | 2458 | _count-views_day-20171118 | 1 |
    | 138834 | 8210 | _count-views_day-20171118 | 1 |
    +———+———+—————————+————+
    MariaDB [xxxxx]> select count(*) from wp_postmeta where meta_key like ‘%count-views_day%’;
    +———-+
    | count(*) |
    +———-+
    | 71996 |
    +———-+
    1 row in set (0.08 sec)

    Simple WordPress query, but it takes 3.19 seconds

    MariaDB [admin_dbwiki]> SELECT SQL_NO_CACHE DISTINCT post_title, ID, post_type, post_name
    -> FROM wp_posts wposts
    -> LEFT JOIN wp_postmeta wpostmeta ON wposts.ID = wpostmeta.post_id
    -> LEFT JOIN wp_term_relationships ON (wposts.ID = wp_term_relationships.object_id)
    -> LEFT JOIN wp_term_taxonomy ON (wp_term_relationships.term_taxonomy_id = wp_term_taxonomy.term_taxonomy_id)
    -> WHERE (post_type=’page’
    -> OR (wp_term_taxonomy.taxonomy = ‘category’ AND wp_term_taxonomy.term_id=197))
    -> AND post_status = ‘publish’ AND LENGTH(post_title)>=5 ORDER BY LENGTH(post_title) ASC LIMIT 500;

    ……..
    17 rows in set (3.19 sec)

  • The topic ‘Nerver use this plugin!’ is closed to new replies.