I'm writing a client-server program. There are more than 500 clients. I start a thread to process and response to each client and the processing needs some MySQL query. I'm looking for any possible hazards on my server!
1- Any limitation on "Maximum Simultaneous Socket Connection"?
2- Any limitation on using mysql?
3- As socket on Linux are file, Any limitation on number of sockets or threads?
I'm using a Linux server (Centos or Fedora or Ubuntu) and clients are both Linux and Windows.
Any answer is appreciated