Cannot Collect Old Data in Count Per Day

  • Resolved carlyjcais

    (@carlyjcais)


    10 years, 6 months ago

    Hi-
    Count Per Day has made my database tables MASSIVE (556 MB), and for 2 months I have been unable to backup my site at all due to server timeout during database dump.

    I saw the previous post and read your response to collect old data in the plugin’s Tools section, which I have tried to do 3 times.

    I changed it to only keep 1 previous month+current month in counter table. I don’t need any of this data – all I want to retain is the post-read counts that appear in my WP dashboard next to the post-titles. That’s it – that’s the only thing I use the plugin for.

    I cleaned out the mass bots and changed the settings to not save + show client referrers, and to use URLs only, no query string.

    But each time I press the “Collect Old Data” button (with “Delete old collection and create a new one” checked), the site spends 5 minutes loading in the backend, and comes back with “Backup of 2834158 entries in progress. Every point complies 10000 entries.

    And the Current size of my counter table wp_cpd_counter does not change each time I do this. I also cannot delete any counter table backups – I just get a blank screen when I click the button.

    Please tell me how to get rid of all this old database information so I can finally backup my site, and continue to use Count Per Day to just keep track of post-reads in my Dashboard.

    Thank you!

    http://wordpress.org/plugins/count-per-day/

Viewing 9 replies - 1 through 9 (of 9 total)
  • Plugin Author tom-braider

    (@tom-braider)

    10 years, 6 months ago

    When you show “Backup of 2834158 entries in progress. Every point complies 10000 entries.” you see some lines ||||?
    It seems the 5 minutes timeout is the php timeout. I work with parts of 10000 entries to not run in any timeout. This work around seems not working for you. Do you get any php or javascript errors?

    Is the wp-content directory writable? Do you have the permissions to delete the files? Otherwise delete the old files per ftp.

    Thread Starter carlyjcais

    (@carlyjcais)

    10 years, 6 months ago

    Yes, I do see some lines ||||| – about 200 of them.

    I don’t believe there are any php or javascript errors otherwise – at least not that I can see or that are displayed in the browser window.

    Yes, the wp-content directory is writeable. I deleted all of the backups that were created yesterday when I clicked the “Collect Old Data” button, via FTP as you wrote above.

    However, I still need to Collect all my Old Data to delete this enormous 550 MB database table. All I want to keep are the number of post-reads that are displayed in the All Posts Dashboard. I don’t want or need any other data, just the total number of times each post has been read.

    How do I get rid of all the old data?

    Thank you.
    Best,
    Carly

    Plugin Author tom-braider

    (@tom-braider)

    10 years, 6 months ago

    OK, if you see a lot of |||| the script should work.
    With every single | the page reloads, so i don’t know why you get an timeout.
    I tested this function with 1000000 entries in the database round about 100 MB.
    OK, to make your databas smaller you can empty (not delete) the columns client and referer of the table wp_cpd_counter. They needing a lot of space. Maybe after that the collections works better.

    Thread Starter carlyjcais

    (@carlyjcais)

    10 years, 6 months ago

    I’m sorry…how do I empty the client and referer columns?

    Through the Tools or Settings tab in the Dashboard?
    Please provide the steps so I may do this.

    Thank you.
    Best,
    Carly

    Plugin Author tom-braider

    (@tom-braider)

    10 years, 6 months ago

    with phpmyadmin or another database admin tool of your hoster. but if you don’t know that it would be better to ask a friend. 😉

    Thread Starter carlyjcais

    (@carlyjcais)

    10 years, 6 months ago

    Um…no, I do not know how, and I have no friends that are technically sophisticated enough to be able to use phpmyadmin.

    Please provide the steps I must do in order to ensure that the plugin you authored does not interfere with backing up my site.

    Thank you.
    Best,
    Carly

    Plugin Author tom-braider

    (@tom-braider)

    10 years, 6 months ago

    You have to go to your MySql database admin tool and run the SQL Querys

    UPDATE wp_cpd_counter SET client = '', referer = '';
OPTIMIZE TABLE wp_cpd_counter;

    This will empty the two columns and free a lot of space.

    Thread Starter carlyjcais

    (@carlyjcais)

    10 years, 6 months ago

    Thank you – I will try that.

    sakbudak

    (@sakbudak)

    10 years, 5 months ago

    Thank you !!!

    UPDATE wp_cpd_counter SET client = '', referer = '';
OPTIMIZE TABLE wp_cpd_counter;

    Saved my life 🙂

Viewing 9 replies - 1 through 9 (of 9 total)
  • The topic ‘Cannot Collect Old Data in Count Per Day’ is closed to new replies.