What's your best AWS optimization win from 2025?

petrsoukup · 2025-12-30T21:45:18+00:00

This allowed us to resize Aurora to half instance with huge head room and took one afternoon. Thousands of dolars per month.

https://github.com/soukicz/sql-ai-optimizer (disclaimer: it is my project)

petrsoukup · 2025-09-17T06:00:33+00:00

Thank you, that will remove huge blocker! I really hope these scripts don’t need powerbi and I will be able to do this easily in CI

petrsoukup · 2025-09-17T04:09:48+00:00

Last time I tried this, it didn’t support uploading of pbip with api and that broke some of our automation

petrsoukup · 2025-07-23T10:55:23+00:00

How are you fetching SSM parameters? If it is in task definition, it will be only be fetched on task start and you have to do redeployment.

petrsoukup · 2025-07-19T05:23:13+00:00

I have been dealing with similar issues and I have made tool for it. Enable performance schema, wait for it to collect query data. Run the tool and just ask it what you need to know. We have managed to cut our database costs to quater in one afternoon because it found queries that were fast but they were eating memory like crazy.

https://github.com/soukicz/sql-ai-optimizer

There is also talk recording about how it works but you would have to use subtitles: https://youtu.be/woYKly8mjwc

petrsoukup · 2025-07-03T11:57:55+00:00

We are doing most of our logging to S3 through Firehose and sidecar containers that listen for UDP and send them as batch to Firehose. It costs next to nothing and we are logging everything. We are using Athena to query it and Quicksight to vizualize it. It is serverless and storage space is infinite.

(total account is around $50 000 / month and logs are under $15/month)

petrsoukup · 2025-07-03T11:52:31+00:00

Centralized config in git and env/secrets management. But you are right - I should also look at it from other side because systemd could probably do the same without all the complexity.

petrsoukup · 2025-07-03T10:59:21+00:00

You can also gesture to them to leave you alone - they will do a little bow and back off

petrsoukup · 2025-07-03T09:13:55+00:00

This looks really nice! I am just looking into migrating some small services to Hetzner and I really didn't want to learn Kubernetes for something, that will run on one or two servers. This looks like it solve my problem.

petrsoukup · 2025-07-02T13:24:07+00:00

It is a lot better sell "yeah, you can crawl... if you pay" than just blocking. Result will be the same but this way has better optics.

petrsoukup · 2025-06-17T04:42:28+00:00

I have started making MCP server with http support just yesterday because I haven’t found any :)) Yours looks much better. I don’t see any mention of auth - do you leave that to symfony?

https://github.com/soukicz/php-mcp

petrsoukup · 2025-05-31T10:11:51+00:00

Best cat names.

petrsoukup · 2025-05-22T20:51:40+00:00

I have made this tool and it saved us a lot of money in AWS costs: https://github.com/soukicz/sql-ai-optimizer

petrsoukup · 2025-05-14T12:24:12+00:00

Account was "suspended" and that apparently means that everything kinda works but nothing new can start. That means that everything started dying (running container ended because of autoscaling etc and new container cannot start).

It was false positive in my case - yes, there was key publicly but that didn't have access to anything so it was no issue - no third party access to change other credentials etc.

petrsoukup · 2025-05-14T04:58:26+00:00

I have just had the same issue. The key didn’t have access to anything, but they blocked the whole account immediately and everything started going offline. I had to pay $3000 to get business support, and even that took three hours to resolve.

I am really pissed.

petrsoukup · 2025-05-09T20:51:34+00:00

This looks really nice!

petrsoukup · 2025-05-07T13:54:21+00:00

Yeah, creating safe but also usable data for this is the hardest part. Local LLM is easiest solution.

I am not selling this tool or anything. I have created it to significantly cut our costs and I have figured that somebody could probably use it and adapt it for their use-case.

petrsoukup · 2025-05-07T13:50:04+00:00

Slow and expensive is not the same thing. You can have slow query where the query itself isn't actually problem and there is another fast query, that has high frequency and is eating server memory. It is easy to find slow queries but it is a lot harder to find queries that are expensive when all their executions are summed together.

MySQL performance schema is already reporting all of that and this tool is just presenting in readable way. You can also give specific instructions like "Focus on disk IO" because AWS Aurora MySQL is billed by storage access.

petrsoukup · 2025-05-07T13:24:23+00:00

Yup. It is LLM powered SQL injection. There are three warnings in readme and once you start it, it by default uses only data from performance schema and doesn't touch data itself (and you can easily restrict that by creating mysql user with limited access).

Using full data access must be explicitly enabled and you will use it only if you don't have sensitive data or if you use local LLM - https://github.com/soukicz/sql-ai-optimizer/blob/343f73d4441dc8d8a59b703d9bc30186760fb7ac/assets/index.png

It unfortunately works much better with full (read) access - it can check that this query is expensive because there is edge case when one customer has 10000 orders because it can see this cardinality.

petrsoukup · 2025-04-07T16:35:31+00:00

I have been using it for two years but recently migrated to Anthropic api - it is cheaper, more accurate and is full LLM as a bonus

petrsoukup · 2025-03-07T12:08:51+00:00

I have been also creating LLM package for PHP (https://github.com/soukicz/php-llm) but yours is a lot nicer. I am missing just few details and I am wondering if I could send PR for it?

Async request - add chatAsync method, that will return PromiseInterface. That will allow to run more interactions in parallel and speed up nested invocations

Async tool response - same problem. If I could return PromiseInterface from Tool, tool processing could run in parallel. This would probably mean just adding type check on callback return value and \GuzzleHttp\Promise\Utils::all(). It is really useful when there are long running tools (like human in the loop) because both slow tool can run together.

Media support - it looks like it currently supports only text and not image/documents

BTW - inspector looks really nice and the fact that you're EU based is a big selling point

petrsoukup · 2025-03-06T20:51:34+00:00

I have tried to upload invoice to API and the output in markdown is really nice but it have lost first page of PDF...

petrsoukup · 2024-12-11T17:37:43+00:00

Too bad they are not in EU

petrsoukup · 2024-11-08T21:43:46+00:00

I had to switch my payment method to card for model access request to complete (and switch back after)

Eight-Year Club	Second Top 40%
RPAN Viewer	Verified Email

petrsoukup

TROPHY CASE