SitePoint Sponsor

User Tag List

Results 1 to 2 of 2
  1. #1
    SitePoint Member
    Join Date
    May 2008
    Posts
    20
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Unauthenticated Users

    Hi,

    I am having problem on my master database server. I am getting 5-10 connections from "Unauthenticated User" and State is "Reading from Net". I observed that whenever i recieves those connections the queue is stuk (mysql>show processlist
    and it's growing and most of the threads are idle other valid user queries are in Sleep state.

    However i am already using skip-name-resolve. And for unauthenticated users the Host name is valid i.e. my webserver ip address. Can an one help me out and highlight the issue. what the problem is ?

    +-----+----------------------+--------------------+------+---------+------+-------+------------------+
    | Id | User | Host | db | Command | Time | State | Info |
    +-----+----------------------+--------------------+------+---------+------+-------+------------------+
    | 235 | unauthenticated user | WebServerIP:53216 | NULL | Connect | NULL | Reading from net | NULL |
    | 236 | unauthenticated user | WebServerIP:51721 | NULL | Connect | NULL | Reading from net | NULL |
    ------------------------------------------------------------------------------------------------------+

    Regards,
    Muhammad Irfan

  2. #2
    SitePoint Member captaincarne's Avatar
    Join Date
    Dec 2008
    Location
    Las Vegas, NV
    Posts
    23
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    I think that's because of the hostname lookups. If you turn the hostname lookups off those unauthenticated users should go away.

    So in your my.cnf

    Code:
    [mysqld]
    .....
    ......
    skip-name-resolve


Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •