why do you want to limit the sockets to a dozen, the sockets are
created/closed dynamically depending on the current connections from
clients, so if your server is not servicing many clients they will
automatically be reduced , also in your case is this a slave??? , as the src
and dest ip's look to be the same (guessing replication threads), I am not a
mysql guru but these look pretty normal to me and nothing to worry about
....

Kishore Jalleda


On 2/8/06, Logg, Connie A. <[EMAIL PROTECTED]> wrote:
>
> Netstat -a shows the following:
>
> tcp        0      0 iepm-bw.slac.stanford:54335
> iepm-bw.slac.stanford.:1000 TIME_WAIT
> tcp        0      0 iepm-bw.slac.stanford:54334
> iepm-bw.slac.stanford.:1000 TIME_WAIT
> tcp        0      0 iepm-bw.slac.stanford:54333
> iepm-bw.slac.stanford.:1000 TIME_WAIT
> tcp        0      0 iepm-bw.slac.stanford:54332
> iepm-bw.slac.stanford.:1000 TIME_WAIT
> tcp        0      0 iepm-bw.slac.stanford:54331
> iepm-bw.slac.stanford.:1000 TIME_WAIT
> tcp        0      0 iepm-bw.slac.stanford:54330
> iepm-bw.slac.stanford.:1000 TIME_WAIT
> tcp        0      0 iepm-bw.slac.stanford:54329
> iepm-bw.slac.stanford.:1000 TIME_WAIT
> tcp        0      0 iepm-bw.slac.stanford:54328
> iepm-bw.slac.stanford.:1000 TIME_WAIT
> tcp        0      0 iepm-bw.slac.stanford:54327
> iepm-bw.slac.stanford.:1000 TIME_WAIT
> tcp        0      0 iepm-bw.slac.stanford:54326
> iepm-bw.slac.stanford.:1000 TIME_WAIT
> tcp        0      0 iepm-bw.slac.stanford:54325
> iepm-bw.slac.stanford.:1000 TIME_WAIT
> tcp        0      0 iepm-bw.slac.stanford:54324
> iepm-bw.slac.stanford.:1000 TIME_WAIT
> tcp        0      0 iepm-bw.slac.stanford:54323
> iepm-bw.slac.stanford.:1000 TIME_WAIT
> tcp        0      0 iepm-bw.slac.stanford:54322
> iepm-bw.slac.stanford.:1000 TIME_WAIT
> tcp        0      0 iepm-bw.slac.stanford:54321
> iepm-bw.slac.stanford.:1000 TIME_WAIT
> tcp        0      0 iepm-bw.slac.stanford:54399
> iepm-bw.slac.stanford.:1000 TIME_WAIT
> tcp        0      0 iepm-bw.slac.stanford:54397
> iepm-bw.slac.stanford.:1000 TIME_WAIT
> tcp        0      0 iepm-bw.slac.stanford:54396
> iepm-bw.slac.stanford.:1000 TIME_WAIT
> tcp        0      0 iepm-bw.slac.stanford:54395
> iepm-bw.slac.stanford.:1000 TIME_WAIT
> tcp        0      0 iepm-bw.slac.stanford:54394
> iepm-bw.slac.stanford.:1000 TIME_WAIT
> tcp        0      0 iepm-bw.slac.stanford:54393
> iepm-bw.slac.stanford.:1000 TIME_WAIT
> tcp        0      0 iepm-bw.slac.stanford:54392
> iepm-bw.slac.stanford.:1000 TIME_WAIT
> tcp        0      0 iepm-bw.slac.stanford:54391
> iepm-bw.slac.stanford.:1000 TIME_WAIT
> tcp        0      0 iepm-bw.slac.stanford:54390
> iepm-bw.slac.stanford.:1000 TIME_WAIT
> tcp        0      0 iepm-bw.slac.stanford:54389
> iepm-bw.slac.stanford.:1000 TIME_WAIT
> tcp        0      0 iepm-bw.slac.stanford:54388
> iepm-bw.slac.stanford.:1000 TIME_WAIT
> tcp        0      0 iepm-bw.slac.stanford:54387
> iepm-bw.slac.stanford.:1000 TIME_WAIT
> tcp        0      0 iepm-bw.slac.stanford:54386
> iepm-bw.slac.stanford.:1000 TIME_WAIT
> tcp        0      0 iepm-bw.slac.stanford:54385
> iepm-bw.slac.stanford.:1000 TIME_WAIT
> tcp        0      0 iepm-bw.slac.stanford:54384
> iepm-bw.slac.stanford.:1000 TIME_WAIT
> tcp        0      0 iepm-bw.slac.stanford:54383
> iepm-bw.slac.stanford.:1000 TIME_WAIT
> tcp        0      0 iepm-bw.slac.stanford:54382
> iepm-bw.slac.stanford.:1000 TIME_WAIT
> tcp        0      0 iepm-bw.slac.stanford:54381
> iepm-bw.slac.stanford.:1000 TIME_WAIT
> tcp        0      0 iepm-bw.slac.stanford:54380
> iepm-bw.slac.stanford.:1000 TIME_WAIT
> tcp        0      0 iepm-bw.slac.stanford:54379
> iepm-bw.slac.stanford.:1000 TIME_WAIT
> tcp        0      0 iepm-bw.slac.stanford:54378
> iepm-bw.slac.stanford.:1000 TIME_WAIT
> tcp        0      0 iepm-bw.slac.stanford:54377
> iepm-bw.slac.stanford.:1000 TIME_WAIT
> tcp        0      0 iepm-bw.slac.stanford:54376
> iepm-bw.slac.stanford.:1000 TIME_WAIT
> tcp        0      0 iepm-bw.slac.stanford:54375
> iepm-bw.slac.stanford.:1000 TIME_WAIT
> tcp        0      0 iepm-bw.slac.stanford:54374
> iepm-bw.slac.stanford.:1000 TIME_WAIT
> tcp        0      0 iepm-bw.slac.stanford:54373
> iepm-bw.slac.stanford.:1000 TIME_WAIT
> tcp        0      0 iepm-bw.slac.stanford:54372
> iepm-bw.slac.stanford.:1000 TIME_WAIT
> tcp        0      0 iepm-bw.slac.stanford:54371
> iepm-bw.slac.stanford.:1000 TIME_WAIT
> tcp        0      0 iepm-bw.slac.stanford:54370
> iepm-bw.slac.stanford.:1000 TIME_WAIT
> tcp        0      0 iepm-bw.slac.stanford:54369
> iepm-bw.slac.stanford.:1000 TIME_WAIT
> tcp        0      0 iepm-bw.slac.stanford:54368
> iepm-bw.slac.stanford.:1000 TIME_WAIT
> tcp        0      0 iepm-bw.slac.stanford:54367
> iepm-bw.slac.stanford.:1000 TIME_WAIT
> tcp        0      0 iepm-bw.slac.stanford:54366
> iepm-bw.slac.stanford.:1000 TIME_WAIT
> tcp        0      0 iepm-bw.slac.stanford:54365
> iepm-bw.slac.stanford.:1000 TIME_WAIT
> tcp        0      0 iepm-bw.slac.stanford:54364
> iepm-bw.slac.stanford.:1000 TIME_WAIT
> tcp        0      0 iepm-bw.slac.stanford:54363
> iepm-bw.slac.stanford.:1000 TIME_WAIT
> tcp        0      0 iepm-bw.slac.stanford:54362
> iepm-bw.slac.stanford.:1000 TIME_WAIT
> tcp        0      0 iepm-bw.slac.stanford:54361
> iepm-bw.slac.stanford.:1000 TIME_WAIT
> tcp        0      0 iepm-bw.slac.stanford:54360
> iepm-bw.slac.stanford.:1000 TIME_WAIT
> tcp        0      0 iepm-bw.slac.stanford:54359
> iepm-bw.slac.stanford.:1000 TIME_WAIT
> tcp        0      0 iepm-bw.slac.stanford:54358
> iepm-bw.slac.stanford.:1000 TIME_WAIT
> tcp        0      0 iepm-bw.slac.stanford:54357
> iepm-bw.slac.stanford.:1000 TIME_WAIT
> tcp        0      0 iepm-bw.slac.stanford:54355
> iepm-bw.slac.stanford.:1000 TIME_WAIT
> tcp        0      0 iepm-bw.slac.stanford:54354
> iepm-bw.slac.stanford.:1000 TIME_WAIT
> tcp        0      0 iepm-bw.slac.stanford:54353
> iepm-bw.slac.stanford.:1000 TIME_WAIT
> tcp        0      0 iepm-bw.slac.stanford:54352
> iepm-bw.slac.stanford.:1000 TIME_WAIT
> tcp        0      0 iepm-bw.slac.stanford:54351
> iepm-bw.slac.stanford.:1000 TIME_WAIT
> tcp        0      0 iepm-bw.slac.stanford:54350
> iepm-bw.slac.stanford.:1000 TIME_WAIT
> tcp        0      0 iepm-bw.slac.stanford:54349
> iepm-bw.slac.stanford.:1000 TIME_WAIT
> tcp        0      0 iepm-bw.slac.stanford:54348
> iepm-bw.slac.stanford.:1000 TIME_WAIT
> tcp        0      0 iepm-bw.slac.stanford:54347
> iepm-bw.slac.stanford.:1000 TIME_WAIT
> tcp        0      0 iepm-bw.slac.stanford:54346
> iepm-bw.slac.stanford.:1000 TIME_WAIT
> tcp        0      0 iepm-bw.slac.stanford:54345
> iepm-bw.slac.stanford.:1000 TIME_WAIT
> tcp        0      0 iepm-bw.slac.stanford:54344
> iepm-bw.slac.stanford.:1000 TIME_WAIT
> tcp        0      0 iepm-bw.slac.stanford:54343
> iepm-bw.slac.stanford.:1000 TIME_WAIT
> tcp        0      0 iepm-bw.slac.stanford:54342
> iepm-bw.slac.stanford.:1000 TIME_WAIT
> tcp        0      0 iepm-bw.slac.stanford:54341
> iepm-bw.slac.stanford.:1000 TIME_WAIT
> tcp        0      0 iepm-bw.slac.stanford:54340
> iepm-bw.slac.stanford.:1000 TIME_WAIT
> tcp        0      0 iepm-bw.slac.stanford:54339
> iepm-bw.slac.stanford.:1000 TIME_WAIT
> tcp        0      0 iepm-bw.slac.stanford:54338
> iepm-bw.slac.stanford.:1000 TIME_WAIT
> tcp        0      0 iepm-bw.slac.stanford:54337
> iepm-bw.slac.stanford.:1000 TIME_WAIT
> tcp        0      0 iepm-bw.slac.stanford:54336
> iepm-bw.slac.stanford.:1000 TIME_WAIT
> tcp        0      0 iepm-bw.slac.stanford:54463
> iepm-bw.slac.stanford.:1000 TIME_WAIT
> tcp        0      0 iepm-bw.slac.stanford:54462
> iepm-bw.slac.stanford.:1000 TIME_WAIT
> tcp        0      0 iepm-bw.slac.stanford:54461
> iepm-bw.slac.stanford.:1000 TIME_WAIT
> tcp        0      0 iepm-bw.slac.stanford:54460
> iepm-bw.slac.stanford.:1000 TIME_WAIT
> tcp        0      0 iepm-bw.slac.stanford:54459
> iepm-bw.slac.stanford.:1000 TIME_WAIT
> tcp        0      0 iepm-bw.slac.stanford:54458
> iepm-bw.slac.stanford.:1000 TIME_WAIT
> tcp        0      0 iepm-bw.slac.stanford:54457
> iepm-bw.slac.stanford.:1000 TIME_WAIT
> tcp        0      0 iepm-bw.slac.stanford:54456
> iepm-bw.slac.stanford.:1000 TIME_WAIT
> tcp        0      0 iepm-bw.slac.stanford:54455
> iepm-bw.slac.stanford.:1000 TIME_WAIT
> tcp        0      0 iepm-bw.slac.stanford:54454
> iepm-bw.slac.stanford.:1000 TIME_WAIT
> tcp        0      0 iepm-bw.slac.stanford:54453
> iepm-bw.slac.stanford.:1000 TIME_WAIT
> tcp        0      0 iepm-bw.slac.stanford:54452
> iepm-bw.slac.stanford.:1000 TIME_WAIT
> tcp        0      0 iepm-bw.slac.stanford:54451
> iepm-bw.slac.stanford.:1000 TIME_WAIT
> tcp        0      0 iepm-bw.slac.stanford:54450
> iepm-bw.slac.stanford.:1000 TIME_WAIT
> tcp        0      0 iepm-bw.slac.stanford:54449
> iepm-bw.slac.stanford.:1000 TIME_WAIT
> tcp        0      0 iepm-bw.slac.stanford:54448
> iepm-bw.slac.stanford.:1000 TIME_WAIT
> tcp        0      0 iepm-bw.slac.stanford:54447
> iepm-bw.slac.stanford.:1000 TIME_WAIT
> tcp        0      0 iepm-bw.slac.stanford:54446
> iepm-bw.slac.stanford.:1000 TIME_WAIT
> tcp        0      0 iepm-bw.slac.stanford:54445
> iepm-bw.slac.stanford.:1000 TIME_WAIT
> tcp        0      0 iepm-bw.slac.stanford:54444
> iepm-bw.slac.stanford.:1000 TIME_WAIT
> tcp        0      0 iepm-bw.slac.stanford:54443
> iepm-bw.slac.stanford.:1000 TIME_WAIT
> tcp        0      0 iepm-bw.slac.stanford:54442
> iepm-bw.slac.stanford.:1000 TIME_WAIT
> tcp        0      0 iepm-bw.slac.stanford:54441
> iepm-bw.slac.stanford.:1000 TIME_WAIT
> tcp        0      0 iepm-bw.slac.stanford:54440
> iepm-bw.slac.stanford.:1000 TIME_WAIT
> tcp        0      0 iepm-bw.slac.stanford:54439
> iepm-bw.slac.stanford.:1000 TIME_WAIT
> tcp        0      0 iepm-bw.slac.stanford:54438
> iepm-bw.slac.stanford.:1000 TIME_WAIT
> tcp        0      0 iepm-bw.slac.stanford:54437
> iepm-bw.slac.stanford.:1000 TIME_WAIT
> tcp        0      0 iepm-bw.slac.stanford:54436
> iepm-bw.slac.stanford.:1000 TIME_WAIT
> tcp        0      0 iepm-bw.slac.stanford:54435
> iepm-bw.slac.stanford.:1000 TIME_WAIT
> tcp        0      0 iepm-bw.slac.stanford:54434
> iepm-bw.slac.stanford.:1000 TIME_WAIT
> tcp        0      0 iepm-bw.slac.stanford:54433
> iepm-bw.slac.stanford.:1000 TIME_WAIT
> tcp        0      0 iepm-bw.slac.stanford:54432
> iepm-bw.slac.stanford.:1000 TIME_WAIT
> tcp        0      0 iepm-bw.slac.stanford:54431
> iepm-bw.slac.stanford.:1000 TIME_WAIT
> tcp        0      0 iepm-bw.slac.stanford:54430
> iepm-bw.slac.stanford.:1000 TIME_WAIT
> tcp        0      0 iepm-bw.slac.stanford:54429
> iepm-bw.slac.stanford.:1000 TIME_WAIT
> tcp        0      0 iepm-bw.slac.stanford:54428
> iepm-bw.slac.stanford.:1000 TIME_WAIT
> tcp        0      0 iepm-bw.slac.stanford:54427
> iepm-bw.slac.stanford.:1000 TIME_WAIT
> tcp        0      0 iepm-bw.slac.stanford:54426
> iepm-bw.slac.stanford.:1000 TIME_WAIT
> tcp        0      0 iepm-bw.slac.stanford:54425
> iepm-bw.slac.stanford.:1000 TIME_WAIT
> tcp        0      0 iepm-bw.slac.stanford:54424
> iepm-bw.slac.stanford.:1000 TIME_WAIT
> tcp        0      0 iepm-bw.slac.stanford:54423
> iepm-bw.slac.stanford.:1000 TIME_WAIT
> tcp        0      0 iepm-bw.slac.stanford:54422
> iepm-bw.slac.stanford.:1000 TIME_WAIT
> tcp        0      0 iepm-bw.slac.stanford:54421
> iepm-bw.slac.stanford.:1000 TIME_WAIT
> tcp        0      0 iepm-bw.slac.stanford:54420
> iepm-bw.slac.stanford.:1000 TIME_WAIT
> tcp        0      0 iepm-bw.slac.stanford:54419
> iepm-bw.slac.stanford.:1000 TIME_WAIT
> tcp        0      0 iepm-bw.slac.stanford:54418
> iepm-bw.slac.stanford.:1000 TIME_WAIT
> tcp        0      0 iepm-bw.slac.stanford:54417
> iepm-bw.slac.stanford.:1000 TIME_WAIT
> tcp        0      0 iepm-bw.slac.stanford:54416
> iepm-bw.slac.stanford.:1000 TIME_WAIT
> tcp        0      0 iepm-bw.slac.stanford:54415
> iepm-bw.slac.stanford.:1000 TIME_WAIT
> tcp        0      0 iepm-bw.slac.stanford:54414
> iepm-bw.slac.stanford.:1000 TIME_WAIT
> tcp        0      0 iepm-bw.slac.stanford:54413
> iepm-bw.slac.stanford.:1000 TIME_WAIT
> tcp        0      0 iepm-bw.slac.stanford:54412
> iepm-bw.slac.stanford.:1000 TIME_WAIT
> tcp        0      0 iepm-bw.slac.stanford:54411
> iepm-bw.slac.stanford.:1000 TIME_WAIT
> tcp        0      0 iepm-bw.slac.stanford:54410
> iepm-bw.slac.stanford.:1000 TIME_WAIT
> tcp        0      0 iepm-bw.slac.stanford:54409
> iepm-bw.slac.stanford.:1000 TIME_WAIT
> tcp        0      0 iepm-bw.slac.stanford:54408
> iepm-bw.slac.stanford.:1000 TIME_WAIT
> tcp        0      0 iepm-bw.slac.stanford:54407
> iepm-bw.slac.stanford.:1000 TIME_WAIT
> tcp        0      0 iepm-bw.slac.stanford:54406
> iepm-bw.slac.stanford.:1000 TIME_WAIT
> tcp        0      0 iepm-bw.slac.stanford:54405
> iepm-bw.slac.stanford.:1000 TIME_WAIT
> tcp        0      0 iepm-bw.slac.stanford:54404
> iepm-bw.slac.stanford.:1000 TIME_WAIT
> tcp        0      0 iepm-bw.slac.stanford:54403
> iepm-bw.slac.stanford.:1000 TIME_WAIT
> tcp        0      0 iepm-bw.slac.stanford:54402
> iepm-bw.slac.stanford.:1000 TIME_WAIT
> tcp        0      0 iepm-bw.slac.stanford:54401
> iepm-bw.slac.stanford.:1000 TIME_WAIT
> tcp        0      0 iepm-bw.slac.stanford:54400
> iepm-bw.slac.stanford.:1000 TIME_WAIT
> tcp        0      0 iepm-bw.slac.stanford:54491
> iepm-bw.slac.stanford.:1000 ESTABLISHED
> tcp        0      0 iepm-bw.slac.stanford:54490
> iepm-bw.slac.stanford.:1000 TIME_WAIT
> tcp        0      0 iepm-bw.slac.stanford:54489
> iepm-bw.slac.stanford.:1000 TIME_WAIT
> tcp        0      0 iepm-bw.slac.stanford:54488
> iepm-bw.slac.stanford.:1000 TIME_WAIT
> tcp        0      0 iepm-bw.slac.stanford:54487
> iepm-bw.slac.stanford.:1000 TIME_WAIT
> tcp        0      0 iepm-bw.slac.stanford:54486
> iepm-bw.slac.stanford.:1000 TIME_WAIT
> tcp        0      0 iepm-bw.slac.stanford:54485
> iepm-bw.slac.stanford.:1000 TIME_WAIT
> tcp        0      0 iepm-bw.slac.stanford:54484
> iepm-bw.slac.stanford.:1000 TIME_WAIT
> tcp        0      0 iepm-bw.slac.stanford:54483
> iepm-bw.slac.stanford.:1000 TIME_WAIT
> tcp        0      0 iepm-bw.slac.stanford:54482
> iepm-bw.slac.stanford.:1000 TIME_WAIT
> tcp        0      0 iepm-bw.slac.stanford:54480
> iepm-bw.slac.stanford.:1000 TIME_WAIT
> tcp        0      0 iepm-bw.slac.stanford:54479
> iepm-bw.slac.stanford.:1000 TIME_WAIT
> tcp        0      0 iepm-bw.slac.stanford:54478
> iepm-bw.slac.stanford.:1000 TIME_WAIT
> tcp        0      0 iepm-bw.slac.stanford:54477
> iepm-bw.slac.stanford.:1000 TIME_WAIT
> tcp        0      0 iepm-bw.slac.stanford:54476
> iepm-bw.slac.stanford.:1000 TIME_WAIT
> tcp        0      0 iepm-bw.slac.stanford:54475
> iepm-bw.slac.stanford.:1000 TIME_WAIT
> tcp        0      0 iepm-bw.slac.stanford:54474
> iepm-bw.slac.stanford.:1000 TIME_WAIT
> tcp        0      0 iepm-bw.slac.stanford:54473
> iepm-bw.slac.stanford.:1000 TIME_WAIT
> tcp        0      0 iepm-bw.slac.stanford:54472
> iepm-bw.slac.stanford.:1000 TIME_WAIT
> tcp        0      0 iepm-bw.slac.stanford:54471
> iepm-bw.slac.stanford.:1000 TIME_WAIT
> tcp        0      0 iepm-bw.slac.stanford:54470
> iepm-bw.slac.stanford.:1000 TIME_WAIT
> tcp        0      0 iepm-bw.slac.stanford:54469
> iepm-bw.slac.stanford.:1000 TIME_WAIT
> tcp        0      0 iepm-bw.slac.stanford:54468
> iepm-bw.slac.stanford.:1000 TIME_WAIT
> tcp        0      0 iepm-bw.slac.stanford:54467
> iepm-bw.slac.stanford.:1000 TIME_WAIT
> tcp        0      0 iepm-bw.slac.stanford:54466
> iepm-bw.slac.stanford.:1000 TIME_WAIT
> tcp        0      0 iepm-bw.slac.stanford:54465
> iepm-bw.slac.stanford.:1000 TIME_WAIT
>
> How can I limit these to say a dozen? I have looked at the tuning pages,
> but I probably do not understand the terminology enough to figure it out.
>
> Connie Logg
> Network analyst
> SLAC
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]
>
>

Reply via email to