[openstack-dev] [nova] Mysql db connection leaking?
Qiming Teng
tengqim at linux.vnet.ibm.com
Fri Apr 17 09:21:25 UTC 2015
> Can you show us the full listing for
>
> mysqladmin processlist
>
> as 125 seems high for a toy setup? How many nova instances are
> running? I have a (single node) devstack setup with 2 nova instances
> running and I have 9 mysql connections to the nova db.
>
> Regards
>
> Mark
Hi, Mark,
Below is the full list as of now. Two instances running on a two-host
devstack environment.
+------+------+-----------------+----------+---------+------+-------+------------------+----------+
| Id | User | Host | db | Command | Time | State |
Info | Progress |
+------+------+-----------------+----------+---------+------+-------+------------------+----------+
| 2183 | root | localhost:44303 | glance | Sleep | 1567 | |
| 0.000 |
| 2185 | root | localhost:44695 | glance | Sleep | 2646 | |
| 0.000 |
| 2270 | root | localhost:46238 | glance | Sleep | 967 | |
| 0.000 |
| 2281 | root | localhost:46387 | glance | Sleep | 3907 | |
| 0.000 |
| 2287 | root | localhost:46483 | glance | Sleep | 1477 | |
| 0.000 |
| 2320 | root | localhost:47122 | glance | Sleep | 457 | |
| 0.000 |
| 2336 | root | localhost:47743 | glance | Sleep | 427 | |
| 0.000 |
| 2346 | root | localhost:47874 | glance | Sleep | 217 | |
| 0.000 |
| 2349 | root | localhost:47964 | heat | Sleep | 508 | |
| 0.000 |
| 2350 | root | localhost:47965 | heat | Sleep | 508 | |
| 0.000 |
| 2351 | root | localhost:48018 | glance | Sleep | 97 | |
| 0.000 |
| 2352 | root | localhost:48040 | heat | Sleep | 476 | |
| 0.000 |
| 2353 | root | localhost:48101 | heat | Sleep | 444 | |
| 0.000 |
| 2354 | root | localhost:48191 | heat | Sleep | 411 | |
| 0.000 |
| 2355 | root | localhost:48263 | heat | Sleep | 380 | |
| 0.000 |
| 2356 | root | localhost:48371 | heat | Sleep | 349 | |
| 0.000 |
| 2357 | root | localhost:48389 | glance | Sleep | 298 | |
| 0.000 |
| 2358 | root | localhost:48450 | heat | Sleep | 316 | |
| 0.000 |
| 2359 | root | localhost:48527 | heat | Sleep | 285 | |
| 0.000 |
| 2360 | root | localhost:48617 | heat | Sleep | 253 | |
| 0.000 |
| 2361 | root | localhost:48673 | glance | Sleep | 2437 | |
| 0.000 |
| 2362 | root | localhost:48697 | heat | Sleep | 222 | |
| 0.000 |
| 2363 | root | localhost:48820 | heat | Sleep | 189 | |
| 0.000 |
| 2364 | root | localhost:48821 | heat | Sleep | 189 | |
| 0.000 |
| 2365 | root | localhost:48908 | heat | Sleep | 156 | |
| 0.000 |
| 2366 | root | localhost:48909 | heat | Sleep | 156 | |
| 0.000 |
| 2367 | root | localhost:49007 | heat | Sleep | 123 | |
| 0.000 |
| 2368 | root | localhost:49008 | heat | Sleep | 123 | |
| 0.000 |
| 2369 | root | localhost:49214 | glance | Sleep | 307 | |
| 0.000 |
| 2370 | root | localhost:49294 | heat | Sleep | 26 | |
| 0.000 |
| 2371 | root | localhost:49295 | heat | Sleep | 26 | |
| 0.000 |
| 2372 | root | localhost:49368 | heat | Sleep | 506 | |
| 0.000 |
| 2373 | root | localhost:49463 | heat | Sleep | 475 | |
| 0.000 |
| 2374 | root | localhost:49464 | heat | Sleep | 475 | |
| 0.000 |
| 2375 | root | localhost:49546 | heat | Sleep | 443 | |
| 0.000 |
| 2376 | root | localhost:49551 | nova | Sleep | 152 | |
| 0.000 |
| 2377 | root | localhost:49643 | heat | Sleep | 410 | |
| 0.000 |
| 2378 | root | localhost:49729 | heat | Sleep | 377 | |
| 0.000 |
| 2379 | root | localhost:49788 | heat | Sleep | 346 | |
| 0.000 |
| 2380 | root | localhost:49808 | glance | Sleep | 1537 | |
| 0.000 |
| 2381 | root | localhost:49867 | heat | Sleep | 315 | |
| 0.000 |
| 2382 | root | localhost:49955 | heat | Sleep | 284 | |
| 0.000 |
| 2383 | root | localhost:50030 | heat | Sleep | 252 | |
| 0.000 |
| 2384 | root | localhost:50097 | heat | Sleep | 218 | |
| 0.000 |
| 2385 | root | localhost:50193 | heat | Sleep | 187 | |
| 0.000 |
| 2386 | root | localhost:50194 | heat | Sleep | 187 | |
| 0.000 |
| 2387 | root | localhost:50303 | heat | Sleep | 152 | |
| 0.000 |
| 2388 | root | localhost:50304 | heat | Sleep | 152 | |
| 0.000 |
| 2389 | root | localhost:50418 | glance | Sleep | 2698 | |
| 0.000 |
| 2390 | root | localhost:50621 | glance | Sleep | 1207 | |
| 0.000 |
| 2391 | root | localhost:50797 | glance | Sleep | 157 | |
| 0.000 |
| 2392 | root | localhost:50942 | glance | Sleep | 2227 | |
| 0.000 |
| 2393 | root | localhost:51157 | glance | Sleep | 367 | |
| 0.000 |
| 2394 | root | localhost:51326 | glance | Sleep | 847 | |
| 0.000 |
| 2395 | root | localhost:51356 | nova | Sleep | 24 | |
| 0.000 |
| 2396 | root | localhost:51463 | glance | Sleep | 727 | |
| 0.000 |
| 2397 | root | localhost:51743 | glance | Sleep | 2137 | |
| 0.000 |
| 2398 | root | localhost:52160 | glance | Sleep | 397 | |
| 0.000 |
| 2399 | root | localhost:52543 | glance | Sleep | 1807 | |
| 0.000 |
| 2400 | root | localhost:53244 | glance | Sleep | 186 | |
| 0.000 |
| 2401 | root | localhost:53766 | glance | Sleep | 1117 | |
| 0.000 |
| 2402 | root | localhost:53803 | nova | Sleep | 37 | |
| 0.000 |
| 2403 | root | localhost:54201 | glance | Sleep | 487 | |
| 0.000 |
| 2404 | root | localhost:54704 | cinder | Sleep | 3 | |
| 0.000 |
| 2405 | root | localhost:54705 | nova | Sleep | 9 | |
| 0.000 |
| 2406 | root | localhost:54719 | cinder | Sleep | 8 | |
| 0.000 |
| 2407 | root | localhost:54742 | nova | Sleep | 6 | |
| 0.000 |
| 2408 | root | localhost:54761 | neutron | Sleep | 0 | |
| 0.000 |
| 2409 | root | localhost:54777 | neutron | Sleep | 7 | |
| 0.000 |
| 2410 | root | localhost:54778 | neutron | Sleep | 4 | |
| 0.000 |
| 2411 | root | localhost:54811 | nova | Sleep | 15 | |
| 0.000 |
| 2412 | root | localhost:54812 | nova | Sleep | 12 | |
| 0.000 |
| 2413 | root | localhost:54813 | nova | Sleep | 12 | |
| 0.000 |
| 2414 | root | localhost:54815 | nova | Sleep | 5 | |
| 0.000 |
| 2415 | root | localhost:54838 | keystone | Sleep | 6 | |
| 0.000 |
| 2416 | root | localhost:54843 | keystone | Sleep | 7 | |
| 0.000 |
| 2417 | root | localhost:54854 | nova | Sleep | 19 | |
| 0.000 |
| 2418 | root | localhost:54868 | nova | Sleep | 8 | |
| 0.000 |
| 2419 | root | localhost:54869 | nova | Sleep | 8 | |
| 0.000 |
| 2420 | root | localhost:54874 | nova | Sleep | 5 | |
| 0.000 |
| 2421 | root | localhost:54875 | nova | Sleep | 15 | |
| 0.000 |
| 2422 | root | localhost:54876 | nova | Sleep | 15 | |
| 0.000 |
| 2423 | root | localhost:54878 | nova | Sleep | 15 | |
| 0.000 |
| 2424 | root | localhost:54881 | nova | Sleep | 13 | |
| 0.000 |
| 2425 | root | localhost:54883 | nova | Sleep | 2 | |
| 0.000 |
| 2426 | root | localhost:54885 | nova | Sleep | 11 | |
| 0.000 |
| 2427 | root | localhost:54886 | nova | Sleep | 4 | |
| 0.000 |
| 2428 | root | localhost:54888 | nova | Sleep | 9 | |
| 0.000 |
| 2429 | root | localhost:54889 | nova | Sleep | 8 | |
| 0.000 |
| 2430 | root | localhost:54891 | nova | Sleep | 18 | |
| 0.000 |
| 2431 | root | localhost:54892 | nova | Sleep | 18 | |
| 0.000 |
| 2432 | root | localhost:54894 | nova | Sleep | 8 | |
| 0.000 |
| 2433 | root | localhost:54895 | nova | Sleep | 18 | |
| 0.000 |
| 2434 | root | localhost:54896 | nova | Sleep | 8 | |
| 0.000 |
| 2435 | root | localhost:54905 | keystone | Sleep | 6 | |
| 0.000 |
| 2436 | root | localhost:54908 | nova | Sleep | 6 | |
| 0.000 |
| 2437 | root | localhost:54909 | nova | Sleep | 5 | |
| 0.000 |
| 2438 | root | localhost:54910 | nova | Sleep | 5 | |
| 0.000 |
| 2439 | root | localhost:54911 | nova | Sleep | 3 | |
| 0.000 |
| 2440 | root | localhost:54912 | nova | Sleep | 12 | |
| 0.000 |
| 2441 | root | localhost:54913 | nova | Sleep | 18 | |
| 0.000 |
| 2442 | root | localhost:54914 | nova | Sleep | 2 | |
| 0.000 |
| 2443 | root | localhost:54915 | nova | Sleep | 1 | |
| 0.000 |
| 2444 | root | localhost:54916 | nova | Sleep | 9 | |
| 0.000 |
| 2445 | root | localhost:54920 | nova | Sleep | 8 | |
| 0.000 |
| 2446 | root | localhost:54924 | nova | Sleep | 16 | |
| 0.000 |
| 2447 | root | localhost:54925 | nova | Sleep | 15 | |
| 0.000 |
| 2448 | root | localhost:54926 | nova | Sleep | 15 | |
| 0.000 |
| 2449 | root | localhost:54927 | nova | Sleep | 5 | |
| 0.000 |
| 2450 | root | localhost:54928 | nova | Sleep | 5 | |
| 0.000 |
| 2451 | root | localhost:54929 | nova | Sleep | 11 | |
| 0.000 |
| 2452 | root | localhost:54930 | nova | Sleep | 3 | |
| 0.000 |
| 2453 | root | localhost:54931 | nova | Sleep | 12 | |
| 0.000 |
| 2454 | root | localhost:54932 | nova | Sleep | 2 | |
| 0.000 |
| 2455 | root | localhost:54933 | nova | Sleep | 2 | |
| 0.000 |
| 2456 | root | localhost:54960 | nova | Sleep | 1 | |
| 0.000 |
| 2457 | root | localhost:54982 | nova | Sleep | 18 | |
| 0.000 |
| 2458 | root | localhost:55002 | nova | Sleep | 5 | |
| 0.000 |
| 2459 | root | localhost:55003 | nova | Sleep | 5 | |
| 0.000 |
| 2460 | root | localhost:55004 | nova | Sleep | 5 | |
| 0.000 |
| 2461 | root | localhost:55005 | nova | Sleep | 15 | |
| 0.000 |
| 2462 | root | localhost:55006 | nova | Sleep | 5 | |
| 0.000 |
| 2463 | root | localhost:55007 | nova | Sleep | 14 | |
| 0.000 |
| 2464 | root | localhost:55008 | nova | Sleep | 3 | |
| 0.000 |
| 2465 | root | localhost:55009 | nova | Sleep | 3 | |
| 0.000 |
| 2466 | root | localhost:55011 | nova | Sleep | 12 | |
| 0.000 |
| 2467 | root | localhost:55014 | nova | Sleep | 9 | |
| 0.000 |
| 2468 | root | localhost:55022 | nova | Sleep | 15 | |
| 0.000 |
| 2469 | root | localhost:55023 | nova | Sleep | 15 | |
| 0.000 |
| 2470 | root | localhost:55024 | nova | Sleep | 15 | |
| 0.000 |
| 2471 | root | localhost:55025 | nova | Sleep | 2 | |
| 0.000 |
| 2472 | root | localhost:55026 | nova | Sleep | 13 | |
| 0.000 |
| 2473 | root | localhost:55029 | nova | Sleep | 2 | |
| 0.000 |
| 2474 | root | localhost:55030 | nova | Sleep | 15 | |
| 0.000 |
| 2475 | root | localhost:55031 | nova | Sleep | 5 | |
| 0.000 |
| 2476 | root | localhost:55032 | nova | Sleep | 5 | |
| 0.000 |
| 2477 | root | localhost:55033 | nova | Sleep | 15 | |
| 0.000 |
| 2478 | root | localhost:55034 | nova | Sleep | 12 | |
| 0.000 |
| 2479 | root | localhost:55048 | keystone | Sleep | 7 | |
| 0.000 |
| 2480 | root | localhost:55070 | nova | Sleep | 5 | |
| 0.000 |
| 2481 | root | localhost:55077 | keystone | Sleep | 25 | |
| 0.000 |
| 2482 | root | localhost:55287 | nova | Sleep | 27 | |
| 0.000 |
| 2483 | root | localhost:55288 | nova | Sleep | 27 | |
| 0.000 |
| 2484 | root | localhost:55353 | nova | Sleep | 26 | |
| 0.000 |
| 2485 | root | localhost:55354 | nova | Sleep | 26 | |
| 0.000 |
| 2486 | root | localhost:55365 | nova | Sleep | 28 | |
| 0.000 |
| 2487 | root | localhost:55369 | nova | Sleep | 28 | |
| 0.000 |
| 2488 | root | localhost:55372 | nova | Sleep | 27 | |
| 0.000 |
| 2489 | root | localhost:55375 | nova | Sleep | 27 | |
| 0.000 |
| 2490 | root | localhost:55380 | nova | Sleep | 26 | |
| 0.000 |
| 2491 | root | localhost:55382 | nova | Sleep | 26 | |
| 0.000 |
| 2492 | root | localhost:55401 | nova | Sleep | 26 | |
| 0.000 |
| 2493 | root | localhost:55402 | nova | Sleep | 27 | |
| 0.000 |
| 2494 | root | localhost:55541 | keystone | Sleep | 59 | |
| 0.000 |
| 2495 | root | localhost:55571 | keystone | Sleep | 57 | |
| 0.000 |
| 2496 | root | localhost:55579 | nova | Sleep | 27 | |
| 0.000 |
| 2497 | root | localhost:55580 | nova | Sleep | 27 | |
| 0.000 |
| 2498 | root | localhost:55590 | nova | Sleep | 25 | |
| 0.000 |
| 2499 | root | localhost:55606 | nova | Sleep | 25 | |
| 0.000 |
| 2500 | root | localhost:55637 | nova | Sleep | 27 | |
| 0.000 |
| 2501 | root | localhost:55638 | nova | Sleep | 27 | |
| 0.000 |
| 2502 | root | localhost:55684 | nova | Sleep | 27 | |
| 0.000 |
| 2503 | root | localhost:55685 | nova | Sleep | 27 | |
| 0.000 |
| 2504 | root | localhost:55693 | nova | Sleep | 27 | |
| 0.000 |
| 2505 | root | localhost:55695 | nova | Sleep | 27 | |
| 0.000 |
| 2506 | root | localhost:55696 | nova | Sleep | 157 | |
| 0.000 |
| 2507 | root | localhost:55698 | nova | Sleep | 25 | |
| 0.000 |
| 2508 | root | localhost:55703 | nova | Sleep | 24 | |
| 0.000 |
| 2509 | root | localhost:55750 | nova | Sleep | 59 | |
| 0.000 |
| 2510 | root | localhost:55765 | glance | Sleep | 487 | |
| 0.000 |
| 2511 | root | localhost:55773 | keystone | Sleep | 26 | |
| 0.000 |
| 2512 | root | localhost:55827 | nova | Sleep | 28 | |
| 0.000 |
| 2513 | root | localhost:55828 | nova | Sleep | 28 | |
| 0.000 |
| 2514 | root | localhost:55834 | nova | Sleep | 26 | |
| 0.000 |
| 2515 | root | localhost:55835 | nova | Sleep | 26 | |
| 0.000 |
| 2516 | root | localhost:55837 | nova | Sleep | 60 | |
| 0.000 |
| 2517 | root | localhost:55838 | nova | Sleep | 60 | |
| 0.000 |
| 2518 | root | localhost:55845 | nova | Sleep | 26 | |
| 0.000 |
| 2519 | root | localhost:55846 | nova | Sleep | 26 | |
| 0.000 |
| 2520 | root | localhost:55849 | nova | Sleep | 26 | |
| 0.000 |
| 2521 | root | localhost:55858 | nova | Sleep | 24 | |
| 0.000 |
| 2522 | root | localhost:55863 | keystone | Sleep | 7 | |
| 0.000 |
| 2523 | root | localhost:55867 | nova | Sleep | 25 | |
| 0.000 |
| 2524 | root | localhost:55893 | keystone | Sleep | 26 | |
| 0.000 |
| 2525 | root | localhost:55902 | nova | Sleep | 27 | |
| 0.000 |
| 2526 | root | localhost:55903 | nova | Sleep | 27 | |
| 0.000 |
| 2527 | root | localhost:55935 | nova | Sleep | 59 | |
| 0.000 |
| 2528 | root | localhost:56026 | nova | Sleep | 37 | |
| 0.000 |
| 2529 | root | localhost:56035 | nova | Sleep | 25 | |
| 0.000 |
| 2530 | root | localhost:56073 | nova | Sleep | 26 | |
| 0.000 |
| 2531 | root | localhost:56134 | nova | Sleep | 25 | |
| 0.000 |
| 2532 | root | localhost:56191 | nova | Sleep | 120 | |
| 0.000 |
| 2533 | root | localhost:56223 | glance | Sleep | 277 | |
| 0.000 |
| 2534 | root | localhost:56268 | nova | Sleep | 7 | |
| 0.000 |
| 2535 | root | localhost:56280 | nova | Sleep | 58 | |
| 0.000 |
| 2536 | root | localhost:56288 | glance | Sleep | 37 | |
| 0.000 |
| 2537 | root | localhost:56308 | nova | Sleep | 25 | |
| 0.000 |
| 2538 | root | localhost:56337 | nova | Sleep | 27 | |
| 0.000 |
| 2539 | root | localhost:56338 | nova | Sleep | 27 | |
| 0.000 |
| 2540 | root | localhost:56406 | nova | Sleep | 188 | |
| 0.000 |
| 2541 | root | localhost:56419 | nova | Sleep | 24 | |
| 0.000 |
| 2542 | root | localhost:56466 | nova | Sleep | 25 | |
| 0.000 |
| 2543 | root | localhost:56557 | glance | Sleep | 127 | |
| 0.000 |
| 2544 | root | localhost:56591 | nova | Sleep | 7 | |
| 0.000 |
| 2545 | root | localhost:56596 | nova | Sleep | 7 | |
| 0.000 |
| 2546 | root | localhost:56609 | heat | Sleep | 120 | |
| 0.000 |
| 2547 | root | localhost:56610 | heat | Sleep | 120 | |
| 0.000 |
| 2548 | root | localhost:56614 | nova | Sleep | 92 | |
| 0.000 |
| 2549 | root | localhost:56621 | nova | Sleep | 58 | |
| 0.000 |
| 2550 | root | localhost:56642 | heat | Sleep | 92 | |
| 0.000 |
| 2551 | root | localhost:56643 | heat | Sleep | 92 | |
| 0.000 |
| 2552 | root | localhost:56659 | heat | Sleep | 89 | |
| 0.000 |
| 2553 | root | localhost:56660 | heat | Sleep | 89 | |
| 0.000 |
| 2554 | root | localhost:56686 | glance | Sleep | 67 | |
| 0.000 |
| 2556 | root | localhost:56712 | heat | Sleep | 59 | |
| 0.000 |
| 2557 | root | localhost:56713 | heat | Sleep | 59 | |
| 0.000 |
| 2558 | root | localhost:56731 | heat | Sleep | 58 | |
| 0.000 |
| 2559 | root | localhost:56732 | heat | Sleep | 58 | |
| 0.000 |
| 2561 | root | localhost:56806 | heat | Sleep | 26 | |
| 0.000 |
| 2562 | root | localhost:56807 | heat | Sleep | 26 | |
| 0.000 |
| 2563 | root | localhost:56864 | glance | Sleep | 6 | |
| 0.000 |
| 2564 | root | localhost:56865 | | Query | 0 | |
show processlist | 0.000 |
+------+------+-----------------+----------+---------+------+-------+------------------+----------+
Regards,
Qiming
More information about the OpenStack-dev
mailing list