-
- 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)
-
- 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
-
- .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
-
- Checking FQDN, Reverse-DNS/PTR, MX record
- Clients
- DKIM with Postfix
- Postfix Queue Management
- RoundCube
- Server Setup
- 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
-
- 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
- Let's Encrypt with EasyEngine
- Nginx's Open file cache
- Serving fonts with correct mime types
- SSL – PCI compliance and performance optimization
- Troubleshooting
- 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
-
- 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
-
- 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
Last updated on Dec 18, 2020
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!
Comments
I have to do 02 first:
1-/ you have to create a ~/.my.cnf. reference: https://rtcamp.com/tutorials/mysql/mycnf-preference/
2-/ use apt-get install bc
May I know which OS/version you are using? I would like to know which OS does not has
bcpreinstalled.About ~/.my.cnf it is mere convenience part. If that file is not present, you need to specify username and password while running commands.
I am using Ubuntu 12.04 LTS. Your posts is very helpful so I just want to update a little bit
information
Did not get you? What would you like to update?
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
What happens when you run command:
tuning-primer.sh?Ok Understand it started working after quite sometime I think it takes time to load 🙂