How do you start multiple processes of MySQL?
I am having problems with the major application on my server filling up the pool of mysql connections. I have just moved my production environment to a new server.
I noticed that my previous server started 4 processes of mysql. My new one only starts one. I would assume that my previous server was providing 4X the number of available connections as does the new one.
I would like to see whether more processes would solve my problem rather than adjusting mysql's TTL for connections. How do I get the system to start multiple processes?