We have a set of PHPUnit tests running against a Propel/PDO application. Recently, with a recent increase in the number of tests, we’ve found that we’ve been hitting MySQL’s max_connections or max_user_connections limit (see /etc/mysql/my.cnf on the MySQL server).
TL;DR version Use Solr as a ‘search engine’ for applications. It is fast. A lot faster than MySQL (at least in one slightly-scientific study we’ve undertaken). Further details below….
Web applications often have a requirement to log information about a request to a database. In a contrived example this could just be a global counter which attempts to amaze visitors to your site about how many requests you’ve handled in the last hour/day/week/month. One approach to doing this is to update a database each […]