Forum for users of JoomlaWatch / ExtraWatch for Joomla, Wordpress, Drupal, Magento, Prestashop

JoomlaWatch / ExtraWatch has following features: live real-time visitor statistics, location of your visitors on a map, blocking of users based on bad word list, front-end counters, click heat map, definition of goals and rules, graphs, directory size monitoring, monitoring of increase of database data in time, nightly email reports, interactive HTML5 chart of traffic flow within your website, SEO report with keyword statistics and keyword position trends

Welcome, Guest
Please Login or Register.    Lost Password?

joomlawatch make DB heavy time taking site backups
(1 viewing) (1) Guest
Go to bottomPage: 1
TOPIC: joomlawatch make DB heavy time taking site backups
#3452
joomlawatch make DB heavy time taking site backups 4 Years, 7 Months ago Karma: 0
Hello,

When I use Akeeba to back up the site, it takes huge amount of time to back up Joomla Watch Database data (several hours).

Considering that there is not much traffic on the website, and still in development, I was wondering if someone could give a solution to overcome this issue, maybe changing the settings, etc.

Thanks.
amir00251 (User)
Fresh Boarder
Posts: 6
graphgraph
User Offline Click here to see the profile of this user
The administrator has disabled public write access.
 
#3453
Re: joomlawatch make DB heavy time taking site backups 4 Years, 7 Months ago Karma: 31
The jos_joomlawatch_ip2c contains IP 2 country geolocation data. You should avoid backing up that database table. This should do the trick.
matto (Admin)
Moderator
Posts: 770
graph
User Offline Click here to see the profile of this user
The administrator has disabled public write access.
 
#3465
Re: joomlawatch make DB heavy time taking site backups 4 Years, 7 Months ago Karma: 0
Hello,

The heaviest DB table is chel_joomlawatch_uri_post which is 234Mb.
The second heaviest is chel_joomlawatch_uri_history about 85Mb.

Please advise where exactly I should change or edit DB settings?

Thank you
amir00251 (User)
Fresh Boarder
Posts: 6
graphgraph
User Offline Click here to see the profile of this user
Last Edit: 2012/02/12 20:22 By amir00251.
The administrator has disabled public write access.
 
#3471
Re: joomlawatch make DB heavy time taking site backups 4 Years, 7 Months ago Karma: 31
What is your traffic to your website? approx. daily unique visits..
matto (Admin)
Moderator
Posts: 770
graph
User Offline Click here to see the profile of this user
The administrator has disabled public write access.
 
#3476
Re: joomlawatch make DB heavy time taking site backups 4 Years, 7 Months ago Karma: 31
I suggest to always check the database table status via the "Status" link in JoomlaWatch
matto (Admin)
Moderator
Posts: 770
graph
User Offline Click here to see the profile of this user
The administrator has disabled public write access.
 
#3477
Re:joomlawatch make DB heavy time taking site backups 4 Years, 7 Months ago Karma: 0
Hello,

At the moment probably only two daily unique visits, the rest is bots.

As I mentioned site is under development.
amir00251 (User)
Fresh Boarder
Posts: 6
graphgraph
User Offline Click here to see the profile of this user
The administrator has disabled public write access.
 
#3478
Re:joomlawatch make DB heavy time taking site backups 4 Years, 7 Months ago Karma: 31
Are these the spambots who post large amount of data ? maybe I could try to take a look at it, it's quite few visits for such large amount of data.. If you're interested please open a support ticket with temporary admin access information. Thank you.
matto (Admin)
Moderator
Posts: 770
graph
User Offline Click here to see the profile of this user
The administrator has disabled public write access.
 
#3479
Re:joomlawatch make DB heavy time taking site backups 4 Years, 7 Months ago Karma: 0
Thanks, just sent the details.
amir00251 (User)
Fresh Boarder
Posts: 6
graphgraph
User Offline Click here to see the profile of this user
The administrator has disabled public write access.
 
#3488
Re:joomlawatch make DB heavy time taking site backups 4 Years, 7 Months ago Karma: 0
Hi Any update on this issue please!
amir00251 (User)
Fresh Boarder
Posts: 6
graphgraph
User Offline Click here to see the profile of this user
The administrator has disabled public write access.
 
#3489
Re:joomlawatch make DB heavy time taking site backups 4 Years, 7 Months ago Karma: 0
Hi, I did set up the admin log in again with same username and password sent before. I appreciate if you could have a look. Thank you.
amir00251 (User)
Fresh Boarder
Posts: 6
graphgraph
User Offline Click here to see the profile of this user
The administrator has disabled public write access.
 
Go to topPage: 1

Latest News

Get the latest freelance project announcements
Follow CodeGravity.com

Download ExtraWatch™

ExtraWatch™ FREE is Joomla, Wordpress, Prestashop, Magento plugin with following features: Live Stats, Nightly Email Reports, Goals, Graphs, Anti-spam, History and more