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

382 comments
  1. ingilizce yeminli tercüme

    Express Tercüme, tüm dillerde dünya çapında profesyonel tercüme hizmeti veren bir online tercüme bürosudur. Uzman İngilizce yeminli tercüman kadromuz ile 2014 yılından beri kesintisiz tercüme hizmeti sunmaya devam ediyoruz.

  2. kartal avukat

    Kartal avukatlık hizmetinde amacımız, şirket ve kurumlara yönelik avukatlık, hukuki danışmanlık, kurumsal eğitim ve teşvik danışmanlığı sunmaktır. Hedefimiz müvekkillerimizin yasal sorunlarının ortaya çıkmasını engellemek ve mevcut sorunlara kazandıran etkili çözümler üretmektir. Akademik kariyeri ve meslek tecrübesi olan avukat, danışman ve eğitmenlerden oluşan ekibi ve çözüm ortakları ile Türkiye’nin ve dünyanın birçok yerinde bulunan müvekkillerine çok yönlü yasal danışmanlık hizmetleri sunmaktadır.

  3. off white shoes

    I precisely wanted to thank you so much again. I am not sure the things I would have made to happen without the actual advice revealed by you over such a industry. It had become a traumatic matter for me, however , being able to see the specialized strategy you resolved it forced me to cry over gladness. Now i’m grateful for this service as well as wish you know what a powerful job you are always accomplishing training other individuals through the use of your site. Most likely you haven’t encountered all of us.

  4. curry 6 shoes

    I want to express my passion for your kindness supporting folks who need help on this one idea. Your personal dedication to getting the message all through had become exceptionally effective and have frequently permitted guys and women just like me to reach their endeavors. Your new informative hints and tips implies this much to me and substantially more to my mates. Warm regards; from each one of us.

  5. cialis side effects erbu

    Losing an erection or being unable to ripen into create much results from nerves, solicitude, or using alcohol or other drugs. Sometimes men problem more gig, and on they’re anxious in whether or not having union is the strategic decree, or whether they’re with the fairly partner. Source: cialis 20 mg

  6. goyard handbag

    I simply had to thank you very much again. I am not sure the things that I would have implemented without those recommendations shown by you relating to that area. It actually was a real distressing crisis in my position, nevertheless taking note of a new professional style you treated that forced me to weep over happiness. I am happy for the service and thus expect you really know what an amazing job you were undertaking training the rest using your websites. I’m certain you’ve never come across all of us.

  7. Teknory

    Hello, we are making a difference to the world with our elborweltech brand, can you take a look at our article that we have prepared for you?

  8. Aile Danışmanlığı Eğitimi

    Aile danışmanlığı eğitimi, aileler arasındaki iletişimi geliştirmeyi, çatışmaları çözmeyi ve ilişkileri düzene sokmayı amaçlar. Bu eğitim programı, ailelerin çeşitli konularda yardıma ihtiyaç duyduklarında, örneğin çocuk büyüme ve eğitimine ilişkin sorunlar, boşanma, yeniden evlenme gibi konular gibi, onlara destek olmayı hedefler.

  9. cialis coupon walmart togp

    Booze, tiredness and solicitude can all pretend to your adeptness to tune in to or fence in an erection, so your doing can be stricken every these days and then. But if it’s episode oftentimes then it’s significance a stop in to your GP so they can dismiss out any possible healthiness issues. Source: cialis information

  10. off white nike

    I wish to voice my admiration for your kind-heartedness giving support to men who have the need for help on your area. Your personal dedication to passing the message up and down turned out to be really helpful and has surely encouraged women just like me to reach their goals. Your personal informative facts entails a whole lot to me and much more to my fellow workers. Many thanks; from all of us.

  11. off white hoodie

    I want to express some appreciation to the writer just for rescuing me from this incident. Right after searching throughout the search engines and seeing things which were not productive, I thought my entire life was well over. Living without the presence of solutions to the issues you’ve fixed all through your main posting is a serious case, as well as ones that would have badly damaged my career if I hadn’t discovered the blog. That capability and kindness in controlling the whole thing was precious. I don’t know what I would have done if I hadn’t come across such a solution like this. I can also at this time look ahead to my future. Thanks for your time very much for the impressive and result oriented help. I won’t hesitate to suggest your blog to any person who should get assistance about this subject.

  12. cialis trial nrap

    Organic ED involves abnormalities the penile arteries, veins, or both and is the most workaday basis of ED, especially in older men. When the riddle is arterial, it is all things considered caused away arteriosclerosis, or hardening of the arteries, although trauma to the arteries may be the cause. Source: cost of cialis at walmart pharmacy

Laisser un commentaire

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