- Trending Categories
Data Structure
Networking
RDBMS
Operating System
Java
iOS
HTML
CSS
Android
Python
C Programming
C++
C#
MongoDB
MySQL
Javascript
PHP
Physics
Chemistry
Biology
Mathematics
English
Economics
Psychology
Social Studies
Fashion Studies
Legal Studies
- 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)
- Related Articles
- How to set background drawable programmatically in android?
- How to set locale programmatically in android app?
- How to set Wallpaper Image programmatically in Android?
- How to set margins in an Android LinearLayout programmatically?
- How to programmatically set drawableLeft on Android button?
- How to set the Android wallpaper image programmatically in Kotlin
- How to set margins in an Android LinearLayout programmatically using Kotlin?
- 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?
- How to set the layout weight of a TextView programmatically in Android using Kotlin?
- How to programmatically set the value of a select box element using JavaScript?
- How to set sql_mode permanently in MySQL?
- How can I set an ImageView's width and height programmatically in Android?
- How to set default Field Value in MySQL?

Advertisements