Imbalanced Load Query
Apr 16, 2009what causes an imbalanced load on a server? what/who makes a demand that causes something to be unbalanced?how is the problem solved?
View 1 Replies
ADVERTISEMENT
Query Regarding VPS
Aug 31, 2007I run a small Fan community / forum that I am looking to move to a VPS server as these are a little cheaper than Dedicated
I have a couple of questions & wondered if anyone could assist?
I need a Control panel as I have had experience with Plesk & Cpanel & do not have any SSH experience whatsoever
I see Cpanel offered in some VPS offers, Would this include things like Fantastico etc?
Would I better suited to a Managed or Unmanaged account? I assume seeing I have no SSH knowledge Managed account would be better
I had looked at a site called nameway dot com & like the look of their VPS offer but would love to hear other peoples thoughts on them (I haven't posted enough to post a url so site is
www dot nameway dot com/resellers-hosting.htm )
If I were to go unamanaged or part managed if there is such a thing, would this mean I would have to upload things like apache for php, mysql etc? or would this still be standard in an unmanaged account if a cpanel or control panel is offered?
DNS Query.
Jun 7, 2007check the dns settings on my server?
I have a feeling there's something not quite right with it
I ran DNSreport.com's query and it said there were a few problems which might cause slowdowns (Which is what i'm experiencing), but didn't go into any detail on how to fix it
They've now put in a fee for doing anymore dns checks, so i'm abit in the dark as to what to do?
I'm running a WHM/Cpanel VPS at present.
.co.uk & .com Hosting Query
Jul 11, 2008Am just about to emigrate to USA (yay) and I want to keep my xxxxxxxx.co.uk domain active so I can recieve emails etc. I would also like to register a yyyyyyyyy.com domain.
Can anyone advise me on this please?
Can I host a .co.uk in the US?
Can I host a different .com and .co.uk on the same servers?
Can anyone recommend a good reliable, cheapish ($10-$20per month) host that provide MSSQL and asp.net 2.0 support.
DNS Server Query
Aug 21, 2007I have a dedicated server with the 'typical' 2 ips pointing to the same instance of BIND on it for its nameservers.
I would like to actually have an ns2 to remove this single point of failure. Even though my 'infrastructure,' such as it is, is only a single server; my research on here and elsewhere suggests that this separate DNS server will make my site appear to be non-responsive when the server is down rather than simply non-existent. This is the behavior I would like to have!
I am still left with questions on implementing this. I know I need either a small VPS account, or an account with a provider such as DNSMadeEasy.com. What is not clear to me is how I would set up such an arrangement with the separate DNS server.
Does anyone have a link to a resource that shows how to do this, or would be willing to do a quick run through here?
I am not technically incompetent but am unfamiliar with this procedure and cannot seem to find documentation.
VPS Performance Query
Jun 19, 2007I've got a VPS, and its performance sucks.
I've got 18 domains parked on it, with only 4 of those having active websites. There are 3 mailman lists set up, and a further 10 or so email accounts with SpamAssassin active on them.
It also runs cPanel/WHM.
The server itself has 384Mb RAM, with 512Mb burst.
My beancounters are.....
Version: 2.5
uid resource held maxheld barrier limit failcnt
2102: kmemsize 8406834 10504002 30000000 30000000 2722182
lockedpages 0 0 256 256 0
privvmpages 111738 132127 131072 131072 1034096
shmpages 731 747 21504 21504 0
dummy 0 0 0 0 0
numproc 73 96 240 240 0
physpages 55335 75477 0 2147483647 0
vmguarpages 0 0 65536 2147483647 0
oomguarpages 55335 75477 26112 2147483647 0
numtcpsock 24 47 360 360 0
numflock 9 20 188 206 0
numpty 1 1 16 16 0
numsiginfo 0 17 256 256 0
tcpsndbuf 214656 1750788 53687296 61551616 0
tcprcvbuf 393216 786996 53687296 61551616 0
othersockbuf 30416 275664 53687296 61551616 0
dgramrcvbuf 0 55460 53687296 61551616 0
numothersock 24 42 360 360 0
dcachesize 0 0 2273280 2416640 0
numfile 2078 2449 5820 5820 0
dummy 0 0 0 0 0
dummy 0 0 0 0 0
dummy 0 0 0 0 0
numiptent 10 10 128 128 0
Am I putting too much strain on the VPS with the amount of domains/emails I run through it? Is cPanel/WHM the problem? Is the server config suspect? Are VPS accounts only good for 1 or 2 domains?
Query Optimization
Feb 20, 2007I been logging queries for a whole 3 days and my logs is huge and the problem seems to be my phpBB search table thats causing such problems for me heres what I logged
Code:
# Time: 070219 19:41:53
# User@Host: admin_db[admin_db] @ localhost []
# Query_time: 11 Lock_time: 0 Rows_sent: 0 Rows_examined: 13274745
SELECT word_id
FROM phpbb_search_wordmatch
GROUP BY word_id
HAVING COUNT(word_id) > 259756;
Everything from phpbb_search_wordmatch takes more then 11 sec Query time.
How can I optimze this and lower the Query time to something like 1 or 2.
Some adivce would be helpful me not that good with mysql.
Query About ASP Hosting
Jan 25, 2007I currently have my jimpix site hosted by a really good Canadian company called Alentus. BUT, they are based in Canada, and I'm based in the UK.
I am working on a site at the moment which will require a timetable / scheduling facility, so working in the 7 hour time difference between the UK and Canada is a pain.
The package I need is:
ASP Hosting
MySQL Hosting
Use of ASPJPeg and ASPUpload Components
I've not been able to find a UK hosting firm offering these - or haven't spent hours looking for one, so wanted to check here if anyone could recommend a UK firm offering these - and a good one if possible! I have used other hosts before with other web clients, and some have been pretty ropey to say the least!
Query Cache Denied
Jun 29, 2009what does this mean? its been flooding /var/log/messages
Jun 28 08:12:50 host named[7649]: client 209.86.63.238#9427: query (cache) 'root.domain.tld/A/IN' denied
Jun 28 08:12:50 host named[7649]: client 209.86.63.230#42462: query (cache) 'root.domain.tld/A/IN' denied
Jun 28 08:12:50 host named[7649]: client 200.23.242.203#37863: query (cache) 'root.domain.tld/A/IN' denied
Jun 28 08:12:50 host named[7649]: client 212.93.151.237#8080: query (cache) 'root.domain.tld/A/IN' denied
Jun 28 08:12:50 host named[7649]: client 212.202.215.18#35119: query (cache) 'root.domain.tld/A/IN' denied
Jun 28 08:12:50 host named[7649]: client 212.93.151.237#40106: query (cache) 'root.domain.tld/A/IN' denied
Jun 28 08:12:50 host named[7649]: client 209.86.63.231#51272: query (cache) 'root.domain.tld/A/IN' denied
Cron Job And Query String
Oct 11, 2009Is it possible to call a cron job with a query string appended to the file. I have no problem setting up crons in the cron tab..but i'd like the cron to fetch a url that looks something like
/home/php/some-file.php?a=1
is this possible directly through the cron job? I guess an alternative is call some php file that uses curl but i was wondering if there 's a direct way.
Mysql Licensing Query
Nov 17, 2008Our local authority is looking into using MySQL database for some internal applications and possibly our website.
Do we need a commercial or enterprise license for this particular use or can we use a free version?
Can BIND Query Another Nameserver
Jul 2, 2008I've got mydomain.com using my own BIND nameserver hosted on a dedicated server.
I need subdomain.mydomain.com to have a dynamic IP. I know many dynamic DNS providers, but they all require you to change the nameservers of your domain to their own nameservers. Unfortunately I cannot do this - I need mydomain.com to keep using my nameservers.
I therefore need a way to get my nameserver to query a dynamic DNS providers' nameserver for subdomain.mydomain.com. Esentially my nameserver would just copy the IP that the other nameserver returns. Can BIND do this, or if not, any other name-server software?
Mysql Files To .sql Query
Apr 30, 2008I have the files .myd .myi and .frm files in a archive .tar.gz
My host do not provide shell access.
Is the any way that i can convert the files into .sql queries
Or is there any method other that using shell access.
Or is there any software to convert the database files into .sql query in my desktop computer so that i can restore it using phpmyadmin
My site has been down from several days
Mysql And Query Cache
Jan 4, 2007What is the good value to set query_cache_size. I have set it to 60 M and here
is the status. Is it good? I am not sure how to check this? Can anyone explain?
query_cache_size=60M
mysql> SHOW STATUS LIKE 'Qcache%';
+-------------------------+----------+
| Variable_name | Value |
+-------------------------+----------+
| Qcache_free_blocks | 5 |
| Qcache_free_memory | 62666440 |
| Qcache_hits | 922 |
| Qcache_inserts | 381 |
| Qcache_lowmem_prunes | 0 |
| Qcache_not_cached | 565 |
| Qcache_queries_in_cache | 182 |
| Qcache_total_blocks | 400 |
+-------------------------+----------+
8 rows in set (0.00 sec)
Strange Http Query Attack
Apr 9, 2009I have a problem since yesterday in one of my servers, Im receiving between 200 and 300 hits by second from different IPs to a non existent path in a site, the hits are going to different cracks, films and download query's, this site is a directory and its not a warez or p2p site.
The site is onemilliondirectory.com, and I have suspended it because it was using a lot of resources of the first server, now its being redirected to other location, I have placed some traffic trackers to determine the referer or any other usefull info about the visitors, but the referer is always empty and I think that they are fake users because the statcounter tracker do not recognize the visits.
For example, some of the hits are:
Code:
GET /suspended.page/?v=ABC%204%20KIDS%20Workshop%201.0.zip HTTP
GET /suspended.page/?v=DecryptSQL%202.8.zip HTTP/1.1
GET /suspended.page/?v=[0]%20Msn%20Live%20Messenger%20Mobile.zip
GET /inactive.html?v=Able%20Photo%20Slide%20Show%202.2.5.5.zip
GET /suspended.page/?v=English%20Grammar%20Worksheet%201.4.zip
GET /inactive.html?v=Karaoke%205%2030.zip HTTP/1.1
GET /suspended.page/?v=Nero%208%208.3.2.1.zip HTTP/1.1
Detail of one of the visits from the cpanel latest visitors tool:
Code:
Host: 82.246.88.241
/inactive.html?a=Knowing.2009.TS.FRENCH.XVID-PaGlop.****.[emule-island.com].avi
Http Code: 200 Date: Apr 07 16:39:54 Http Version: HTTP/1.1 Size in Bytes: 262
Referer: -
Agent: Internet Explorer
Exchange/Push Email Query
Oct 25, 2008I own a small company of 15 people who are all based remotely at their own homes throughout Europe.
Most of us are based in the UK and our web hosting server names.co.uk provide our email and web hosting service but we do not have an exchange server with them.
Now most of my colleagues own blackberry's which i just dont get on well with and I have my eyes set on buying a windows mobile device with Push email, namely the Sony Ericsson Xperia X1.
Anyway my query is this:
How do i go about getting exchange included to my hosting setup? Can another company host it or do i have to transfer my web hosting and email hosting to another company which facilitates exchange as well?
Apache :: Characters In URL But Not In Query String
Feb 21, 2013I have an [URL] ....
I use htaccess to rewrite it to: [URL] ...
and there is a problem, because I do not get what I need. The result is: [URL] .....
The last / sing dous not even matter, because if I write the url without the ending /, the three dots are still removed.
It looks like everywhere in the url the (in regexp) .+/ pattern is replaced with a simple / sign.
The RewriteRule is very simple, I can not imagine it has anything to do with this, but it looks this:
RewriteRule ^(.*)$ index.php?p=$1 [QSA]
I started to log the rewrite and it looks like if the specific parts of the url are replaced before the rewrite got it.
These are the first few rows of the rewrite log:
add path info postfix: E:/web/service/szerz....odes -> E:/web/service/szerz....odes/action/axgetszerzodesar/ugyfelid/46402/termekid/46032/szerzodesszam/2012.01.01/
strip per-dir prefix: E:/web/service/szerz....odes/action/axgetszerzodesar/ugyfelid/46402/termekid/46032/szerzodesszam/2012.01.01/ -> szerz....odes/action/axgetszerzodesar/ugyfelid/46402/termekid/46032/szerzodesszam/2012.01.01/
applying pattern '^(.*)$' to uri 'szerz....odes/action/axgetszerzodesar/ugyfelid/46402/termekid/46032/szerzodesszam/2012.01.01/'
webserver: Apache/2.2.22 (Win32) PHP/5.2.17
and Apache/2.2.9 (Win32) PHP/5.2.17 (I refreshed it today because of this problem)
os: win7 home premium sp1
It is tested on a linux os too, but there were no such problems.
Apache :: Match Query String With URL As Value
Dec 30, 2014I want to match a query string with modrewrite , the problem is that my query_string has a url as value:
%{QUERY_STRING} next=https://play.google.com/store/apps/details?pepe=1
and it doesn't work for me.
input='next=https://play.google.com/store/apps/details?pepe=1'
patttern='next=https://play.google.com/store/apps/details?pepe=1' => not-matched
but if I had to match only the uri , it works , the problem is when I try to add parameters to the query_string url:
http://someurl.com?next=https://play.google.com/store/apps/details?pepe=1
Is there any way to match that kind of query_string?
Lost Connection To Mysql Server During Query
Aug 12, 2007some vBulletin customers facing to that error message, with session table with attachment only. Other just work fine. It's not because of server load. The load is just around 0 - 0.1
I have increased wait_timeout to 200 and max_allowed_packet to 64MB. Each attachment file in those vBulletin is just around 1-3MB.
Is there any idea why and how to fix?
Very Slow Query Time After Upgrade To Mysql 5
Apr 8, 2009We have a dedicated server and we host 4 news portals based on e107 and joomla.
My partner on Sunday has upgraded mysql from version 4 to 5. Now the server experiences very high CPU usage and query time on portals has been increased very much.
We used to have query times lower than 1 sec for the main page of [url](which is a site that receives about 2000 visits/day) and now query times are 5-15sec !
Does anybody know if this is makes sense ?
Below is the server Status from WHM :
-------------------------------------
cpdavd up
cpsrvd up
exim (exim-4.69-15.1_cpanel_maildir) up
ftpd up
httpd (2.2.11 (Unix)) up
imap up
interval up
mysql (5.0.67-community-log) up
named (9.3.4) up
pop up
rsyslogd up
spamd up
syslogd up
Server Load 6.97 (1 cpu)
Memory Used 49.4 %
Swap Used 0.23 %
Disk /dev/hda3 (/tmp) DMA+ 70 %
Disk /dev/hda5 (/) DMA+ 22 %
Disk /dev/hda1 (/boot) DMA+ 14 %
Below is the Server Information from WHM :
------------------------------------------
Processor #1 Vendor: GenuineIntel
Processor #1 Name: Intel(R) Core(TM)2 Duo CPU E4600 @ 2.40GHz
Processor #1 speed: 2394.068 MHz
Processor #1 cache size: 2048 KB
Memory Information
Memory: 2064420k/2087424k available (2091k kernel code, 21752k reserved, 846k data, 236k init, 1169920k highmem)
System Information
Linux server.aktoweb.biz 2.6.20-1.2319.fc5 #1 Mon May 21 19:52:13 EDT 2007 i686 i686 i386 GNU/Linux
Physical Disks
hda: WDC WD3200AAJB-00TYA0, ATA DISK drive
hda: hw_config=600d
hda: hw_config=600d
hda: max request size: 512KiB
hda: 625142448 sectors (320072 MB) w/8192KiB Cache, CHS=38913/255/63<6>hda: hw_config=600d
hda: cache flushes supported
Current Memory Usage
total used free shared buffers cached
Mem: 2066428 1756324 310104 0 339576 486636
-/+ buffers/cache: 930112 1136316
Swap: 1052248 2428 1049820
Total: 3118676 1758752 1359924
Current Disk Usage
Filesystem Size Used Avail Use% Mounted on
/dev/hda5 288G 60G 213G 22% /
/dev/hda1 99M 13M 82M 14% /boot
tmpfs 1009M 0 1009M 0% /dev/shm
/dev/hda3 494M 215M 254M 46% /tmp
Below is the CPU/Memmory/Mysql Usage from WHM :
-------------------------------------------------
mysql42.707.300.0
Top Process%CPU 42.7/usr/sbin/mysqld --basedir/ --datadir/var/lib/mysql --usermysql --pid-file/var/lib/mysql/server.aktoweb.biz.pid --skip-external-locking
Top Process%CPU 42.6/usr/sbin/mysqld --basedir/ --datadir/var/lib/mysql --usermysql --pid-file/var/lib/mysql/server.aktoweb.biz.pid --skip-external-locking
giaprakigiapraki.com2.7012.111.7
Top Process%CPU 1.3httpd [urll] [/e107_plugins/pm/pm.php?inbox]
Top Process%CPU 1.1httpd [url] [/e107_plugins/forum/forum_viewforum.php?87]
Top Process%CPU 1.0httpd [url] [/e107_plugins/chatbox_menu/chatbox_iframe.php]
adsnetadsnet.gr1.177.900.7
Top Process%CPU 0.5httpd [adsnet.gr] [/www/delivery/lg.php?bannerid16&campaignid4&zoneid5&chan]
Top Process%CPU 0.4httpd [adsnet.gr] [/www/delivery/lg.php?bannerid50&campaignid6&zoneid15&cha]
Top Process%CPU 0.3httpd [adsnet.gr] [/www/delivery/lg.php?bannerid183&campaignid77&zoneid1&ch]
r40r40.gr1.073.340.0
Top Process%CPU 1.1httpd [r40.gr] [/index.php?optioncom_fireboard&Itemid188&funcshowcat&cat]
Top Process%CPU 0.5httpd [r40.gr] [/images/fbfiles/avatars/s_64.png]
Top Process%CPU 0.3httpd [r40.gr] [/index2.php?optioncom_jim&taskxml&no_html1]
root0.278.532.0
Top Process%CPU 0.2[kjournald]
alex123alexandroupoli.net0.030.270.0
Top Process%CPU 0.1httpd [alexandroupoli.net] [/e107_images/banners/banner468x60-alexandroupolinet.gif]
galfasgalfas.gr0.030.270.0
Top Process%CPU 0.1httpd [galfas.gr] [/racing/images/galfas_R40_banner.jpg]
eximstats0.000.000.3
nobody0.001.100.0
mailnull0.000.000.0
unauthenticated0.000.000.0
named0.000.10
High Usage Email System Query
Apr 15, 2009One of the projects I will work on will require to process 50,000 emails a day. Most of these emails would include attachments and the challenge is to process them and put all the stuff into a database for the application to use.
My biggest concern is spam and we cannot afford to lose out on legitimate emails. One way of configuring the setup would entail checking emails for the specific types of attachments and piping it in.
However I was just wondering if someone here has dealt with this volume of emails and also what are the spam limiting options available (even commercial would do)
How To Enable Slow-query Logging In MySQL
Apr 23, 2007how to enable slow-query logging in MySQL ? Im using mysql version 4.1.20
well i just added following line in my.cnf can you please tell me is it correct way or not?
Code:
log-slow-queries=/tmp/slow_queries.log
log-update = /var/lib/mysql/updates.log
Mysql: Schedule Flush Query Cache
Dec 5, 2007I want to run flush query cache, saying once a week. Is there anyway to schedule it, so system can do it automatically? Currently, I have to login server, and run it manually
View 1 Replies View RelatedApache :: Trying To Rewrite URLs With Query Strings
Feb 23, 2013I need htaccess file for one of my sites. I've searched everywhere, and I can't find a solution for my problem.
System Info:
Easy Apache v3.18.1
CentOS 6.3 (x86_64)
So I'm trying to redirect all URLs in a certain query range to a new website. i.e.,
mydomain.com/?p=35000
mydomain.com/?p=35001
mydomain.com/?p=35002
mydomain.com/?p=35003
etc.
all need to 301 redirect to myotherdomain.com
I don't need to append each query to the new domain. All the URLs simply need to redirect to the naked domain of the other site. So
mydomain.com/?p=35000 is not redirecting to myotherdomain.com/?p=35000
It is simply redirecting to myotherdomain.com
Also, I need to redirect the specific series ([35000-35999]) to the new domain. I want to redirect the www and the non-www URLs.
I've attempted to write the code myself, but when I upload the htaccess file, the URLs are not redirecting. I'm doing something wrong.
Here's what I've tried:
Code:
RewriteEngine on
RewriteCond %{HTTP_HOST} ^mydomain.com$ [OR]
RewriteCond %{HTTP_HOST} ^www.mydomain.com$
RewriteCond %{QUERY_STRING} ^p=([35000-35999]*)$
RewriteRule ^(.*)$ "http://myotherdomain.com/" [R=301,L]
Mysql Access Host Via Command Line Or Sql Query
Apr 30, 2009how to add a mysql access host by command line? or or how to add a mysql access host through an sql query?
View 3 Replies View RelatedFasthosts Query - Multiple Domains On One Hosting Package
Dec 4, 2008I'm doing some work for a client, they have a linux developer package with Fasthosts for an existing website.
[url]
what I can't seem to work out from the Fasthosts website is whether I could register another domain with this package to save having to buy further hosting. Both websites are pretty small.
Apache :: How To Block A Specific (Query String) URL Via HTAccess
Mar 18, 2013I don't know how to block a specific QUERY STRING url via .htaccess file, well actually I want to block this type of url :
test.php?q=RANDOMTEXT=&tl=The%20path%20ends