Loading...
Développement-code

Optimiser MySql tuning

Optimiser les performances de MySQL

MySQLTuner est un script Perl qui effectue un audit  de vos bases de données MySQL. En résultat il fournit un tableau de bord simplifié se terminant par une liste d’indications de modifications du fichier de configuration de la base mysql : my.cnf
Par défaut le fichier de configuration de MySql a trés peu de chances de corrrespondre à votre serveur.

MySQLTuner vous « assiste » dans la configuration de votre serveur Mysql et propose des améliorations dans le but d’accroitre la stabilité et les performances du serveur. En quelques secondes, MySQLTuner affiche des statistiques sur votre serveur mysql et vous propose les options « qui vont bien ».

 

La documentation est orientée pour les utilisateurs de serveur Ubuntu. Elle est facilement transposable à d’autres systèmes d’exploitation.

Installer MySQLTuner

Ouvrir une console et exécuter les commandes suivantes :

Sur Debian


sudo apt-get install mysqltuner

Ou télécharger le script et le rendre exécutable

wget http://mysqltuner.com/mysqltuner.pl

chmod +x mysqltuner.pl

Pour lancer

sudo ./mysqltuner.pl

Utiliser l’application quelques heures

MySQLTuner se base sur des indicateurs de MySQL.
Il est donc nécessaire d’utiliser ses applications plusieurs heures afin que les optimisations préconisées soient efficaces.

Exécuter MySQLTuner

perl mysqltuner.pl

Auditer et améliorer les performances

 

Pour optimiser au mieux, il faut aussi utiliser tuning-primer, on a ainsi 2 outils pour une meilleure performance.

https://github.com/rackerhacker/MySQLTuner-perl

19 comments
  1. yeezy

    I needed to compose you one very little note just to say thanks a lot again on your wonderful principles you have shown in this case. This has been so surprisingly open-handed with you to give unhampered all numerous people might have sold for an e book to generate some profit for themselves, most importantly since you might have tried it in case you decided. These concepts likewise acted as the great way to realize that many people have the same passion the same as my own to know the truth much more with respect to this condition. I believe there are lots of more pleasurable instances in the future for those who view your site.

  2. a bathing ape

    I wanted to compose you one little bit of word so as to say thank you the moment again regarding the amazing principles you have featured above. It’s extremely generous with you to supply extensively exactly what most of us might have offered as an electronic book to generate some profit for themselves, notably considering the fact that you might have tried it in case you desired. The smart ideas likewise worked like the good way to be aware that some people have a similar zeal the same as my own to figure out a great deal more around this problem. Certainly there are thousands of more pleasant instances in the future for individuals who read carefully your blog.

  3. golden goose sneakers

    I must express my love for your kind-heartedness supporting men and women that require help on this one topic. Your very own commitment to getting the message all through has been rather effective and have all the time permitted workers much like me to get to their endeavors. This invaluable help and advice implies this much to me and further more to my colleagues. Warm regards; from everyone of us.

  4. supreme

    I must convey my respect for your generosity in support of individuals that must have help on this one idea. Your special commitment to getting the solution all over turned out to be exceedingly good and have really empowered ladies much like me to reach their targets. Your entire invaluable tutorial means this much a person like me and far more to my mates. With thanks; from everyone of us.

  5. nike off whtie

    I must get across my passion for your kindness for men and women who really need help with this important field. Your very own dedication to passing the solution all over came to be particularly significant and have regularly made professionals much like me to attain their goals. Your amazing invaluable tutorial denotes this much a person like me and additionally to my colleagues. Best wishes; from all of us.

  6. nike kyrie 5

    I want to express my respect for your kindness in support of individuals that really want help on this concern. Your real commitment to passing the solution across had become extraordinarily powerful and has always permitted professionals like me to attain their ambitions. The important help denotes a whole lot to me and much more to my office colleagues. Thanks a lot; from everyone of us.

Laisser un commentaire

Votre adresse e-mail ne sera pas publiée. Les champs obligatoires sont indiqués avec *