Problem with database

  • davidin80

    (@davidin80)


    11 years, 2 months ago

    Bonjour,

    Merci pour cet excellent plugin qui me permets enfin de compter efficacement le nombre de vues d’un article.

    Par contre, je viens de m’apercevoir que la taille de la base de données avait tendance a augmenter de façon exponentielle.

    En effet, dans la table wp_options, j’ai au moins 40000 lignes avec :
    – _transient_timeout_baw_count_views-xxxxxxxxxx
    – _transient_baw_count_views-xxxxxxxxxx

    Et cela augmente tous les jours.

    Peut-on supprimer ces lignes ? A quoi servent-elles ?
    Ne peuvent-elles pas se supprimer automatiquement ?

    Merci pour vos réponses.

    http://wordpress.org/extend/plugins/baw-post-views-count/

Viewing 7 replies - 1 through 7 (of 7 total)
  • Plugin Author Julio Potier

    (@juliobox)

    11 years, 2 months ago

    Bonjour

    avez vous mis un délai entre le temps de recomptage sans les options ?

    Merci

    Thread Starter davidin80

    (@davidin80)

    11 years, 2 months ago

    Bonjour,

    Je vous remercie pour votre réponse rapide.
    Voici un aperçu du paramétrage : http://data.imagup.com/10/1176474810.jpg

    Est-il possible d’épurer les tables wp_options et wp_postmeta sachant que je ne souhaite garder que le compteur total (où j’ai ajouté le hack pour récupérer le compteur WP-PostViews) et le compteur hebdomadaire ?

    Merci.

    Plugin Author Julio Potier

    (@juliobox)

    11 years, 2 months ago

    Oups i forgot to talk in english here (sorry Mika!)

    Ok so, the “900 sec” parameter is guilty, and so am i.

    I’ll have a look asap.

    Thanks for your interest!

    Thread Starter davidin80

    (@davidin80)

    11 years, 2 months ago

    Okay!
    I look forward to hearing from you.
    Especially for cleaning the database.

    thank you

    Thread Starter davidin80

    (@davidin80)

    11 years, 1 month ago

    Hi,

    Could you find a solution?
    Thank you.

    trevhcs

    (@trevhcs)

    11 years, 1 month ago

    Not sure if the 900 seconds is necessarily the cause as I just discovered this problem on 1 of our 2 popular blogs. Both blogs have identical settings for this plugin and both run on WP 3.5.1 (upgraded from 3.4.x).

    One blog shows nothing when I search the database for the rows mentioned below, but the other had over 80,000 each of these two rows:

    %_transient_timeout_baw_%
    %_transient_baw_count_views-%

    They both have the “Time between counts” set to 0 and all other plugin settings are identical.

    I deleted all those rows from the misbehaving blog, but it’s now adding them back slowly again. The other blog is still showing no new rows.

    Only discovered this after the database update for v3.5.1 kept failing and after much searching it was getting stuck reading 161,000 rows from wp_options. 🙂

    ——–

    Regarding cleaning the database as David asked. What I did was this and can’t see anything broken yet.

    DELETE FROM  'wp_options' WHERE  'option_name' LIKE  '%_transient_timeout_baw_%'

DELETE FROM  'wp_options' WHERE 'option_name' LIKE  '%_transient_baw_count_views%'

    Trev

    trevhcs

    (@trevhcs)

    11 years, 1 month ago

    [Sorry, this was a double post – double clicked the submit button]

Viewing 7 replies - 1 through 7 (of 7 total)
  • The topic ‘Problem with database’ is closed to new replies.