Re: MySQL forums, blogs and tuning books (was Uber & Postgres)

Everyone else has been killing it with their suggestions and I can't add a whole lot there. Grafana is amazing for visualization. I've used the percona app, and really do like it. It relies on Prometheus to gather and persist data behind the scenes. You won't find anything with better dashboards straight out of the box. Another potential data source is Telegraf (and the MySQL plugin) dumping data to InfluxDB. We're using Influx for a great deal of our metrics, so that route was a little more natural than adding in another data store.

The one thing I would add for anybody else who's curious at alternate databases; MySQL does seem to be hitting a maturation tipping point. I'm at a crossroads where I'm seriously considering moving away from Oracle to focus mostly on MySQL. I feel like I rode the coat tails of the Oracle wave (starting right after the release of 10.1). I want to get out ahead of the next thing.

The addition of Performance Schema was huge for me. What MySQL has historically lacked is instrumentation. PS is a huge step forward into seeing what the DB is doing internally. Throw the sys schema on top, making an Oracle DBA feel at home, and it's adding up to having a great level of potential in the next few years.

Thanks,
Ryan

> On Aug 31, 2016, at 11:35 AM, Marko Sutic <marko.sutic_at_gmail.com> wrote:
>
> Kyle,
>
> in my humble opinion the best performance book:
> High Performance MySQL, 3rd Edition
> Baron Schwartz, Peter Zaitsev, Vadim Tkachenko
>
> The best (free) monitoring and visualisation performance tool for MySql:
> https://grafana.net/plugins/percona-percona-app <https://grafana.net/plugins/percona-percona-app>
>
> And of course blogs Thiago noted.
>
> Regards,
> Marko
>
>
> On Wed, Aug 31, 2016 at 1:55 AM, kyle Hailey <kylelf_at_gmail.com <mailto:kylelf_at_gmail.com>> wrote:
>
>
> After all the fun with Uber going from Postgres to MySQL (after they had previous gone from MySQL to Postgres) ...
>
> Does anyone have recommendations on good MySQL forums (like Oracle-L) or recommend performance blogs or performances books?
>
> I'm looking into ways of monitoring and visualizing performance data in these databases similar to the work I did with teams at Oracle on OEM and Embarcadero for DB Optimizer.
>
> Thanks
> Kyle
>
>

--
http://www.freelists.org/webpage/oracle-l