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@xxxxxxxxx> 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@xxxxxxxxx
<mailto:kylelf@xxxxxxxxx>> 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