by marcos.albe | Jul 23, 2019 | MySQL
ERROR 1040…again A pretty common topic in Support tickets is the rather infamous error: ERROR 1040: Too many connections. The issue is pretty self-explanatory: your application/users are trying to create more connections than the server allows, or in other... by marcos.albe | Jul 5, 2019 | MySQL
During our work in support, we see this again and again: “I try to connect to MySQL and am getting a 1045 error”, and most times it comes accompanied with “…but I am sure my user and password are OK”. So we decided it was worth... by marcos.albe | Apr 11, 2017 | Insight for DBAs, MySQL
As part of our support services, we do a lot of query optimization. This is where most performance gains come from. Here’s an example of the work we do.Some days ago a customer arrived with the following table: CREATE TABLE `infamous_table` ( `id` int(11)... by marcos.albe | Apr 6, 2017 | Insight for DBAs, Insight for Developers, MySQL
Updated 7-05-2019 In this blog, we’ll look at how to resolve MySQL error code 1215: “Cannot add foreign key constraint”. Our Support customers often come to us with things like “My database deployment fails with error 1215”, “Am...