Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 289
  • Last Modified:

to many connects on mysql

Is this normal?

*************************** 38. row ***************************
     Id: 834622
   User: unauthenticated user
   Host: 10.10.10.30:50232
     db: NULL
Command: Connect
   Time: NULL
  State: login
   Info: NULL
*************************** 39. row ***************************
     Id: 834623
   User: unauthenticated user
   Host: 10.10.10.30:50233
     db: NULL
Command: Connect
   Time: NULL
  State: login
   Info: NULL
*************************** 40. row ***************************
     Id: 834624
   User: unauthenticated user
   Host: 10.10.10.30:50234
     db: NULL
Command: Connect
   Time: NULL
  State: login
   Info: NULL
*************************** 41. row ***************************
     Id: 834625
   User: unauthenticated user
   Host: 10.10.10.31:35424
     db: NULL
Command: Connect
   Time: NULL
  State: login
   Info: NULL
*************************** 42. row ***************************
     Id: 834626
   User: unauthenticated user
   Host: 10.10.10.30:50235
     db: NULL
Command: Connect
   Time: NULL
  State: login
   Info: NULL
*************************** 43. row ***************************
     Id: 834627
   User: unauthenticated user
   Host: 10.10.10.30:50236
     db: NULL
Command: Connect
   Time: NULL
  State: login
   Info: NULL
*************************** 44. row ***************************
     Id: 834628
   User: unauthenticated user
   Host: 10.10.10.31:35425
     db: NULL
Command: Connect
   Time: NULL
  State: login
   Info: NULL
*************************** 45. row ***************************
     Id: 834629
   User: unauthenticated user
   Host: 10.10.10.30:50237
     db: NULL
Command: Connect
   Time: NULL
  State: login
   Info: NULL
*************************** 46. row ***************************
     Id: 834631
   User: unauthenticated user
   Host: 10.10.10.31:35426
     db: NULL
Command: Connect
   Time: NULL
  State: login
   Info: NULL
*************************** 47. row ***************************
     Id: 834632
   User: unauthenticated user
   Host: 10.10.10.31:35427
     db: NULL
Command: Connect
   Time: NULL
  State: login
   Info: NULL
*************************** 48. row ***************************
     Id: 834633
   User: unauthenticated user
   Host: 10.10.10.30:50238
     db: NULL
Command: Connect
   Time: NULL
  State: login
   Info: NULL
*************************** 49. row ***************************
     Id: 834634
   User: unauthenticated user
   Host: 10.10.10.30:50239
     db: NULL
Command: Connect
   Time: NULL
  State: login
   Info: NULL
*************************** 50. row ***************************
     Id: 834635
   User: unauthenticated user
   Host: 10.10.10.30:50240
     db: NULL
Command: Connect
   Time: NULL
  State: login
   Info: NULL
*************************** 51. row ***************************
     Id: 834636
   User: unauthenticated user
   Host: 10.10.10.30:50241
     db: NULL
Command: Connect
   Time: NULL
  State: login
   Info: NULL
*************************** 52. row ***************************
     Id: 834637
   User: unauthenticated user
   Host: 10.10.10.30:50242
     db: NULL
Command: Connect
   Time: NULL
  State: login
   Info: NULL
*************************** 53. row ***************************
     Id: 834638
   User: unauthenticated user
   Host: 10.10.10.31:35428
     db: NULL
Command: Connect
   Time: NULL
  State: login
   Info: NULL
*************************** 54. row ***************************
     Id: 834639
   User: unauthenticated user
   Host: 10.10.10.30:50243
     db: NULL
Command: Connect
   Time: NULL
  State: login
   Info: NULL
*************************** 55. row ***************************
     Id: 834640
   User: unauthenticated user
   Host: 10.10.10.30:50244
     db: NULL
Command: Connect
   Time: NULL
  State: login
   Info: NULL
*************************** 56. row ***************************
     Id: 834641
   User: unauthenticated user
   Host: 10.10.10.30:50245
     db: NULL
Command: Connect
   Time: NULL
  State: login
   Info: NULL
*************************** 57. row ***************************
     Id: 834642
   User: unauthenticated user
   Host: 10.10.10.31:35429
     db: NULL
Command: Connect
   Time: NULL
  State: login
   Info: NULL
*************************** 58. row ***************************
     Id: 834643
   User: unauthenticated user
   Host: 10.10.10.31:35430
     db: NULL
Command: Connect
   Time: NULL
  State: login
   Info: NULL
*************************** 59. row ***************************
     Id: 834644
   User: unauthenticated user
   Host: 10.10.10.30:50246
     db: NULL
Command: Connect
   Time: NULL
  State: login
   Info: NULL
*************************** 60. row ***************************
     Id: 834645
   User: unauthenticated user
   Host: 10.10.10.30:50247
     db: NULL
Command: Connect
   Time: NULL
  State: login
   Info: NULL
*************************** 61. row ***************************
     Id: 834646
   User: unauthenticated user
   Host: 10.10.10.31:35431
     db: NULL
Command: Connect
   Time: NULL
  State: login
   Info: NULL
*************************** 62. row ***************************
     Id: 834647
   User: unauthenticated user
   Host: 10.10.10.31:35432
     db: NULL
Command: Connect
   Time: NULL
  State: login
   Info: NULL
*************************** 63. row ***************************
     Id: 834648
   User: unauthenticated user
   Host: 10.10.10.31:35433
     db: NULL
Command: Connect
   Time: NULL
  State: login
   Info: NULL
*************************** 64. row ***************************
     Id: 834649
   User: unauthenticated user
   Host: 10.10.10.30:50248
     db: NULL
Command: Connect
   Time: NULL
  State: login
   Info: NULL
*************************** 65. row ***************************
     Id: 834650
   User: unauthenticated user
   Host: 10.10.10.30:50249
     db: NULL
Command: Connect
   Time: NULL
  State: login
   Info: NULL
*************************** 66. row ***************************
     Id: 834651
   User: unauthenticated user
   Host: 10.10.10.30:50250
     db: NULL
Command: Connect
   Time: NULL
  State: login
   Info: NULL
*************************** 67. row ***************************
     Id: 834652
   User: unauthenticated user
   Host: 10.10.10.30:50251
     db: NULL
Command: Connect
   Time: NULL
  State: login
   Info: NULL
*************************** 68. row ***************************
     Id: 834653
   User: unauthenticated user
   Host: 10.10.10.31:35434
     db: NULL
Command: Connect
   Time: NULL
  State: login
   Info: NULL
*************************** 69. row ***************************
     Id: 834654
   User: unauthenticated user
   Host: 10.10.10.30:50252
     db: NULL
Command: Connect
   Time: NULL
  State: login
   Info: NULL
*************************** 70. row ***************************
     Id: 834655
   User: unauthenticated user
   Host: 10.10.10.2:3014
     db: NULL
Command: Connect
   Time: NULL
  State: login
   Info: NULL
*************************** 71. row ***************************
     Id: 834656
   User: unauthenticated user
   Host: 10.10.10.30:50253
     db: NULL
Command: Connect
   Time: NULL
  State: login
   Info: NULL
*************************** 72. row ***************************
     Id: 834657
   User: unauthenticated user
   Host: 10.10.10.30:50254
     db: NULL
Command: Connect
   Time: NULL
  State: login
   Info: NULL
*************************** 73. row ***************************
     Id: 834658
   User: unauthenticated user
   Host: 10.10.10.30:50255
     db: NULL
Command: Connect
   Time: NULL
  State: login
   Info: NULL
*************************** 74. row ***************************
     Id: 834659
   User: unauthenticated user
   Host: 10.10.10.30:50256
     db: NULL
Command: Connect
   Time: NULL
  State: login
   Info: NULL
*************************** 75. row ***************************
     Id: 834660
   User: unauthenticated user
   Host: 10.10.10.30:50257
     db: NULL
Command: Connect
   Time: NULL
  State: login
   Info: NULL
*************************** 76. row ***************************
     Id: 834661
   User: unauthenticated user
   Host: 10.10.10.30:50258
     db: NULL
Command: Connect
   Time: NULL
  State: login
   Info: NULL
*************************** 77. row ***************************
     Id: 834662
   User: unauthenticated user
   Host: 10.10.10.30:50259
     db: NULL
Command: Connect
   Time: NULL
  State: login
   Info: NULL
*************************** 78. row ***************************
     Id: 834663
   User: unauthenticated user
   Host: 10.10.10.30:50260
     db: NULL
Command: Connect
   Time: NULL
  State: login
   Info: NULL
*************************** 79. row ***************************
     Id: 834664
   User: unauthenticated user
   Host: 10.10.10.31:35435
     db: NULL
Command: Connect
   Time: NULL
  State: login
   Info: NULL
*************************** 80. row ***************************
     Id: 834666
   User: unauthenticated user
   Host: 10.10.10.30:50261
     db: NULL
Command: Connect
   Time: NULL
  State: login
   Info: NULL
*************************** 81. row ***************************
     Id: 834667
   User: unauthenticated user
   Host: 10.10.10.30:50262
     db: NULL
Command: Connect
   Time: NULL
  State: login
   Info: NULL
0
grupodeca
Asked:
grupodeca
  • 3
1 Solution
 
grupodecaAuthor Commented:
In MySQL Doc chapter 7.10.1 Thread Command Values it says command "Connect" stands for: A replication slave is connected to its master.

The thing is I don't have replication enabled on my server.

???
0
 
grupodecaAuthor Commented:
* MySQL server version is 5.1.56 on linux Fedora 14 with IP 10.10.10.17.
* Clients using PHP 5.2.6 on linux Fedora 9 with IP 10.10.10.30 & 31
0
 
Kerem ERSOYPresidentCommented:
Hi,

Whan a new connection comes to MySQL it will try to resolve its name. Connections to DB wiill hang if you're timing out with DNS resolution. Will you check that if your name resolution works (using nslookup, checking /etc/resolv.conf etc)

If not try to add entries for the clients in the /etc/hosts

Cheers,
K.
0
 
grupodecaAuthor Commented:
The question was answered partially but gave me the main topic to follow the solution.
0

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now