New answers tagged

1

The heavy hitters have Load balancer --> one of a set of web servers --> load balancer --> one of a set of MySQL slaves. That is, you are hitting at least 4 boxes. And none of them is "heavy" on CPU. Don't fear using dedicated servers. If the CPU is high in MySQL, then you are missing an index, or don't have a "composite index" or have a poorly written ...


0

A little late, but here we go... If you can't add more disk space and can't promote a replica I think your only option (short of adding more disk space) is upgrading to MySQL 5.6 and using the online alter feature. The third-party tools that I know of all require a second copy of the table to be created before performing the swap. As you mentioned, the good ...


0

After reseting root password, I could connect with workbench. I still can't connect with old users (which were already created), but connecting with root and creating new users with workbench allows me to connect with these new users. It looks it has something to do with the password, or the way MySQL Server stores password for users. I don't know the ...


0

A malformed package is usually a sign that you didn't connect to the expected service (in this case the MySQL server). Doublecheck that the expected server is running behind the given port on the given machine.


3

The argument against a dedicated server is invalid, if the microseconds that account for the delay when talking to a different server matter you would not be asking about MySQL. But there is one thing you could check before going out and buying hardware: A good database is trying to utilize as much main memory as possible for caching. Make sure your system ...



Top 50 recent answers are included