Increase max database connections

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
Caribouhill
Forum Newbie
Posts: 1
Joined: Tue Feb 22, 2022 5:41 am

Increase max database connections

Post by Caribouhill »

I've been working on a website for 2.5 years in my free time, starting from zero programming experience & now I'm somewhat satisfied enough to start up the website.

But I have encountered an issue I cannot seem to find an easy solution for.
The max TCP port range is screwing me over when I want to have a bunch of connections to both local & LAN mysql databases - since each connection uses 1 port. I don't want to be limited to 65535 connections.

I've read that mysql got a shared memory protocol.
Which I think would be the solution for the local database but I cannot seem to find a way to use that in php.

If I could get that to work, I can move on to setting up the LAN mysql databases being each connected to from 5 different internet cables.
Which will stack up the max amount of connections since each of those IP addresses have about 65535 free ports.

My questions are -
1. How can I make a shared memory connection between php & mysql?
2. Is there any better ways I could connect to either of the local & LAN mysql databases?
User avatar
Benjamin
Site Administrator
Posts: 6930
Joined: Sun May 19, 2002 10:24 pm

Re: Increase max database connections

Post by Benjamin »

I don't understand why you would ever need that many simultaneous connections. Even 1000 would be a lot for a high traffic site.
Post Reply