Skip to main content


Showing posts from May, 2019

Increase MySQL/MariaDB max_connections online (without a restart)

MySQL/MariaDB makes DBA's life much easier by allowing to increase the number of max_connections.

You can use SHOW VARIABLE LIKE'max_connections'; to check the number of max connections allowed.

mysql> SHOW VARIABLE LIKE 'max_connections';
| Variable_name   | Value |
| max_connections | 151   |
1 row in set (0.01 sec)

You might want to see how many connections you have in your database right now. You can use the below query to check that.

mysql> SELECT COUNT(1) FROM information_schema.processlist;
| COUNT(1) |
|      100 |
1 row in set (0.00 sec)

Let's assume, we need to increase maximum connections allowed to 250. Please run below query.

mysql> SET GLOBAL max_connections = 250;
Query OK, 0 rows affected (0.00 sec)

You can verify the change by running SHOW VARIABLE LIKE 'max_connections';

mysql> SHOW VARIABLE LIKE 'max_connections…

The other side

Porto is a city with a vibrant culture. When you see blue tiled walls, you know that you are in Portugal. This river has few Port wine cellars. Don't forget to taste Port wine if you happen to visit Porto.

Location: Luís I Bridge, Porto, Portugal

Sunset in 2014

This photo was taken in 2014 by me. As I reckon we were on a trip to Sigiriya. Good old days!
Location: Ibbankatuwa Wewa, Dambulla, Sri Lanka

Plan and Dine

(Location: Mazel Tov Restaurant, Budapest, Hungary)

Call it a day!

One of the best places, you can spend an evening in Prague. (Location: Vyšehrad)