Also Read: MariaDB administration commands for beginners. Before we make changes to increase the number of mysql connections, we will check the current number of configured mysql connections.
To check it, connect to mysql from your terminal,. This will bring the max number of connections configured on the screen as output. To do so , run the following command from mysql terminal only,. Our maximum mysql connections value has now been increased to but its for the current session only.
As soon as we restart the mysql service or restart the system, this value will reset to default. To increase the number of mysql connections permanently, we need to edit the mysql configuration file I. Available anywhere. Use the command:. SHOW variables;. Update my. Directly beneath the first line:. Add a line:. Save and exit the file. Start your website quickly and benefit from the most secure and up-to-date version of WordPress!
Related products. View packages. John Maver John Maver is a champion for building customer-centric social communities, with a focus on nurturing strong brand advocates. Find me on:. Follow us:. Enjoy this article? Don't forget to share. Interested in Working With Us?
0コメント