Hi Andy, I feel your pain, I also had an Oracle background before landing working with MySQL. mariaDB. I moved us off MySQL it was an old version to mariaDB now on 10.0.16 and will look to move to 10.1.x in the second half of next year The MySQL-sys schema objects will give some Oracle like views. however you will feel you have stepped back into the dark ages compared to AWR and all those niceties like session tracing that are standard fare in Oracle. My experience has been to look at IO performance first and foremost without it nothing else matters unless you have enough RAM to buffer your entire db. All my data tables are innodb for ACID compliance and that with file per table I was able to look to individual behaviors of data and as your RAID can handle accessing multiple files at a time this has potential performance gains. The old 80% rule for the buffer is a bit of a misnomer as you might find yourself with other performance problems due to excess memory consumption from sessions, as you will have heard or said a number of times in Oracle "it depends". Use Thread pooling to manage connections it seems to me to have higher performance and manages resources better. Look out for poor db design that will ultimately hurt you just as it will hurt any other database. Use a lot I have 10 smaller innodb buffer files 64MB - that seems to have been a good recommendation. Finally good SQL, few and quality indexes on tables and SQL to maximise index use I have tried just about every tool out there from some simple profiling tools to Percona Cloud and Monyog which is where we are at monitoring and unless you are planning to move to MySQL and get Enterprise to get the management tools then Monyog is the best, I will recommend you get some JSON skills or you will be learning them with Monyog to set up alerts that are not standard out of teh box. But it is worth every penny as we have various alerts wired to Slack and PagerDuty as well as some lower ones as email only and it has cut off some issues early as we got an alert and were able to address a problem before it took out the system. HTH Cheers Peter On Tue, Dec 15, 2015 at 5:29 AM, FERRETTI, ANDY <af4299@att.com> wrote:

I’m looking for recommendations on MariaDB Performance Analysis tools.

1. I try MySQL workbench, but much of the capability is disabled. I get an error when I click on the Dashboard “This feature requires MySQL version 5.6.6 or newer”.

2. I’m wondering if there are some good scripts to help identify key performance metrics from the performance_schema. I’d like to see a capability similar to an Oracle AWR report. I spent a fair amount of time doing google searches, and found some information on the performance_schema: https://php-built.com/enabling-performance-monitoring-for-mariadb-and-mysql/ , but I really think there should be something better.

Thanks,

*Andy Ferretti* Lead Principal-Technical Architect

*AT&T** Technology Development – SD&E*

*Cloud, Platform, Application and Data Layer Support (CPADS)*

*Work:* 205 989 0662 *Cell:* 205 478 9694 *e-mail:* andy.ferretti@att.com

*This e-mail and any files transmitted with it are AT&T property, are confidential, and are intended solely for the use of the individual or entity to whom this emailis addressed. If you are not one of the named recipient(s) or otherwise have reason to believe that you have received this message in error, please notify the sender and delete this message immediately from your computer. Any other use, retention, dissemination, forwarding, printing, or copying of this e-mail is strictly prohibited.*

_______________________________________________ Mailing list: https://launchpad.net/~maria-discuss Post to : maria-discuss@lists.launchpad.net Unsubscribe : https://launchpad.net/~maria-discuss More help : https://help.launchpad.net/ListHelp

-- *Peter McLarty* *Data Analyst DBA* Compare The Market P: +61 7 3377 8952 M: +61 4 0209 4238 http://www.comparethemarket.com.au -- Compare The Market is a brand and trading name of Compare The Market (Pty) Ltd (CTM). This email is for the intended addressee and is confidential and subject to copyright. If you are not the intended addressee, confidentiality has not been waived and any use, interference with, or disclosure of this email is unauthorised. If you are not the intended addressee please immediately notify CTM and then delete the email. CTM does not warrant that this email is error or virus free.