+
+

Related Products

  • DbVisualizer
    541 Ratings
    Visit Website
  • RaimaDB
    10 Ratings
    Visit Website
  • Google Cloud SQL
    543 Ratings
    Visit Website
  • Google Cloud Platform
    60,456 Ratings
    Visit Website
  • KrakenD
    71 Ratings
    Visit Website
  • TeamDesk
    92 Ratings
    Visit Website
  • MongoDB Atlas
    1,649 Ratings
    Visit Website
  • Google Cloud BigQuery
    1,939 Ratings
    Visit Website
  • Retool
    566 Ratings
    Visit Website
  • ToucanTech
    175 Ratings
    Visit Website

About

MySQLTuner is a lightweight, Perl-based script designed to assist database administrators in optimizing the performance and configuration of MySQL and MariaDB databases. It analyzes key metrics and parameters related to system performance, security, and resource usage, providing actionable recommendations for improvement. By examining the current workload, cache efficiency, query performance, and memory usage, MySQLTuner identifies potential bottlenecks and suggests adjustments to configuration files. It is particularly valuable for ongoing maintenance, as it highlights issues such as inefficient indexes, excessive temporary tables, or suboptimal query caching. MySQLTuner is widely used by database administrators to ensure optimal performance, reduce system overhead, and maintain a healthy, efficient database environment.

About

Deliver consistent database performance and availability through intelligent tuning advisors and continuous database profiling. Drill down into detailed per-query statistics and benefit from insights into your query performance history to detect slow queries. Automatically collect your plans and get detailed insights based on query plans gathered from your database. Understand why a query is slow and get tuning recommendations on how to make the query faster. Identify slowdowns for specific queries over time, I/O vs CPU time spent, and buffer cache hit ratio for each query. Automatically detects missing indexes and recommends single and multi-column indexes that improve query performance across your databases. Provides per-table recommendations for auto vacuum settings to optimize table bloat, freezing, VACUUM performance, and more. Discover effective config settings tailored to your database workload that enable you to achieve consistent Postgres performance and availability.

Platforms Supported

Windows
Mac
Linux
Cloud
On-Premises
iPhone
iPad
Android
Chromebook

Platforms Supported

Windows
Mac
Linux
Cloud
On-Premises
iPhone
iPad
Android
Chromebook

Audience

Database administrators

Audience

Enterprises in search of a solution to manage and monitor their production databases

Support

Phone Support
24/7 Live Support
Online

Support

Phone Support
24/7 Live Support
Online

API

Offers API

API

Offers API

Screenshots and Videos

Screenshots and Videos

Pricing

Free
Free Version
Free Trial

Pricing

$149 per month
Free Version
Free Trial

Reviews/Ratings

Overall 0.0 / 5
ease 0.0 / 5
features 0.0 / 5
design 0.0 / 5
support 0.0 / 5

This software hasn't been reviewed yet. Be the first to provide a review:

Review this Software

Reviews/Ratings

Overall 0.0 / 5
ease 0.0 / 5
features 0.0 / 5
design 0.0 / 5
support 0.0 / 5

This software hasn't been reviewed yet. Be the first to provide a review:

Review this Software

Training

Documentation
Webinars
Live Online
In Person

Training

Documentation
Webinars
Live Online
In Person

Company Information

MySQLTuner
github.com/major/MySQLTuner-perl

Company Information

pganalyze
Founded: 2012
United States
pganalyze.com

Alternatives

Alternatives

SQL Workload Analysis

SQL Workload Analysis

IDERA, an Idera, Inc. company

Categories

Categories

Integrations

Active Directory
Amazon Web Services (AWS)
Docker
Google Apps Script
Google Cloud Platform
LDAP Admin Tool
MariaDB
Microsoft Azure
MySQL
Okta
Perl
PostgreSQL
SQL

Integrations

Active Directory
Amazon Web Services (AWS)
Docker
Google Apps Script
Google Cloud Platform
LDAP Admin Tool
MariaDB
Microsoft Azure
MySQL
Okta
Perl
PostgreSQL
SQL
Claim MySQLTuner and update features and information
Claim MySQLTuner and update features and information
Claim pganalyze and update features and information
Claim pganalyze and update features and information