2

Had to optimize today a DB File / MySQL 5.7

I'm sometimes sad that software cannot bite people in their crotches, shit in their faces and fuck their eyes out.

The config was non commented and a disaster.

Yay. Let's set thread_cache to 16K while max connections is 50.

And raise limits like max files without adjusting SystemD / ulimit

And OF COURSE MySQL sucks...

So let's migrate to PostGres.

*Brainfart*

This has happened way too often.

Really. Software should have the right to punish dumb people. At least ... 10 kv shock to teach a lesson.

Comments
  • 1
    People should leave that config file alone unless they know what they doing.

    And for every changed config variable, a bloody reason left behind to indicate why you would actually need to adjust it, which is more then "wiii more connections - scalability here we come", + the default setting underneath commented out.
Add Comment