← Back to team overview

maria-discuss team mailing list archive

Re: MariaDB Performance and Diagnostic Tools


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
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.




On Tue, Dec 15, 2015 at 5:29 AM, FERRETTI, ANDY <af4299@xxxxxxx> 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@xxxxxxx
> *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@xxxxxxxxxxxxxxxxxxx
> 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


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.