• Home
  • WordPress
  • web Hosting
    • Free hosting
    • Cheap Hosting
    • comparison cloud , vps, shared, wordpress
    • managed wordpress hosting
    • managed cloud hosting
  • page Speed
  • Deals
  • Services
  • About

RAaz Kumar .com

wordpress tutorials seo hosting etc


mysqltuner installation suggestions

Tune automatically by mysql tuner

official website https://github.com/major/MySQLTuner-perl

 

mysql tuner Installation

  1. Download the MySQLTuner script:
     wget https://raw.githubusercontent.com/major/MySQLTuner-perl/master/mysqltuner.pl
    
  2. Change the scripts permissions to be executable:
     chmod +x mysqltuner.pl
    
  3. Run the mysqltuner.pl script. You will be prompted to enter in your MySQL administrative login and password:
     ./mysqltuner.pl
    
  4. The script will return results similar to the output below:

root@localhost:/# ./mysqltuner.pl
>> MySQLTuner 1.9.4
* Jean-Marie Renouard <jmrenouard@gmail.com>
* Major Hayden <major@mhtx.net>
>> Bug reports, feature requests, and downloads at http://mysqltuner.pl/
>> Run with ‘–help’ for additional options and output filtering

 

[–] Skipped version check for MySQLTuner script
Please enter your MySQL administrative login: root
Please enter your MySQL administrative password: [OK] Currently running supported MySQL version 8.0.25
[OK] Operating on 64-bit architecture

——– Log file Recommendations ———————————————- ——————–

[OK] Log file /var/lib/mysql/localhost.err exists
[–] Log file: /var/lib/mysql/localhost.err(3K)
[OK] Log file /var/lib/mysql/localhost.err is not empty
[OK] Log file /var/lib/mysql/localhost.err is smaller than 32 Mb
[OK] Log file /var/lib/mysql/localhost.err is readable.
[!!] /var/lib/mysql/localhost.err contains 7 warning(s).
[OK] /var/lib/mysql/localhost.err doesn’t contain any error.
[–] 4 start(s) detected in /var/lib/mysql/localhost.err
[–] 1) 2021-06-01T07:00:43.413030Z 0 [System] [MY-010931] [Server] /usr/sbin/my sqld: ready for connections. Version: ‘8.0.25’ socket: ‘/var/run/mysqld/mysqld. sock’ port: 0 MySQL Community Server – GPL.
[–] 2) 2021-06-01T07:00:43.208875Z 0 [System] [MY-011323] [Server] X Plugin rea dy for connections. Socket: /var/run/mysqld/mysqlx.sock
[–] 3) 2021-06-01T06:35:03.850014Z 0 [System] [MY-010931] [Server] /usr/sbin/my sqld: ready for connections. Version: ‘8.0.25’ socket: ‘/var/run/mysqld/mysqld. sock’ port: 0 MySQL Community Server – GPL.
[–] 4) 2021-06-01T06:35:03.586233Z 0 [System] [MY-011323] [Server] X Plugin rea dy for connections. Socket: /var/run/mysqld/mysqlx.sock
[–] 2 shutdown(s) detected in /var/lib/mysql/localhost.err
[–] 1) 2021-06-01T07:08:42.473166Z 0 [System] [MY-010910] [Server] /usr/sbin/my sqld: Shutdown complete (mysqld 8.0.25) MySQL Community Server – GPL.
[–] 2) 2021-06-01T06:58:59.012396Z 0 [System] [MY-010910] [Server] /usr/sbin/my sqld: Shutdown complete (mysqld 8.0.25) MySQL Community Server – GPL.

——– Storage Engine Statistics ——————————————— ——————–

[–] Status: +ARCHIVE +BLACKHOLE +CSV -FEDERATED +InnoDB +MEMORY +MRG_MYISAM +My ISAM +PERFORMANCE_SCHEMA
[–] Data in MyISAM tables: 79.1M (Tables: 38)
[–] Data in InnoDB tables: 624.2M (Tables: 629)
[OK] Total fragmented tables: 0

——– Analysis Performance Metrics —————————————— ——————–

[–] innodb_stats_on_metadata: OFF
[OK] No stat updates during querying INFORMATION_SCHEMA.

——– Views Metrics ——————————————————— ——————–

——– Triggers Metrics —————————————————— ——————–

——– Routines Metrics —————————————————— ——————–

——– Security Recommendations ———————————————- ——————–
[–] Skipped due to unsupported feature for MySQL 8

——– CVE Security Recommendations —————————————— ——————–

[OK] NO SECURITY CVE FOUND FOR YOUR VERSION

——– Performance Metrics ————————————————— ——————–

[–] Up for: 1h 0m 21s (184K q [50.977 qps], 1K conn, TX: 31G, RX: 108M)
[–] Reads / Writes: 95% / 5%
[–] Binary logging is enabled (GTID MODE: OFF)
[–] Physical Memory : 7.8G
[–] Max MySQL memory : 9.8G
[–] Other process memory: 0B
[–] Total buffers: 168.0M global + 65.1M per thread (151 max threads)
[–] P_S Max memory usage: 72B
[–] Galera GCache Max memory usage: 0B
[OK] Maximum reached memory usage: 689.2M (8.66% of installed RAM)
[!!] Maximum possible memory usage: 9.8G (125.74% of installed RAM)
[!!] Overall possible memory usage with other process exceeded memory
[OK] Slow queries: 0% (0/184K)
[OK] Highest usage of available connections: 5% (8/151)
[OK] Aborted connections: 0.17% (3/1761)
[!!] name resolution is active : a reverse name resolution is made for each new connection and can reduce performance
[–] Query cache have been removed in MySQL 8
[OK] Sorts requiring temporary tables: 3% (921 temp sorts / 28K sorts)
[OK] No joins without indexes
[OK] Temporary tables created on disk: 0% (0 on disk / 5K total)
[OK] Thread cache hit rate: 99% (8 created / 1K connections)
[OK] Table cache hit rate: 98% (242K hits / 245K requests)
[OK] table_definition_cache(2000) is upper than number of tables(991)
[OK] Open file limit used: 0% (169/30K)
[OK] Table locks acquired immediately: 100% (2K immediate / 2K locks)
[OK] Binlog cache memory access: 99.05% (5853 Memory / 5909 Total)

——– Performance schema —————————————————- ——————–

[–] Performance_schema is activated.
[–] Memory used by P_S: 72B
[–] Sys schema is installed.

——– ThreadPool Metrics —————————————————- ——————–
[–] ThreadPool stat is disabled.

——– MyISAM Metrics ——————————————————– ——————–
[–] MyISAM Metrics are disabled on last MySQL versions.

——– InnoDB Metrics ——————————————————– ——————–
[–] InnoDB is enabled.
[–] InnoDB Thread Concurrency: 0
[OK] InnoDB File per table is activated
[!!] InnoDB buffer pool / data size: 128.0M/624.2M
[!!] Ratio InnoDB log file size / InnoDB Buffer pool size (75 %): 48.0M * 2/128. 0M should be equal to 25%
[OK] InnoDB buffer pool instances: 1
[–] Number of InnoDB Buffer Pool Chunk : 1 for 1 Buffer Pool Instance(s)
[OK] Innodb_buffer_pool_size aligned with Innodb_buffer_pool_chunk_size & Innodb _buffer_pool_instances
[OK] InnoDB Read buffer efficiency: 99.88% (190217499 hits/ 190436985 total)
[!!] InnoDB Write Log efficiency: 60.73% (47529 hits/ 78265 total)
[OK] InnoDB log waits: 0.00% (0 waits / 30736 writes)

——– Aria Metrics ———————————————————- ——————–
[–] Aria Storage Engine not available.

——– TokuDB Metrics ——————————————————– ——————–
[–] TokuDB is disabled.

——– XtraDB Metrics ——————————————————– ——————–
[–] XtraDB is disabled.

——– Galera Metrics ——————————————————– ——————–
[–] Galera is disabled.

——– Replication Metrics ————————————————— ——————–
[–] Galera Synchronous replication: NO
[–] No replication slave(s) for this server.
[–] Binlog format: ROW
[–] XA support enabled: ON
[–] Semi synchronous replication Master: Not Activated
[–] Semi synchronous replication Slave: Not Activated
[–] This is a standalone server

——– Recommendations ——————————————————- ——————–

General recommendations:
Check warning line(s) in /var/lib/mysql/localhost.err file
MySQL was started within the last 24 hours – recommendations may be inaccura te
Reduce your overall MySQL memory footprint for system stability
Dedicate this server to your database for highest performance.
Configure your accounts with ip or subnets only, then update your configurat ion with skip-name-resolve=1
Before changing innodb_log_file_size and/or innodb_log_files_in_group read t his: https://bit.ly/2TcGgtU
Variables to adjust:
*** MySQL’s maximum memory usage is dangerously high ***
*** Add RAM before increasing MySQL buffer variables ***   //mysql memory usage
innodb_buffer_pool_size (>= 624.2M) if possible.
innodb_log_file_size should be (=16M) if possible, so InnoDB total log files size equals to 25% of buffer pool size.
root@localhost:/#

 

 

Related topics:

  1. Innodb vs myisam (table engines row lock vs table lock)
  2. MySQL innodb memory allocation & usage calculation
  3. datadog nginx integration installation process
  4. MySQL query cache vs redis vs memcached buffer pool database cache
  5. mysql configuration file location linux , windows , mac

tutorials

  • Vivek Bindra Videos Transcription (business strategy)
  • git commands
  • new relic php agent install in 3 steps
  • new relic mysql install integration - 2 ways fix problems
  • new relic installation linux (infrastructure agent , php, mysql , nginx)
  • xampp tutorials 2021 installation errors fix wordpress phpmyadmin mysql apache
  • Redis performance metrics & tuning for nginx apache ubuntu & debian
  • Devops course Syllabus topics PDF AWS, Azure, cisco, redhat
  • CCNA Syllabus pdf (CCNA / CCNP vs devops vs mcsa /MCSE)
  • how to create a website free of cost on google
  • what is vpn vs proxy vs tor, http vs https, http2, tcp vs udp, kali linux sql source code injection
  • nginx server tutorials (installation, configuration, performance tuning, security)
  • MySQL Tutorial (create,connect database, update tables, export etc) Documentation & TIPS
    • mysql 8 installation on ubuntu 20.4
    • mysql auto backup ubuntu 22.04 using automysqlbackup
    • mysqltuner installation suggestions
    • mysql memory limit setting increase or decrease allocation
    • mysql open_files_limit increase to raise open file cache table definition cache
    • mysql restart ubuntu status start stop in linux windows reload
    • monitoring mysql with new relic
    • mysql access denied for user 'root'@'localhost' (using password yes) no Error 1045
    • mysql slow query log enable disable set query time ideal mysql long query time
    • mysql user creation, password , grant permissions user management guide
    • mysql root password change reset update set A-Z info
    • mysql configuration file location linux , windows , mac
    • mysqldump import /export mysql database command line, phpmyadmin, Cpanel, mysql workbench, xamp
    • MySQL query cache vs redis vs memcached buffer pool database cache
    • MySQL innodb memory allocation & usage calculation
    • mysql max connections limit check increase how to decide thread cache size
    • Innodb vs myisam (table engines row lock vs table lock)
    • mysql errors
    • mysql workbench tutorials (Sql Development , modelling, server admin export & import)
    • How measure & adjust mysql buffer pool size by pages, read requests etc
    • improve mysql performance wordpress my.cnf file configuration
    • phpmyadmin install / configure on nginx ubuntu 20.04 apache2 debian 10
    • mysql commands
  • AUdio Editing Background Noise removal (Audacity, Adobe Premiere Addition, Camtasia Filmora Windows Obs)
  • Android Studio tutorials syllabus Topics Course details #AndroidApplicationDevelopment
  • [INTRO] Ethical hacking / cyber Security / Penetration testing Tutorial -{updates frequently}
  • redis install ubuntu 20.04 with wordpress php redis mysql configuration
  • ubuntu tutorials installation download issues etc
  • Php tutorials
  • HTML & CSS Tutorials
  • Core Java Tutorial Free online
  • Linux sysadmin tutorials linux system administrator
  • apache server tutorial (install,config, performance tuning, security, error handling)

 

 

wordpress Pagespeed optimization

Digitalocean free $100 Credit

Cloudways Review pricing promo codes

Siteground cpu limits Pricing

Shared Hosting

Managed wordpress Hosting

Managed Hosting Cloud server

VPS Hosting

Cloud Hosting – Unmanaged

Google cloud Pricing

Aws Pricing

Azure pricing

nginx server tutorials

apache server tutorials

linux sysadmin tutorials

mysql Commands list pdf

LEMP Install Ubuntu

Mysql Performance Tuning

Nginx Performance tuning

Linux Performance tuning

Php -fpm performance tuning

Redis Performance tuning

linux server security

nginx security best practices

wordpress security plugins

 

 

wordpress

 

Top 5  WP Google Analytics Plugins

WP Backup Plugins

Wp Comment Plugins

Top wordpress Security Plugins

WP Seo Plugins

WP Caching Plugins

Best Adsense Plugins for WordPress

Wp social Sharing Plugins

autoshare social media plugins

WP speed Optimization Plugins

Speedup WordPress google Score

More Wp tuts

Server Admin Cloud

 

Installing Nginx LEMP On ubuntu

Installing apache Lamp ubuntu

nginx fastcgi cache enable

php – fpm install  & Configuration

Opcache install & Configure

php -fpm pool manager explained

Mysql Install & Configuration

Redis Object cache install & configure

 

Nginx as Reverse Proxy and Load balancer

Load Balance / auto scaling in google cloud

Linux Commands PDF

Mysql Commands Pdf

Letsencrypt tutorial

mysqldump export & import 

Pagespeed Module install & configure

nginx.conf best file

mysql.conf best file

upgrade ubuntu

© 2023 - All Rights Reserved Disclaimer & Privacy Policy