diff options
| author | Monty <monty@mariadb.org> | 2018-03-22 20:03:54 +0200 |
|---|---|---|
| committer | Monty <monty@mariadb.org> | 2018-03-26 17:53:17 +0300 |
| commit | ca0c96fc8925d36ea0c5121520bf7d8f12ad90a5 (patch) | |
| tree | 843095647e3a3d7c1d9be94954e51e9476729a68 /mysql-test/r/connect.result | |
| parent | 4d83b01537e3f1eb257a8e9a6416938e03adea59 (diff) | |
| download | mariadb-git-ca0c96fc8925d36ea0c5121520bf7d8f12ad90a5.tar.gz | |
Adjust table_open_cache to avoid getting error 24 (too many open files)
MDEV--15609 engines/funcs.crash_manytables_number crashes with error 24
(too many open files)
MDEV-10286 Adjustment of table_open_cache according to system limits
does not work when open-files-limit option is provided
Fixed by adjusting tc_size downwards if there is not enough file
descriptors to use.
Other changes:
- Ensure that there is 30 (was 10) extra file descriptors for other usage
- Decrease TABLE_OPEN_CACHE_MIN to 200 as it's better to have a smaller
table cache than getting error 24
- Increase minimum of max_connections and table_open_cache from 1 to 10
as 1 is not usable for any real application, only for testing.
Diffstat (limited to 'mysql-test/r/connect.result')
| -rw-r--r-- | mysql-test/r/connect.result | 9 |
1 files changed, 8 insertions, 1 deletions
diff --git a/mysql-test/r/connect.result b/mysql-test/r/connect.result index 315aea0ef46..cb66ff483e1 100644 --- a/mysql-test/r/connect.result +++ b/mysql-test/r/connect.result @@ -147,7 +147,7 @@ drop table t1; CREATE USER mysqltest_u1@localhost; GRANT USAGE ON *.* TO mysqltest_u1@localhost; -SET GLOBAL max_connections = 3; +SET GLOBAL max_connections = 10; SET GLOBAL event_scheduler = ON; # -- Waiting for Event Scheduler to start... @@ -191,6 +191,13 @@ event_scheduler mysqltest_u1 mysqltest_u1 mysqltest_u1 +mysqltest_u1 +mysqltest_u1 +mysqltest_u1 +mysqltest_u1 +mysqltest_u1 +mysqltest_u1 +mysqltest_u1 root # -- Resetting variables... |