Rocky upgrade open db connections
ActivePublic
Actions

Authored by • JHedden on Apr 16 2020, 4:10 PM.

Tags

None

Referenced Files

	F31759766: raw.txt
	Apr 16 2020, 4:12 PM

	F31759764: raw.txt
	Apr 16 2020, 4:10 PM

Subscribers

None

	select user, db, SUBSTRING_INDEX(host,':',1) as host, count(*) from information_schema.processlist group by user, db, SUBSTRING_INDEX(host,':',1);
	+-----------------+--------------------+----------------+----------+
	\| user \| db \| host \| count(*) \|
	+-----------------+--------------------+----------------+----------+
	\| designate \| designate \| 208.80.154.11 \| 11 \|
	\| designate \| designate \| 208.80.154.135 \| 11 \|
	\| glance \| glance \| 208.80.154.23 \| 4 \|
	\| keystone \| keystone \| 208.80.154.23 \| 10 \|
	\| neutron \| neutron \| 208.80.154.132 \| 37 \|
	\| neutron \| neutron \| 208.80.154.23 \| 42 \|
	\| nova \| nova_api_eqiad1 \| 208.80.154.132 \| 15 \|
	\| nova \| nova_api_eqiad1 \| 208.80.154.23 \| 17 \|
	\| nova \| nova_cell0_eqiad1 \| 208.80.154.132 \| 4 \|
	\| nova \| nova_cell0_eqiad1 \| 208.80.154.23 \| 4 \|
	\| nova \| nova_eqiad1 \| 208.80.154.132 \| 31 \|
	\| nova \| nova_eqiad1 \| 208.80.154.23 \| 39 \|
	+-----------------+--------------------+----------------+----------+

Event Timeline

• JHedden changed the title of this paste from Rocky upgrade nova db connections to Rocky upgrade open db connections.Apr 16 2020, 4:12 PM

• JHedden edited the content of this paste. (Show Details)

	select user, db, SUBSTRING_INDEX(host,':',1) as host, count(*) from information_schema.processlist group by user, db, SUBSTRING_INDEX(host,':',1);
	+-----------------+--------------------+----------------+----------+
	\| user \| db \| host \| count(*) \|
	+-----------------+--------------------+----------------+----------+
	\| designate \| designate \| 208.80.154.11 \| 11 \|
	\| designate \| designate \| 208.80.154.135 \| 11 \|
	\| glance \| glance \| 208.80.154.23 \| 4 \|
	\| keystone \| keystone \| 208.80.154.23 \| 10 \|
	\| neutron \| neutron \| 208.80.154.132 \| 37 \|
	\| neutron \| neutron \| 208.80.154.23 \| 42 \|
	\| nova \| nova_api_eqiad1 \| 208.80.154.132 \| 15 \|
	\| nova \| nova_api_eqiad1 \| 208.80.154.23 \| 17 \|
	\| nova \| nova_cell0_eqiad1 \| 208.80.154.132 \| 4 \|
	\| nova \| nova_cell0_eqiad1 \| 208.80.154.23 \| 4 \|
	\| nova \| nova_eqiad1 \| 208.80.154.132 \| 31 \|
	\| nova \| nova_eqiad1 \| 208.80.154.23 \| 39 \|
	+-----------------+--------------------+----------------+----------+