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.


  1. Lutein

    I have learned result-oriented things from a blog post. Also a thing to I have discovered is that generally, FSBO sellers can reject you. Remember, they would prefer to not use your companies. But if you actually maintain a gradual, professional relationship, offering assistance and keeping contact for about four to five weeks, you will usually have the capacity to win an interview. From there, a listing follows. Thanks

  2. russell westbrook shoes

    I have to show my admiration for your kindness giving support to men and women that need guidance on that content. Your real dedication to getting the solution along came to be exceptionally advantageous and have really helped guys and women much like me to realize their ambitions. This warm and helpful recommendations indicates a lot to me and still more to my mates. Thanks a lot; from everyone of us.

  3. palm angels clothing

    I wish to express my respect for your kind-heartedness supporting men and women that actually need help with this important situation. Your real commitment to getting the message throughout came to be rather interesting and has continually enabled guys much like me to achieve their aims. Your new warm and helpful hints and tips means so much to me and somewhat more to my fellow workers. With thanks; from each one of us.

  4. curry 9

    I want to convey my gratitude for your generosity giving support to folks that absolutely need assistance with the concept. Your personal dedication to getting the message all through appeared to be surprisingly useful and have really encouraged girls much like me to get to their goals. Your own helpful publication indicates a lot to me and further more to my office colleagues. Best wishes; from each one of us.

Laisser un commentaire

Votre adresse e-mail ne sera pas publiée.