Max Connections

Overview

Max Connections are optimized on MariaDB SkySQL on a per-service and per-instance-size basis to permit a specific number of concurrent database connections.

Max Connections settings are not customer-tunable through SkySQL Configuration Manager. SkySQL Power Tier customers can contact us to discuss custom tuning requirements.

Stated values are as configured on each server within the service.

Instance Size

Single Node Transactions

Replicated Transactions

Distributed Transactions

Single Node Analytics

Multi-Node Analytics

Sky-2x4

480

480

N/A

N/A

N/A

Sky-2x8

480

480

N/A

N/A

N/A

Sky-4x15

900

900

900

N/A

N/A

Sky-4x16

900

900

900

900

900

Sky-4x26

900

900

900

900

900

Sky-4x32

900

900

900

900

900

Sky-8x30

900

900

900

900

900

Sky-8x32

900

900

900

900

900

Sky-8x52

1200

1200

1200

1200

1200

Sky-8x64

1200

1200

1200

1200

1200

Sky-16x60

1200

1200

1200

1200

1200

Sky-16x64

1200

1200

1200

1200

1200

Sky-16x104

2400

2400

2400

2400

2400

Sky-16x128

2400

2400

2400

2400

2400

Sky-32x120

2400

2400

2400

2400

2400

Sky-32x128

2400

2400

2400

2400

2400

Sky-32x208

2400

2400

2400

2400

2400

Sky-32x256

2400

2400

2400

2400

2400

Sky-64x240

2400

2400

N/A

2400

2400

Sky-64x256

2400

2400

2400

2400

2400

Sky-64x416

2400

2400

N/A

2400

2400

Sky-64x512

2400

2400

2400

2400

2400

Custom

varies

varies

varies

varies

varies

For additional information on Max Connections with Distributed Transactions, see "Max Connection Tuning with MariaDB Xpand".

For additional information on Max Connections with all other topologies, see "Max Connection Tuning with MariaDB Enterprise Server".