Why use mytune
- Config for your hardware. Enter RAM, CPU, storage and workload profile to get
innodb_buffer_pool_size,sort_buffer_size, InnoDB redo and I/O settings. - Diff and risks. Paste
SHOW VARIABLESor your current conf to see gaps versus the recommendation and short risk notes. - Multiple export formats.
my.cnf,SET GLOBAL / SET PERSISTand Docker-c; managed platforms filter unsafe parameters. - Hints from stats. Run the provided
status_*SQL, paste the result — the tool suggests workload profile and data size. - Browser only. No server and no API — parameters never leave your device. Free, in 37 languages, with a shareable link.
- Pooler, presets and IaC (0.4). ProxySQL modes, AWS/Yandex presets, Orchestrator and Ansible export, deeper
status(statements/io) — all in the browser.
How to tune MySQL
- Choose the MySQL version, operating system and workload profile.
- Enter total RAM and its unit, plus CPU cores and max connections if you know them.
- Optionally paste stats SQL output or your current conf for comparison.
- Press Generate, pick an export format, then apply the snippet on the server or in a managed console.
About the generated settings
The result is a starting point based on well-known heuristics for memory, InnoDB redo, I/O and session buffers. It does not replace load testing and monitoring on your own data.
Tips:
- Settings that need a restart are marked with a separate badge.
sort_buffer_sizeapplies per operation, not per connection — a complex query can use it several times.- For many clients, use a pooler such as ProxySQL instead of raising
max_connections. - On Linux with
innodb_buffer_pool_sizeof 2 GB or more, enable huge pages. - After the change, check
EXPLAIN (ANALYZE, BUFFERS)andperformance_schema, change parameters in groups and keep the previous config.
What mytune is for
- getting a sensible starting config for a new MySQL server;
- recalculating settings after adding RAM or CPU or upgrading the major version;
- comparing profiles (web, OLTP, analytics) on the same hardware;
- explaining parameter choices in a review or runbook.
FAQ
Does mytune send my parameters to a server?
No. All calculations run in your browser and there is no API.
Which MySQL versions are supported?
MySQL 8.0 / 8.4 / 9.0, MariaDB 10.11 / 11.4. The set of parameters and their values depends on the selected version.
Can I paste the result straight into production?
Treat it as a starting point. Review the warnings, apply it on a test instance and watch metrics under real load.
Why is max_connections low even for a large database?
Every connection costs memory and sort_buffer_size is divided among them. A pooler such as ProxySQL is usually better than thousands of direct connections.
What if I do not know the CPU count or connections?
Leave the fields empty: values are picked from the profile and RAM, and the assumed number of connections is shown in the result.
Can mytune compare my current config and export SET GLOBAL / SET PERSIST or Docker flags?
Yes. Paste your current my.cnf or SHOW VARIABLES output to get a diff and risk notes. The result can be exported as my.cnf, SET GLOBAL / SET PERSIST statements or Docker -c flags; for managed platforms (RDS, Aurora, Cloud SQL, Azure, Yandex) parameters you cannot change are filtered out. You can also paste status output for optional hints. Everything is processed in the browser.
How does the host collector script (curl one-liner) work?
It runs on your own machine, reads RAM, CPU and MySQL settings locally and prints a mytune link with query parameters. Nothing is uploaded to mytune servers; you open the link yourself.
What are the “Human TZ” and “AI-agent TZ” download buttons?
They export the current setup as a brief. Human TZ is a readable task brief for a DBA; AI-agent TZ is a structured brief that an LLM agent can follow to apply the change.
Why does Docker Compose use command: -c instead of environment variables?
The official mysql image does not map MySQL parameters (system variabless) from environment variables, so values such as innodb_buffer_pool_size must be passed as -c name=value flags in command.
What are memory headroom and the MySQL RAM percent for?
They set what share of host RAM MySQL may use. Keep it below 100% when the host also runs an app, Redis or monitoring, or has a cgroup/Kubernetes memory limit; the memory budget bar shows the result.
Can I use this with MySQL Operator / Helm?
Yes. The Helm / Operator tab exports the parameters as values for a Helm chart or as mysql.parameters of a MySQL Operator Cluster. Check the key names for your chart and try it on a test cluster first.
Does the share link include the pasted conf or stats?
No. The link contains only the form query parameters (version, OS, profile, RAM, CPU and so on). Pasted configs, SHOW VARIABLES output and stats stay in your browser.