FeaturesWP CloudPricingEE CLIContactMy Account

Features

Team Access & User Permissions

Server Setup & Management

Site Creation & Management

Deployments & Developer Tools

Firewall Protection

Speed & Caching

Backups & Recovery

Logs & Monitoring

Create WP Cloud Sites

All Features

Read Documentation

Install

Installation Guide

FAQ

Roadmap

Explore EE CLI

Resources

Commands

Handbook

Blog

Community

Forum

EasyExperts

Tutorials

Subscribe

Github

CLEAR

Start For Free

Tutorials Mysql tuning-primer.sh – an alternative for mysqltuner

Topics

On this page

• Amazon AWS

  • Amazon ELB and multi-domain SAN/SSL Setup
  • Auto Scaling
  • Change Instance Type in AutoScaling

• Backup

  • Duplicity + Amazon S3

• Benchmark

  • apachebench
  • httperf
  • Siege

• CDN

  • Amazon Cloudfront CDN with W3 Total Cache WordPress
  • CDN.NET Configuration with W3 Total Cache Wordpress
  • CDN77 Configuration with W3 Total Cache WordPress

• Composer and WordPress

  • Getting Started
  • Git and File-System Layout (non-default setup)
  • Version Constraints
  • Managing Themes and Plugins (for entire WordPress site)
  • Updating Themes and Plugins (for entire WordPress site)
  • Adding Composer Support to Your Own Themes and Plugins (for developers)
  • Using Composer to Manage Own Theme/Plugin Dependencies (for developers)

• Docker and WordPress [WIP]

  • Kubernetes

    • WordPress with Kubernetes using Minikube and Helm on localhost (MacOS)

• Git

  • Git – Resolve Merge Conflicts
  • First time Git setup
  • Forking the Git
  • Mandatory stages in Git

• Gitlab

  • Gitlab-CE
  • gitlab-ci-multi-runner

• KVM

  • Convert qcow2 to raw format
  • Enable virtio for existing VM's

• Mac

  • Brew'ing PHP, MySQL & Nginx on Mac OS X

• Monitoring

  • Latest Monit setup on Ubuntu
  • NewRelic Setup for Ubuntu Server with PHP, FPM, Nginx and MySQL

• node.js

  • Installing ghost with nginx proxy-cache
  • Latest node.js & npm installation on Ubuntu 12.04

• Plesk

  • List Mailboxes Storage and Passwords

• Redis

• Standards

  • PHP

    • Code Sniffer

• Vagrant

• wpcli

  • Finding a faulty plugin
  • wp profile command

• Linux

  • Assigning Multiple IP Addresses to Single LAN Card
  • Disable IPv6 on Ubuntu 12.04
  • dsh – distributed shell
  • fdupes – find & replace duplicate files with hardlinks
  • GPG Keys Cheatsheet
  • Increase "Open Files Limit"
  • kill all php, nginx, mysql or any kind of processes
  • Passwordless Authentication for SSH
  • Screen
  • search replace in multiple files useing grep xargs sed
  • Setup sftp
  • sysctl.conf
  • Timezone Sync
  • Using Google Public DNS on Ubuntu Server
  • Using openssl to match private key, cerificate and CSR
  • Configure Postfix to Use Gmail SMTP on Ubuntu
  • Logrotate Example for Custom Logs
  • PHP 5.5, MySQL, Postfix, Nginx and WordPress on Ubuntu
  • Serverdensity
  • Upgrade Ubuntu 10.04 to 12.04
  • Using find and sed to replace strings in multiple files
  • Webmin

• Apache – Turn On/Off Directory Listing

• Enabling FastCGI on MediaTemple

• Manage SVN Users with htpasswd

• Mysql

  • .my.cnf – mysql user & password
  • Analyse slow-query-log using Anemometer
  • Improving MySQL Query Cache
  • MySQL Query Profiling
  • Reset MySQL root password
  • tuning-primer.sh – an alternative for mysqltuner
  • Using MariaDB 10
  • Install/Upgrade to MySQL 5.6 on Ubuntu 12.04 LTS
  • Change WordPress Domain Name
  • Character Sets and Collations
  • Enable innodb_file_per_table
  • Enable Remote Access (Grant)
  • Installing Percona Toolkit
  • Using tmpfs for temporary folder creation
  • YARPP and InnoDB
  • Convert MyISAM to InnoDB
  • Using tmpfs for mysqldump & mysqlimport
  • Convert from INNODB to MYISAM
  • Analyse slow-query-log using mysqldumpslow & pt-query-digest
  • mysqlcheck with cron to optimize automatically
  • Using MySQLTuner to Optimize MySQL configuration

• Emails

  • Checking FQDN, Reverse-DNS/PTR, MX record

  • Clients

    • Apple Mail
    • Mozilla Thunderbird

  • DKIM with Postfix

  • Postfix Queue Management

  • RoundCube

    • Forwarding all mails to other email id

  • Server Setup

    • Packages & Conventions

    • Postfix, Dovecot, ViMbAdmin, RoundCube

    • Amavis, Spamassassin & ClamAV Setup

    • Sieve Mail Filtering Setup

    • Mail-Server Testing

      • Antivirus Tests
      • IMAP Tests
      • POP Tests
      • SMTP Tests
      • Spam Tests

    • Mailserver Port Numbers

  • Setup OpenDKIM

  • SPF Records

  • swaks – SMTP test tool

  • Using larch for mail transfer between imap/gmail servers

  • Debugging Postfix Config, Mail Logs & more

  • Increasing Attachment Size in Posfix

• Nginx

  • Adding $upstream_cache_status in HTTP Response Headers

  • Amazon Elastic Load Balancer and Forwarding Real-IP Nginx

  • Block wp-login.php bruteforce attack

  • Configuring HTTP/2 Server Push

  • Enable gzip compression

  • fail2ban

  • Filter query string for Redis-Nginx cache

  • Let's Encrypt with EasyEngine

  • Nginx's Open file cache

  • Serving fonts with correct mime types

  • SSL – PCI compliance and performance optimization

  • Troubleshooting

    • Error: pcre_compile() failed: unrecognized character after
    • [emerg]: bind() to 0.0.0.0:80 failed (98: Address already in use)

  • Tweaking fastcgi-buffers

  • Using $upstream_cache_status in access.log

  • Using Pagespeed

  • Weak Diffie Hellman Logjam Attack Fix

  • Website access restriction using nginx

  • Enable Nginx Status Page

  • Forwarding Visitor's Real-IP + Nginx Proxy/Fastcgi backend correctly

  • Parsing access.log and error.logs using linux commands

  • Debugging Nginx Configuration

  • Nginx config for www to non-www and non-www to www redirection

  • Optimizing Nginx Configuration

  • Rewrite Rules for vBulletin SEO-friendly permalinks

• PHP

  • Directly connect to PHP-FPM
  • Generating core-dump for php5-fpm
  • GeoIP
  • Having php5 and php7 on same system.
  • Install Xdebug and configure it with webgrind
  • Installation of PHP Code Review Tools
  • memcache
  • PHP's Zend Opcache Config & Web Viewer
  • Setting Sqlite support with PHP
  • Using HHVM with PHP-FPM Fallback
  • Using Redis for PHP Sessions on Ubuntu Server
  • Installing PhpMyAdmin Quickly
  • Moving PHP's session storage to tmpfs
  • Install Xdebug and configure it with Netbeans
  • Nginx – Enable PHP-FPM Status Page
  • PHP-FPM: Socket vs TCP/IP and sysctl tweaking
  • APC Cache Optimization & Monitoring Using Web Interface
  • Checking if PHP/WordPress can send mails
  • Debugging PHP Scripts Using slow_log and more
  • Increase file upload size limit in PHP-Nginx
  • Increase PHP script execution time with Nginx

• ActiveCollab with Nginx + APC Cache

• WordPress

  • Performance Optimization
  • Remove Query string of css/js files
  • Setup ElasticSearch with ElasticPress
  • Using Redis for WordPress Object-Cache
  • WooCommerce Window Shopping Caching Technique
  • Moving WordPress To New Server (Faster)
  • Better wp-cron using linux's crontab
  • 404 error- Page not Found!!!
  • Debugging WordPress with Nginx

Insatllation

Running

tuning-primer.sh – an alternative for mysqltuner

We are recently using tuning-primer.sh and finding it is better than mysqltuner.

Insatllation

			cd /usr/local/bin
wget https://launchpadlibrarian.net/78745738/tuning-primer.sh
chmod u+x tuning-primer.sh
		

mysqltuner looks like giving wrong suggestions sometimes. Also its not mysql 5.6 ready something which we are using everywhere.

Running

			tuning-primer.sh
		

For example, mysqltuner on mysql 5.6 ask us to change value of table_cache variable. It is renamed to table_open_cache. So following mysqltuner suggestion blindly can be risky sometimes.

Though, both are good tools. Use both!

Reset MySQL root password

PREVIOUS

Using MariaDB 10

NEXT

Comments

1. 

   Pete

   February 5, 2014

   I have to do 02 first:
   1-/ you have to create a ~/.my.cnf. reference: External link to rtcamp.comhttps://rtcamp.com/tutorials/mysql/mycnf-preference/
   2-/ use apt-get install bc

   1. 

      Rahul Bansal

      February 5, 2014

      May I know which OS/version you are using? I would like to know which OS does not has bc preinstalled.

      About ~/.my.cnf it is mere convenience part. If that file is not present, you need to specify username and password while running commands.

      1. 

         Pete

         February 8, 2014

         I am using Ubuntu 12.04 LTS. Your posts is very helpful so I just want to update a little bit
         information

         1. 

            Rahul Bansal

            February 8, 2014

            Did not get you? What would you like to update?

2. 

   Sujoy Dhar

   February 17, 2014

   Brother Rahul I have done the following commands that you mentioned about in my server but I am not getting any result output so can you tell me how to use this one ?

   Thank You,
   Sujoy

   1. 

      Rahul Bansal

      February 17, 2014

      What happens when you run command: tuning-primer.sh ?

      1. 

         Sujoy Dhar

         March 1, 2014

         Ok Understand it started working after quite sometime I think it takes time to load 🙂

Features

• Server Setup & Management
• Site Creation & Management
• Create WP Cloud Sites
• Speed & Caching
• Firewall Protection
• Backups & Recovery
• Logs & Monitoring
• Deployments & Developer Tools
• Team Access & User Permissions

Useful Links

• EE Dashboard Docs
• My Account
• Blog
• Contact
• About

Product

• EE Dashboard
• EE CLI (OpenSource)

Other Products

• GoDAM

Subscribe for curated product updates, tips, and announcements.

"*" indicates required fields

Instagram

This field is for validation purposes and should be left unchanged.

Email*

SIGN ME UP

Δ

© rtCamp, since 2009. All rights reserved.

• T&Cs
• Refund Policy
• Support Policy
• Terms of Use & Privacy Policy

Powered by