> 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 __________________________________________________________________________ OpenStack Development Mailing List (not for usage questions) Unsubscribe: openstack-dev-requ...@lists.openstack.org?subject:unsubscribe http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack-dev
