- Trending Categories
Data Structure
Networking
RDBMS
Operating System
Java
iOS
HTML
CSS
Android
Python
C Programming
C++
C#
MongoDB
MySQL
Javascript
PHP
- Selected Reading
- UPSC IAS Exams Notes
- Developer's Best Practices
- Questions and Answers
- Effective Resume Writing
- HR Interview Questions
- Computer Glossary
- Who is Who
How to set max_connections in MySQL Programmatically?
To set max_connections in MySQL programmatically, you can use SET command. The syntax is as follows −
SET GLOBAL max_connections=yourIntegerValue;
Let us implement the above query to set maximum connections. The query is as follows −
mysql> set global max_connections=1000; Query OK, 0 rows affected (0.04 sec)
Check maximum connections are set or not, using the show variables command. The query is as follows.
mysql> show variables like 'max_connections';
The following is the output.
+-----------------+-------+ | Variable_name | Value | +-----------------+-------+ | max_connections | 1000 | +-----------------+-------+ 1 row in set (0.18 sec)
Updated on 29-Jun-2020 08:57:05
- Related Questions & Answers
- How to set Wallpaper Image programmatically in Android?
- How to set background drawable programmatically in android?
- How to set locale programmatically in android app?
- Restricting MySQL Connections to Secure Transport
- How to programmatically set drawableLeft on Android button?
- How to set margins in an Android LinearLayout programmatically?
- How to set the Android wallpaper image programmatically in Kotlin
- How to set margins in an Android LinearLayout programmatically using Kotlin?
- Sorting max to min value in MySQL
- How to set the layout weight of a textview programmatically in Android?
- How to set the margin of ImageView programmatically in Android using Kotlin ?
- How to programmatically set drawableLeft on the Android button using Kotlin?
- Set max on MongoDB capped collection?
- How to get max(id) of row data in MySQL?
- How to get the max of two values MySQL?
Advertisements