On: Ways to shoot yourself in the foot with Postgres

[NegativeLatency]

Any good guides like this for MySQL? Unfortunately having to use it instead of Postgres at my current job.

[grafelic → NegativeLatency]

Check out https://www.percona.com/blog (filter for MySQL)

I have been a heavy user of the Percona distribution of MySQL for many years and highly recommend it. I think that most of the MySQL articles on percona.com are relevant for other MySQL distributions.

As a side note, depending on the software stack, ProxySQL can have a major positive impact on performance and scalability.

[Scarbutt → NegativeLatency]

They seem pretty generic, the same ideas/concepts can probably be taken over to mysql.

[lbriner → Scarbutt]

This is definitely not true. They are not generic at all.

* work_mem is postgres specific

* stored procs and functions don't perform as badly in SQL Server

* Triggers behave differently

* NOTIFY is postgres specific

etc.