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

106 comments
  1. rkcnfw

    I had a wonderful shopping feel with ivermcov.com. They answered all my questions patiently and directed me to the proper product. I also did a figure match, and their value was significantly cheaper than the other websites I visited. I wishes machine shop here again. Terrific forum posts. Appreciate it.

  2. bape hoodie

    I in addition to my pals happened to be studying the nice pointers located on the website and then before long I had a terrible feeling I never expressed respect to you for them. Most of the people were consequently thrilled to read all of them and have seriously been using those things. We appreciate you simply being simply accommodating and for going for this kind of awesome issues millions of individuals are really wanting to be informed on. Our honest regret for not saying thanks to sooner.

  3. golden goose sneakers

    I precisely wanted to say thanks yet again. I’m not certain what I would’ve gone through in the absence of the entire strategies revealed by you regarding such concern. This was an absolute difficult situation in my view, nevertheless discovering a specialised tactic you treated it took me to weep with delight. Now i’m grateful for the support and wish you realize what a great job that you are carrying out educating other individuals through the use of your websites. Probably you haven’t got to know any of us.

  4. kobe

    I must show my respect for your kind-heartedness supporting men and women that really want assistance with that content. Your personal dedication to passing the solution across turned out to be surprisingly beneficial and have continually made guys and women like me to get to their goals. Your entire useful tips and hints means a great deal to me and further more to my mates. Thanks a lot; from each one of us.

  5. golden goose sneakers

    I have to point out my love for your generosity for those people who actually need guidance on this important topic. Your very own commitment to getting the message all-around became exceptionally significant and have continuously enabled many people just like me to achieve their goals. Your entire informative publication entails much a person like me and much more to my peers. Thanks a lot; from all of us.

  6. izmir temizlik şirketleri

    Eskiden temizlik işlemlerini yapan insanlar bu kadar profesyonel değilken artık günümüzde temizlik bir meslek haline gelmiştir. Bununla birlikte en iyi hizmet için insanlar kaliteli kadroya sahip ekiplerle çalışmak istemektedirler. İzmir Temizlik Şirketleri arasında tercih yaparken kurumsal referansları olan güvenilir ve tecrübeli bir firmayı seçmenizi öneririz.

  7. yeezy 350

    I simply wanted to say thanks once again. I do not know the things I might have tried without these creative concepts contributed by you over such subject. It absolutely was a very depressing matter in my position, nevertheless discovering a new skilled technique you solved it made me to jump over gladness. Now i am happier for the help and trust you really know what a powerful job you happen to be providing instructing the others thru your blog. I know that you’ve never met all of us.

  8. lebron james shoes

    I would like to show my admiration for your kindness for men and women who have the need for help on this important idea. Your special dedication to getting the message all-around appeared to be really interesting and has in every case encouraged some individuals much like me to achieve their ambitions. Your warm and friendly guide indicates much to me and additionally to my office colleagues. Thank you; from each one of us.

Laisser un commentaire

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