Under, you can increase your maximum MySQL connections by changing the max_connections attribute to something like this. There will be a section that looks like this: (may be slightly different) Connect to the server via SSH as root or sudo user, and type this: vi /etc/my.cnf To increase the maximum connections that MySQL allows, you must edit the file /etc/my.cnf. The three different sizes offered are 60, 100, and 150 concurrent connections respectively.įor more information on the MySQL GridContainer, please see our Grid product page. It is possible to upgrade your concurrent MySQL connections by adding a MySQL GridContainer to your Grid hosting package. For more information on what Advanced Support can do for you, please click here. Our expert engineers can tweak and tune your server for optimal performance. If you're having trouble with the steps in this article, additional assistance is available via Advanced Support, our premium services division. How do I disable SSH login for the root user?.You must have SSH access set up for root or a sudo user.Requirementsīefore you start, this article has the following dependencies: If you need to support more connections, you should set a larger value for this variable. The number of connections permitted is controlled by the max_connections system variable. If you get a Too many connections error when you try to connect to the mysqld server, this means that all available connections are in use by other clients. The MySQL SmartPool v.2 for the Grid comes with 30 MySQL connections.
0 kommentar(er)
