+
+

Related Products

  • RaimaDB
    9 Ratings
    Visit Website
  • DbVisualizer
    528 Ratings
    Visit Website
  • Google Cloud SQL
    542 Ratings
    Visit Website
  • Google Cloud Platform
    60,449 Ratings
    Visit Website
  • KrakenD
    71 Ratings
    Visit Website
  • TeamDesk
    92 Ratings
    Visit Website
  • MongoDB Atlas
    1,648 Ratings
    Visit Website
  • Google Cloud BigQuery
    1,934 Ratings
    Visit Website
  • Retool
    567 Ratings
    Visit Website
  • ToucanTech
    174 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

PawSQL integrates the best practices of query optimization in database industry, provides advanced SQL rewrite optimization, and sophisticate index recommendation capabilities for slow queries. Based on the professional PawSQL optimization engine (used by more than 10,000 database practitioners around the world), it provides rich SQL optimization suggestions and intelligent index recommendations. PawSQL provides a comprehensive and balanced audit rule set for multiple databases such as MySQL, PostgreSQL, openGauss, Oracle, etc., providing enterprises with a consistent audit experience no matter how diverse their database environment is. Rule-based SQL review, covering potential correctness and performance optimization issues. Rich rewrite optimization, recommending semantically equivalent but more efficient SQL queries. Cost-based verification ensures that new solutions based on SQL rewrite and index recommendation have better performance. Intelligent index recommendation.

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

Individuals looking for query optimization in database industry, advanced SQL rewrite optimization, and sophisticate index recommendation capabilities for slow queries

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

No information available.
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 5.0 / 5
ease 5.0 / 5
features 5.0 / 5
design 4.0 / 5
support 3.0 / 5

Training

Documentation
Webinars
Live Online
In Person

Training

Documentation
Webinars
Live Online
In Person

Company Information

MySQLTuner
github.com/major/MySQLTuner-perl

Company Information

PawSQL
Founded: 2024
China
www.pawsql.com

Alternatives

Alternatives

SQL Query Tuner

SQL Query Tuner

IDERA, an Idera, Inc. company

Categories

Categories

Integrations

MariaDB
MySQL
DataGrip
Oracle Database
Perl
PostgreSQL
SQL

Integrations

MariaDB
MySQL
DataGrip
Oracle Database
Perl
PostgreSQL
SQL
Claim MySQLTuner and update features and information
Claim MySQLTuner and update features and information
Claim PawSQL and update features and information
Claim PawSQL and update features and information