Important MySQL Monitoring Functionality.

Dec 10, 2007

What this does is amongst others is to add "SHOW USER_STATISTICS"
statement do MySQL. What this does is keep statistics on which users on your mysql machine is spending the most time processing queries.

It is also mentioned here: [url]

If you believe this functionality could be important to our industry you are more than welcome to vote for this or add comments to the following feature request:

[url]

View 2 Replies


ADVERTISEMENT

Extended Monitoring For MySQL

Oct 30, 2009

I have 2 dedicated servers (Centos with WHM/cPanel), for the oldest server it will be great for me to have some option to monitor which users/databases are more used, I'm more interested about the "spikes" i see in the munin graphs once in a while.

This server has an average of 42 queries/second but sometimes there are some spikes of over 250 queries/second and in munin I can't see which users/databases ware causing the spike.

Curently I use munin for monitoring the server, and it's graphs are ok but I need a more detailed graphs or statistics for mysql, I searched munin plugins but there's no plugins to show the user or database which gets the most queries.

how can I see which user/database had more queries?

I attached a graph generated by munin, you can see the spike, I seen the spike after about one hour, when the traffic was normal, and the page in WHM - Mysql Processes couldn't help me because there's no history.

View 5 Replies View Related

Would You Like To Monitor Your Web Forms Functionality

Jul 15, 2008

Considering a web site could be completely useless without its web forms working as expected, and the uptime reports do not verify them at all, I would like to know if you people, consider it important.

View 1 Replies View Related

Hosts That Allow Full Mod_rewrite Functionality

Aug 8, 2007

What popular hosts allow full mod_rewrite functionality via an .htaccess file?

Particularly, something like this:

Code:
RewriteRule ^avatars/([^.]*.(jpg|jpeg|png|gif|swf))$ imghost.php?fn=$1&dir=avatars [NC,L]
Hosts that allow it:
- Dreamhost
- Hostgator

Hosts that don't allow it:
- Godaddy
- 1&1 / 1and1

View 10 Replies View Related

Mod_security Functionality Bypass Through .htaccess Issue

May 5, 2007

I accidently found that it could be available to de-activate mod_security in a certain directory by using a .htaccess like that...

<IfModule mod_security.c>
SecFilterEngine Off
SecFilterScanPOST Off
</IfModule>

I believe it's something related to the "AllowOverride" directive from apache but im not exactly sure, the available arguments for this directive are "AuthConfig, FileInfo, Indexes, Limit, Options", I've tried hardly to find a way to not to disable the usage of .htaccess files and keep it's functionality but also to prevent it from being able to modify through it the functionality of mod_security.

I'm sure Anyone here could help me in this issue as it's a big pain for any server running apache in a shared vhosting environment.

View 13 Replies View Related

C99Shell :: How To Detect Or Disable The Functionality Of C99Shell

Jul 13, 2008

Recently my site was defaced, (i own a dedicated server), my server was not touched, but one of the applications I used on the site was exploited to gain access to it.

I have noticed 4 or 5 c99 shells in different locations on my ftp. The site is back online, but it's definitely possible that they have one of these hidden somewhere and that they'll just do it again. I am using cent os 5

How can I easily search for these on my box? Can I disable their functionality? is there setting I can use in htaccess or something to make my website safer? I visited one of the scripts, and it said SAFEMODE OFF, how can I at least enable safemode?

I don't know much of anything about linux, but I am running cpanel and WHM. I have a guy who manages my box but he is hard to get a hold of sometimes, and I'd like to take care of this ASAP!

View 6 Replies View Related

Most Important VPS Features?

May 12, 2009

The market is full of VPS providers with different combinations of features.. some offer huge amounts of ram, bandwidth, managed, unmanaged, etc.. The sheer number of choices is dizzying..

My question is, if you had to pick one feature of a VPS plan that was most important to you, what would it be?

View 14 Replies View Related

How Important Is Location

Oct 11, 2009

I live in Turkey. I'm gonna buy a reseller package from Hostgator which is located in Texas. I will mostly make websites in English language for business(affiliate websites) but I decided to make 2 websites in Turkish language for a hobby of mine. Should I buy hosting from a company in Europe or can I still go with Hostgator? I really like Hostgator's package but how much disadvantage would there be in terms of speed? Would people be able to tell by speed whether the server is close or not? Is there a way to test it? All my friends' computers have a speed around 100kb download per second.

View 15 Replies View Related

PCI Compliance How Important Is It To You

Dec 11, 2008

How important is PCI Compliance to you as a hosting provider? Are you compliant now?

Do you intend to be complaint? Also how many thing that just getting a scan from comodo or another scanner makes you compliant?

As far the rules for PCI-DSS state if you store CC's which all hosting companies do if they are using a billing system, i.e MB, WHMCS etc.. You have to be compliant to a fault for a 37 page document with lots and lots of requirements that most don't do and don't know how to do.

Is it worth it to not make the effort and get compliant or risk losing your merchant account and getting on the TMF list and fined $50k?

View 9 Replies View Related

How Important Is Host Location

May 5, 2009

I am in the process of finding a host for my website (as I am not very happy with the current one).

My statistics shows that most of my visitors are from Europe and Asia and not much from US.

My question is, should I think of a host in Europe or Asia?

does it actually make a lot of difference where is your host located ?

View 14 Replies View Related

How Important Is Live Chat?

Feb 15, 2009

How important is this from a customer standpoint? Assuming ticket response times are under 1 hour, is Live support something that customers really want? I'm considering adding it as a support option, but want to weigh whether or not its worth it.
<<Please setup signature in Member Control Panel>>

View 14 Replies View Related

Is Ping Time Important

Apr 12, 2009

When I talked with my friends who are into computer stuff, they'd say that it is important that the provider that I am about to host my site with, has good ping response so that my site will load faster.

View 14 Replies View Related

Is 24x7 Support Important To You

Apr 9, 2009

I don't know how some web hosting companies get away with saying they offer 24x7 support but don't. I have come across many companies that all clam the same thing but at the end when it comes down to it they are not there when you need them.

My question is if they have a live chat button on there site and I see there sales team offline, that is an immediate sign they are really not there 24x7. If a person is qualified to manage a server is he/she not qualified to sell a product?

how can a network be monitored if you don't have a staff 24x7?

View 14 Replies View Related

How Important Is Hosting Location

Oct 4, 2009

I work for a company that does business mainly in California but we have people all over the country including Boston and NYC. I'm looking for dedicated servers and found good pricing/service in Chicago but worried about response times for my Cali folks. I'm hosting a non public web app that everyone needs to use so the load is low and response times are not super critical.

Will my users experience noticable latency?

Also people that manage the servers may be in Cali as well. Will they find it fustrating to remote into these windows servers and manage them or will it be acceptable or should I find something closer to california?

View 9 Replies View Related

How Important Is It To Have RAID On A Dedicated Box

Apr 18, 2008

What really are the chances of a drive failure in any given year?

I worked in corporate IT departments for 15 years and had RAID on everything even though I rarely saw a drive failure. Out of hundreds of drives one might fail in any given year.

It does look like some folks here have experienced drive failures on dedicated boxes though, so my dilemma is this: If both cost the same am I better off to have a box with no RAID at a good host like theplanet, or have a box WITH raid with one of the value hosts?

View 14 Replies View Related

How Important Is Server Location

Mar 2, 2007

I am based in the UK and ideally I want my server based in the UK too. But the best host I've found so far seems to be American.

If most of my users are from the UK, then I don't want the latency to be too high. Or it so insignificant that I don't need to worry?

I was looking at [url] but if someone knows a similar deal in the UK I'd like to hear about it!

View 12 Replies View Related

IMPORTANT: Do Not Ignore This Email

Jul 25, 2008

I'm receiving this email from the server :

"IMPORTANT: Do not ignore this email.
The hostname (one.icv.ro) resolves to 76.163.193.147. It should resolve to 209.188.81.112. Please be sure to correct /etc/hosts as well as the 'A' entry in zone file for the domain.

Some are all of these problems can be caused by
/etc/resolv.conf being setup incorrectly. Please check this file if you
believe everything else is correct.


You may be able to
automaticly correct this problem by using the ' Add an A entry for your
hostname ' under ' Dns Functions ' in your Web Host Manager"

So everything is working fine ..
I checked the DNS zone and every thing is ok.

but run this on the server :
====================
dig +noall +answer +additional icv.ro NS
icv.ro. 84220 IN NS ns9.ixwebhosting.com.
icv.ro. 84220 IN NS ns10.ixwebhosting.com.
====================
dig +noall +answer +additional icv.ro
icv.ro. 82792 IN A 76.163.193.147

and they are wrong.

strange that the ping is fine.. and is corect ip:

ping icv.ro
PING icv.ro (209.188.81.112) 56(84) bytes of data.
64 bytes from one.icv.ro (209.188.81.112): icmp_seq=1 ttl=64 time=0.060 ms
======================

So my server didn't updated the ns. They are the old ns .. and the new one are

Name Server: ns1.wiredtree.com
Name Server: ns2.wiredtree.com

View 3 Replies View Related

Why Server Memory Is Important

Oct 27, 2007

today i was asked if my server support ruby on the rail. The person said that the rail needs at least 256Mb of free RAM to run it. Is it true?

I checked my server memory by using TOP command and saw that it has less than 10MB of free RAM. My question: Where does it go? I got only 30 sites running and mostly are static site and No proxy.

what eats up memory? What ways can i use to free up my memory?

View 10 Replies View Related

Is Logwatch Important? Can I Remove It

May 9, 2007

I'm running out of disk space on /var and it seem /var/cache/logwatch has almost 4GB of space. Can I remove everything inside and uninstall logwatch? How do I remove logwatch from the system and any affect of the system functionality.

DirectAdmin
CentOS4.4

View 5 Replies View Related

Location Of The Domain Name Server (DNS) Is Important ?

Jun 26, 2009

we have a server where we run sites and emails, but now we are going to buy a offsite email solution (based on ms exchange) in order to have our emails running when our web server is down.

But at the momment we run our own dns at our webserver using our own nameservers, in order that our emails keep working during a webserver downtime, we need to host our dns server at another location. So the offsite email company that is based in usa, said to us that they can host our dns at their datacenter in usa.

So i will have a configuration like this:

Webserver >> location: Spain
Mail Server >> location: USA
DNS Server >> location: USA

note: 99% of my website visitors came from Spain

So my question is:

Does it matters in terms of speed/performance having my dns server located in usa?

So in a simple way, will my website will it be fast with the dns located in spain, or having it in usa is exactly the same in terms of speed/performance?

View 5 Replies View Related

Clients: Is Phone Support Important

Jan 26, 2009

This question is mainly for the client, but anyone is welcome. I am curious how important is phone support when you are looking for a host. Does the host need to have one or not or does it even matter?

Support also includes billing and sales.

View 14 Replies View Related

Whats Important To You In A Colo Facility

Apr 25, 2009

We are in the process building a new colocation facility and I wanted to take some input from everyone here. We have most of the infrastructure planning and layout done but were still early on in the construction phase so now is the last chance to get some input. I have two main questions I wanted to ask.

1)When your looking for a colocation facility what things are most important to you?

2)Have you ever wished that datacenters offered something outside the normal things that most providers do.

View 14 Replies View Related

What Is Most Important To You In A Dedicated Hosting Company

Feb 28, 2008

I am interested as I am sure others are as well in the results. Please also list things you want to see providers that they are missing the boat on now. Please dont mention specific providers and make this a bash session. I think this type of dialoge will benefit all the providers out there.

This was supposed to have a poll but my laptop died before I could post the poll questions

What is most important to you in a dedicated hosting company?

#1 Price
#2 Support
#3 Network
#4 Client User interface

View 14 Replies View Related

Where Is Important Config Files For Iptables?

Dec 4, 2008

backup from my iptables config files, where is important config files for iptables?

View 2 Replies View Related

How Important Is The InterNap FCP Or Route Science

Mar 12, 2007

I wonder how it effects to network performance? The network will be faster? How much? The normal routers can choose the best routes too, is it correct?

View 14 Replies View Related

Bandwidth Or Features?which Is Important In Webhosting

Dec 22, 2007

i have entered in contract with a web hosting compnay and they are providing the cheapest rate.But have no good features..only they are giving 20 gb bandwidth for 15$.So is this good plan.

View 6 Replies View Related

What Server Specs Are Important In This Situation

Sep 18, 2007

I'm building a web app that will be both serving ads as well as recording things like impressions and clicks.

Obviously it will have a dedicated server (and will most likely quickly expand in to needing multiple servers) but I'm curious what specs are most important for this sort of thing.

Is processor speed more important? RAM? Hard drive speed?

It won't be heavy so much on the side of server full pages of data (like a normal website) as much as it will be heavy for display ads and recording visitor data.

View 3 Replies View Related

What Server Specs Are Important In This Situation

Sep 18, 2007

I'm building a web app that will be both serving ads as well as recording things like impressions and clicks.

Obviously it will have a dedicated server (and will most likely quickly expand in to needing multiple servers) but I'm curious what specs are most important for this sort of thing.

Is processor speed more important? RAM? Hard drive speed?

It won't be heavy so much on the side of server full pages of data (like a normal website) as much as it will be heavy for display ads and recording visitor data.

I'll be running a LAMP setup for this and will also be serving actual ad files (images, flash) from a CDN.

View 3 Replies View Related

Top 10 Coolest/smartest/most Important Scripts Right Now

Aug 12, 2007

I am trying to put a top 10 list together of the most cool scripts around these days. Not only Wordpress, Joomla etc, but perhaps smart scripts that might not be that well known?

Could you help me out by naming what script you have been amazed by recently? I'd actually prefer that this was not hosting related scripts (so, dont just scream WHMCS or CE!! ).

...mods feel free to move if this is not the right forum, wasnt sure myself

View 6 Replies View Related







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