Crea sito

Plugin

NewStatPress is a new StatPress plugin for WordPress.

StatPress is a Daniele Lippi first real-time plugin dedicated to the management of statistics about blog visits.

The problem with that plugin is that the stored data will increase database size a lot and than you will not be able anymore to see realtime statistics due to 505 server error (too much server computation).

This NewStatPress will have some improvements over StatPress:

  • Uses database index to make response faster (increase index size by 80%, but response can be 50% faster)
  • Change database fields to save space (5%)
  • Use same StatPress table so you don’t lose your already collected data

Else, there will be some specific features in NewStatPress:

  • Make old data historized so you can have statistic but without having too much database usages

IMPORTANT NOTES:

  • If you use this plugin, you have to disable StatPress: never use the two plugin at the same time or you will have many troubles and wrong data collected.
  • You can go back to use StatPress but you will not see the historized data
  • This plugin born for my personal usage (I use it in 5 blogs), hope that it will be useful even for you

If you get those messages when install/upgrade the plugin:

WordPress database error: [Duplicate key name 'spider_nation']
ALTER TABLE avwp_statpress ADD index spider_nation (spider, nation)

WordPress database error: [Duplicate key name 'ip_date']
ALTER TABLE avwp_statpress ADD index ip_date (ip, date)

WordPress database error: [Duplicate key name 'agent']
ALTER TABLE avwp_statpress ADD index agent (agent)

WordPress database error: [Duplicate key name 'search']
ALTER TABLE avwp_statpress ADD index search (search)

WordPress database error: [Duplicate key name 'referrer']
ALTER TABLE avwp_statpress ADD index referrer (referrer)

WordPress database error: [Duplicate key name 'feed_spider_os']
ALTER TABLE avwp_statpress ADD index feed_spider_os (feed, spider, os)

WordPress database error: [Duplicate key name 'os']
ALTER TABLE avwp_statpress ADD index os (os)

WordPress database error: [Duplicate key name 'date_feed_spider']
ALTER TABLE avwp_statpress ADD index date_feed_spider (date, feed, spider)

WordPress database error: [Duplicate key name 'feed_spider_browser']
ALTER TABLE avwp_statpress ADD index feed_spider_browser (feed, spider, browser)

WordPress database error: [Duplicate key name 'browser']
ALTER TABLE avwp_statpress ADD index browser (browser)

Don’t warry, all is OK.

This is just a message from MYSQL  that says that index are already up and running into your database.

Powered by AlterVista