Ask Your Question

jeff's profile - activity

2016-08-23 02:32:26 -0500 received badge  Popular Question (source)
2016-08-23 02:32:26 -0500 received badge  Famous Question (source)
2016-08-23 02:32:26 -0500 received badge  Notable Question (source)
2016-05-02 18:15:00 -0500 commented answer mariadb max_open_files

thanks for the reply ...that was it :)

2016-05-02 18:07:59 -0500 received badge  Supporter (source)
2016-05-02 18:07:58 -0500 received badge  Scholar (source)
2016-04-27 00:30:10 -0500 received badge  Enthusiast
2016-04-26 11:19:10 -0500 asked a question mariadb max_open_files

any experts in mysql here with centos?

for the life of me i cannot increase the number of max open files for mariadb/mqsql past 1024. i am running centos 7.1 liberty release of openstack deployed via packstack/rdo.

during boot, mariadb complains: 160426 5:43:58 [Warning] Could not increase number of max_open_files to more than 1024 (request: 10811)

as the number of db connections increases past 1024 in my openstack cloud i get this in log files and openstack services start failing...

[ERROR] Error in accept: Too many open files

in /etc/my.conf:

[mysqld]

open_files_limit = 10000

max_connections = 10000

[mysqld_safe]

open_files_limit = 10000

max_connections = 10000

in /etc/security/limits.conf (that's an asterisk not a bullet point)

  • hard nofile 65536

  • soft nofile 16384

  • soft nproc 10240

  • hard nproc 10240

in /etc/systemd/system/mariadb.service.d/limits.conf

[Service]

LimitNOFILE=30000 LimitNPROC=65535 max_connections=10000 open_files_limit=10000 LimitMEMLOCK=infinity

in /usr/lib/systemd/system/mariadb.service

[Service]

LimitNOFILE=10000

LimitMEMLOCK=infinity

max_connections=10000

LimitNPROC=65535

also:

su mysql --shell /bin/bash --command "ulimit -n"

10000

any ideas appreciated to increase num of open file.

gracias

2013-07-06 20:44:49 -0500 received badge  Nice Question (source)
2013-07-06 20:39:25 -0500 received badge  Famous Question (source)
2013-05-30 05:55:10 -0500 received badge  Notable Question (source)
2013-05-30 05:48:12 -0500 received badge  Student (source)
2013-05-30 02:25:04 -0500 received badge  Popular Question (source)
2013-05-25 04:44:29 -0500 asked a question devstack external net with linux bridge

hi - i trying to build an all-in-one devstack with linux bridge (later i will add additional compute nodes). i have 3 physical nics, one for mgmt(eth0), one for private tenant nets(eth1), and one for external access/floating range(eth2). i would like my external network to be on eth2, but i'm not sure what to put into the localrc to make this work. it seems to always end up on eth1 (which is for my tenant networks). i have tried PUBLIC_INTERFACE=eth2...

NOVA_BRANCH=stable/grizzly
CINDER_BRANCH=stable/grizzly
GLANCE_BRANCH=stable/grizzly
HORIZON_BRANCH=stable/grizzly
KEYSTONE_BRANCH=stable/grizzly
QUANTUM_BRANCH=stable/grizzly

disable_service n-net
enable_service q-svc
enable_service q-agt
enable_service q-dhcp
enable_service q-l3
enable_service q-meta
enable_service quantum

SWIFT_HASH=66a3d6b56c1f479c8b4e70ab5c2000f5
SWIFT_REPLICAS=1

KEYSTONE_CATALOG_BACKEND=sql

DATABASE_PASSWORD=openstack
ADMIN_PASSWORD=openstack
RABBIT_PASSWORD=openstack
SERVICE_PASSWORD=openstack
SERVICE_TOKEN=openstack
MYSQL_PASSWORD=openstack

Q_PLUGIN="linuxbridge"

PUBLIC_INTERFACE=eth2
FLOATING_RANGE=192.168.10.0/24
FIXED_RANGE=10.1.1.0/24
FIXED_NETWORK_SIZE=256
NETWORK_GATEWAY=10.1.1.1

ENABLE_TENANT_VLANS="True"
PHYSICAL_NETWORK="phys1"
TENANT_VLAN_RANGE=800:900
LB_PHYSICAL_INTERFACE=eth1

LOG=True
LOGFILE=stack.sh.log
LOGDAYS=1

HOST_IP=10.17.88.87

SERVICE_HOST=10.17.88.87
MYSQL_HOST=$SERVICE_HOST
RABBIT_HOST=$SERVICE_HOST
GLANCE_HOSTPORT=$SERVICE_HOST:9292
KEYSTONE_AUTH_HOST=$SERVICE_HOST
KEYSTONE_SERVICE_HOST=$SERVICE_HOST

devstack creates a public & private net:

$ quantum net-list
+--------------------------------------+---------+------------------------------------------------------+
| id                                   | name    | subnets                                              |
+--------------------------------------+---------+------------------------------------------------------+
| 1107cb11-c2ba-4293-98d5-e80788df6366 | private | f82a477d-dbd5-4f23-a162-eccd9f871b53 10.1.1.0/24     |
| 91323327-adf2-46d4-9050-993261c7fcc6 | public  | 395141d3-cb59-4145-a141-56849098bc29 192.168.10.0/24 |

.

$ brctl show
bridge name     bridge id               STP enabled     interfaces
brq1107cb11-c2          8000.0019999ba003       no              eth1.800
                                                        tap1d462c35-7d
                                                        tape155ca28-21
brq91323327-ad          8000.0019999ba003       no              eth1.801
                                                        tapab9e5efa-4f
virbr0          8000.000000000000       yes

.

$ sudo ip netns exec qrouter-7591ad8f-2003-46b8-b004-91683f6c0be9 ifconfig
qg-ab9e5efa-4f Link encap:Ethernet  HWaddr fa:16:3e:b5:87:e2
          inet addr:192.168.10.2  Bcast:192.168.10.255  Mask:255.255.255.0
qr-e155ca28-21 Link encap:Ethernet  HWaddr fa:16:3e:7c:de:f5
          inet addr:10.1.1.1  Bcast:10.1.1.255  Mask:255.255.255.0

$ sudo ip netns exec qdhcp-1107cb11-c2ba-4293-98d5-e80788df6366 ifconfig
ns-1d462c35-7d Link encap:Ethernet  HWaddr fa:16:3e:a8:7d:af
          inet addr:10.1.1.2  Bcast:10.1.1.255  Mask:255.255.255.0

any suggestions appreciated. All 3 of my interfaces are plumbed up with only the mgmt having an IP address (eth1 & 2 are in promisc mode). thanks.