Hope to add MySQL 8 support! #377

kn007 · 2018-04-20T09:38:06Z

The MySQL 8.0.11 GA now, but the script partial support fot it.

Thanks for your work.

jmrenouard · 2018-04-26T12:13:41Z

Can you give us more feedback on MySQL 8 issue you face ?

Thnaks by advance,

kn007 · 2018-05-12T16:44:03Z

 >>  MySQLTuner 1.7.9 - Major Hayden <major@mhtx.net>
 >>  Bug reports, feature requests, and downloads at http://mysqltuner.com/
 >>  Run with '--help' for additional options and output filtering

[--] Skipped version check for MySQLTuner script
[!!] Currently running unsupported MySQL version 8.0.11
[OK] Operating on 64-bit architecture

-------- Log file Recommendations ------------------------------------------------------------------
[--] Log file: /usr/local/mysql/data/mysql-error.log(2K)
[OK] Log file /usr/local/mysql/data/mysql-error.log exists
[OK] Log file /usr/local/mysql/data/mysql-error.log is readable.
[OK] Log file /usr/local/mysql/data/mysql-error.log is not empty
[OK] Log file /usr/local/mysql/data/mysql-error.log is smaller than 32 Mb
[!!] /usr/local/mysql/data/mysql-error.log contains 4 warning(s).
[OK] /usr/local/mysql/data/mysql-error.log doesn't contain any error.
[--] 3 start(s) detected in /usr/local/mysql/data/mysql-error.log
[--] 1) 2018-05-11T07:39:06.355671+08:00 0 [System] [MY-010931] [Server] /usr/local/mysql/bin/mysqld: ready for connections. Version: '8.0.11'  socket: '/tmp/mysql.sock'  port: 0  MySQL Community Server - GPL.
[--] 2) 2018-04-20T18:44:26.576581+08:00 0 [System] [MY-010931] [Server] /usr/local/mysql/bin/mysqld: ready for connections. Version: '8.0.11'  socket: '/tmp/mysql.sock'  port: 0  MySQL Community Server - GPL.
[--] 3) 2018-04-19T22:26:22.988540+08:00 0 [System] [MY-010931] [Server] /usr/local/mysql/bin/mysqld: ready for connections. Version: '8.0.11'  socket: '/tmp/mysql.sock'  port: 0  MySQL Community Server - GPL.
[--] 2 shutdown(s) detected in /usr/local/mysql/data/mysql-error.log
[--] 1) 2018-05-11T07:36:03.547341+08:00 0 [System] [MY-010910] [Server] /usr/local/mysql/bin/mysqld: Shutdown complete (mysqld 8.0.11)  MySQL Community Server - GPL.
[--] 2) 2018-04-20T18:44:22.259513+08:00 0 [System] [MY-010910] [Server] /usr/local/mysql/bin/mysqld: Shutdown complete (mysqld 8.0.11)  MySQL Community Server - GPL.

-------- Storage Engine Statistics -----------------------------------------------------------------
[--] Status: +ARCHIVE +BLACKHOLE +CSV -FEDERATED +InnoDB +MEMORY +MRG_MYISAM +MyISAM +PERFORMANCE_SCHEMA
[--] Data in InnoDB tables: 223M (Tables: 82)
[OK] Total fragmented tables: 0

-------- Security Recommendations ------------------------------------------------------------------
[OK] There are no anonymous accounts for any database users
[!!] failed to execute: SELECT CONCAT(user, '@', host) FROM mysql.user WHERE (password = '' OR password IS NULL) AND plugin NOT IN ('unix_socket', 'win_socket', 'auth_pam_compat')
[!!] FAIL Execute SQL / return code: 256
[OK] All database users have passwords assigned
[!!] failed to execute: SELECT CONCAT(user, '@', host) FROM mysql.user WHERE CAST(password as Binary) = PASSWORD(user) OR CAST(password as Binary) = PASSWORD(UPPER(user)) OR CAST(password as Binary) = PASSWORD(CONCAT(UPPER(LEFT(User, 1)), SUBSTRING(User, 2, LENGTH(User))))
[!!] FAIL Execute SQL / return code: 256
[--] There are 1 basic passwords in the list.
[!!] failed to execute: SELECT CONCAT(user, '@', host) FROM mysql.user WHERE password = PASSWORD('root') OR password = PASSWORD(UPPER('root')) OR password = PASSWORD(CONCAT(UPPER(LEFT('root', 1)), SUBSTRING('root', 2, LENGTH('root'))))
[!!] FAIL Execute SQL / return code: 256

-------- CVE Security Recommendations --------------------------------------------------------------
[OK] NO SECURITY CVE FOUND FOR YOUR VERSION
Use of uninitialized value in addition (+) at /data/www/mysqltuner.pl line 2487 (#1)
    (W uninitialized) An undefined value was used as if it were already
    defined.  It was interpreted as a "" or a 0, but maybe it was a mistake.
    To suppress this warning assign a defined value to your variables.

    To help you figure out what was undefined, perl will try to tell you
    the name of the variable (if any) that was undefined.  In some cases
    it cannot do this, so it also tells you what operation you used the
    undefined value in.  Note, however, that perl optimizes your program
    anid the operation displayed in the warning may not necessarily appear
    literally in your program.  For example, "that $foo" is usually
    optimized into "that " . $foo, and the warning will refer to the
    concatenation (.) operator, even though there is no . in
    your program.

Use of uninitialized value in division (/) at /data/www/mysqltuner.pl line 2487 (#1)
Use of uninitialized value $mystat{"Qcache_lowmem_prunes"} in numeric eq (==)
        at /data/www/mysqltuner.pl line 2502 (#1)

-------- Performance Metrics -----------------------------------------------------------------------
[--] Up for: 1d 17h 0m 17s (180K q [1.225 qps], 16K conn, TX: 112M, RX: 17M)
[--] Reads / Writes: 99% / 1%
[--] Binary logging is enabled (GTID MODE: ON)
[--] Physical Memory     : 7.7G
[--] Max MySQL memory    : 7.0G
[--] Other process memory: 1.3G
[--] Total buffers: 432.0M global + 56.5M per thread (120 max threads)
[--] P_S Max memory usage: 72B
[--] Galera GCache Max memory usage: 0B
[OK] Maximum reached memory usage: 827.5M (10.50% of installed RAM)
[!!] Maximum possible memory usage: 7.0G (91.49% of installed RAM)
[!!] Overall possible memory usage with other process exceeded memory
[OK] Slow queries: 0% (0/180K)
[OK] Highest usage of available connections: 5% (7/120)
[OK] Aborted connections: 0.00%  (0/16756)
[--] Skipped name resolution test due to skip_networking=ON in system variables.
Use of uninitialized value $myvar{"query_cache_size"} in numeric lt (<) at
        /data/www/mysqltuner.pl line 2880 (#1)
Use of uninitialized value $myvar{"query_cache_type"} in string eq at
        /data/www/mysqltuner.pl line 2880 (#1)
[!!] Query cache may be disabled by default due to mutex contention.
Use of uninitialized value $num in numeric ge (>=) at /data/www/mysqltuner.pl
        line 338 (#1)
Use of uninitialized value $num in numeric ge (>=) at /data/www/mysqltuner.pl
        line 341 (#1)
Use of uninitialized value $num in numeric ge (>=) at /data/www/mysqltuner.pl
        line 344 (#1)
Use of uninitialized value in concatenation (.) or string at
        /data/www/mysqltuner.pl line 2896 (#1)
Use of uninitialized value in addition (+) at /data/www/mysqltuner.pl line 2896 (#1)
[!!] Query cache efficiency: 0.0% ( cached / 97K selects)
[OK] Query cache prunes per day: 0
[OK] Sorts requiring temporary tables: 0% (0 temp sorts / 25K sorts)
[OK] No joins without indexes
[!!] Temporary tables created on disk: 41% (1K on disk / 4K total)
[OK] Thread cache hit rate: 99% (7 created / 16K connections)
[OK] Table cache hit rate: 20% (834 open / 4K opened)
[OK] Open file limit used: 0% (3/100K)
[OK] Table locks acquired immediately: 100% (9 immediate / 9 locks)
[OK] Binlog cache memory access: 100.00% (125 Memory / 125 Total)

-------- Performance schema ------------------------------------------------------------------------
[--] Memory used by P_S: 72B
[--] Sys schema is installed.

-------- ThreadPool Metrics ------------------------------------------------------------------------
[--] ThreadPool stat is disabled.

-------- MyISAM Metrics ----------------------------------------------------------------------------
[!!] Key buffer used: 18.2% (6M used / 33M cache)
[!!] Cannot calculate MyISAM index size - re-run script as root user

-------- InnoDB Metrics ----------------------------------------------------------------------------
[--] InnoDB is enabled.
[--] InnoDB Thread Concurrency: 0
[OK] InnoDB File per table is activated
[OK] InnoDB buffer pool / data size: 256.0M/223.6M
[OK] Ratio InnoDB log file size / InnoDB Buffer pool size: 32.0M * 2/256.0M should be equal 25%
[OK] InnoDB buffer pool instances: 1
[--] Number of InnoDB Buffer Pool Chunk : 1 for 1 Buffer Pool Instance(s)
[OK] Innodb_buffer_pool_size aligned with Innodb_buffer_pool_chunk_size & Innodb_buffer_pool_instances
[OK] InnoDB Read buffer efficiency: 99.94% (9219524 hits/ 9224923 total)
[!!] InnoDB Write Log efficiency: 65.79% (1373 hits/ 2087 total)
[OK] InnoDB log waits: 0.00% (0 waits / 714 writes)

-------- AriaDB Metrics ----------------------------------------------------------------------------
[--] AriaDB is disabled.

-------- TokuDB Metrics ----------------------------------------------------------------------------
[--] TokuDB is disabled.

-------- XtraDB Metrics ----------------------------------------------------------------------------
[--] XtraDB is disabled.

-------- RocksDB Metrics ---------------------------------------------------------------------------
[--] RocksDB is disabled.

-------- Spider Metrics ----------------------------------------------------------------------------
[--] Spider is disabled.

-------- Connect Metrics ---------------------------------------------------------------------------
[--] Connect is disabled.

-------- Galera Metrics ----------------------------------------------------------------------------
[--] Galera is disabled.

-------- Replication Metrics -----------------------------------------------------------------------
[--] Galera Synchronous replication: NO
[--] No replication slave(s) for this server.
[--] Binlog format: ROW
Use of uninitialized value $myvar{"innodb_support_xa"} in concatenation (.) or
        string at /data/www/mysqltuner.pl line 1850 (#1)
[--] XA support enabled:
[--] Semi synchronous replication Master: Not Activated
[--] Semi synchronous replication Slave: Not Activated
[--] This is a standalone server

-------- Recommendations ---------------------------------------------------------------------------
General recommendations:
    Control warning line(s) into /usr/local/mysql/data/mysql-error.log file
    Reduce your overall MySQL memory footprint for system stability
    Dedicate this server to your database for highest performance.
    When making adjustments, make tmp_table_size/max_heap_table_size equal
    Reduce your SELECT DISTINCT queries which have no LIMIT clause
Variables to adjust:
  *** MySQL's maximum memory usage is dangerously high ***
  *** Add RAM before increasing MySQL buffer variables ***
    query_cache_size (=0)
    query_cache_type (=0)
    query_cache_limit (> 0B, or use smaller result sets)
    tmp_table_size (> 128M)
    max_heap_table_size (> 128M)

query cache have been deprecated.

In MySQL 8.0.11, several deprecated features related to account management have been removed, such as use of the GRANT statement to modify nonprivilege characteristics of user accounts, the NO_AUTO_CREATE_USER SQL mode, the PASSWORD() function, and the old_passwords system variable.

jmrenouard · 2018-07-06T06:38:07Z

We are facing issue with new authentication_string content and we aren't enable to compare password with our dummies list.

MySQL 8: disabling Query cache recommandations MySQL 8: check password disabled due to new authentication storage model - Help wanted

jmrenouard · 2018-09-23T07:47:14Z

Hi,
I have pushed new staff for MySQL 8:

no more query cache recommandations (removed feature)
Disabling password check due to new storage model for password in MySQL 8

Can you give us your feedback on MySQL Tuner 1.7.12 & MySQL 8 ?

kn007 · 2018-09-24T06:00:59Z

It's working fine on Mysql 8.0.12!

 >>  MySQLTuner 1.7.12 - Major Hayden <major@mhtx.net>
 >>  Bug reports, feature requests, and downloads at http://mysqltuner.com/
 >>  Run with '--help' for additional options and output filtering

[--] Skipped version check for MySQLTuner script
[!!] Currently running unsupported MySQL version 8.0.12
[OK] Operating on 64-bit architecture

-------- Log file Recommendations ------------------------------------------------------------------
[--] Log file: /usr/local/mysql/data/mysql-error.log(5K)
[OK] Log file /usr/local/mysql/data/mysql-error.log exists
[OK] Log file /usr/local/mysql/data/mysql-error.log is readable.
[OK] Log file /usr/local/mysql/data/mysql-error.log is not empty
[OK] Log file /usr/local/mysql/data/mysql-error.log is smaller than 32 Mb
[!!] /usr/local/mysql/data/mysql-error.log contains 9 warning(s).
[OK] /usr/local/mysql/data/mysql-error.log doesn't contain any error.
[--] 8 start(s) detected in /usr/local/mysql/data/mysql-error.log
[--] 1) 2018-07-28T09:23:44.198678+08:00 0 [System] [MY-010931] [Server] /usr/local/mysql/bin/mysqld: ready for connections. Version: '8.0.12'  socket: '/tmp/mysql.sock'  port: 0  MySQL Community Server - GPL.
[--] 2) 2018-07-24T21:56:00.507150+08:00 0 [System] [MY-010931] [Server] /usr/local/mysql/bin/mysqld: ready for connections. Version: '8.0.11'  socket: '/tmp/mysql.sock'  port: 0  MySQL Community Server - GPL.
[--] 3) 2018-07-04T06:07:10.961290+08:00 0 [System] [MY-010931] [Server] /usr/local/mysql/bin/mysqld: ready for connections. Version: '8.0.11'  socket: '/tmp/mysql.sock'  port: 0  MySQL Community Server - GPL.
[--] 4) 2018-05-26T14:37:17.742528+08:00 0 [System] [MY-010931] [Server] /usr/local/mysql/bin/mysqld: ready for connections. Version: '8.0.11'  socket: '/tmp/mysql.sock'  port: 0  MySQL Community Server - GPL.
[--] 5) 2018-05-26T14:14:47.948256+08:00 0 [System] [MY-010931] [Server] /usr/local/mysql/bin/mysqld: ready for connections. Version: '8.0.11'  socket: '/tmp/mysql.sock'  port: 0  MySQL Community Server - GPL.
[--] 6) 2018-05-11T07:39:06.355671+08:00 0 [System] [MY-010931] [Server] /usr/local/mysql/bin/mysqld: ready for connections. Version: '8.0.11'  socket: '/tmp/mysql.sock'  port: 0  MySQL Community Server - GPL.
[--] 7) 2018-04-20T18:44:26.576581+08:00 0 [System] [MY-010931] [Server] /usr/local/mysql/bin/mysqld: ready for connections. Version: '8.0.11'  socket: '/tmp/mysql.sock'  port: 0  MySQL Community Server - GPL.
[--] 8) 2018-04-19T22:26:22.988540+08:00 0 [System] [MY-010931] [Server] /usr/local/mysql/bin/mysqld: ready for connections. Version: '8.0.11'  socket: '/tmp/mysql.sock'  port: 0  MySQL Community Server - GPL.
[--] 7 shutdown(s) detected in /usr/local/mysql/data/mysql-error.log
[--] 1) 2018-07-28T09:19:21.842110+08:00 0 [System] [MY-010910] [Server] /usr/local/mysql/bin/mysqld: Shutdown complete (mysqld 8.0.11)  MySQL Community Server - GPL.
[--] 2) 2018-07-24T21:54:08.658734+08:00 0 [System] [MY-010910] [Server] /usr/local/mysql/bin/mysqld: Shutdown complete (mysqld 8.0.11)  MySQL Community Server - GPL.
[--] 3) 2018-07-04T06:05:21.503844+08:00 0 [System] [MY-010910] [Server] /usr/local/mysql/bin/mysqld: Shutdown complete (mysqld 8.0.11)  MySQL Community Server - GPL.
[--] 4) 2018-05-26T14:35:38.912095+08:00 0 [System] [MY-010910] [Server] /usr/local/mysql/bin/mysqld: Shutdown complete (mysqld 8.0.11)  MySQL Community Server - GPL.
[--] 5) 2018-05-26T14:12:00.363601+08:00 0 [System] [MY-010910] [Server] /usr/local/mysql/bin/mysqld: Shutdown complete (mysqld 8.0.11)  MySQL Community Server - GPL.
[--] 6) 2018-05-11T07:36:03.547341+08:00 0 [System] [MY-010910] [Server] /usr/local/mysql/bin/mysqld: Shutdown complete (mysqld 8.0.11)  MySQL Community Server - GPL.
[--] 7) 2018-04-20T18:44:22.259513+08:00 0 [System] [MY-010910] [Server] /usr/local/mysql/bin/mysqld: Shutdown complete (mysqld 8.0.11)  MySQL Community Server - GPL.

-------- Storage Engine Statistics -----------------------------------------------------------------
[--] Status: +ARCHIVE +BLACKHOLE +CSV -FEDERATED +InnoDB +MEMORY +MRG_MYISAM +MyISAM +PERFORMANCE_SCHEMA
[--] Data in InnoDB tables: 171.0M (Tables: 85)
[OK] Total fragmented tables: 0

-------- Analysis Performance Metrics --------------------------------------------------------------
[--] innodb_stats_on_metadata: OFF
[OK] No stat updates during querying INFORMATION_SCHEMA.

-------- Security Recommendations ------------------------------------------------------------------
[--] Skipped due to unsupported feature for MySQL 8

-------- CVE Security Recommendations --------------------------------------------------------------
[OK] NO SECURITY CVE FOUND FOR YOUR VERSION

-------- Performance Metrics -----------------------------------------------------------------------
[--] Up for: 58d 4h 35m 55s (5M q [1.037 qps], 505K conn, TX: 7G, RX: 470M)
[--] Reads / Writes: 99% / 1%
[--] Binary logging is enabled (GTID MODE: ON)
[--] Physical Memory     : 7.8G
[--] Max MySQL memory    : 7.0G
[--] Other process memory: 1.3G
[--] Total buffers: 432.0M global + 56.5M per thread (120 max threads)
[--] P_S Max memory usage: 72B
[--] Galera GCache Max memory usage: 0B
[OK] Maximum reached memory usage: 1.8G (23.11% of installed RAM)
[!!] Maximum possible memory usage: 7.0G (90.37% of installed RAM)
[!!] Overall possible memory usage with other process exceeded memory
[OK] Slow queries: 0% (0/5M)
[OK] Highest usage of available connections: 20% (25/120)
[OK] Aborted connections: 0.00%  (0/505831)
[--] Skipped name resolution test due to skip_networking=ON in system variables.
[--] Query cache have been removed in MySQL 8
[OK] Sorts requiring temporary tables: 0% (0 temp sorts / 731K sorts)
[!!] Joins performed without indexes: 14653
[!!] Temporary tables created on disk: 41% (78K on disk / 187K total)
[OK] Thread cache hit rate: 99% (25 created / 505K connections)
[!!] Table cache hit rate: 0% (730 open / 228K opened)
[OK] Open file limit used: 0% (3/100K)
[OK] Table locks acquired immediately: 100% (374 immediate / 374 locks)
[OK] Binlog cache memory access: 100.00% (6791 Memory / 6791 Total)

-------- Performance schema ------------------------------------------------------------------------
[--] Memory used by P_S: 72B
[--] Sys schema is installed.

-------- ThreadPool Metrics ------------------------------------------------------------------------
[--] ThreadPool stat is disabled.

-------- MyISAM Metrics ----------------------------------------------------------------------------
[!!] Key buffer used: 18.2% (6M used / 33M cache)
[!!] Cannot calculate MyISAM index size - re-run script as root user

-------- InnoDB Metrics ----------------------------------------------------------------------------
[--] InnoDB is enabled.
[--] InnoDB Thread Concurrency: 0
[OK] InnoDB File per table is activated
[OK] InnoDB buffer pool / data size: 256.0M/171.0M
[OK] Ratio InnoDB log file size / InnoDB Buffer pool size: 32.0M * 2/256.0M should be equal 25%
[OK] InnoDB buffer pool instances: 1
[--] Number of InnoDB Buffer Pool Chunk : 1 for 1 Buffer Pool Instance(s)
[OK] Innodb_buffer_pool_size aligned with Innodb_buffer_pool_chunk_size & Innodb_buffer_pool_instances
[OK] InnoDB Read buffer efficiency: 100.00% (287153123 hits/ 287157896 total)
[!!] InnoDB Write Log efficiency: 81.04% (315579 hits/ 389393 total)
[OK] InnoDB log waits: 0.00% (0 waits / 73814 writes)

-------- AriaDB Metrics ----------------------------------------------------------------------------
[--] AriaDB is disabled.

-------- TokuDB Metrics ----------------------------------------------------------------------------
[--] TokuDB is disabled.

-------- XtraDB Metrics ----------------------------------------------------------------------------
[--] XtraDB is disabled.

-------- Galera Metrics ----------------------------------------------------------------------------
[--] Galera is disabled.

-------- Replication Metrics -----------------------------------------------------------------------
[--] Galera Synchronous replication: NO
[--] No replication slave(s) for this server.
[--] Binlog format: ROW
[--] XA support enabled: ON
[--] Semi synchronous replication Master: Not Activated
[--] Semi synchronous replication Slave: Not Activated
[--] This is a standalone server

-------- Recommendations ---------------------------------------------------------------------------
General recommendations:
    Control warning line(s) into /usr/local/mysql/data/mysql-error.log file
    Reduce your overall MySQL memory footprint for system stability
    Dedicate this server to your database for highest performance.
    Adjust your join queries to always utilize indexes
    When making adjustments, make tmp_table_size/max_heap_table_size equal
    Reduce your SELECT DISTINCT queries which have no LIMIT clause
    Increase table_open_cache gradually to avoid file descriptor limits
    Read this before increasing table_open_cache over 64: http://bit.ly/1mi7c4C
    This is MyISAM only table_cache scalability problem, InnoDB not affected.
    See more details here: https://bugs.mysql.com/bug.php?id=49177
    This bug already fixed in MySQL 5.7.9 and newer MySQL versions.
    Beware that open_files_limit (100000) variable
    should be greater than table_open_cache (1024)
Variables to adjust:
  *** MySQL's maximum memory usage is dangerously high ***
  *** Add RAM before increasing MySQL buffer variables ***
    join_buffer_size (> 16.0M, or always use indexes with JOINs)
    tmp_table_size (> 128M)
    max_heap_table_size (> 128M)
    table_open_cache (> 1024)

jmrenouard · 2018-09-25T14:46:15Z

Hi @kn007

Can we close this issue ?

Thanks for your feedback

sghoe · 2019-05-21T14:59:16Z

I have problems with version 1.7.15 on MySQL 8.0.15 on Debian 9

`-------- Log file Recommendations ------------------------------------------------------------------
[--] Log file: /var/log/mysql/error.log(24K)
[OK] Log file /var/log/mysql/error.log exists
[OK] Log file /var/log/mysql/error.log is readable.
[OK] Log file /var/log/mysql/error.log is not empty
[OK] Log file /var/log/mysql/error.log is smaller than 32 Mb
[!!] /var/log/mysql/error.log contains 50 warning(s).
[!!] /var/log/mysql/error.log contains 19 error(s).
[--] 36 start(s) detected in /var/log/mysql/error.log
[--] 1) 2019-05-13T13:36:04.148105Z 0 [System] [MY-011323] [Server] X Plugin ready for connections. Socket: '/var/run/mysqld/mysqlx.sock' bind-address: '::' port: 33060
[--] 2) 2019-05-13T13:36:04.040770Z 0 [System] [MY-010931] [Server] /usr/sbin/mysqld: ready for connections. Version: '8.0.15' socket: '/var/run/mysqld/mysqld.sock' port: 3306 MySQL Community Server - GPL.
[--] 3) 2019-05-13T07:38:48.437686Z 0 [System] [MY-011323] [Server] X Plugin ready for connections. Socket: '/var/run/mysqld/mysqlx.sock' bind-address: '::' port: 33060
[--] 4) 2019-05-13T07:38:48.329031Z 0 [System] [MY-010931] [Server] /usr/sbin/mysqld: ready for connections. Version: '8.0.15' socket: '/var/run/mysqld/mysqld.sock' port: 3306 MySQL Community Server - GPL.
[--] 5) 2019-05-13T07:25:46.902208Z 0 [System] [MY-011323] [Server] X Plugin ready for connections. Socket: '/var/run/mysqld/mysqlx.sock' bind-address: '::' port: 33060
[--] 6) 2019-05-13T07:25:46.858502Z 0 [System] [MY-010931] [Server] /usr/sbin/mysqld: ready for connections. Version: '8.0.15' socket: '/var/run/mysqld/mysqld.sock' port: 3306 MySQL Community Server - GPL.
[--] 7) 2019-04-15T05:04:00.676959Z 0 [System] [MY-011323] [Server] X Plugin ready for connections. Socket: '/var/run/mysqld/mysqlx.sock' bind-address: '::' port: 33060
[--] 8) 2019-04-15T05:04:00.460618Z 0 [System] [MY-010931] [Server] /usr/sbin/mysqld: ready for connections. Version: '8.0.15' socket: '/var/run/mysqld/mysqld.sock' port: 3306 MySQL Community Server - GPL.
[--] 9) 2019-03-12T11:58:38.728717Z 0 [System] [MY-011323] [Server] X Plugin ready for connections. Socket: '/var/run/mysqld/mysqlx.sock' bind-address: '::' port: 33060
[--] 10) 2019-03-12T11:58:38.600713Z 0 [System] [MY-010931] [Server] /usr/sbin/mysqld: ready for connections. Version: '8.0.15' socket: '/var/run/mysqld/mysqld.sock' port: 3306 MySQL Community Server - GPL.
[--] 22 shutdown(s) detected in /var/log/mysql/error.log
[--] 1) 2019-05-13T13:26:29.327609Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.0.15) MySQL Community Server - GPL.
[--] 2) 2019-05-13T07:38:19.288114Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.0.15) MySQL Community Server - GPL.
[--] 3) 2019-05-13T07:06:43.920937Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.0.15) MySQL Community Server - GPL.
[--] 4) 2019-03-12T11:58:03.346471Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.0.15) MySQL Community Server - GPL.
[--] 5) 2019-03-11T13:47:22.717934Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.0.15) MySQL Community Server - GPL.
[--] 6) 2019-02-08T12:50:45.420295Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.0.15) MySQL Community Server - GPL.
[--] 7) 2019-02-08T12:48:21.875168Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.0.15) MySQL Community Server - GPL.
[--] 8) 2019-02-07T14:00:22.036208Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.0.15) MySQL Community Server - GPL.
[--] 9) 2019-02-07T13:58:08.607776Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.0.15) MySQL Community Server - GPL.
[--] 10) 2019-02-07T13:58:06.536153Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.0.15) MySQL Community Server - GPL.

-------- Storage Engine Statistics -----------------------------------------------------------------
[--] Status: +ARCHIVE +BLACKHOLE +CSV -FEDERATED +InnoDB +MEMORY +MRG_MYISAM +MyISAM +PERFORMANCE_SCHEMA
[--] Data in InnoDB tables: 328.4M (Tables: 38)
[OK] Total fragmented tables: 0

-------- Analysis Performance Metrics --------------------------------------------------------------
[--] innodb_stats_on_metadata: OFF
[OK] No stat updates during querying INFORMATION_SCHEMA.

-------- Database Metrics --------------------------------------------------------------------------
[--] There is 1 Database(s).
[--] All User Databases:
[--] +-- TABLE : 43
[--] +-- ROWS : 232354
[--] +-- DATA : 296.8M(90.38%)
[--] +-- INDEX : 31.6M(9.62%)
[--] +-- SIZE : 328.4M
[--] +-- COLLA : 2 (NULL, utf8mb4_0900_ai_ci, utf8_general_ci, utf8_bin, utf8mb4_bin)
[--] +-- ENGIN : 1 (NULL, InnoDB, CSV, PERFORMANCE_SCHEMA)

[--] Database:x
[--] +-- TABLE: 43
[--] +-- COLL : 2 (utf8mb4_0900_ai_ci, NULL, utf8_general_ci)
[--] +-- ROWS : 232354
[--] +-- DATA : 296.8M(90.38%)
[--] +-- INDEX: 31.6M(9.62%)
[--] +-- TOTAL: 328.4M
[--] +-- ENGIN : 1 (InnoDB, NULL)
[!!] 2 different collations for database x
[OK] 1 engine for x database.
[--] Charsets for x database table column: utf8mb4, utf8, latin1
[!!] x table column(s) has several charsets defined for all text like column(s).
[--] Collations for x database table column: utf8mb4_0900_ai_ci, utf8_general_ci, latin1_swedish_ci
[!!] x table column(s) has several collations defined for all text like column(s).

-------- Table Column Metrics ----------------------------------------------------------------------
[--] Database: x
[--] +-- TABLE: x
[--] +-- Column x.id:
[!!] failed to execute: SELECT id FROM x PROCEDURE ANALYSE(100000)
[!!] FAIL Execute SQL / return code: 256
[--] Current Fieldtype: INT(10) UNSIGNED NOT NULL
[--] Optimal Fieldtype: Not available
[--] +-- Column x.name:
[!!] failed to execute: SELECT name FROM x PROCEDURE ANALYSE(100000)
[!!] FAIL Execute SQL / return code: 256
[--] Current Fieldtype: VARCHAR(50) NOT NULL
[--] Optimal Fieldtype: Not available
[--] +-- Column apigroups.rightsId:`

I tested with two users one with mysql_native_password and the other with caching_sha_password

Does someone have a solution?

jmrenouard added enhancement Help Wanted labels Apr 26, 2018

jmrenouard added a commit that referenced this issue Jun 29, 2018

#377 adding 0 as query cache efficiency for MySQL 8

a43032b

jmrenouard added this to TODO in Version 1.8 Jul 16, 2018

jmrenouard mentioned this issue Sep 19, 2018

MySQL 8.x support #399

Closed

jmrenouard added a commit that referenced this issue Sep 23, 2018

Hope to add MySQL 8 support! #377

b8ef183

MySQL 8: disabling Query cache recommandations MySQL 8: check password disabled due to new authentication storage model - Help wanted

kn007 closed this as completed Sep 25, 2018

jmrenouard moved this from TODO to In Progress in Version 1.8 Nov 15, 2018

Provide feedback

Saved searches

Use saved searches to filter your results more quickly

Hope to add MySQL 8 support! #377

Hope to add MySQL 8 support! #377

kn007 commented Apr 20, 2018

jmrenouard commented Apr 26, 2018

kn007 commented May 12, 2018

jmrenouard commented Jul 6, 2018

jmrenouard commented Sep 23, 2018

kn007 commented Sep 24, 2018

jmrenouard commented Sep 25, 2018

sghoe commented May 21, 2019 •

edited

Hope to add MySQL 8 support! #377

Hope to add MySQL 8 support! #377

Comments

kn007 commented Apr 20, 2018

jmrenouard commented Apr 26, 2018

kn007 commented May 12, 2018

jmrenouard commented Jul 6, 2018

jmrenouard commented Sep 23, 2018

kn007 commented Sep 24, 2018

jmrenouard commented Sep 25, 2018

sghoe commented May 21, 2019 • edited

sghoe commented May 21, 2019 •

edited