[Openstack-operators] Ops Meetups Team - Meeting Tuesday 1400 UTC

[Tom Fifield]

Hi all,

We're up for a meeting:

Tuesday, 31 of May at 1400 UTC [1]


It's going to be an interesting one - it's a US holiday on the 30th, so 
people might not remember that they have this very important meeting 
first thing back! We'll see if it's necessary to postpone based on how 
many show up :)



Anyway, let's meet in IRC[2], in the #openstack-operators channel.


Details about the group, and the link to the agenda etherpad, can be 
found at:


https://wiki.openstack.org/wiki/Ops_Meetups_Team#Meeting_Information



Regards,


Tom


[1] To see this in your local time - check: 
http://www.timeanddate.com/worldclock/fixedtime.html?msg=Ops+Meetups+Team=20160531T22=241


[2] If you're new to IRC, there's a great guide here: 
http://docs.openstack.org/upstream-training/irc.html



___
OpenStack-operators mailing list
OpenStack-operators@lists.openstack.org
http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack-operators

___
OpenStack-operators mailing list
OpenStack-operators@lists.openstack.org
http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack-operators

Re: [Openstack-operators] Too many connections

[Clint Byrum]

Excerpts from Kris G. Lindgren's message of 2016-05-30 15:33:49 +:
> You are most likely running db pools with a number of worker processes.  If 
> you look at the MySQL connections most of them will be idle.  If that's the 
> case set the db pool timeout lower.  Lower the pool size down.  Each worker 
> thread opens a connection pool to the database.  If you are running 10 
> workers with a min db pool size of 5 and a max of 10.  You will have a 
> minimum number of 50 db connections, max 100, per server running that service.
> 
> 
> I would be looking at: pool_timeout, min_pool_size, max_pool_size
> 
> http://docs.openstack.org/developer/oslo.db/opts.html
> 

This is great information Kris.

It's also worth noting that MySQL connections that are idle eat up very
little RAM and so you can probably bump it up a bit.

The setting for that is max_connections:

https://dev.mysql.com/doc/refman/5.6/en/server-system-variables.html#sysvar_max_connections

The default of 151 is pretty conservative. You can probably safely raise
it to 400 on anything but the most memory constrained MySQL server.

> 
> On May 30, 2016, at 9:24 AM, Fran Barrera 
> > wrote:
> 
> Hi,
> 
> I'm using Mitaka on ubuntu 16.04 and I have many problems in horizon. I can 
> see this in the logs of all components: "OperationalError: 
> (pymysql.err.OperationalError) (1040, u'Too many connections')" If I increase 
> the max_connections on mysql works well a few minutes but the same error. 
> Maybe Openstack don't close connections with Mysql. The version of Mysql is 
> 5.7.
> 
> Any suggestions?
> 
> Regards,
> Fran

___
OpenStack-operators mailing list
OpenStack-operators@lists.openstack.org
http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack-operators

[Openstack-operators] nova-compute-lxd on kilo / trusty

[Gustavo Randich]

Hi,

Is it possible to install nova-compute-lxd with Kilo and Trusty?

Thanks!
___
OpenStack-operators mailing list
OpenStack-operators@lists.openstack.org
http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack-operators

Re: [Openstack-operators] Too many connections

[Kris G. Lindgren]

You are most likely running db pools with a number of worker processes.  If you 
look at the MySQL connections most of them will be idle.  If that's the case 
set the db pool timeout lower.  Lower the pool size down.  Each worker thread 
opens a connection pool to the database.  If you are running 10 workers with a 
min db pool size of 5 and a max of 10.  You will have a minimum number of 50 db 
connections, max 100, per server running that service.


I would be looking at: pool_timeout, min_pool_size, max_pool_size

http://docs.openstack.org/developer/oslo.db/opts.html


On May 30, 2016, at 9:24 AM, Fran Barrera 
> wrote:

Hi,

I'm using Mitaka on ubuntu 16.04 and I have many problems in horizon. I can see 
this in the logs of all components: "OperationalError: 
(pymysql.err.OperationalError) (1040, u'Too many connections')" If I increase 
the max_connections on mysql works well a few minutes but the same error. Maybe 
Openstack don't close connections with Mysql. The version of Mysql is 5.7.

Any suggestions?

Regards,
Fran
___
OpenStack-operators mailing list
OpenStack-operators@lists.openstack.org
http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack-operators
___
OpenStack-operators mailing list
OpenStack-operators@lists.openstack.org
http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack-operators

[Openstack-operators] Too many connections

[Fran Barrera]

Hi,

I'm using Mitaka on ubuntu 16.04 and I have many problems in horizon. I can
see this in the logs of all components: "OperationalError:
(pymysql.err.OperationalError) (1040, u'Too many connections')" If I
increase the max_connections on mysql works well a few minutes but the same
error. Maybe Openstack don't close connections with Mysql. The version of
Mysql is 5.7.

Any suggestions?

Regards,
Fran
___
OpenStack-operators mailing list
OpenStack-operators@lists.openstack.org
http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack-operators

[Openstack-operators] Problem in using ide disk_type and virtio network interface

[shiva m]

Hi,

I have an image with /dev/sda partitions (IDE disk type) and virtio network
interfaces. I loaded my image on Openstack  with followign command.

glance image-create --name  --disk-format qcow2
--container-format bare --property hw_disk_bus=ide --property
hw_vif_model=virtio --is-public True --file 


I am able to launch the instane from this image but my network interfaces
are not coming up.

if I do lspci, I can see network interfaces are of type *virtio*


Can anyone please help in this regard. Am I missing anything.


Thanks,
Shiva
___
OpenStack-operators mailing list
OpenStack-operators@lists.openstack.org
http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack-operators

Re: [Openstack-operators] Fwd: [openstack-dev] [nova] I'm going to expire open bug reports older than 18 months.

[Vincent Legoll]

I'm open for suggestions to make this sound better. Thanks for this
feedback.


That's OK for me, +1 on the other comments in the thread.

--
Vincent Legoll
EGI FedCloud task force
Cloud Computing at IdGC
France Grilles / CNRS / IPHC

___
OpenStack-operators mailing list
OpenStack-operators@lists.openstack.org
http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack-operators