This page explains what MySQL Advisor collects and what it does not. The short version: analysis runs on text you paste — no connection to your database is needed or made. One optional feature, the collector, does connect if you explicitly ask it to, using credentials you supply; that is described below. Nothing you paste is stored, and analytics only run after you accept them.
The analyzer
When you paste SHOW GLOBAL VARIABLES, SHOW GLOBAL STATUS, or Percona Toolkit
output, that text is sent to the server, analyzed in memory to produce your report, and then discarded.
It is not written to disk, not shared, and not used to train anything. Analysis itself never opens a
database connection.
The optional collector
Instead of pasting, you can ask MySQL Advisor to fetch the two inputs for you. This is opt-in — it only runs when you fill in the collector form and click Collect Data. When you do:
- The host, username, and password you enter are sent to the MySQL Advisor server over HTTPS. The connection to your database is opened from our server, not from your browser.
- Exactly two statements are run:
SHOW GLOBAL VARIABLESandSHOW GLOBAL STATUS. No writes, no locks, no schema changes, and no table or row data is read. - The credentials are used for that one request and are then discarded. They are never written to disk, never logged, and never emailed. Only the query output is returned to your browser.
- The target must be reachable from the public internet. Private, loopback, and link-local addresses are rejected. To analyze a database on an internal network, paste the output instead.
If you would rather no credentials leave your network at all, use the paste workflow — it produces an identical report.
Analytics and cookies
This site uses Google Analytics 4 to understand how many people visit and which pages are useful. A short cookie notice appears on your first visit. These analytics cookies measure traffic in aggregate and do not identify you personally. You can opt out at any time using your browser's cookie controls or Google's opt-out browser add-on. Your day/night theme preference and the dismissal of the notice are also stored locally in your browser. We do not run advertising and do not sell any data.
API key requests
If you request an API key, the form collects your name, email, organization, and a short description of your use case. This is used only to review the request and, if approved, to email you the key. Disposable email domains are rejected. Requests are kept until they are approved or declined and are periodically purged. The API itself records per-call metadata for rate limiting and abuse prevention (a timestamp, the key's numeric id, the client IP, request size, and response status). It never records the content you submit.
What we never do
- Connect to your database unless you explicitly use the collector — and never to write, lock, or modify anything.
- Read table contents or row data, under any workflow.
- Store the credentials you enter in the collector, or the configuration and status text you paste.
- Sell, rent, or share your data with advertisers.
- Set analytics cookies before you accept them.
Hosting
The site is hosted on Hostinger. Standard server logs may be kept by the host for security and reliability. Email for key requests is sent over authenticated SMTP.
Using this tool
MySQL Advisor is an aid to judgement, not a substitute for it. Its findings come from a fixed set of heuristic rules โ thresholds, version gates and OS hints โ applied to a snapshot of text you paste. It does not see your queries, your data distribution, your access patterns, your hardware under load, or your business constraints. Two servers with identical configuration can need opposite changes.
You are expected to use it with working knowledge of MySQL administration. Specifically:
- Understand every change before you apply it. If a recommendation is not clear to you,
read the linked documentation first. Do not paste a generated
my.cnfinto production. - Test in a non-production environment that resembles production in data volume and workload shape, and validate with your own metrics before and after.
- Follow your own change control. Some suggested settings require a restart; some affect durability, replication behaviour, or crash recovery.
- Treat severities as priorities, not verdicts. A CRITICAL finding may be a deliberate and correct choice for your environment. An absence of findings is not a clean bill of health.
Nothing here creates a support relationship. For production issues, use your database vendor's support channel.
Terms of service
MySQL Advisor is a hosted service operated by its author. By using this site or its API you agree to these terms. If you do not agree, do not use the service.
The service
The service is provided free of charge. No account is required to use the web analyzer. API access requires a key, which is issued at the operator's discretion and may be rate limited, suspended, or revoked at any time. Keys are issued to a person or organisation and must not be shared or resold.
Acceptable use
- Use the service only against database servers you own or are explicitly authorised to assess. If you use the optional collector, you confirm you are permitted to connect to that host and to use the credentials you supply.
- Do not attempt to disrupt, overload, probe, or gain unauthorised access to the service or its infrastructure, and do not circumvent rate limits, the CAPTCHA, or API key checks.
- Do not scrape or automate against the web pages. The API exists for automation; use it instead.
- Do not use the service to build or train a competing dataset or ruleset, or to redistribute its analysis as your own product.
- Do not use the service for anything unlawful.
The operator may block any client or revoke any key for any reason, without notice.
Ownership
Copyright © 2026 Kedar Vaijanapurkar. All rights reserved. The site, its rule engine, its rule content, and its documentation are the property of the author and are not currently released under an open source licence. Nothing on this site grants you a licence to copy, modify, redistribute, or create derivative works from it.
The reports you generate are yours. You may keep, share, publish, or act on the output of your own analysis without restriction or attribution.
No warranty
The service is provided “as is” and “as available”, without warranty of any kind, express or implied, including without limitation any warranty of accuracy, completeness, merchantability, fitness for a particular purpose, or non-infringement. The operator does not warrant that the service will be uninterrupted, error free, or that its recommendations are correct or suitable for your environment.
Limitation of liability
To the fullest extent permitted by law, the operator shall not be liable for any direct, indirect, special, incidental, or consequential damages arising out of your use of, or inability to use, the service โ including loss of data, loss of revenue, loss of goodwill, downtime, or work stoppage โ even if advised of the possibility of such damages. You accept full responsibility for any configuration change you make.
Availability and changes
The service carries no service level agreement. Features may be added, changed, archived, or withdrawn at any time, and the service may be discontinued entirely. These terms may change; the date at the top of this page will be updated when they do, and continued use after a change means you accept it.
Author
MySQL Advisor is written and maintained by Kedar Vaijanapurkar.
The author thanks Percona for fostering a culture of open source and community contribution. That culture is what inspired this project. This is an independent personal project and not endorsed or sponsored by Oracle Corporation, Percona, MariaDB Foundation or MariaDB plc. Opinions and recommendations expressed by the tool are the author's own.
MySQL is a registered trademark of Oracle Corporation. Percona, Percona Server and Percona XtraDB Cluster are trademarks of Percona LLC. MariaDB is a trademark of MariaDB Corporation Ab or MariaDB Foundation. All other trademarks are the property of their respective owners. They are referenced here for identification purposes only.
Contact
Questions about privacy? Email mysql-advisor@nitty-witty.com. If this policy changes, the date above will be updated.