Just encountered an interesting issue.
I use DNS names instead of IPs in mysql grants. Yes, I'm aware of the
performance impact, that's not an issue.
I just found out through failing logins that a server was still connecting to
an old DNS server, and properly updated the resolv.conf.
Johan,
Consider also the DNS TTL.
If you flush hosts in MySQL it'll ask again the OS to resolve a name , but
if that is still in the DNS cache it could return that 'old' value instead
of querying the newly updated NS.
I'm not sure thou, may be test by restarting the name server cache
deamon
- Original Message -
From: Claudio Nanni claudio.na...@gmail.com
Consider also the DNS TTL.
That should be irrelevant when changing DNS servers :-)
If you flush hosts in MySQL it'll ask again the OS to resolve a name
, but if that is still in the DNS cache it could return that
In the last episode (May 19), Johan De Meersman said:
I use DNS names instead of IPs in mysql grants. Yes, I'm aware of the
performance impact, that's not an issue.
I just found out through failing logins that a server was still connecting
to an old DNS server, and properly updated the
- Original Message -
From: Dan Nelson dnel...@allantgroup.com
I doubt that mysql calls anything other than gethostbyname() or
getaddrinfo(), so your behaviour is probably dependant on whatever OS
you are running and how often its local resolver re-checks resolv.conf.
Usually that's
Nestor [EMAIL PROTECTED] wrote:
I send this last week and no one commented.
Nestor, I've already asked you check value of sql_select_limit variable:
SELECT @@session.sql_select_limit;
Is SELECT * FROM course_eng exact query that you use?
Has anyone run into this simmilar problem?
Victoria,
The seleect statements that I wrote is what I use.
And if there was a limit should the limit be used in both o f my select?
Database changed
mysql SELECT @@session.sql_select_limit;
++
| @@session.sql_select_limit |
++
|
I send this last week and no one commented.
Has anyone run into this simmilar problem?
-Original Message-
From: Nestor Florez [mailto:[EMAIL PROTECTED]
Sent: Thursday, March 18, 2004 10:28 AM
I have a php web application that has an admin page for inserting course
records and one for
: Nestor [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Friday, March 26, 2004 7:38 PM
Subject: RE: interestingBUG? COMMENTS?
I send this last week and no one commented.
Has anyone run into this simmilar problem?
-Original Message-
From: Nestor Florez [mailto:[EMAIL PROTECTED]
Sent
Nestor Florez [EMAIL PROTECTED] wrote:
I have a php web application that has an admin page for inserting course =
records and one for selecting course records=20
and a client page for selecting course record. =20
In the admin side I insert records with an insert into Course_Eng and I =
People,
I have a php web application that has an admin page for inserting course records and
one for selecting course records
and a client page for selecting course record.
In the admin side I insert records with an insert into Course_Eng and I select
records witha select * from Course_Eng
11 matches
Mail list logo