Annika Backstrom is a user on xoxo.zone. You can follow them or interact with them if you have an account anywhere in the fediverse.
i just spent an hour fucking with #mysql connection problems. end result? the mysql user had ssl_type = x509 and my certs weren't set up correctly.
@annika I have to say, though, I’m floored by how responsive the Linux system is while that mysqld process is hyperventilating.
@annika Unsuprisingly, the Linux machine, with an older mysqld, is not optimizing some queries as strenuously as the Windows machine that has a more recent mysqld.
Oh, well, those queries just need to be factored into smaller ones.
@annika Monday I’ll have to figure out why a PHP program that runs fine against a Windows copy of a MySQL database causes a Linux mysqld to use ~100% of CPU indefinitely with precisely the same data.