MySQL DNS (Domain Name Server) Lookup

Feb 18, 2008

My MySQL server slowed down to a crawl a few days ago, and I finally fixed it by starting it without DNS lookups via "--skip-name-resolve".

I tested domain name resolution on the MySQL machine and it was able to return IPs from domains rather quickly, so I'm at a loss as to why DNS was the problem here? I am using "192.168.1.6" as the MySQL server's IP, in case that matters?

I have a couple of questions:Why is DNS resolution so slow when in the command line it's running normally?

Why does MySQL need to do DNS lookups at all? I don't see any log files that's converting IPs to host names or vice versa.

View 3 Replies


ADVERTISEMENT

MySQL DNS Lookup Delay - Internal IP

May 30, 2009

I have six dedicated servers on a VPR. I use one of these as the Database server and the other five connects to that server to read the Database.

When I setup my scripts for the first time I used the external IP to connect to the DB server. Everything worked perfect for these weeks:

mysql_connect('174.xxx.xxx.xx', 'user', 'pass');

Since three days ago I finally received the internal IPs of my servers and now I use the internal IP of the DB server:

mysql_connect('10.0.0.1:3306', 'user', 'pass');

When I did this last change this my database started to collapse. Queries stuck on a bottleneck every 10 minutes. Here's an example:

40468 simon 10.0.0.7:47002 pkindigo_db Query 115 Locked update `captured` set hp_left = '79', status = 'normal', att1pp = '25', att2pp = '30', att3p
40523 simon 10.0.0.2:58080 pkindigo_db Query 115 Locked update `captured` set experience = '5120', level = '16', hp_left = '58', hp = '58', status =
... (tons of locked queries before) ...

As you may see table is locked since 115 seconds for a simple update... after some hours this ends on a "#1135 - Can't create a new thread (errno 13); if you are not out of available memory, you can consult the manual for a possible OS-dependent bug" and even some of my tables finally crashing.

I think that my Database stuck because of a DNS lookup delay. When I had this problem before using the external IPs, I added skip-name-resolve and the problem was fixed. But now with the internal IPs it seems that's not enough.

View 2 Replies View Related

Name Server Lookup

Jan 13, 2008

Somebody purchased a domain from a popular registrar. When you lookup the domain, it points to its own name servers (i.e. ns1.registrar.com and ns2.registrar.com), which means that it is hosted by them as well. correct?

this person is saying they bought their domain from the registrar, but they are hosted by company X. he says that he is pointing the ip address of his web site on company X to his registrar.

View 7 Replies View Related

Reverse DNS Lookup ...

May 5, 2008

if I do a reverse lookup on my server's IP it returns a host assigned by the data center. So is this something I should even be managing too or is that always left up to the DC? I run my own DNS for the forward lookup zones.


Also just a technical question, when you do a reverse lookup, how does it know where to look to get the host? I'm not sure I fully understand how these work.

View 11 Replies View Related

DNS Lookup Explanation

Mar 14, 2007

I want to know how serious following nameserver problem can be in reality:
[url] ?

From DNS timing someone could conclude it's a slow hosting.

Can anyone explain above results "accurately" ? I still don't know what's "good" result in DNS timing: A or F?

The problem is that
[url] loads slow (5-10 seconds on T1 connection), here's a speed test. I'm aware images and scripts contribute to slow site loading.

My question is: Beside removing some images from the Home page, is it any reason to change the hosting (regarding DNS tests).

View 2 Replies View Related

CURL Named Lookup

Sep 26, 2007

Friend of mine asked me what "CURL named lookup issue resolved" means, he's got a CentOS 4 machine, with cPanel/WHM latest builds I tried recompiling apache and even cPanel at some point but no good..

View 1 Replies View Related

Hostname/dns Lookup And Exim.

May 28, 2007

I am having a problem. My server was able to ping google.com successfully before installing DirectAdmin.

However after installing DirectAdmin, I am no longer able to ping google.com anymore. I just get a host cannot be found error. This is the same with all other domains.

The /etc/resolv.conf is exactly the same, so I do not know the issue. I also have other servers using the same nameserver and are still able to ping and resolve successfully.

The main problem here is that exim no longer can send email as it cannot lookup the hostnames.

the error from exim is: R=lookuphost defer (-1): host lookup did not complete.

Thats the only error within the message.

View 6 Replies View Related

Relaying Denied. IP Name Lookup Failed [xx.xxx.xx.xxx]

Nov 17, 2006

My VPS Config:
centos with webmin
mail program sendmail

Its a newly configured VPS have a problem with smtp realying through outlook and other smtp programs. When i use smtp on outlook it give following error:

The message could not be sent because one of the recipients was rejected by the server. The rejected e-mail address was 'xxxxx@yahoo.com'. Subject 'Outlook', Account: 'Testing', Server: 'xxxx.com', Protocol: SMTP, Server Response: '550 5.7.1 <xxxxx@yahoo.com>... Relaying denied. IP name possibly forged [xx.xxx.xx.xxx]', Port: 25, Secure(SSL): No, Server Error: 550, Error Number: 0x800CCC79

I want to make outgoing authentication activate instead of allowing some iprange or domain for relaying through /etc/mail/access.

View 4 Replies View Related

Ffmpeg Symbol Lookup Error

May 14, 2009

ffmpeg: symbol lookup error: /usr/lib/libavcodec.so.52: undefined symbol: speex_header_free

I am using a centos 5 vps

View 4 Replies View Related

Bind DNS Reverse Lookup File

Aug 3, 2009

I'm having tons of problems trying to get reverse lookup working on my dns server. I've scoured the net and tried lots of methods but so far none work.

Forward lookup DNS is working perfect, but reverse lookup is completely broken.

db.44.80.212.67:

Code:
$TTL 86400 ; Default TTL in secs(1 day)
@ IN SOA ns1.capturetheprize.com. info.capturetheprize.com. (

2009072902; serial number YYMMDDNN
28800 ; Refresh
7200 ; Retry
864000 ; Expire
86400 ; Min TTL
)

IN NS ns1.capturetheprize.com.
IN NS ns1.mytempmail.com.

; Reverse lookups
44 IN PTR ns2.mytempmail.com.
44 IN PTR ns1.mytempmail.com.
44 IN PTR ns2.capturetheprize.com.
44 IN PTR ns1.capturetheprize.com.
44 IN PTR mail.mytempmail.com.
44 IN PTR mail.capturetheprize.com.
44 IN PTR stats.capturetheprize.com.
44 IN PTR secure.capturetheprize.com.
named.conf

Code:
zone "80.212.67.in-addr.arpa" IN {
type master;
file "etcdb.44.80.212.67";
allow-transfer { localhost; };
};

View 3 Replies View Related

Changing Host Name Or Reverse Lookup

Jul 19, 2008

if its possible to change the reverse lookup, or at least i think thats what it is called.

I have 2 accounts on my CentOS, WHM/cPanel VPS and they are hosted on their own seperate IPs however when you do a lookup on one domain it also lists the other domain as being hosted on the server and vice-versa.

How do i change this so they appear like they are on different servers? Each one has their own nameservers which are on seperate IPs also.

View 3 Replies View Related

Where Are My E-mails Sent From? Should I Create Reverse Ip Lookup

May 11, 2007

Where am I sending e-mails from with the below settings:

(Is it mail.freesexdoor.com, www.freesexdoor.com, 64.85.161.123 or 64.85.161.124?)

My secondary question is: Is creating own reverse IP lookup to 64.85.161.124 possible and beneficial in my case? If so, what should I replace this SPF line with: freesexdoor.com. TXT "v=spf1 a mx ip4:64.85.161.123 ?all"?

I'm trying to improve freesexdoor.com's e-mail delivery ratio because hotmail and gmail deliver my PHP mailer's sent confirmation e-mails to the junk folder. I've done everything I can to improve the sent headers etc. so there's only one more possible way to improve it: (That I can think of). Freesexdoor.com is hosted on the same server as mitorahgames.com.

DirectAdmin control panel on CentOS 4.4.

My server's primary IP is: 64.85.161.123
My server's hostname is: server.mitorahgames.com

server.mitorahgames.com's Related DNS Settings:
mailA64.85.161.123
server.mitorahgames.com.A64.85.161.123
server.mitorahgames.com.NSns1.mitorahgames.com.
server.mitorahgames.com.NSns2.mitorahgames.com.
mailMX10
123.161.85.64.in-addr.arpaPTRserver.mitorahgames.com.
server.mitorahgames.com.TXT"v=spf1 a mx ip4:64.85.161.123 ?all"

freesexdoor.com's IP is: 64.85.161.124
freesexdoor.com's Related DNS Settings:

freesexdoor.com.A64.85.161.124
mailA64.85.161.124
mailMX10
freesexdoor.com.TXT"v=spf1 a mx ip4:64.85.161.123 ?all"

I'm by the way putting www.freesexdoor.com (PHP reported server name) to the Message ID: field in the e-mail headers. Would putting IP there perhaps work better? If so, which IP?

View 1 Replies View Related

How To Hide DNS Info On WHOIS Lookup

May 18, 2007

I want to hide my NS records on WHOIS lookup, or show a fake or something so that no one can find me, Is it possible,

View 5 Replies View Related

Forward Lookup Zones In Windows 2000

Aug 21, 2009

I have a windows 2000 server and I would like to configure two domain names, c.com and bnvsaj.c.com and requests to these domains should be forwarded to 192.168.0.1 and 192.168.0.2. How can I configure like this?

View 1 Replies View Related

DNS Lookup Timeout From Googlebot Indexing Webpages

Jul 4, 2007

One of my customers uses Webmasters Tools from google , looking at what pages he have indexed by Googlebot, found that 180 pages are giving a "DNS lookup timeout" error, tried searching for help on google and the only thing that i found is " We received a timeout on DNS lookup."

DNS are ok, same as the zone file, everything is responding OK, I dont know what can be the issue.. ? any ideas ?

Im using Ensim Pro and RHES 4.

View 1 Replies View Related

Network - DNS Lookup Error At Random Times

Sep 27, 2009

I regularly have DNS issues with some of my sites hosted with a specific host... At random sites, the urls done resolve and I get a DNS error.
Just to find out that a few hours later it loads again without issues...


I always thought it had something to do with my ISP... My host says that there's nothing wrong with their DNS.
However, I asked a few people now and it seems they're having DNS problems too sometimes when accessing the problematic urls...

View 6 Replies View Related

Apache :: OpenSSL 1.0.2 - Symbol Lookup Error

Feb 20, 2015

I'm getting the below error message when trying to perform "configtest" after upgrading apache to 2.4.12 version with success.

/home/apache/bin/httpd: symbol lookup error: /home/apache/bin/httpd: undefined symbol: SSL_CONF_CTX_new

Note: I received the error after recently upgrading my openssl to 1.0.2.

Just wonder how to get rid of the error message.

Running on Ubuntu Server 12.04.05 LTS 32bit.

View 6 Replies View Related

Hide Php/mysql Errors On Live Domain

Apr 27, 2009

how can i stop php and mysql errors from being displayed on a live site. I'd rather just check the error log than have the errors displayed to all users.

View 4 Replies View Related

How To Limit Http/mysql Connections Per Domain

Jun 22, 2007

how i can limit http and mysql connection limit on per domain basis.

View 2 Replies View Related

Plesk 12.x / Linux :: MySQL Resources Used By Domain

Jul 3, 2015

I am migrating some clients between Plesk panels ...

After migrate 10 domains the Health monitoring growup from MSQL from 1gb to 4.5gb

All 10 websites are small, how can i see to identify which domain/subscription is consuming a lot of resources?

View 6 Replies View Related

Postfix-mysql & Partial-catchall For Single Domain

Jan 29, 2007

I'm running postfix 2.3.5 with my alias info being drawn from a mysql database.

What i'm trying to do is setup a partial catchall setup to forward all email that's addressed *@hah.cx to uber@spamcop.net. However, I want email addressed to mikey@hah.cx, and mike@hah.cx to be directed to my local "mikey" user email account.

View 0 Replies View Related

Plesk 11.x / Linux :: Server Domain 302 Redirects To Hosted Domain - How To Undo

Nov 16, 2014

When I hit my server's domain it redirects me to one of the hosted sites' domain with a 302 redirect. It used to return the default plesk server page. How can I cancel the redirect?

View 2 Replies View Related

Domain Parking - Wildcard Domain Name Server (DNS)?

Nov 5, 2008

We have a lot of unused domains that we'd like to setup domain parking for.

To keep it simple, we'd like to just change the namesevers to ns1.domainparking.com and ns2.domainparking.com (not real nameservers!) and the domains would then automatically show a simple web page.

We use cpanel servers and are wondering how easy this is to do? I've seem mention of wildcard dns? Is that the answer?

View 2 Replies View Related

Domain Parking With Win2k3 Domain Name Server (DNS)?

Aug 3, 2007

i have about 8 different domains i'd like to point to a nameserver (ns1./ns2.mydomain.com) on Win2k3 server, but i can't get them resolved through my nameserver without creating a manual forward lookup entry for each *parked* domain separatly..

Does anyone know how to resolve "parked" domains automatically on Win2k3 DNS??

I just can't find any answer for this, everything i've found required manual creation of lookup entries..

anyone?

View 8 Replies View Related

Reverse Domain Name Server (DNS) ARPA For Domain On VPS

Jul 6, 2007

I have a vps with dedicated ip's for my domain names.

I read that in order for mails coming from my server not be picked up as spam, i need to add reverse ip entries.

Now i have already added the glue nameserver records on my godaddy control panel,

ns1.mydomain.com -> 10.20.30.40
ns2.mydomain.com -> 10.20.30.41

But do i need to speak to the datacenter to add the reverse dns entries for my domain on their nameservers? What about if i host my nameservers offsite, but then have my webserver/mailserver etc inside the datacenter? Would i need to request the datacenter where the nameservers are hosted to add the reverse ip entries for the domain, and then the request the same from the datacenter for my web/mail servers to add the reverse entries?

Is it really required?

View 2 Replies View Related

Domain Does Not Resolve :: Domain Name Server (DNS) Issues

Aug 14, 2008

I've been having some DNS problems with one of my domains for quite some time now. The domain does not always resolve - some go days without being able to access the site.

I ran a simple BASH script to show what I mean. I replaced my domain with "mysite.net" and the IP with "xx.xx.xxx.xxx".

# for i in `seq 1 15`; do host mysite.net; done

mysite.net has address xx.xx.xxx.xxx
mysite.net mail is handled by 0 mysite.net.
Host mysite.net not found: 2(SERVFAIL)
mysite.net has address xx.xx.xxx.xxx
Host mysite.net not found: 2(SERVFAIL)
mysite.net has address xx.xx.xxx.xxx
Host mysite.net not found: 2(SERVFAIL)
mysite.net has address xx.xx.xxx.xxx
Host mysite.net not found: 2(SERVFAIL)
mysite.net mail is handled by 0 mysite.net.
mysite.net has address xx.xx.xxx.xxx
Host mysite.net not found: 2(SERVFAIL)
Host mysite.net not found: 2(SERVFAIL)
mysite.net has address xx.xx.xxx.xxx
Host mysite.net not found: 2(SERVFAIL)
mysite.net mail is handled by 0 mysite.net.
mysite.net has address xx.xx.xxx.xxx
mysite.net mail is handled by 0 mysite.net.
mysite.net has address xx.xx.xxx.xxx
mysite.net mail is handled by 0 mysite.net.
mysite.net has address xx.xx.xxx.xxx
mysite.net mail is handled by 0 mysite.net.
mysite.net has address xx.xx.xxx.xxx
Host mysite.net not found: 2(SERVFAIL)
mysite.net has address xx.xx.xxx.xxx
mysite.net mail is handled by 0 mysite.net.
mysite.net has address xx.xx.xxx.xxx
mysite.net mail is handled by 0 mysite.net.
mysite.net has address xx.xx.xxx.xxx
mysite.net mail is handled by 0 mysite.net.
mysite.net has address xx.xx.xxx.xxx
mysite.net mail is handled by 0 mysite.net.

Has anyone experienced a similar problem? I have gone over the DNS records countless times and see no problems. The site is hosted on my own dedicated server.

View 13 Replies View Related

MySQL Error : MySQL Server Has Gone Away

Dec 18, 2007

I keep getting this error :
MySQL Error : MySQL server has gone away

How do I fix it?

my.cnf contents

Quote:

[mysqld]
safe-show-database
old_passwords
back_log = 75
skip-innodb
max_connections = 800
key_buffer = 48M
myisam_sort_buffer_size = 64M
join_buffer_size = 1M
read_buffer_size = 1M
sort_buffer_size = 2M
table_cache = 3000
thread_cache_size = 128
wait_timeout = 90
connect_timeout = 30
tmp_table_size = 128M
max_heap_table_size = 64M
max_allowed_packet = 256M
net_buffer_length = 16384
max_connect_errors = 10
thread_concurrency = 4
read_rnd_buffer_size = 786432
bulk_insert_buffer_size = 8M
query_cache_limit = 3M
query_cache_size = 48M
query_cache_type = 1
query_prealloc_size = 262144
query_alloc_block_size = 65536
transaction_alloc_block_size = 8192
transaction_prealloc_size = 4096
default-storage-engine = MyISAM
max_user_connections = 500

[mysqld_safe]
nice = -5
open_files_limit = 8192

[mysqldump]
quick
max_allowed_packet = 16M

[myisamchk]
key_buffer = 64M
sort_buffer = 64M
read_buffer = 16M
write_buffer = 16M

[mysqlhotcopy]
interactive-timeout

View 5 Replies View Related







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