Support » Plugin: Count per Day » WP Count Per Day make my db larger

Viewing 10 replies - 1 through 10 (of 10 total)
  • Plugin Author Tom Braider

    (@tom-braider)

    Use the collection function of CpD if you want to keep some summaries or just empty the DB table to free space and loose the data.

    Thank for your response Author.

    Is there any solution instead of emptying db table?

    Plugin Author Tom Braider

    (@tom-braider)

    You can free space by deleting data only.
    But you can as i said use the collection function to get summaries of the counter data. Look at the tools section at the options page.

    OK. Thanks.

    blogwire

    (@blogwire)

    I find this plugin excellent but a huge resource drain. With p3tools it is 56% just for CpD…Any suggestions to reduce server load?
    Thanks

    Plugin Author Tom Braider

    (@tom-braider)

    Check the Debug mode to find out which part uses the memory or time.
    Maybe you have to clean up/size down the database.

    blogwire

    (@blogwire)

    Count per Day - DEBUG: 0.328 s 1.Server: Apache
    PHP: 5.4.29
    mySQL Server: 5.5.37-35.1
    mySQL Client: 5.5.37-35.1
    WordPress: 3.9.1
    Count per Day: 3.2.10
    Time for Count per Day: 2014-07-03 07:04
    URL: www.blogwire.ca/wp-admin/index.php?page=cpd_metaboxes
    Referrer: http://www.blogwire.ca/wp-admin/options-general.php?page=count-per-day/counter-options.php
    PHP-Memory: peak: 31.04 MB, limit: 256M
    2.POST:
     array(0) { }
    3.SESSION:
     array(1) { ["cpd_wp"]=> string(28) "/home3/bloglink/public_html/" }
    4.Table:
    bl_cpd_counter: id = int(10)   ip = int(10) unsigned   client = varchar(150)   date = date   page = mediumint(9)   country = char(2)   referer = varchar(100)
    5.Options:
     version = 3.2.10
     onlinetime = 300
     user = 0
     user_level = 0
     autocount = 1
     dashboard_posts = 5
     dashboard_last_posts = 5
     dashboard_last_days = 7
     show_in_lists = 0
     chart_days = 30
     chart_height = 200
     countries = 25
     startdate =
     startcount =
     startreads =
     anoip = 0
     massbotlimit = 25
     clients = Firefox, MSIE, Chrome, Safari, Opera
     ajax = 1
     debug = 1
     referers = 0
     referers_cut = 0
     localref = 0
     dashboard_referers = 10
     referers_last_days = 7
     no_front_css = 1
     whocansee = publish_posts
     backup_part = 10000
     chart_old = 0
    
    6.ChartReads 274 : 0.01206 - 27.41 MB
     SELECT COUNT(*) count, c.date FROM bl_cpd_counter c WHERE c.date BETWEEN '2014-06-04' AND '2014-07-03' GROUP BY c.date
    
    7.ChartVisitors 289 : 0.01147 - 27.43 MB
     SELECT COUNT(*) count, t.date FROM ( SELECT COUNT(*) count, date FROM bl_cpd_counter GROUP BY date, ip ) AS t WHERE t.date BETWEEN '2014-06-04' AND '2014-07-03' GROUP BY t.date
    
    8.getReadsAll 474 : 0.00028 - 27.38 MB
    SELECT COUNT(*) FROM bl_cpd_counter
    
    9.getReadsToday 497 : 0.00027 - 27.38 MB
    SELECT COUNT(*) FROM bl_cpd_counter WHERE date = '2014-07-03'
    
    10.getReadsYesterday 517 : 0.00019 - 27.38 MB
    SELECT COUNT(*) FROM bl_cpd_counter WHERE date = DATE_SUB('2014-07-03', INTERVAL 1 DAY)
    
    11.getReadsLastWeek 537 : 0.00066 - 27.38 MB
    SELECT COUNT(*) FROM bl_cpd_counter WHERE date >= DATE_SUB('2014-07-03', INTERVAL 7 DAY)
    
    12.getReadsThisMonth 559 : 0.00013 - 27.38 MB
    SELECT COUNT(*) FROM bl_cpd_counter WHERE date >= '2014-07-01';
    
    13.getUserAll 463 : 0.01492 - 27.39 MB
    SELECT 1 FROM bl_cpd_counter GROUP BY date, ip
    
    14.getUserToday 486 : 0.00039 - 27.39 MB
    SELECT 1 FROM bl_cpd_counter WHERE date = '2014-07-03' GROUP BY ip
    
    15.getUserYesterday 507 : 0.00020 - 27.39 MB
    SELECT 1 FROM bl_cpd_counter WHERE date = DATE_SUB('2014-07-03', INTERVAL 1 DAY) GROUP BY ip
    
    16.getUserLastWeek 527 : 0.00078 - 27.39 MB
    SELECT 1 FROM bl_cpd_counter WHERE date >= DATE_SUB('2014-07-03', INTERVAL 7 DAY) GROUP BY date, ip;
    
    17.getUserThisMonth 548 : 0.00020 - 27.39 MB
    SELECT 1 FROM bl_cpd_counter WHERE date >= '2014-07-01' GROUP BY date, ip;
    
    18.getUserPerDay 685 : 0.00177 - 27.39 MB
    SELECT 1 FROM bl_cpd_counter WHERE date > '2014-06-25' AND date < '2014-07-03' GROUP BY ip, date
    
    19.getDayWithMostReads 969 : 0.01090 - 27.39 MB
     SELECT date, COUNT(id) count FROM bl_cpd_counter GROUP BY date ORDER BY count DESC LIMIT 1
    
    20.getDayWithMostVisitors 993 : 0.02385 - 27.39 MB
     SELECT t.date, count(*) count FROM ( SELECT count(*) count, date, page FROM bl_cpd_counter GROUP BY date, ip ) AS t GROUP BY t.date ORDER BY count DESC LIMIT 1
    
    21.getUserPerMonths 569 : 0.02199 - 27.39 MB
    SELECT LEFT(date,7) month FROM bl_cpd_counter GROUP BY year(date), month(date) ORDER BY date DESC
    
    22.getUserPerMonth 577 : 0.01558 - 27.39 MB
    SELECT 1 FROM bl_cpd_counter WHERE LEFT(date,7) = '2014-07' GROUP BY date, ip
    
    23.getUserPerMonth 577 : 0.01810 - 27.40 MB
    SELECT 1 FROM bl_cpd_counter WHERE LEFT(date,7) = '2014-06' GROUP BY date, ip
    
    24.getCountries 1233 : 0.03252 - 27.45 MB
    SELECT country, COUNT(*) c FROM bl_cpd_counter WHERE ip > 0 GROUP BY country ORDER BY c DESC
    
    25.getCountries 1233 : 0.03370 - 27.45 MB
    SELECT country, COUNT(*) c FROM ( SELECT country, COUNT(*) c FROM bl_cpd_counter WHERE ip > 0 GROUP BY country, date, ip ) as t GROUP BY country ORDER BY c desc
    
    26.getReadsPerMonths 605 : 0.02398 - 27.40 MB
    SELECT COUNT(*) count, LEFT(date,7) month FROM bl_cpd_counter GROUP BY year(date), month(date) ORDER BY date DESC
    
    27.getUserPerPost 6491011 : 0.04171 - 29.73 MB
     SELECT COUNT(*) count, page FROM bl_cpd_counter WHERE page GROUP BY page
    
    28.getUserPerPost 649 1071 : 0.01175 - 29.74 MB
     SELECT temp_outer.* FROM ( SELECT CASE p.id WHEN 999 THEN 231 WHEN 52 THEN 81 WHEN 17082 THEN 80 WHEN -2288 THEN 69 WHEN -30 THEN 69 ELSE 0 END count, p.id post_id, p.post_title post, '' tag_cat_name, '' tag_cat_slug, '' tax FROM bl_posts p WHERE p.id IN (999,52,17082,-2288,-30) GROUP BY p.id UNION SELECT CASE -t.term_id WHEN 999 THEN 231 WHEN 52 THEN 81 WHEN 17082 THEN 80 WHEN -2288 THEN 69 WHEN -30 THEN 69 ELSE 0 END count, t.term_id post_id, '' post, t.name tag_cat_name, t.slug tag_cat_slug, x.taxonomy tax FROM bl_terms t LEFT JOIN bl_term_taxonomy x ON x.term_id = t.term_id WHERE -t.term_id IN (999,52,17082,-2288,-30) GROUP BY t.term_id ) temp_outer ORDER BY count DESC
    
    29.getMostVisitedPosts1011 : 0.04909 - 27.53 MB
     SELECT COUNT(c.id) count, c.page post_id, p.post_title post, t.name tag_cat_name, t.slug tag_cat_slug, x.taxonomy tax FROM bl_cpd_counter c LEFT JOIN bl_posts p ON p.id = c.page LEFT JOIN bl_terms t ON t.term_id = 0 - c.page LEFT JOIN bl_term_taxonomy x ON x.term_id = t.term_id WHERE c.date >= '2014-06-26' GROUP BY c.page ORDER BY count DESC LIMIT 5
    
    30.getVisitedPostsOnDay1011 : 0.00107 - 27.52 MB
     SELECT COUNT(c.id) count, c.page post_id, p.post_title post, t.name tag_cat_name, t.slug tag_cat_slug, x.taxonomy tax FROM bl_cpd_counter c LEFT JOIN bl_posts p ON p.id = c.page LEFT JOIN bl_terms t ON t.term_id = 0 - c.page LEFT JOIN bl_term_taxonomy x ON x.term_id = t.term_id WHERE c.date = '2014-07-03' GROUP BY c.page ORDER BY count DESC LIMIT 100
    
    31.showFields : 0.00264 - 27.54 MB
    SHOW FIELDS FROM <code>bl_cpd_counter</code>
    
    GeoIP: d_ir=755 f_ile=644 f_open=true g_zopen=true a_llow_url_fopen=true

    [Moderator Note: Please post log files between backticks or use the code button.]

    Plugin Author Tom Braider

    (@tom-braider)

    0.328 s for the CpD-queries and max. 31.04 MB RAM
    It’s nothing. What is the problem?

    blogwire

    (@blogwire)

    Here’s a screenshot of p3plugin profiler. cpd is using 58%. Is this normal?
    http://www.blogwire.ca/temp/cpd.jpg

    Plugin Author Tom Braider

    (@tom-braider)

    If all Plugins together are using 0.6 seconds it is correct. The absolute time is no problem i think.

Viewing 10 replies - 1 through 10 (of 10 total)
  • The topic ‘WP Count Per Day make my db larger’ is closed to new replies.