]> git.pld-linux.org Git - packages/mysql.git/blame - mysql-innodb_dict_size_limit.patch
projects / packages / mysql.git / blame
? search:
summary | shortlog | log | commit | commitdiff | tree
blob | blame (incremental) | history | HEAD
- resurrect more options, bconds, post-fix mysql_config
[packages/mysql.git] / mysql-innodb_dict_size_limit.patch
CommitLineData
d0da6fe5
ER		 1diff -ru mysql-5.0.75_base/innobase/dict/dict0boot.c mysql-5.0.75/innobase/dict/dict0boot.c
2--- mysql-5.0.75_base/innobase/dict/dict0boot.c 2008-12-19 02:19:35.000000000 +0900
3+++ mysql-5.0.75/innobase/dict/dict0boot.c 2009-01-23 19:28:25.000000000 +0900
4@@ -247,6 +247,7 @@
5 system tables */
6 /*-------------------------*/
7 table = dict_mem_table_create("SYS_TABLES", DICT_HDR_SPACE, 8, FALSE);
8+ table->n_mysql_handles_opened = 1; /* for pin */
9
10 dict_mem_table_add_col(table, "NAME", DATA_BINARY, 0, 0, 0);
11 dict_mem_table_add_col(table, "ID", DATA_BINARY, 0, 0, 0);
12@@ -283,6 +284,7 @@
13 ut_a(success);
14 /*-------------------------*/
15 table = dict_mem_table_create("SYS_COLUMNS", DICT_HDR_SPACE, 7, FALSE);
16+ table->n_mysql_handles_opened = 1; /* for pin */
17
18 dict_mem_table_add_col(table, "TABLE_ID", DATA_BINARY,0,0,0);
19 dict_mem_table_add_col(table, "POS", DATA_INT, 0, 4, 0);
20@@ -309,6 +311,7 @@
21 ut_a(success);
22 /*-------------------------*/
23 table = dict_mem_table_create("SYS_INDEXES", DICT_HDR_SPACE, 7, FALSE);
24+ table->n_mysql_handles_opened = 1; /* for pin */
25
26 dict_mem_table_add_col(table, "TABLE_ID", DATA_BINARY, 0,0,0);
27 dict_mem_table_add_col(table, "ID", DATA_BINARY, 0, 0, 0);
28@@ -345,6 +348,7 @@
29 ut_a(success);
30 /*-------------------------*/
31 table = dict_mem_table_create("SYS_FIELDS", DICT_HDR_SPACE, 3, FALSE);
32+ table->n_mysql_handles_opened = 1; /* for pin */
33
34 dict_mem_table_add_col(table, "INDEX_ID", DATA_BINARY, 0,0,0);
35 dict_mem_table_add_col(table, "POS", DATA_INT, 0, 4, 0);
36diff -ru mysql-5.0.75_base/innobase/dict/dict0crea.c mysql-5.0.75/innobase/dict/dict0crea.c
37--- mysql-5.0.75_base/innobase/dict/dict0crea.c 2008-12-19 02:19:35.000000000 +0900
38+++ mysql-5.0.75/innobase/dict/dict0crea.c 2009-01-23 19:41:38.000000000 +0900
39@@ -1178,6 +1178,9 @@
40 /* Foreign constraint system tables have already been
41 created, and they are ok */
42
43+ table1->n_mysql_handles_opened = 1; /* for pin */
44+ table2->n_mysql_handles_opened = 1; /* for pin */
45+
46 mutex_exit(&(dict_sys->mutex));
47
48 return(DB_SUCCESS);
49@@ -1266,6 +1269,11 @@
50
51 trx->op_info = "";
52
53+ table1 = dict_table_get_low("SYS_FOREIGN");
54+ table2 = dict_table_get_low("SYS_FOREIGN_COLS");
55+ table1->n_mysql_handles_opened = 1; /* for pin */
56+ table2->n_mysql_handles_opened = 1; /* for pin */
57+
58 row_mysql_unlock_data_dictionary(trx);
59
60 trx_free_for_mysql(trx);
61diff -ru mysql-5.0.75_base/innobase/dict/dict0dict.c mysql-5.0.75/innobase/dict/dict0dict.c
62--- mysql-5.0.75_base/innobase/dict/dict0dict.c 2008-12-19 02:19:35.000000000 +0900
63+++ mysql-5.0.75/innobase/dict/dict0dict.c 2009-01-26 16:03:29.000000000 +0900
64@@ -638,6 +638,8 @@
65 mutex_enter(&(dict_sys->mutex));
66
67 table = dict_table_get_on_id_low(table_id, trx);
68+
69+ dict_table_LRU_trim(table);
70
71 mutex_exit(&(dict_sys->mutex));
72
73@@ -752,6 +754,8 @@
74
75 table = dict_table_get_low(table_name);
76
77+ dict_table_LRU_trim(table);
78+
79 mutex_exit(&(dict_sys->mutex));
80
81 if (table != NULL) {
82@@ -787,6 +791,8 @@
83 table->n_mysql_handles_opened++;
84 }
85
86+ dict_table_LRU_trim(table);
87+
88 mutex_exit(&(dict_sys->mutex));
89
90 if (table != NULL) {
91@@ -1267,20 +1273,64 @@
92 too much space. Currently not used! */
93
94 void
95-dict_table_LRU_trim(void)
96-/*=====================*/
97+dict_table_LRU_trim(
98+/*================*/
99+ dict_table_t* self)
100 {
101 dict_table_t* table;
102 dict_table_t* prev_table;
103+ dict_foreign_t* foreign;
104+ ulint n_removed;
105+ ulint n_have_parent;
106+ ulint cached_foreign_tables;
107
108- ut_error;
109+ //ut_error;
110
111 #ifdef UNIV_SYNC_DEBUG
112 ut_ad(mutex_own(&(dict_sys->mutex)));
113 #endif /* UNIV_SYNC_DEBUG */
114
115+retry:
116+ n_removed = n_have_parent = 0;
117 table = UT_LIST_GET_LAST(dict_sys->table_LRU);
118
119+ while ( srv_dict_size_limit && table
120+ && ((dict_sys->table_hash->n_cells
121+ + dict_sys->table_id_hash->n_cells
122+ + dict_sys->col_hash->n_cells) * sizeof(hash_cell_t)
123+ + dict_sys->size) > srv_dict_size_limit ) {
124+ prev_table = UT_LIST_GET_PREV(table_LRU, table);
125+
126+ if (table == self || table->n_mysql_handles_opened)
127+ goto next_loop;
128+
129+ cached_foreign_tables = 0;
130+ foreign = UT_LIST_GET_FIRST(table->foreign_list);
131+ while (foreign != NULL) {
132+ if (foreign->referenced_table)
133+ cached_foreign_tables++;
134+ foreign = UT_LIST_GET_NEXT(foreign_list, foreign);
135+ }
136+
137+ /* TODO: use table->mem_fix also, if it becomes exact. */
138+
139+ if (cached_foreign_tables == 0) {
140+ dict_table_remove_from_cache(table);
141+ n_removed++;
142+ } else {
143+ n_have_parent++;
144+ }
145+next_loop:
146+ table = prev_table;
147+ }
148+
149+ if ( srv_dict_size_limit && n_have_parent && n_removed
150+ && ((dict_sys->table_hash->n_cells
151+ + dict_sys->table_id_hash->n_cells
152+ + dict_sys->col_hash->n_cells) * sizeof(hash_cell_t)
153+ + dict_sys->size) > srv_dict_size_limit )
154+ goto retry;
155+/*
156 while (table && (dict_sys->size >
157 buf_pool_get_max_size() / DICT_POOL_PER_VARYING)) {
158
159@@ -1292,6 +1341,7 @@
160
161 table = prev_table;
162 }
163+*/
164 }
165
166 /**************************************************************************
167diff -ru mysql-5.0.75_base/innobase/ibuf/ibuf0ibuf.c mysql-5.0.75/innobase/ibuf/ibuf0ibuf.c
168--- mysql-5.0.75_base/innobase/ibuf/ibuf0ibuf.c 2009-01-23 11:44:18.000000000 +0900
169+++ mysql-5.0.75/innobase/ibuf/ibuf0ibuf.c 2009-01-23 19:22:54.000000000 +0900
170@@ -535,6 +535,7 @@
171 sprintf(buf, "SYS_IBUF_TABLE_%lu", (ulong) space);
172 /* use old-style record format for the insert buffer */
173 table = dict_mem_table_create(buf, space, 2, FALSE);
174+ table->n_mysql_handles_opened = 1; /* for pin */
175
176 dict_mem_table_add_col(table, "PAGE_NO", DATA_BINARY, 0, 0, 0);
177 dict_mem_table_add_col(table, "TYPES", DATA_BINARY, 0, 0, 0);
178diff -ru mysql-5.0.75_base/innobase/include/dict0dict.h mysql-5.0.75/innobase/include/dict0dict.h
179--- mysql-5.0.75_base/innobase/include/dict0dict.h 2008-12-19 02:19:35.000000000 +0900
180+++ mysql-5.0.75/innobase/include/dict0dict.h 2009-01-23 21:46:22.000000000 +0900
181@@ -938,6 +938,11 @@
182 const char* ptr, /* in: scan from */
183 const char* string);/* in: look for this */
184
185+void
186+dict_table_LRU_trim(
187+/*================*/
188+ dict_table_t* self);
189+
190 /* Buffers for storing detailed information about the latest foreign key
191 and unique key errors */
192 extern FILE* dict_foreign_err_file;
193diff -ru mysql-5.0.75_base/innobase/include/dict0dict.ic mysql-5.0.75/innobase/include/dict0dict.ic
194--- mysql-5.0.75_base/innobase/include/dict0dict.ic 2008-12-19 02:19:35.000000000 +0900
195+++ mysql-5.0.75/innobase/include/dict0dict.ic 2009-01-23 18:35:55.000000000 +0900
196@@ -533,6 +533,13 @@
197
198 HASH_SEARCH(name_hash, dict_sys->table_hash, table_fold, table,
199 ut_strcmp(table->name, table_name) == 0);
200+
201+ /* make young in table_LRU */
202+ if (table) {
203+ UT_LIST_REMOVE(table_LRU, dict_sys->table_LRU, table);
204+ UT_LIST_ADD_FIRST(table_LRU, dict_sys->table_LRU, table);
205+ }
206+
207 return(table);
208 }
209
210@@ -592,6 +599,10 @@
211 if (table != NULL) {
212 table->mem_fix++;
213
214+ /* make young in table_LRU */
215+ UT_LIST_REMOVE(table_LRU, dict_sys->table_LRU, table);
216+ UT_LIST_ADD_FIRST(table_LRU, dict_sys->table_LRU, table);
217+
218 /* lock_push(trx, table, LOCK_DICT_MEM_FIX) */
219 }
220
221diff -ru mysql-5.0.75_base/innobase/include/srv0srv.h mysql-5.0.75/innobase/include/srv0srv.h
222--- mysql-5.0.75_base/innobase/include/srv0srv.h 2009-01-23 11:44:19.000000000 +0900
223+++ mysql-5.0.75/innobase/include/srv0srv.h 2009-01-27 10:47:26.000000000 +0900
224@@ -146,6 +146,8 @@
225 extern uint srv_read_ahead;
226 extern ulint srv_adaptive_checkpoint;
227
228+extern ulint srv_dict_size_limit;
229+
230 extern volatile ibool srv_io_pattern;
231 extern ulong srv_io_pattern_trace;
232 extern ulong srv_io_pattern_trace_running;
233@@ -545,6 +547,7 @@
234 ulint innodb_data_writes;
235 ulint innodb_data_written;
236 ulint innodb_data_reads;
237+ ulint innodb_dict_tables;
238 ulint innodb_buffer_pool_pages_total;
239 ulint innodb_buffer_pool_pages_data;
240 ulint innodb_buffer_pool_pages_dirty;
241diff -ru mysql-5.0.75_base/innobase/srv/srv0srv.c mysql-5.0.75/innobase/srv/srv0srv.c
242--- mysql-5.0.75_base/innobase/srv/srv0srv.c 2009-01-23 11:44:19.000000000 +0900
243+++ mysql-5.0.75/innobase/srv/srv0srv.c 2009-01-27 10:52:19.000000000 +0900
244@@ -345,6 +345,8 @@
245 uint srv_read_ahead = 3; /* 1: random 2: linear 3: Both */
246 ulint srv_adaptive_checkpoint = 0; /* 0:disable 1:enable */
247
248+ulint srv_dict_size_limit = 0;
249+
250 volatile ibool srv_io_pattern = FALSE;
251 ulint srv_io_pattern_trace = 0;
252 ulint srv_io_pattern_trace_running = 0;
253@@ -1936,6 +1938,7 @@
254 export_vars.innodb_data_reads= os_n_file_reads;
255 export_vars.innodb_data_writes= os_n_file_writes;
256 export_vars.innodb_data_written= srv_data_written;
257+ export_vars.innodb_dict_tables= (dict_sys ? UT_LIST_GET_LEN(dict_sys->table_LRU) : 0);
258 export_vars.innodb_buffer_pool_read_requests= buf_pool->n_page_gets;
259 export_vars.innodb_buffer_pool_write_requests= srv_buf_pool_write_requests;
260 export_vars.innodb_buffer_pool_wait_free= srv_buf_pool_wait_free;
261diff -ru mysql-5.0.75_base/sql/ha_innodb.cc mysql-5.0.75/sql/ha_innodb.cc
262--- mysql-5.0.75_base/sql/ha_innodb.cc 2009-01-23 11:44:19.000000000 +0900
263+++ mysql-5.0.75/sql/ha_innodb.cc 2009-01-27 10:54:08.000000000 +0900
264@@ -288,6 +288,8 @@
265 (char*) &export_vars.innodb_dblwr_pages_written, SHOW_LONG},
266 {"dblwr_writes",
267 (char*) &export_vars.innodb_dblwr_writes, SHOW_LONG},
268+ {"dict_tables",
269+ (char*) &export_vars.innodb_dict_tables, SHOW_LONG},
270 {"log_waits",
271 (char*) &export_vars.innodb_log_waits, SHOW_LONG},
272 {"log_write_requests",
273diff -ru mysql-5.0.75_base/sql/ha_innodb.h mysql-5.0.75/sql/ha_innodb.h
274--- mysql-5.0.75_base/sql/ha_innodb.h 2009-01-23 11:44:19.000000000 +0900
275+++ mysql-5.0.75/sql/ha_innodb.h 2009-01-26 15:49:37.000000000 +0900
276@@ -242,6 +242,7 @@
277 extern ulong srv_flush_neighbor_pages;
278 extern uint srv_read_ahead;
279 extern ulong srv_adaptive_checkpoint;
280+extern ulong srv_dict_size_limit;
281 extern ulong srv_show_locks_held;
282 extern ulong srv_show_verbose_locks;
283 extern ulong srv_io_pattern_trace;
284diff -ru mysql-5.0.75_base/sql/mysqld.cc mysql-5.0.75/sql/mysqld.cc
285--- mysql-5.0.75_base/sql/mysqld.cc 2009-01-23 11:44:19.000000000 +0900
286+++ mysql-5.0.75/sql/mysqld.cc 2009-01-26 15:29:45.000000000 +0900
287@@ -5053,6 +5053,7 @@
288 OPT_INNODB_ADAPTIVE_CHECKPOINT,
289 OPT_INNODB_READ_IO_THREADS,
290 OPT_INNODB_WRITE_IO_THREADS,
291+ OPT_INNODB_DICT_SIZE_LIMIT,
292 OPT_INNODB_ADAPTIVE_HASH_INDEX,
293 OPT_RPL_MIRROR_BINLOG,
294 OPT_SYNC_MIRROR_BINLOG,
295@@ -5406,6 +5407,10 @@
296 "Number of background write I/O threads in InnoDB.",
297 (gptr*) &innobase_write_io_threads, (gptr*) &innobase_write_io_threads,
298 0, GET_LONG, REQUIRED_ARG, 1, 1, 64, 0, 0, 0},
299+ {"innodb_dict_size_limit", OPT_INNODB_DICT_SIZE_LIMIT,
300+ "Limit the allocated memory for dictionary cache. (0: unlimited)",
301+ (gptr*) &srv_dict_size_limit, (gptr*) &srv_dict_size_limit, 0,
302+ GET_ULONG, REQUIRED_ARG, 0, 0, ULONG_MAX, 0, 0 ,0},
303 {"innodb_io_pattern_trace", OPT_INNODB_IO_PATTERN_TRACE,
304 "Create/Drop the internal hash table for IO pattern tracing.",
305 (gptr*) &srv_io_pattern_trace, (gptr*) &srv_io_pattern_trace,
306diff -ru mysql-5.0.75_base/sql/set_var.cc mysql-5.0.75/sql/set_var.cc
307--- mysql-5.0.75_base/sql/set_var.cc 2009-01-23 11:44:19.000000000 +0900
308+++ mysql-5.0.75/sql/set_var.cc 2009-01-26 15:46:45.000000000 +0900
309@@ -522,6 +522,8 @@
310 &innodb_read_ahead_typelib, fix_innodb_read_ahead);
311 sys_var_long_ptr sys_innodb_adaptive_checkpoint("innodb_adaptive_checkpoint",
312 &srv_adaptive_checkpoint);
313+sys_var_long_ptr sys_innodb_dict_size_limit("innodb_dict_size_limit",
314+ &srv_dict_size_limit);
315 sys_var_long_ptr sys_innodb_show_locks_held(
316 "innodb_show_locks_held",
317 &srv_show_locks_held);
318@@ -905,6 +907,7 @@
319 &sys_innodb_flush_neighbor_pages,
320 &sys_innodb_read_ahead,
321 &sys_innodb_adaptive_checkpoint,
322+ &sys_innodb_dict_size_limit,
323 &sys_innodb_show_locks_held,
324 &sys_innodb_show_verbose_locks,
325 &sys_innodb_io_pattern_trace,
326@@ -1056,6 +1059,7 @@
327 {sys_innodb_adaptive_checkpoint.name, (char*) &sys_innodb_adaptive_checkpoint, SHOW_SYS},
328 {"innodb_read_io_threads", (char*) &innobase_read_io_threads, SHOW_LONG},
329 {"innodb_write_io_threads", (char*) &innobase_write_io_threads, SHOW_LONG},
330+ {sys_innodb_dict_size_limit.name, (char*) &sys_innodb_dict_size_limit, SHOW_SYS},
331 {sys_innodb_io_pattern_trace.name, (char*) &sys_innodb_io_pattern_trace, SHOW_SYS},
332 {sys_innodb_io_pattern_trace_running.name, (char*) &sys_innodb_io_pattern_trace_running, SHOW_SYS},
333 {sys_innodb_io_pattern_size_limit.name, (char*) &sys_innodb_io_pattern_size_limit, SHOW_SYS},
334diff -ruN mysql-5.0.75_base/mysql-test/r/innodb_dict_size_limit.result mysql-5.0.75/mysql-test/r/innodb_dict_size_limit.result
335--- /dev/null 1970-01-01 09:00:00.000000000 +0900
336+++ mysql-5.0.75/mysql-test/r/innodb_dict_size_limit.result 2009-01-27 11:43:46.000000000 +0900
337@@ -0,0 +1,60 @@
338+DROP TABLE IF EXISTS `test_5`;
339+DROP TABLE IF EXISTS `test_4`;
340+DROP TABLE IF EXISTS `test_3`;
341+DROP TABLE IF EXISTS `test_2`;
342+DROP TABLE IF EXISTS `test_1`;
343+SET storage_engine=InnoDB;
344+SET GLOBAL innodb_dict_size_limit=1;
345+FLUSH TABLES;
346+CREATE TABLE `test_1` (`a` int, `b` int, PRIMARY KEY (`a`));
347+CREATE TABLE `test_2` (`a` int, `b` int, PRIMARY KEY (`a`));
348+CREATE TABLE `test_3` (`a` int, `b` int, PRIMARY KEY (`a`));
349+CREATE TABLE `test_4` (`a` int, `b` int, PRIMARY KEY (`a`));
350+CREATE TABLE `test_5` (`a` int, `b` int, PRIMARY KEY (`a`));
351+ALTER TABLE `test_5` ADD CONSTRAINT FOREIGN KEY(`b`) REFERENCES `test_4`(`a`);
352+ALTER TABLE `test_4` ADD CONSTRAINT FOREIGN KEY(`b`) REFERENCES `test_3`(`a`);
353+SHOW GLOBAL STATUS LIKE 'Innodb_dict_tables';
354+Variable_name Value
355+Innodb_dict_tables 9
356+FLUSH TABLES;
357+SELECT * FROM `test_1`;
358+a b
359+SHOW GLOBAL STATUS LIKE 'Innodb_dict_tables';
360+Variable_name Value
361+Innodb_dict_tables 8
362+SELECT * FROM `test_3`;
363+a b
364+SHOW GLOBAL STATUS LIKE 'Innodb_dict_tables';
365+Variable_name Value
366+Innodb_dict_tables 11
367+FLUSH TABLES;
368+SELECT * FROM `test_2`;
369+a b
370+SHOW GLOBAL STATUS LIKE 'Innodb_dict_tables';
371+Variable_name Value
372+Innodb_dict_tables 8
373+SELECT * FROM `test_1`;
374+a b
375+FLUSH TABLES;
376+SELECT * FROM `test_4`;
377+a b
378+SHOW GLOBAL STATUS LIKE 'Innodb_dict_tables';
379+Variable_name Value
380+Innodb_dict_tables 9
381+SELECT * FROM `test_3`;
382+a b
383+SHOW GLOBAL STATUS LIKE 'Innodb_dict_tables';
384+Variable_name Value
385+Innodb_dict_tables 10
386+SET GLOBAL innodb_dict_size_limit=0;
387+FLUSH TABLES;
388+SELECT * FROM `test_2`;
389+a b
390+SHOW GLOBAL STATUS LIKE 'Innodb_dict_tables';
391+Variable_name Value
392+Innodb_dict_tables 11
393+DROP TABLE `test_5`;
394+DROP TABLE `test_4`;
395+DROP TABLE `test_3`;
396+DROP TABLE `test_2`;
397+DROP TABLE `test_1`;
398diff -ruN mysql-5.0.75_base/mysql-test/t/innodb_dict_size_limit.test mysql-5.0.75/mysql-test/t/innodb_dict_size_limit.test
399--- /dev/null 1970-01-01 09:00:00.000000000 +0900
400+++ mysql-5.0.75/mysql-test/t/innodb_dict_size_limit.test 2009-01-27 11:43:36.000000000 +0900
401@@ -0,0 +1,63 @@
402+#
403+# Test for new variable innodb_dict_size_limit;
404+#
405+-- source include/have_innodb.inc
406+
407+--disable_warnings
408+DROP TABLE IF EXISTS `test_5`;
409+DROP TABLE IF EXISTS `test_4`;
410+DROP TABLE IF EXISTS `test_3`;
411+DROP TABLE IF EXISTS `test_2`;
412+DROP TABLE IF EXISTS `test_1`;
413+--enable_warnings
414+
415+SET storage_engine=InnoDB;
416+SET GLOBAL innodb_dict_size_limit=1;
417+
418+FLUSH TABLES;
419+
420+CREATE TABLE `test_1` (`a` int, `b` int, PRIMARY KEY (`a`));
421+CREATE TABLE `test_2` (`a` int, `b` int, PRIMARY KEY (`a`));
422+CREATE TABLE `test_3` (`a` int, `b` int, PRIMARY KEY (`a`));
423+CREATE TABLE `test_4` (`a` int, `b` int, PRIMARY KEY (`a`));
424+CREATE TABLE `test_5` (`a` int, `b` int, PRIMARY KEY (`a`));
425+
426+ALTER TABLE `test_5` ADD CONSTRAINT FOREIGN KEY(`b`) REFERENCES `test_4`(`a`);
427+ALTER TABLE `test_4` ADD CONSTRAINT FOREIGN KEY(`b`) REFERENCES `test_3`(`a`);
428+
429+SHOW GLOBAL STATUS LIKE 'Innodb_dict_tables';
430+
431+FLUSH TABLES;
432+SELECT * FROM `test_1`;
433+
434+SHOW GLOBAL STATUS LIKE 'Innodb_dict_tables';
435+
436+SELECT * FROM `test_3`;
437+
438+SHOW GLOBAL STATUS LIKE 'Innodb_dict_tables';
439+
440+FLUSH TABLES;
441+SELECT * FROM `test_2`;
442+
443+SHOW GLOBAL STATUS LIKE 'Innodb_dict_tables';
444+
445+SELECT * FROM `test_1`;
446+FLUSH TABLES;
447+SELECT * FROM `test_4`;
448+SHOW GLOBAL STATUS LIKE 'Innodb_dict_tables';
449+
450+SELECT * FROM `test_3`;
451+SHOW GLOBAL STATUS LIKE 'Innodb_dict_tables';
452+
453+SET GLOBAL innodb_dict_size_limit=0;
454+FLUSH TABLES;
455+SELECT * FROM `test_2`;
456+
457+SHOW GLOBAL STATUS LIKE 'Innodb_dict_tables';
458+
459+DROP TABLE `test_5`;
460+DROP TABLE `test_4`;
461+DROP TABLE `test_3`;
462+DROP TABLE `test_2`;
463+DROP TABLE `test_1`;
464+
465diff -ruN mysql-5.0.75_base/patch_info/innodb_dict_size_limit.info mysql-5.0.75/patch_info/innodb_dict_size_limit.info
466--- /dev/null 1970-01-01 09:00:00.000000000 +0900
467+++ mysql-5.0.75/patch_info/innodb_dict_size_limit.info 2009-01-26 15:46:45.000000000 +0900
468@@ -0,0 +1,9 @@
469+File=innodb_dict_size_limit.patch
470+Name=Limit dictionary cache size
471+Version=1.0
472+Author=Percona
473+License=GPL
474+Comment=Variable innodb_dict_size_limit in bytes
475+ChangeLog=
476+2009-01-26
477+YK: Initial release
MySQL: a very fast and reliable SQL database engine
This page took 0.070324 seconds and 4 git commands to generate.