Several years ago we increased the ‘max connections’ value on our mariadb installations from the default of 100, to 5,000 . We also moved from myisam to innodb, allowing multiple active transaction changes to the database at the same time. We have never since had a problem with the number of database connections. Our largest sites have about 20 PoS stations, and very busy, including with online booking too. We also implement stress testing on databases. So far no problems
206 South 11th Street,
Nashville,
TN 37206
USA
Tel: +1 800 213 9956
Alton Rd Ind Est,
Ross-on-Wye,
HR9 5NB
UK
Tel: +44 (0)1989 567 474
© 2025 Tapos | Designed LeftField | Built by Zoe Negus Web Design