asked on

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

grupodeca

ASKER

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.

???

grupodeca

ASKER

* 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

ASKER CERTIFIED SOLUTION

Kerem ERSOY

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

grupodeca

ASKER

The question was answered partially but gave me the main topic to follow the solution.