Question : I have the following configuration: a host machine that runs three docker containers: MongoDB Redis A program using […]
Tag: limits
MySQL failed connection attempts hitting max_connections
Question : I run a couple of websites but I believe one of them is causing too many Connections Failed […]
MySQL/MariaDB Limitations
Question : we’re running MariaDB on our DB server. We have to install multiple databases on each DB instance (in […]
Select with limit, get total count, optimize query [closed]
Question : Closed. This question needs to be more focused. It is not currently accepting answers. Want to improve this […]
Is it possible to limit concurrent aggregations in Mongo?
Question : When clients makes certain requests, our service sends aggregation queries to Mongo. Some of these aggregations take longer […]
MySql LIMIT + JOIN is stopping data from being returned?
Question : I originally posted this question on stackoverflow, but then remembered there’s a stackexchange specifically for databases! I’ve got […]
UPDATE Only one row (using update and join)
Question : I’m trying to get a fast, simple sql query to update only one row at a time while […]
Predicting the primary keys exhaustion in MySQL based on rate of insertion
Question : We are running out of primary keys for our table in production. We do not want that to […]
COUNT(*) gives more than 1 with LIMIT 1?
Question : I’m trying to count old records. Why does Postgres give a result of 1160, even though I set […]
MySQL limits on huge number return zero rows
Question : I have table about 1,000,000 rows. this query work well: SELECT * FROM `articles` WHERE `articles`.`hash` NOT IN […]