diff options
| author | Varun Gupta <varun.gupta@mariadb.com> | 2018-12-09 13:25:27 +0530 |
|---|---|---|
| committer | Varun Gupta <varun.gupta@mariadb.com> | 2018-12-09 13:25:27 +0530 |
| commit | 9207a838ededa0d5f40129848de20a2075ab0e44 (patch) | |
| tree | e26a6d34fbe62ee2fd84010965c20990787865d8 /mysql-test/include | |
| parent | 93c360e3a53dbfe843bc4b769e73cbe9248cd5b3 (diff) | |
| download | mariadb-git-9207a838ededa0d5f40129848de20a2075ab0e44.tar.gz | |
MDEV-17255: New optimizer defaults and ANALYZE TABLE
Added to new values to the server variable use_stat_tables.
The values are COMPLEMENTARY_FOR_QUERIES and PREFERABLY_FOR_QUERIES.
Both these values don't allow to collect EITS for queries like
analyze table t1;
To collect EITS we would need to use the syntax with persistent like
analyze table t1 persistent for columns (col1,col2...) index (idx1, idx2...) / ALL
Changing the default value from NEVER to PREFERABLY_FOR_QUERIES.
Diffstat (limited to 'mysql-test/include')
| -rw-r--r-- | mysql-test/include/default_mysqld.cnf | 1 |
1 files changed, 1 insertions, 0 deletions
diff --git a/mysql-test/include/default_mysqld.cnf b/mysql-test/include/default_mysqld.cnf index 69a2b58288b..edae06ee7be 100644 --- a/mysql-test/include/default_mysqld.cnf +++ b/mysql-test/include/default_mysqld.cnf @@ -107,6 +107,7 @@ loose-performance-schema-consumer-thread-instrumentation=ON binlog-direct-non-transactional-updates default-storage-engine=myisam +use_stat_tables=preferably loose-ssl-ca=@ENV.MYSQL_TEST_DIR/std_data/cacert.pem loose-ssl-cert=@ENV.MYSQL_TEST_DIR/std_data/server-cert.pem |