Hi !
Last evening my mysql database "crashed", it wasn't really a crash because the 3 deamons were still running this morning but no connection was possible.
This "crash" happened when the max of request of the day was reached on the website, so I suppose it's because the pool of connection is too small.
I know I can increase the max_connections parameter but I don't really manage to estimate the consequences. I've read something like this in the forum to calculate the memory used by mysql... but I admit I'm new in all this things ... could someone help me ?
- I've got two servers in "load-balancing"
- all mysql parameters have their default values
- RAM of each server : 512 Mo
- OS : Linux 6.2
- 3 deamons are launched at mysql start
(Can someone tell me why is it three and were it's fixed ? If I increase this number will it improve something ?)
Thank you in advance and sorry for my poor english !
Sophie
Last evening my mysql database "crashed", it wasn't really a crash because the 3 deamons were still running this morning but no connection was possible.
This "crash" happened when the max of request of the day was reached on the website, so I suppose it's because the pool of connection is too small.
I know I can increase the max_connections parameter but I don't really manage to estimate the consequences. I've read something like this in the forum to calculate the memory used by mysql... but I admit I'm new in all this things ... could someone help me ?
- I've got two servers in "load-balancing"
- all mysql parameters have their default values
- RAM of each server : 512 Mo
- OS : Linux 6.2
- 3 deamons are launched at mysql start
(Can someone tell me why is it three and were it's fixed ? If I increase this number will it improve something ?)
Thank you in advance and sorry for my poor english !
Sophie