3 ms·
After Postgres got replication out of the box I'm pretty sure it's just inertia and the fact that it's installed everywhere keeping mysql usage up. Postgres is
by erkkie 12y ago
After Postgres got replication out of the box I'm pretty sure it's just inertia and the fact that it's installed everywhere keeping mysql usage up. Postgres is so much nicer when dealing with day-to-day things.
Eg disabling connections per database using sql and having built-in query stats (http://www.postgresql.org/docs/9.4/static/pgstatstatements.html http://www.postgresql.org/docs/9.4/static/pgstatstatements.h...) just made me smile.
- morgo 12y agoThe built in query stats is similar to Performance Schema in MySQL. The statistics are quite fine grained, and with a set of views on top (https://github.com/MarkLeith/mysql-sys https://github.com/MarkLeith/mysql-sys) are very useful for observability.
- erkkie 12y agoThanks, wasn't aware of that, quit mysql habits pre 5.6 :)
- morgo 12y agoTechnically, it was introduced in 5.5, but off by default :) 5.7 is going to be amazing for observability. Memory, transactions, stored procedures, replication, meta data locking and prepared statements are all instrumented in P_S.