{"id":5537,"date":"2016-11-02T11:14:14","date_gmt":"2016-11-02T11:14:14","guid":{"rendered":"https:\/\/cpanelplesk.com\/wp62\/?p=5537"},"modified":"2021-02-02T05:33:20","modified_gmt":"2021-02-02T05:33:20","slug":"performance-tuning-script-mysql-mysql-tuner","status":"publish","type":"post","link":"https:\/\/cpanelplesk.com\/wp62\/performance-tuning-script-mysql-mysql-tuner\/","title":{"rendered":"Performance tuning script for MySQL \u2013 Mysql Tuner"},"content":{"rendered":"<p><span style=\"color: #000000;\">MySQLTuner is a Perl script that analyzes your MySQL performance and, based on the statistics it gathers. MySQL has a lot of variables in its settings. We can modify and set factors to our specifications on our server. <\/span><!--more--><\/p>\n<p><span style=\"color: #000000;\">A lot of methods and shell scripts are available for tuning your MySQL server. That way, you can tune your my.cnf file to get the every bit of performance from your MySQL server and make it work more effectively.<\/span><\/p>\n<p><span style=\"color: #000000;\">Today I will explain the installation and usage of performance tuning script for tuning the MySQL.<\/span><\/p>\n<p><span style=\"color: #000000;\">This performance tuning shell script will help you to optimize your MySQL on a cpanel server having huge traffic.<\/span><\/p>\n<h2><span style=\"color: #000000;\">Installation steps:<\/span><\/h2>\n<p><span style=\"color: #000000;\">The MySQL tuner has simple installation steps.<\/span><\/p>\n<p><span style=\"color: #000000;\"><strong>Step- 1<\/strong> : SSH to your server as root user.<\/span><br \/>\n<span style=\"color: #000000;\"><strong>Step- 2<\/strong> : wget the latest version.<\/span><\/p>\n<div class=\"space1\"><\/div>\n<div class=\"command-sh\">\n<pre>wget https:\/\/launchpad.net\/mysql-tuning-primer\/trunk\/1.6-r1\/+download\/\r\ntuning-primer.sh\r\nOR\r\n<span class=\"crayon-v\">wget<\/span> <span class=\"crayon-o\">--<\/span><span class=\"crayon-v\">no<\/span><span class=\"crayon-o\">-<\/span><span class=\"crayon-v\">check<\/span><span class=\"crayon-o\">-<\/span><span class=\"crayon-e\">certificate <\/span><span class=\"crayon-v\">https<\/span><span class=\"crayon-o\">:<\/span><span class=\"crayon-c\">\/\/raw.github.com\/major\r\n\/MySQLTuner-perl\/master\/mysqltuner.pl<\/span><\/pre>\n<\/div>\n<div class=\"space1\"><\/div>\n<p><span style=\"color: #000000;\"><strong>Step- 3<\/strong> : Change the file permission as executable.<\/span><\/p>\n<div class=\"space1\"><\/div>\n<div class=\"command-sh\">\n<pre>chmod 755 tuning-primer.sh\r\nOR\r\nchmod +x mysqltuner.pl<\/pre>\n<\/div>\n<div class=\"space1\"><\/div>\n<p><span style=\"color: #000000;\"><br \/>\n<strong>Step-4<\/strong> : Execute the script.<\/span><\/p>\n<div class=\"space1\"><\/div>\n<div class=\"command-sh\">\n<pre>.\/tuning-primer.sh\r\nOR\r\n<span class=\"crayon-sy\">.<\/span><span class=\"crayon-o\">\/<\/span><span class=\"crayon-v\">mysqltuner<\/span><span class=\"crayon-sy\">.<\/span><span class=\"crayon-v\">pl<\/span><\/pre>\n<\/div>\n<div class=\"space1\"><\/div>\n<p>&nbsp;<\/p>\n<p><span style=\"color: #000000;\">That\u2019s all \u00a0you have to do, If you are facing problem with \u00a0<a href=\"https:\/\/cpanelplesk.com\/wp62\/php-modules-not-loading-properly-cloudlinux\/\">PHP Modules<\/a> which are Not Loading Properly On CloudLinux . I have write about it in my previous article please check that\u00a0and also give your opinion below if you experience any issues or to discuss your ideas and experiences.<\/span><\/p>\n","protected":false},"excerpt":{"rendered":"<p>MySQLTuner is a Perl script that analyzes your MySQL performance and, based on the statistics it gathers. MySQL has a lot of variables in its settings. We can modify and set factors to our specifications on our server. [&#8230;]<\/p>\n<p><a class=\"understrap-read-more-link\" href=\"https:\/\/cpanelplesk.com\/wp62\/performance-tuning-script-mysql-mysql-tuner\/\">Continue Reading&#8230;<\/a><\/p>\n","protected":false},"author":2,"featured_media":4877,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1,14],"tags":[],"class_list":["post-5537","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-cpanel","category-linux"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v24.1 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Performance tuning script for MySQL \u2013 Mysql Tuner - cPanel Plesk<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/cpanelplesk.com\/wp62\/performance-tuning-script-mysql-mysql-tuner\/\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:title\" content=\"Performance tuning script for MySQL \u2013 Mysql Tuner - cPanel Plesk\" \/>\n<meta name=\"twitter:description\" content=\"MySQLTuner is a Perl script that analyzes your MySQL performance and, based on the statistics it gathers. MySQL has a lot of variables in its settings. We can modify and set factors to our specifications on our server. [...]Continue Reading...\" \/>\n<meta name=\"twitter:image\" content=\"https:\/\/cpanelplesk.com\/wp62\/wp-content\/uploads\/2016\/08\/mysqli-1.jpg\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Seemab Saleem\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"1 minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/cpanelplesk.com\/wp62\/performance-tuning-script-mysql-mysql-tuner\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/cpanelplesk.com\/wp62\/performance-tuning-script-mysql-mysql-tuner\/\"},\"author\":{\"name\":\"Seemab Saleem\",\"@id\":\"https:\/\/cpanelplesk.com\/wp62\/#\/schema\/person\/73d573cc7eaaf6625cf0dbd72191a648\"},\"headline\":\"Performance tuning script for MySQL \u2013 Mysql Tuner\",\"datePublished\":\"2016-11-02T11:14:14+00:00\",\"dateModified\":\"2021-02-02T05:33:20+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/cpanelplesk.com\/wp62\/performance-tuning-script-mysql-mysql-tuner\/\"},\"wordCount\":206,\"commentCount\":6,\"publisher\":{\"@id\":\"https:\/\/cpanelplesk.com\/wp62\/#\/schema\/person\/c78ae1cf9451a09592fb9697d69c0c13\"},\"image\":{\"@id\":\"https:\/\/cpanelplesk.com\/wp62\/performance-tuning-script-mysql-mysql-tuner\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/cpanelplesk.com\/wp62\/wp-content\/uploads\/2016\/08\/mysqli-1.jpg\",\"articleSection\":[\"Cpanel\",\"Linux\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/cpanelplesk.com\/wp62\/performance-tuning-script-mysql-mysql-tuner\/\",\"url\":\"https:\/\/cpanelplesk.com\/wp62\/performance-tuning-script-mysql-mysql-tuner\/\",\"name\":\"Performance tuning script for MySQL \u2013 Mysql Tuner - cPanel Plesk\",\"isPartOf\":{\"@id\":\"https:\/\/cpanelplesk.com\/wp62\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/cpanelplesk.com\/wp62\/performance-tuning-script-mysql-mysql-tuner\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/cpanelplesk.com\/wp62\/performance-tuning-script-mysql-mysql-tuner\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/cpanelplesk.com\/wp62\/wp-content\/uploads\/2016\/08\/mysqli-1.jpg\",\"datePublished\":\"2016-11-02T11:14:14+00:00\",\"dateModified\":\"2021-02-02T05:33:20+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/cpanelplesk.com\/wp62\/performance-tuning-script-mysql-mysql-tuner\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/cpanelplesk.com\/wp62\/performance-tuning-script-mysql-mysql-tuner\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/cpanelplesk.com\/wp62\/performance-tuning-script-mysql-mysql-tuner\/#primaryimage\",\"url\":\"https:\/\/cpanelplesk.com\/wp62\/wp-content\/uploads\/2016\/08\/mysqli-1.jpg\",\"contentUrl\":\"https:\/\/cpanelplesk.com\/wp62\/wp-content\/uploads\/2016\/08\/mysqli-1.jpg\",\"width\":225,\"height\":225},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/cpanelplesk.com\/wp62\/performance-tuning-script-mysql-mysql-tuner\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/cpanelplesk.com\/wp62\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Performance tuning script for MySQL \u2013 Mysql Tuner\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/cpanelplesk.com\/wp62\/#website\",\"url\":\"https:\/\/cpanelplesk.com\/wp62\/\",\"name\":\"cPanel Plesk\",\"description\":\"Blog on famous hosting control panels\",\"publisher\":{\"@id\":\"https:\/\/cpanelplesk.com\/wp62\/#\/schema\/person\/c78ae1cf9451a09592fb9697d69c0c13\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/cpanelplesk.com\/wp62\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":[\"Person\",\"Organization\"],\"@id\":\"https:\/\/cpanelplesk.com\/wp62\/#\/schema\/person\/c78ae1cf9451a09592fb9697d69c0c13\",\"name\":\"Farooq Omer\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/cpanelplesk.com\/wp62\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/cpanelplesk.com\/wp62\/wp-content\/uploads\/2020\/11\/cpanelplesk.png\",\"contentUrl\":\"https:\/\/cpanelplesk.com\/wp62\/wp-content\/uploads\/2020\/11\/cpanelplesk.png\",\"width\":300,\"height\":44,\"caption\":\"Farooq Omer\"},\"logo\":{\"@id\":\"https:\/\/cpanelplesk.com\/wp62\/#\/schema\/person\/image\/\"}},{\"@type\":\"Person\",\"@id\":\"https:\/\/cpanelplesk.com\/wp62\/#\/schema\/person\/73d573cc7eaaf6625cf0dbd72191a648\",\"name\":\"Seemab Saleem\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/cpanelplesk.com\/wp62\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/6a87ff2e53b03e6839250e5278a6bd46?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/6a87ff2e53b03e6839250e5278a6bd46?s=96&d=mm&r=g\",\"caption\":\"Seemab Saleem\"},\"description\":\"Linux Server Administrator, Web Hosting engineer. I'm dealing with Linux servers since 2014. I started this blog to share the work i love with the world . let me know if you need any assistance. Thanks!!\",\"sameAs\":[\"https:\/\/cpanelplesk.com\/wp62\"],\"url\":\"https:\/\/cpanelplesk.com\/wp62\/author\/cmb\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Performance tuning script for MySQL \u2013 Mysql Tuner - cPanel Plesk","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/cpanelplesk.com\/wp62\/performance-tuning-script-mysql-mysql-tuner\/","twitter_card":"summary_large_image","twitter_title":"Performance tuning script for MySQL \u2013 Mysql Tuner - cPanel Plesk","twitter_description":"MySQLTuner is a Perl script that analyzes your MySQL performance and, based on the statistics it gathers. MySQL has a lot of variables in its settings. We can modify and set factors to our specifications on our server. [...]Continue Reading...","twitter_image":"https:\/\/cpanelplesk.com\/wp62\/wp-content\/uploads\/2016\/08\/mysqli-1.jpg","twitter_misc":{"Written by":"Seemab Saleem","Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/cpanelplesk.com\/wp62\/performance-tuning-script-mysql-mysql-tuner\/#article","isPartOf":{"@id":"https:\/\/cpanelplesk.com\/wp62\/performance-tuning-script-mysql-mysql-tuner\/"},"author":{"name":"Seemab Saleem","@id":"https:\/\/cpanelplesk.com\/wp62\/#\/schema\/person\/73d573cc7eaaf6625cf0dbd72191a648"},"headline":"Performance tuning script for MySQL \u2013 Mysql Tuner","datePublished":"2016-11-02T11:14:14+00:00","dateModified":"2021-02-02T05:33:20+00:00","mainEntityOfPage":{"@id":"https:\/\/cpanelplesk.com\/wp62\/performance-tuning-script-mysql-mysql-tuner\/"},"wordCount":206,"commentCount":6,"publisher":{"@id":"https:\/\/cpanelplesk.com\/wp62\/#\/schema\/person\/c78ae1cf9451a09592fb9697d69c0c13"},"image":{"@id":"https:\/\/cpanelplesk.com\/wp62\/performance-tuning-script-mysql-mysql-tuner\/#primaryimage"},"thumbnailUrl":"https:\/\/cpanelplesk.com\/wp62\/wp-content\/uploads\/2016\/08\/mysqli-1.jpg","articleSection":["Cpanel","Linux"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/cpanelplesk.com\/wp62\/performance-tuning-script-mysql-mysql-tuner\/","url":"https:\/\/cpanelplesk.com\/wp62\/performance-tuning-script-mysql-mysql-tuner\/","name":"Performance tuning script for MySQL \u2013 Mysql Tuner - cPanel Plesk","isPartOf":{"@id":"https:\/\/cpanelplesk.com\/wp62\/#website"},"primaryImageOfPage":{"@id":"https:\/\/cpanelplesk.com\/wp62\/performance-tuning-script-mysql-mysql-tuner\/#primaryimage"},"image":{"@id":"https:\/\/cpanelplesk.com\/wp62\/performance-tuning-script-mysql-mysql-tuner\/#primaryimage"},"thumbnailUrl":"https:\/\/cpanelplesk.com\/wp62\/wp-content\/uploads\/2016\/08\/mysqli-1.jpg","datePublished":"2016-11-02T11:14:14+00:00","dateModified":"2021-02-02T05:33:20+00:00","breadcrumb":{"@id":"https:\/\/cpanelplesk.com\/wp62\/performance-tuning-script-mysql-mysql-tuner\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/cpanelplesk.com\/wp62\/performance-tuning-script-mysql-mysql-tuner\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/cpanelplesk.com\/wp62\/performance-tuning-script-mysql-mysql-tuner\/#primaryimage","url":"https:\/\/cpanelplesk.com\/wp62\/wp-content\/uploads\/2016\/08\/mysqli-1.jpg","contentUrl":"https:\/\/cpanelplesk.com\/wp62\/wp-content\/uploads\/2016\/08\/mysqli-1.jpg","width":225,"height":225},{"@type":"BreadcrumbList","@id":"https:\/\/cpanelplesk.com\/wp62\/performance-tuning-script-mysql-mysql-tuner\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/cpanelplesk.com\/wp62\/"},{"@type":"ListItem","position":2,"name":"Performance tuning script for MySQL \u2013 Mysql Tuner"}]},{"@type":"WebSite","@id":"https:\/\/cpanelplesk.com\/wp62\/#website","url":"https:\/\/cpanelplesk.com\/wp62\/","name":"cPanel Plesk","description":"Blog on famous hosting control panels","publisher":{"@id":"https:\/\/cpanelplesk.com\/wp62\/#\/schema\/person\/c78ae1cf9451a09592fb9697d69c0c13"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/cpanelplesk.com\/wp62\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":["Person","Organization"],"@id":"https:\/\/cpanelplesk.com\/wp62\/#\/schema\/person\/c78ae1cf9451a09592fb9697d69c0c13","name":"Farooq Omer","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/cpanelplesk.com\/wp62\/#\/schema\/person\/image\/","url":"https:\/\/cpanelplesk.com\/wp62\/wp-content\/uploads\/2020\/11\/cpanelplesk.png","contentUrl":"https:\/\/cpanelplesk.com\/wp62\/wp-content\/uploads\/2020\/11\/cpanelplesk.png","width":300,"height":44,"caption":"Farooq Omer"},"logo":{"@id":"https:\/\/cpanelplesk.com\/wp62\/#\/schema\/person\/image\/"}},{"@type":"Person","@id":"https:\/\/cpanelplesk.com\/wp62\/#\/schema\/person\/73d573cc7eaaf6625cf0dbd72191a648","name":"Seemab Saleem","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/cpanelplesk.com\/wp62\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/6a87ff2e53b03e6839250e5278a6bd46?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/6a87ff2e53b03e6839250e5278a6bd46?s=96&d=mm&r=g","caption":"Seemab Saleem"},"description":"Linux Server Administrator, Web Hosting engineer. I'm dealing with Linux servers since 2014. I started this blog to share the work i love with the world . let me know if you need any assistance. Thanks!!","sameAs":["https:\/\/cpanelplesk.com\/wp62"],"url":"https:\/\/cpanelplesk.com\/wp62\/author\/cmb\/"}]}},"_links":{"self":[{"href":"https:\/\/cpanelplesk.com\/wp62\/wp-json\/wp\/v2\/posts\/5537","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/cpanelplesk.com\/wp62\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/cpanelplesk.com\/wp62\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/cpanelplesk.com\/wp62\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/cpanelplesk.com\/wp62\/wp-json\/wp\/v2\/comments?post=5537"}],"version-history":[{"count":0,"href":"https:\/\/cpanelplesk.com\/wp62\/wp-json\/wp\/v2\/posts\/5537\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/cpanelplesk.com\/wp62\/wp-json\/wp\/v2\/media\/4877"}],"wp:attachment":[{"href":"https:\/\/cpanelplesk.com\/wp62\/wp-json\/wp\/v2\/media?parent=5537"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/cpanelplesk.com\/wp62\/wp-json\/wp\/v2\/categories?post=5537"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/cpanelplesk.com\/wp62\/wp-json\/wp\/v2\/tags?post=5537"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}