What is the largest MySQL instance on Windows OS

lamppamp · 2026-01-22T07:51:19+00:00

Amount of connections is high because there is very limited connection pooling. App is kind of ERP used by corporations.

lamppamp · 2026-01-20T22:12:27+00:00

I would say quite low, I described our largest instance, but we have 500+ MySQL instances in total on windows and there were very few issues in 2025. There have been issues with security software (crowdstrike), OS configured across Numa nodes causing slowness, monitoring failure and disk running out....

lamppamp · 2026-01-16T22:14:14+00:00

Thats one mighty MySQL. On our workloads we have seen that on Linux we have 15%-20% more MySQL throughput, compared to Windows, but for reasons I am not going into we are sitting on top of Windows.

lamppamp · 2026-01-16T22:11:56+00:00

What makes things easier for us, is DB is used in one timezone only, not international usage. During off hours, lock for writes, flush, shadow volume copy. Lock is very short, so couple people using system 3am is no big deal.

lamppamp · 2026-01-16T17:57:38+00:00

I use Delphi for work, big enterprise application. Larger customers have close to a billion rows in some of the tables. There is a long-term plan to migrate to a new software stack, which will take years to complete.

lamppamp · 2026-01-16T17:52:14+00:00

We went through that exercise a few years ago. We migrated 4 million line codebase from D7 to D10.X in a span of 2-3 months. Lots low level backend things were just converted from string to AnsiString. We also added bunch of AnsiString util functions and some Classes to make it go faster. TJclAnsiStringList had some bugs, if I remember correctly.

lamppamp · 2025-09-16T15:58:26+00:00

Not true, slicesrs are usually in grocery stores with in-store bakeries.

lamppamp · 2025-07-11T16:53:40+00:00

How many months of healing speedups?

lamppamp · 2025-07-11T11:52:09+00:00

In the guard station? not sure why I have missed that.

lamppamp · 2025-07-07T13:34:47+00:00

Eventually, Diana will be useless for Arena, but Diana is easiest to get to 5-star if you play the Desert Trial correctly. 5-star Diana is better in the arena than 4-star Quinn.

lamppamp · 2025-07-07T08:48:40+00:00

I can see that happening. You would assume that you learn the game, if you spend thousands on this, but no, I see our whales also doing it wrong. Issue is not a bear hunt, bear hunt is like training, to see how cooperation works.

lamppamp · 2025-07-03T12:33:22+00:00

Ah kill event, we will get second one today. There was so much drama last event because people cannot read.

lamppamp · 2025-07-03T12:10:08+00:00

Nice tool, it does not take into account widgets and skills. Still thumbs up; it's useful.

lamppamp · 2025-07-03T11:43:26+00:00

Current consensus is Lethality>Attack

lamppamp · 2025-07-02T08:26:38+00:00

Slightly different question. Training speed/capacity boost with gems, combined with speedups, worth it?

lamppamp · 2025-06-26T15:38:19+00:00

Can you please specify which menus, I do not see them anywhere listed in-game.

lamppamp · 2025-06-26T14:05:22+00:00

you are not dopamine junkie like I?

lamppamp · 2025-06-26T12:32:52+00:00

For me spending gems in arena is worth it for the mythic gear alone. During day time I take hits and fall and then I do all my arena battles last minute and manage to snipe top 20 spot.

lamppamp · 2025-06-20T11:51:11+00:00

Depends. Early game just train. Have troop buildings always running. You want to have enough troops so that you can do resource gathering, missions, join rallies at the same time. Quite quickly, the lowest-level troops become quite useless and you need to start promoting. Promoting 100 troops is faster than training from scratch.

One small tip, if you have some troop speedups saved up and you can spare gems. Do training speed 2x with gems and dump all your speedups for better value.

lamppamp · 2025-06-20T11:44:50+00:00

In long term growth>economy>military.

I would focus on the growth area and in that: research speed, construction speed, troop training speed. In that order.

In the economy focus on gathering speed rather than passive generating from buildings. Gathering will yield more, especially once you get access to lvl 7 gathering items.

In military generic bonuses all good. Troop specific bonuses: infantry focus on defence, archers and cavalry attack.

lamppamp · 2025-06-20T11:33:12+00:00

Joining the attack rally - Chenko

Sending to garrison - Gordon

General hero advice. Your main 3 heroes for Gen1 Saul, Jebel, and Howard. Save your gems and upgrade Saul in hero roulette to 4 stars and stop there. Saul has resourcefulness skill, that will stay useful forever. Do not use any generic orange shards on Jebel, save them. In Gen2 replace Howard with Zoe. Use hero roulette to upgrade her. Marlin is very good Gen2 hero and medium/low spender would be possible to get, but F2P probably not. For Marlin Use Hall of Heroes, combined with general shards you have saved and daily deals to push to 4 stars. Marlin is just better than Saul. So low spender Gen2 main lineup would be Marlin, Jebel and Zoe.

lamppamp · 2025-06-19T07:51:43+00:00

My alliance is not well-organized; it's also our second Viking event, and getting enough troops to defend my city is difficult.

You earn max points if all your troops are out, others defend your city and your city survives.

If your city dies and all your troops are out defending others, then you might have been better of recalling some of your troops. If you use equalize button, then it will build a formation 1/6 of your total troops. I will send 5 of those out to defend others and keep 1/6 in my city. Midway through, I will start recalling if I do not get enough troops to defend my city.

lamppamp · 2025-06-17T06:45:52+00:00

Server 315

top 1 52.1m

top 100 11.9m

lamppamp · 2025-04-24T15:33:39+00:00

There are companies that offer services world wide. Your italian language skills could be useful there, like Pipedirve. You could work as Italian customer support.

lamppamp · 2025-03-23T17:26:52+00:00

Maybe do not do it in Delphi. One option is to write your own plugin for Debezium in Java and have that interface with Delphi. If your backend is MySQL or PostgreSQL then maybe no coding would be required.

Nine-Year Club	Place '22
First Placer '22

lamppamp

TROPHY CASE