3 ms·
Any good guides like this for MySQL? Unfortunately having to use it instead of Postgres at my current job.
by NegativeLatency 3y ago
Any good guides like this for MySQL? Unfortunately having to use it instead of Postgres at my current job.
- Scarbutt 3y agoThey seem pretty generic, the same ideas/concepts can probably be taken over to mysql.
- lbriner 3y agoThis 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.
- grafelic 3y agoCheck out https://www.percona.com/blog 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.