MySQL Statistics
Jan 13, 2007way to disable MySQL statistics (like total querys, rows deleted, and etc.).
(SuSE Linux 10.x, MySQL 5.0.X).
way to disable MySQL statistics (like total querys, rows deleted, and etc.).
(SuSE Linux 10.x, MySQL 5.0.X).
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 View RelatedI 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?
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 RelatedIn 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?
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 RelatedPlease see this picture attached .
How can i change the Destination email?
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
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?
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 RelatedWith 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.
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?
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?
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 RelatedI'd like to track the email user agents that our clients use. Basically, I'd like to have something that looks like that:
[url]
I have a reseller account using cpanel.
What kind of addon or software wopuld let me see number of bd connections, cpu usage by process and user and other statistic to manage accurately my reseller account?
we have a problem with internal statistics in one of our servers with plesk, statistics don't update, trying command line at server with "/usr/local/psa/ admin/sbin/statistics --calculate-one --domain-name=domain.tld" we have this result:
[2015-06-29 11:17:23] ERR [util_exec] proc_close() failed
WARNING during statistics_collector execution: : statistics[22087]: Statistics info parsing error: Number value is out of range for expected type. Error occured at offset 856, character '9'.
[2015-06-29 11:17:29] ERR [statistics[22087]: Statistics info parsing error: Number value is out of range for expected type. Error occured at offset 856, character '9'.] ERROR during statistics_collector execution:
We can update some domains from command line, but others fail and cron dont update any, maybe if one fail the cron command stop working?
I have one subscription that shows incorrect statistics for the log file size. In the statistics pane it reports 130MB, while on the server in the /var/www/vhosts/domain/logs I only see 1.7MB.
Are there any other locations where logs are kept that are included in the statistics?
The sql server I have my users use is on a different server from which plesk is installed. Plesk should include the size of the user's databases from the external server as well otherwise the user can have a database as large as he wants. It's no longer restricted by the plans limits.
View 7 Replies View RelatedWhen executing "statistics" these errors occur:
# /usr/local/psa/admin/sbin/statistics
WARNING during statistics_collector execution: : statistics_collector: Unable to get dir size of /var/lib/mailman/lists/14
System error 2: No such file or directory
statistics_collector: Unable to get dir size of /var/lib/mailman/archives/private/14.mbox
System error 2: No such file or directory
statistics_collector: Unable to get dir size of /var/lib/mailman/archives/private/14
System error 2: No such file or directoryClick to expand...
I am using Plesk 11.5.30 Update #39. The statistics in not updating the mssql database size. It is always showing 0. I am attaching the screen shot. This account has 2 mssql 2008 database and uses 70MB. In plesk it is showing as 0 MB.
We are not able to block the account for mssql over usages.
I'm looking for a way to get a report of the top domains that are continuously greylisted so I can determine which ones need to be put on the "domains- whitelist" because they use different IPs when resending, causing very long delays (hours/days/never) for each message sent.We're using Plesk11 on CentOS 6.4 with Postfix and the Plesk built-in Greylisting option enabled.
# /usr/local/psa/bin/grey_listing --info-server
Grey listing configuration.
Grey listing checking enabled
Grey interval 5 minutes
Expire interval 51840 minutes
Penalty interval 2 minutes
Penalty disabled
Personal grey listing
configuration allowed
[code]....
Black domains patterns list:
SUCCESS: Gathering of server wide information complete.Click to expand...
Since my /var partition is full, so I moved /var/lib/mysql to /backup/mysql/.
Seems all the files are copied and I changed my.cnf reboot mysql, but all the web sites using db is not working anymore..
I installed the MySQL binary packages in /usr/local/mysql/ after removing the MySQL RPM package. MySQL is functioning when I executed /usr/local/mysql/bin/safe_mysqld. I reinstalled MySQL before I installed PHP. When I used a PHP script to access a MySQL database, it outputs an error:
Code:
Warning: mysqli::mysqli() [function.mysqli-mysqli]: (HY000/2002): can't connect to local mysql server through socket /var/lib/mysql/mysql.sock in index.php on line 2
However, I installed MySQL in /usr/local/mysql, not in /var/lib/mysql. How do I fix MySQL?
For some reason mysql wont start, i have tried restarting mysql but it wont, it says FAILED. The mysql.sock file seems to have disappeared and i cannot find it anywhere.
View 5 Replies View RelatedI recently had a harddrive failure and luckliy I can still access certain directories on this failed drive. I can still access the /var/lib/mysql/ directory which holds all the users databases and have backed all these up separately using tar.
Now what I need to know is how do you restore these database files to another server? I tried simply untar'ing one of these to the new servers /var/lib/mysql/ direcotry and it stuffed Mysql up - it went offline. I had to get a cpanel tech to bring Mysql back online.
how can I get these database files to fully work on a new server?
Can someone recommended me some one with knowledge of mysql exploit or mysql injection, it seem to our VB forum have issue with database load..
View 5 Replies View Related