Statistics Tracking In MySQL

Mar 26, 2007

I just finished an information website and my corporation is now asking if there's a way to track the most popular pages on the site. Is there a way to do this with a pre-built function in MySQL or will we need to build a module? I have no experience working with MySQL or ASP.NET; as a purely client-side designer I want to be able to help but I'm at my limit.

View 1 Replies


ADVERTISEMENT

MySQL Statistics

Jan 13, 2007

way to disable MySQL statistics (like total querys, rows deleted, and etc.).

(SuSE Linux 10.x, MySQL 5.0.X).

View 0 Replies View Related

Mod_rewrite Tracking

May 28, 2008

I've lots of:

[warn] RewriteCond: NoCase option for non-regex pattern '-f' is not supported and will be ignored.
[warn] RewriteCond: NoCase option for non-regex pattern '-d' is not supported and will be ignored.

Any ideas how to track them?

View 5 Replies View Related

Process Tracking

May 18, 2009

How can track and follow a process id.

For example i need to know what is following process:

14764 root 39 15 11712 9.8m 1668 R 20 0.1 0:14.22 perl

I need to know wich/where file used perl with process id 14764

View 6 Replies View Related

Tracking Down Load

May 13, 2008

I have a CentOS box here that is causing some strange load. Brand new X3230 (4*2.66Ghz), 2GB ram and 2*500GB SATA2 in raid-1 on a LSI MegaIDE controller.

Basically the server is continuesly at a load of 1. However I dont see why. No CPU load, and no IO as far as I can see. Does anybody have a tip where to look for the problem?

Quote:

top - 05:01:56 up 1:53, 2 users, load average: 1.00, 1.02, 1.20
Tasks: 81 total, 1 running, 80 sleeping, 0 stopped, 0 zombie
Cpu0 : 0.0%us, 0.0%sy, 0.0%ni,100.0%id, 0.0%wa, 0.0%hi, 0.0%si, 0.0%st
Cpu1 : 0.0%us, 0.0%sy, 0.0%ni,100.0%id, 0.0%wa, 0.0%hi, 0.0%si, 0.0%st
Cpu2 : 0.0%us, 0.0%sy, 0.0%ni,100.0%id, 0.0%wa, 0.0%hi, 0.0%si, 0.0%st
Cpu3 : 0.3%us, 0.0%sy, 0.0%ni, 99.7%id, 0.0%wa, 0.0%hi, 0.0%si, 0.0%st
Mem: 2072132k total, 591072k used, 1481060k free, 65652k buffers
Swap: 2048276k total, 0k used, 2048276k free, 461532k cached

Quote:

# iostat
Linux 2.6.18-53.el5 (xxxx.xandrios.net) 05/14/2008

avg-cpu: %user %nice %system %iowait %steal %idle
2.65 0.56 5.56 0.97 0.00 90.26

Device: tps Blk_read/s Blk_wrtn/s Blk_read Blk_wrtn
sda 6.44 99.67 255.89 686581 1762792

Quote:

# hdparm -tT /dev/sda

/dev/sda:
Timing cached reads: 16092 MB in 2.00 seconds = 8057.39 MB/sec
Timing buffered disk reads: 88 MB in 3.04 seconds = 28.92 MB/sec

With the WHT benchmark test the machine scores about 520 points, seems not bad either.

Only thing I could think of is that it has something to do with the raidcard. The data transfer rate is quite low. Could it be that the card is rebuilding the array? Can I check that without rebooting?

View 8 Replies View Related

Tracking Down A User

Mar 22, 2007

A user is running something that eats up all the server memory very quickly. Looking at the access logs this is all I get:

XX.XX.XX.XX - - [22/Mar/2007:12:58:06 -0400] "GET /index2.php?option=com_rss&feed=RSS1.0&no_html=1 HTTP/1.1" 403 -
XX.XX.XX.XX- - [22/Mar/2007:12:58:47 -0400] "GET /index2.php?option=com_rss&feed=RSS1.0&no_html=1 HTTP/1.1" 403 -
XX.XX.XX.XX - - [22/Mar/2007:12:58:58 -0400] "GET /index2.php?option=com_rss&feed=RSS1.0&no_html=1 HTTP/1.1" 403 -

Now there are quite a few index2.php's located on my server so I can not figure out who is running this. When I run ps ax -o pid,user,rss,command|grep httpd
I get about 20-30 of these:
13808 nobody 17360 /usr/local/apache/bin/httpd -DSSL

how I can figure out where this script is being run from?

View 2 Replies View Related

Affiliate Tracking With Ubercart OR

Jan 9, 2009

Does anyone knows if ubercart has embended affiliate tracking capabilities? Do you know if any other open source e-shop has this feature? Could you suggest something you know from experience or heard of?

View 0 Replies View Related

Bandwidth Tracking Software

Jan 13, 2009

software for tracking the bandwidth usage on servers? It would be nice if there is one that has a web interface and the ability to add multiple different servers for tracking. Looking for something that runs on Linux (CentOS in particular).

View 6 Replies View Related

Email, Spamming , Tracking

May 24, 2008

I have a few questions about emails. I have root access to the server in question.

1.) I have a spammer on my server and i'm having trouble tracking him down. Anyone have any suggestions?

2.) I'm using cPanel and WHM is there any way to track by account how many emails there sending?

View 2 Replies View Related

Tracking Down Phishing Site

Jan 10, 2007

We have received the complain from paypal that one of the domains were phishing. How to track it down? How to find out the method that how they uploaded? I checked /tmp file and couldn't find anything. I check access_log file for wget and couldnt find anyting.

View 2 Replies View Related

Tracking Down Web Process User In Cpanel

Nov 3, 2009

Recently, there are a lot of "apache" processes hogging my Cpanel server with the default owner "nobody". How could I track the apache process back to which user is using it?

View 8 Replies View Related

Stats - Mobile Site Tracking

Jul 20, 2007

I have Awstats on my server enabled for:

Nokia Browser (PDA/Phone Browser)
UP.Browser (PDA/Phone Browser)
Motorola Browser (PDA/Phone Browser)

My question is, are the visitors a day accurate - which I take to be uniques. It seems these must be pretty far off.

Presently they show an extremely high multiple of that for pages/s (approx 30 -50 times the visitors). I've never heard of visitors clicking this many pages.

I've not come across these kind of number with other non-mobile sites and it makes wonder if its right.

A) is tracking handled in the same way on mobile devices as on desktops (cookies or sessions?) And is this reliable for mobile/handheld/cell-phone devices?

B) There really isn't much of a chance of these page views being a result of bookmarks - the page views don't seem to add up to this.

The 'Browser Top 10' hits coming from 'unknown' are > 50% of the total amount.

Are there any quirks with awstats or other tracking software when it comes to mobile devices, even though the activity is taking place on the server? I take it Urchin may be more accurate?

View 0 Replies View Related

Tracking Usage Of Yahoo Webservice API

Apr 9, 2007

I am using Yahoo Webservice API.

[url]

Recently I found out that I often hit the 5000 search per day limit.

I think I found a way to track usage of my Application ID with it. I want to know which IP has been using my APPID, for example.

However, I forget how.

Is this possible?

View 4 Replies View Related

Database For Tracking Site Info

Dec 11, 2007

My company is just getting into web hosting. We currently have 10-15 sites that we are hosting. What do you guys use to keep track of all the details for the site (location, company info, etc). We're using a homegrown filemaker database atm, but we don't want to continue using this when we get 50+ sites. It doesn't matter if its web-based or a standalone program.

View 6 Replies View Related

Tracking Server Uptime/Downtime

Jul 12, 2007

Is there a good service for tracking server uptime (and therefore, downtime)?

View 4 Replies View Related

Plesk Automation :: Add Visitor Tracking Code To Control Panel

Dec 11, 2014

We need to add visitor tracking code to the Control panel so we know who's using it and we can prompt inline chat etc. for support, but where to start.

The code is a mixture of Div tags and Java script.

How we can add this as there is no common footer file to drop the code in to.

View 2 Replies View Related

IO Statistics Load

Jan 6, 2008

I just checked my IO statistics and found that I have a large number of blocks bieng written to my two hard drives on my server.

I'm suspecting this is the reason for also increased load on my server.

Now I'm thinking either 1) A site on my server is generating this amount of usage

or

2) Possibly one or both of my hard drives are failing?

View 2 Replies View Related

Server Statistics

Jul 31, 2007

I'm getting ready to leave a host that has been having issues and has been having speed issues.... As I learn more about servers I am wondering if the server statistics can teach me a little about what may be affecting the server performance.... When I look at server statistics in CPANEL it is showing 78% memory used and Disk Usage as 44% and 83%, respectively on two disks. Zabbix also shows as "failed". Another host I have has no issues and is using 40% of memory with disk usage never going over 23% ..... Are the statistics on the first server I mentioned significant in the poor performance being experienced by sites hosted there?

View 7 Replies View Related

Exim Statistics Under WHM

Jun 27, 2007

In WHM Under Exim statistics we see value as:

Messages received per hour (each dot is 75 messages)
----------------------------------------------------

12-13 1643 .....................
13-14 3372 ............................................
14-15 2971 .......................................
15-16 3772 ..................................................
16-17 1088 ..............

Deliveries per hour (each dot is 125 deliveries)
------------------------------------------------

12-13 3000 ........................
13-14 6108 ................................................
14-15 5722 .............................................
15-16 6259 ..................................................
16-17 1333 ..........

--

BUT

This is not really emails receive in pop3 account and not emails sent (delivery)

For delivery we think this can be "try" to delivery, right?

But for messages received?

View 0 Replies View Related

Statistics Running Behind

Jan 15, 2007

Is there a standard on the length of time we should configure stats to run on a cpanel server. Currently mine is 36 hours.

View 1 Replies View Related

Relay Statistics For Root

Jun 6, 2007

Please see this picture attached .

How can i change the Destination email?

View 1 Replies View Related

Does The Memory Usage Statistics Look Right

Jul 13, 2009

My managed dedicated server at 1and 1 has very low load, but quite slow, I was trying to figure out the reason. The top and free command ( I run at midnight without traffic), here is the result. Can anybody tell me if the memory usage is normal, anything suspicious. Look like the memory usage is high even with no traffic, but 1and 1 support say that's because it's reserved for cache.

top - 02:01:38 up 31 days, 14:13, 0 users, load average: 0.00, 0.03, 0.07
Tasks: 6 total, 2 running, 4 sleeping, 0 stopped, 0 zombie
Cpu(s): 0.0%us, 0.0%sy, 0.0%ni,100.0%id, 0.0%wa, 0.0%hi, 0.0%si, 0.0%st
Mem: 1017068k total, 972620k used, 44448k free, 169564k buffers
Swap: 514064k total, 26076k used, 487988k free, 509580k cached


total used free shared buffers cached
Mem: 1017068 972656 44412 0 169600 509612
-/+ buffers/cache: 293444 723624
Swap: 514064 26076 487988

View 1 Replies View Related

Exim Mail Statistics Log

Sep 14, 2007

Under WHM ( Main >> Email >> View Mail Statistics ) there are mail statistics.

My stats is too poor, I see only 1 hour first.. other hour is all 0.. how can I set the size of log for make bigger and store all day value?

View 2 Replies View Related

Web Site Traffic Statistics

Jan 12, 2007

Is it common to get informative and appropriate website traffic statistics via your host? or is this some I should look at joining/purchasing independantly?

View 10 Replies View Related

Disable Statistics For Just One Reseller Account

Apr 11, 2009

With my new VPS, I am trying to disable Statistics software (Awstats & Webalizer) for one reseller account (and all account under it).

So I went to

"Statistics Software Configuration" --> "User Permissions" Selected the user and under "configure" unchecked both option. Is that enough??

When I view "Statistics Status Summary" for all users, it still shows them as "green" for that user.

I haven't actually moved anything to this VPS.

View 2 Replies View Related

How To Move Visitor Statistics To New Hosts

May 25, 2009

I have 5+ websites at hostmonster and now I purchased hosting from infrenion. Now I want to move some sites from hostmonster to infrenion along with statistics. As for data concerns I can upload it fresh from hard drive.

I am concern how to move AWStat, Webilizer, etc data of ONE site (selectively) to next host?

View 6 Replies View Related

How Can I Setup Daily Exim Statistics?

Feb 27, 2008

How can I setup daily exim statistics?

From WHM, it shows for about one month exim statistics.

Is there any way to have daily exim statistics?

View 2 Replies View Related

Empty Cpanel WHM Mail Statistics

May 12, 2008

how to empty the Mail Statistics log in WHM? Also is it ok to do or would it cause problems doing so?

View 2 Replies View Related

How To Track Email Clients' Statistics

May 18, 2007

I'd like to track the email user agents that our clients use. Basically, I'd like to have something that looks like that:

[url]

View 3 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved