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

Also, it's always good to see what the guys from WebScaleSQL are improving. For example:

https://code.facebook.com/posts/190251048047090/myrocks-a-space-and-write-optimized-mysql-database/

On Wed, Aug 31, 2016 at 2:13 PM, Ryan January <rjanuary_at_gmail.com> wrote:

> 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
>
> And of course blogs Thiago noted.
>
> Regards,
> Marko
>
>
> On Wed, Aug 31, 2016 at 1:55 AM, kyle Hailey <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