mirror of
https://github.com/MariaDB/server.git
synced 2025-04-08 00:05:34 +02:00
ca0c96fc89
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.
14 lines
739 B
Text
14 lines
739 B
Text
drop table if exists t1;
|
|
set @orig_table_open_cache = @@global.table_open_cache;
|
|
create table t1(a int) engine = tokudb partition by key(a) partitions 2 (partition p0 engine = tokudb, partition p1 engine = tokudb);
|
|
lock tables t1 read,t1 as t2 read,t1 as t3 read, t1 as t4 read, t1 as t5 read, t1 as t6 read, t1 as t7 read, t1 as t8 read, t1 as t9 read, t1 as t10 read;
|
|
set @@global.table_open_cache = 10;
|
|
begin;
|
|
insert into t1 values(1),(1);
|
|
select * from t1 where c like _ucs2 0x039C0025 collate ucs2_unicode_ci;
|
|
ERROR 42S22: Unknown column 'c' in 'where clause'
|
|
create table t1(c1 binary (1), c2 varbinary(1));
|
|
ERROR 42S01: Table 't1' already exists
|
|
unlock tables;
|
|
drop table t1;
|
|
set @@global.table_open_cache = @orig_table_open_cache;
|