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.

    Thread Starter LSP Sopheak

    (@lsp_sopgheak)

    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.

    Thread Starter LSP Sopheak

    (@lsp_sopgheak)

    OK. Thanks.

    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.

    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?

    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.