Skip to content

Releases: major/MySQLTuner-perl

February 2024 release

06 Feb 17:14
7ffd825
Compare
Choose a tag to compare

commit 4fdd801
Author: Jean-Marie Renouard jmrenouard@gmail.com
Date: Tue Feb 6 18:00:04 2024 +0100

Generate CVE list at 2024-02-06T17:59:02+01:00

commit dd2ed72
Author: Jean-Marie Renouard jmrenouard@gmail.com
Date: Tue Feb 6 17:58:57 2024 +0100

Indenting mysqltuner at 2024-02-06T17:58:52+01:00

commit 30d1d9e
Author: Jean-Marie Renouard jmrenouard@gmail.com
Date: Tue Feb 6 17:58:35 2024 +0100

Generate 2.5.2 sub version at 2024-02-06T17:58:35+01:00

commit b3a7765
Author: Jean-Marie Renouard jmrenouard@gmail.com
Date: Sun Feb 4 00:34:49 2024 +0100

Two separate garb install script with or without SSL

commit 27525ca
Author: Jean-Marie Renouard jmrenouard@gmail.com
Date: Sun Feb 4 00:31:54 2024 +0100

Fix issue in Buffer Pool instead of Log Buffer Pool

commit 65b1c13
Author: Jean-Marie Renouard jmrenouard@gmail.com
Date: Thu Jan 18 05:38:00 2024 +0100

#741 false positive in log error detection

commit 56d16e1
Merge: 3fd633b b608da0
Author: Jean-Marie Renouard jmrenouard@gmail.com
Date: Wed Jan 17 18:35:27 2024 +0100

Merge pull request #745 from FabioPedretti/master

Enable color by default when running on a terminal

commit b608da0
Author: Fabio Pedretti pedretti.fabio@gmail.com
Date: Thu Jan 11 11:27:25 2024 +0100

Enable color by default when running on a terminal

commit 3fd633b
Author: Jean-Marie Renouard jmrenouard@gmail.com
Date: Fri Dec 1 00:46:15 2023 +0100

Generate 2.5.0 minor version at 2023-12-01T00:45:45+01:00

commit 77699b7
Author: Jean-Marie Renouard jmrenouard@gmail.com
Date: Fri Dec 1 00:45:34 2023 +0100

Suggest incrementing log_buffer_size to improve InnoDB Write Log efficiency.
#462

commit c20bcbf
Merge: b10cdb7 01a1e53
Author: Jean-Marie Renouard jmrenouard@gmail.com
Date: Thu Nov 30 21:51:53 2023 +0100

Merge pull request #744 from paskal/remove_innodb_stats_on_metadata

Remove innodb_stats_on_metadata mentions in Readme

commit 01a1e53
Author: Dmitry Verkhoturov paskal.07@gmail.com
Date: Thu Nov 30 15:59:51 2023 +0100

remove innodb_stats_on_metadata mentions in Readme

That flag is off by default, starting with MySQL 5.7, and the tool
itself reports it in the "Performance Metrics" section.

v2.2.12

09 Sep 10:14
76c2156
Compare
Choose a tag to compare
v2.2.12

Version 1.9.9

15 Jun 13:07
Compare
Choose a tag to compare

#448 Generating .html reports
#474 Please add support for --protocol=TCP
#479 Recommendation on innodb_adaptive_hash_index_partitions
#499 --updateversion saves updates to incorrect location
#548 Wrong table cache hit rate calculation
#549 improve FreeBSD support a bit (patch included)
#551 Wrong recommendation "thread_pool_size between 16 and 36 for InnoDB usage" for Percona Server
#553 failed to execute: SHOW SLAVE HOSTS
#555 minor glitch with DROP USER
#557 Update needed for MariaDB 10.6
#558 Illegal division by zero at ./mysqltuner.pl line 2745
#559 fix English grammar
#561 'name resolution is active' should be OK when cPanel is detected
#563 Fix Replication Status
#564 Can't locate Data/Dumper.pm in @inc
#567 The InnoDB log buffer size increase recommendation is confusing
#569 The InnoDB log buffer size recommendation may be tested too strictly
#573 False impression on key buffer usage
#574 DOS-style line endings
#575 [ImgBot] Optimize images
#577 Do not show thread pool metrics when disabled
#579 Recommendation to turn on performance_schema
#580 Version 1.9.1 Incorrectly reporting performance schema is off
#583 Remove erroneous dot
#585 Configure Renovate
#586 Update actions/checkout action to v3
#588 innodb_buffer_pool_instances(=16) suggested for MariaDB 10.5 which doesn't support it
#589 Fix some master/slave renaming issues
#590 Fixing BIGINT UNSIGNED value is out of range error
#597 [Patch] Legibility and typos

Version 1.8.3

15 Oct 12:02
Compare
Choose a tag to compare

#511 Version Number in Releases
#551 Wrong recommendation "thread_pool_size between 16 and 36 for InnoDB usage" for Percona Server enhancement Test wanted
#530 cve list by API enhancement
#503 v1.7.19 minor message oddity
#564 Can't locate Data/Dumper.pm in @inc Help Wanted Questions Test wanted
#566 Illegal division by zero bug Test wanted
#565 innodb_log_files_in_group deprecated and ignored from MariaDB 10.5.2
#359 [!!] There is no basic password file list! Questions
#549 improve FreeBSD support a bit (patch included) enhancement Test wanted
#555 minor glitch with DROP USER Test wanted
#424 Do not redistribute the script without TLS
#501 mysqltuner.com has no DNS records enhancement Help Wanted
#558 Illegal division by zero at ./mysqltuner.pl line 2745 Test wanted
#557 Update needed for MariaDB 10.6 enhancement Test wanted
#556 Performance schema and Sysschema installation for MariaDB >= 10.4 fails
#554 mysqltuner.pl not responding
#523 Tuner gives false info
#550 If password contains single quote, you can't use this script
#552 Randomly MYSQL consumes the whole memory and stops.
#547 Error executing script sys_10.sql in MariaDB 10.5.8 Wont be Fixed
#520 "MySQL's maximum memory usage is dangerously high" Questions Wont be Fixed
#545 Duplicate recommendation/check bug
#544 no longer advise raising innodb_buffer_pool_instances
#498 Where are releases 1.7.18 and 1.7.19 enhancement
#483 MySQLTuner does not work enhancement

Maintenance release

05 Feb 07:51
4e0a8b3
Compare
Choose a tag to compare

commit 4e0a8b3
Merge: 2a63ffd e29b76f
Author: Jean-Marie Renouard jmrenouard@gmail.com
Date: Fri Feb 5 08:38:20 2021 +0100

Merge pull request #543 from grooverdan/rename-user

Rename user

commit e29b76f
Author: Daniel Black daniel@mariadb.org
Date: Fri Feb 5 09:34:43 2021 +1100

empty passwords - use exact user/host quoted

commit 0be85cb
Author: Daniel Black daniel@mariadb.org
Date: Fri Feb 5 09:04:24 2021 +1100

user host recommend - RENAME USER

Altering mysql.user tables isn't something users should do.

RENAME USER has existed for a long time, use this instead.

Also change SpecificDNSorIp because DNS based grants are
a horrible idea, fragile, and could be disabled with
--skip-name-resolve.

closes #536

commit 2a63ffd
Merge: 05925cf b85a443
Author: Jean-Marie Renouard jmrenouard@gmail.com
Date: Mon Feb 1 17:07:52 2021 +0100

Merge pull request #542 from grooverdan/doc_mysql_mariadb_support

Doc mysql mariadb support

commit 05925cf
Merge: f93020f bfeccad
Author: Jean-Marie Renouard jmrenouard@gmail.com
Date: Mon Feb 1 17:07:14 2021 +0100

Merge pull request #541 from grooverdan/travis_percona

travis: add percona supported versions

commit f93020f
Merge: 950df57 5c307d1
Author: Jean-Marie Renouard jmrenouard@gmail.com
Date: Mon Feb 1 17:07:00 2021 +0100

Merge pull request #540 from grooverdan/noinnodb

correct messages on no InnoDB

commit bfeccad
Author: Daniel Black daniel@mariadb.org
Date: Mon Feb 1 15:11:31 2021 +1100

travis: add percona supported versions

Note where Percona announce 3 more years of 5.6 support
https://www.percona.com/blog/2020/12/07/not-ready-to-give-up-mysql-5-6-get-post-eol-support-from-percona/

commit b85a443
Author: Daniel Black daniel@mariadb.org
Date: Mon Feb 1 15:10:25 2021 +1100

doc: 5.5 listed as full support

commit 5901f51
Author: Daniel Black daniel@mariadb.org
Date: Mon Feb 1 15:00:43 2021 +1100

doc: MariaDB-10.[01] were not support by MySQL

commit 5c307d1
Author: Daniel Black daniel@mariadb.org
Date: Mon Feb 1 11:31:40 2021 +1100

correct messages on no InnoDB

enginestats are only populated if tables exist of that type.

Look at default_storage_engine if defined to communicate the default
storage engine.

closes #469

commit 950df57
Merge: 625d2cf 938b434
Author: Jean-Marie Renouard jmrenouard@gmail.com
Date: Sun Jan 31 22:09:26 2021 +0100

Merge pull request #539 from grooverdan/serverlog

--server-log enhancements for containers/pods/systemd journal

commit 938b434
Author: Daniel Black daniel@mariadb.org
Date: Sat Jan 30 12:31:00 2021 +1100

extend server-log for journal/container/pods

Default to reading last 30000 lines.

If reading from file estimate that average line
length is 80 characters and read based that
far back from the end of file.

commit c3da0b0
Author: Daniel Black daniel@mariadb.org
Date: Sat Jan 30 10:23:56 2021 +1100

add server-log option for explict server log

This allows a user to specify a logrotated file
or another file that isn't discoverable from
server log_error system variable or other defaults.

close #504

commit 625d2cf
Merge: 8cda55a be5809e
Author: Jean-Marie Renouard jmrenouard@gmail.com
Date: Fri Jan 29 22:22:50 2021 +0100

Merge pull request #534 from grooverdan/travis_new

travis: test all supported versions

commit be5809e
Author: Daniel Black daniel@mariadb.org
Date: Thu Jan 28 11:55:15 2021 +1100

travis: docker test all versions

commit 8cda55a
Merge: 47ebbbc 85dc955
Author: Jean-Marie Renouard jmrenouard@gmail.com
Date: Thu Jan 28 18:21:58 2021 +0100

Merge pull request #532 from grooverdan/m10.5-travis-fix

travis: correct MariaDB-10.5 test

commit 47ebbbc
Merge: 22789d1 59ce37b
Author: Jean-Marie Renouard jmrenouard@gmail.com
Date: Thu Jan 28 18:21:43 2021 +0100

Merge pull request #535 from grooverdan/snap

skip snap filesystems

commit 22789d1
Merge: 1f879d1 7a94bd5
Author: Jean-Marie Renouard jmrenouard@gmail.com
Date: Thu Jan 28 18:21:11 2021 +0100

Merge pull request #537 from grooverdan/min_dblist

minimal database list retrieval

commit 1f879d1
Merge: 374ef59 72952b5
Author: Jean-Marie Renouard jmrenouard@gmail.com
Date: Thu Jan 28 18:19:09 2021 +0100

Merge pull request #538 from grooverdan/json_total_tables

Add total_tables to json output

commit 374ef59
Merge: 49c2f6e 2c8f5e8
Author: Jean-Marie Renouard jmrenouard@gmail.com
Date: Thu Jan 28 18:18:17 2021 +0100

Merge pull request #533 from grooverdan/exec_perms

add execute permissions to mysqltuner.pl

commit 49c2f6e
Author: Jean-Marie Renouard jmrenouard@gmail.com
Date: Thu Jan 28 18:15:53 2021 +0100

Update mysqltuner.pl

commit 72952b5
Author: Daniel Black daniel@mariadb.org
Date: Thu Jan 28 19:12:56 2021 +1100

Add total_tables to json output

closes #484

commit 7a94bd5
Author: Daniel Black daniel@mariadb.org
Date: Thu Jan 28 18:44:14 2021 +1100

minimal database list retrieval

Information schema access isn't particularly well optimized.

As such, at least in older versions, fetching from the information_schema.TABLES
would involve opening every table.

The ANSI SQL standards SCHEMATA provides a quicker way, and we can reuse it.

commit 59ce37b
Author: Daniel Black daniel@mariadb.org
Date: Thu Jan 28 18:01:59 2021 +1100

skip snap filesystems

commit 2c8f5e8
Author: Daniel Black daniel@mariadb.org
Date: Thu Jan 28 16:22:07 2021 +1100

add execute permissions to mysqltuner.pl

closes #531

commit 85dc955
Author: Daniel Black daniel@mariadb.org
Date: Thu Jan 28 11:18:48 2021 +1100

travis: correct MariaDB-10.5 test

commit 2999446
Merge: 285ba51 083dc22
Author: Jean-Marie Renouard jmrenouard@gmail.com
Date: Wed Jan 27 21:32:37 2021 +0100

Merge pull request #529 from grooverdan/supported_versions

supported version: +mariadb-10.5, eol mysql-5.6, mariadb-10.[01]

commit 285ba51
Merge: d9e0004 9d1d19c
Author: Jean-Marie Renouard jmrenouard@gmail.com
Date: Wed Jan 27 21:31:41 2021 +0100

Merge pull request #528 from grooverdan/gtidmode_mariadb

mariadb gtid mode - base off gtid_current_pos.

commit d9e0004
Merge: f2c8ca8 fa8deec
Author: Jean-Marie Renouard jmrenouard@gmail.com
Date: Wed Jan 27 21:31:16 2021 +0100

Merge pull request #527 from grooverdan/mariadbnames

mariadb is using its on name in mariadb/mariadb-admin

commit f2c8ca8
Merge: 8fb9195 2f45f34
Author: Jean-Marie Renouard jmrenouard@gmail.com
Date: Wed Jan 27 21:29:38 2021 +0100

Merge pull request #526 from grooverdan/anonuser

anonymous users - remove password checks

commit 8fb9195
Merge: 3a7bf40 3ac95cd
Author: Jean-Marie Renouard jmrenouard@gmail.com
Date: Wed Jan 27 21:28:18 2021 +0100

Merge pull request #525 from grooverdan/qc

query_cache off with query_cache_type=OFF OR query_cache_size=0

commit 3a7bf40
Merge: 9a9ff55 99e5c83
Author: Jean-Marie Renouard jmrenouard@gmail.com
Date: Wed Jan 27 21:27:12 2021 +0100

Merge pull request #524 from grooverdan/aria_myisam

Aria/MyISAM cleanup

commit 9d1d19c
Author: Daniel Black daniel@mariadb.org
Date: Wed Jan 27 18:03:28 2021 +1100

mariadb gtid mode - base off gtid_current_pos.

gtid_strict_mode isn't sufficient a test for
MariaDB's GTID mode. The gtid_current_pos
however is always non-blank if GTID is enabled.

closes #513

commit 083dc22
Author: Daniel Black daniel@mariadb.org
Date: Wed Jan 27 17:33:59 2021 +1100

supported version: +mariadb-10.5, eol mysql-5.6, mariadb-10.[01]

Add mariadb-10.5 as a supported version.

Remove MySQL/MariaDB eol versions from their origin of support.

commit fa8deec
Author: Daniel Black daniel@mariadb.org
Date: Wed Jan 27 17:25:30 2021 +1100

mariadb is using its on name in mariadb/mariadb-admin

The mysql client, mysql, in mariadb is starting to be labeled mariadb.
Likewise mysqladmin is getting called mariadb-admin. Lets check
for these names as well.

commit 2f45f34
Author: Daniel Black daniel@mariadb.org
Date: Wed Jan 27 17:15:00 2021 +1100

anonymous users - remove pass...
Read more

Version 1.7.17

01 Oct 23:09
Compare
Choose a tag to compare

Default host should be 127.0.0.1 Help Wanted Test wanted enhancement
#312 by fmonts was closed

Detect user passwords in password and authentication_string mixed environments Help Wanted bug
#234 by pes-soft was closed

Human readable Performance schema report enhancement
#402 by jmrenouard was closed

FAIL Execute SQL / return code: 256 Test wanted bug
#427 by tholu was closed

Lots of SQL error about password detecting under MySQL 5.7 Help Wanted bug enhancement
#441 by ddb4github was closed

MariaDB 10.3 password check incorrect. Test wanted
#413 by plutocrat was closed

disable column type to ENUM suggestion Questions enhancement
#356 by mia0x75 was closed

FAIL Execute SQL / return code: 256 Help Wanted bug
#442 by KarelWintersky was closed

Can't use command line after MySQLTuner Questions
#425 by MalikKrak was closed

Wrong report of InnoDB Storage engine status bug
#450 by schemacs was closed

Issue importing sys_10.sql Help Wanted Questions
#452 by zeki893 was closed

Cannot calculate MyISAM index size - re-run script as root user bug
#453 by acs-ferreira was closed

ERROR 1054 (42S22) at line 1: Unknown column 'password' in 'where clause'
#455 by rustov was closed

sys schema from good-dba does not work with MariaDB
#443 by ebroto was closed

Table column metrics fail if identifiers use reserved words
#445 by ebroto was

Tagging versions enhancement
#405 by weberhofer was closed

Hope to add MySQL 8 support! Help Wanted enhancement
#377 by kn007 was closed

Error en mi MySQL
#437 by maxicabanillas78 was closed

Illegal division by zero Help Wanted Test wanted
#423 by vesatoivonen was closed

Script freezes after first line of Storage Engine Statistics
#55 by jlowe64 was closed

Do not redistribute the script without TLS
#424 by mablae was closed

Unknown column 'password' in 'where clause' Test wanted bug
#373 by fmonts was closed

Attempted to use login credentials, but they were invalid Help Wanted Questions
#420 by akashsarpate was closed

Wrong value about innodb_buffer_pool_instances with MySQL 5.6
#419 by stonio was closed

Version 1.7.15

11 Jun 19:49
037f720
Compare
Choose a tag to compare

Version 1.7.15

Release MySQLTuner 1.7.13

15 Nov 16:18
59e5f40
Compare
Choose a tag to compare
Merge pull request #409 from tcraxs/patch-1

fix defect link to mysql documentation - #408

MySQLTuner v1.7.2

17 May 15:45
Compare
Choose a tag to compare
  • Missing argument requirement for cvefile in mysqltuner help enhancement
  • typo, space missing before 'is' enhancement
  • [Questions] No recommendations for my problems Questions
  • Galera gcs.fc_factor is not evaluated correctly and reports an erroneous message.
  • Use of uninitialized value bug Test wanted
  • Unknown option: pfstat
  • Advice for performance schema given for wrong version?
  • CVE-2016-6663(<= 10.1.18) bug Help Wanted
  • binlog_cache_size
  • How to grant all necessary requirements? Questions
  • Disclosed password in ps uax output enhancement Questions
  • on mysql 5.7.17, the tuner is not working anymore. Test wanted
  • Argument "xxxM" isn't numeric in numeric ge (>=) bug Help Wanted
  • Perl Error bug Test wanted
  • Doesn't work for remote server on AWS bug Test wanted
  • Software doesn't escape SQL statements in basic_passwords.txt enhancement Test wanted
  • MEMORY tables returning as non-InnoDB (Galera Cluster)
  • bug (?) script fails on centos 6.8 due to a number of uninitialized vars Questions Wont be Fixed
  • MariaDB GTID mode bug Test wanted

v1.6.18

02 Sep 08:31
Compare
Choose a tag to compare
  • Galera metrics
  • System metrics
  • Better thread pool metrics
  • InnoDB 5.7 innodb_buffer_pool_chunk_size checks
  • Bugs fixes on CVE detection
  • Bug fixes on error message displayed for some versions