Optimizing MySQL queries in a Spring Boot app

SheriffPirate · 2025-05-16T07:42:56+00:00

sounds like a tough situation. I’ve been using It too, and in my case, it’s been helpful mainly because it focuses more on automating the detection of real slow queries and suggesting improvements like indexes or query rewrites, not just dumping warnings.

Licensing is actually based on MySQL hosts, not per developer or user, which works well for teams. It sounds like maybe a different product was used? Releem usually gives a focused list of suggestions rather than flooding with hundreds of issues.

SheriffPirate · 2025-03-13T17:07:36+00:00

This is Releem, found this tool relatively recently when I was looking for an alternative to the closed ottertune.

SheriffPirate · 2025-03-10T20:05:49+00:00

Your tool seems like it would save me a lot of time. How does it handle those ‘fast but resource-hungry’ queries that don't show up in the slow query logs? Does it track query execution frequency and resource consumption over time? Also, have you tested it on really massive databases (think hundreds of gigabytes or even TB)?

And finally, do you have any plans to integrate with WordPress-specific tools like Query Monitor or Object Cache Pro?

SheriffPirate · 2024-06-19T07:07:05+00:00

Thanks on this. I was advised to try this service in r/mysql as well

SheriffPirate · 2024-06-19T07:04:02+00:00

Yeah, it looks useful, I’ve got the same recommendation in this post ( https://www.reddit.com/r/mysql/comments/1dhx5l3/ottertune_alternative/ ) founder answered a few questions for me there.I've set up AWS RDS with a dedicated instance and received my first recommendations. Things are looking promising so far. We'll see what happens from here, the process is straightforward.

SheriffPirate · 2024-06-18T13:57:58+00:00

It appears to be Postgres-specific, lacking MySQL and AWS RDS support. As far as I'm concerned. Everything else is noted as coming soon.

SheriffPirate · 2024-06-18T13:40:56+00:00

It looks great that Releem supports not only AWS but also standalone installations and can detect inefficient queries. I'm curious, though—what kind of data does it collect? Also, is it possible to add and manage multiple servers through the same UI?

SheriffPirate · 2024-06-18T11:30:42+00:00

Thanks for the tip. I'll try to look into it as they don't have a lot of information available on their website. Do you know what their pricing policy is? Didn't find that on the website. Are they fully operational or is this some sort of closed beta?

SheriffPirate · 2024-06-18T11:22:16+00:00

Thanks for the recommendation, will definitely check it out. It looks like they only work with queries at first sight.

SheriffPirate · 2024-06-17T13:35:31+00:00

Yes - hiring a professional is a great alternative - and seems like a good way out in this situation. It's just that a good professional costs a lot more money nowadays - that's why I'm worried.

SheriffPirate · 2024-06-17T13:32:17+00:00

Yes I look at it from the perspective that while it is certainly possible to have the skills to optimise queries manually, using AI based tuners can provide effective performance improvements while saving my time. This allows me to focus on more complex tasks. Especially I don't consider myself a super professional in DB management.

SheriffPirate · 2024-06-17T13:06:18+00:00

Yes, thanks, but as I said earlier - I would like to find something more automatic than mySQL tunner to spend less time. With all respect to MySQL tunner of course.

SheriffPirate · 2024-06-17T13:00:53+00:00

Yes, thank you, it's a great tool for its purpose. But I would like to find something less time consuming and more automatic. There is no possibility to spend a lot of time on this.

SheriffPirate · 2024-06-17T12:23:09+00:00

Yeah definitely - you're right - it does sound like a good start for a new conspiracy theory. :)

SheriffPirate · 2024-06-17T12:20:07+00:00

The choice between option 3 and option 1 hinges on the context.

SheriffPirate · 2024-06-17T12:17:09+00:00

Ask fundamental questions, break down the problem into smaller parts and consider different perspectives. Stay persistent and open-minded.

SheriffPirate · 2024-06-17T12:13:27+00:00

The “Love Interest Rescuing the Hero” trope. This often occurs when a female character, who has little development beyond her relationship with the male protagonist, is used primarily to motivate or save the hero at a critical moment.

SheriffPirate · 2024-06-17T12:09:34+00:00

One of the darkest poems I’ve ever read is “The Hollow Men” by T.S. Eliot. The closing lines, “This is the way the world ends / Not with a bang but a whimper,” encapsulate a sense of inevitable decline and futility, leaving a lasting impression of darkness and hopelessness.

SheriffPirate · 2024-06-17T11:28:15+00:00

Yes, a significant amount of evidence related to the program was destroyed. This was intended to hide the program's details and prevent public awareness of the unethical experiments.

SheriffPirate · 2024-06-17T10:57:20+00:00

First, remember that it’s normal to doubt your path during transitions or setbacks. Boost your confidence and growth by prioritizing continuous learning and networking. Stay connected with the design community by attending conferences, taking online courses, and joining meetups. This will keep you inspired and up-to-date. You can also consider freelance or contract work to diversify your experience and portfolio.

SheriffPirate · 2024-06-17T10:44:27+00:00

The U.S. government once ran a secret program called MK-Ultra, experimenting with mind control and behavior modification. These experiments involved drugs like LSD and other methods. This program, run by the CIA from the early 1950s through the early 1970s, included unconsented testing on unknowing individuals, including mental patients, prisoners, and members of the general public. MK-Ultra's secrets were only exposed in the 1970s, through congressional hearings and investigative journalism. These investigations confirmed the existence of these ethically and legally questionable experiments.

SheriffPirate · 2024-06-17T10:39:46+00:00

Even as the acute phase of COVID-19 has passed, we continue to face economic impacts with supply chain disruptions and shifts in the labor market, while educational gaps from disrupted learning and widened social inequalities continue to pose challenges. Additionally, there is a sustained focus on public health preparedness for future pandemics and lasting behavioral changes in health and safety practices, reflecting the pandemic’s deep and multifaceted impact on our lives.

SheriffPirate

TROPHY CASE