Comments on: INFORMATION_SCHEMA Optimizations: still crashing my servers https://shlomi-noach.github.io/blog/mysql/information_schema-optimizations-still-crashing-my-servers Blog by Shlomi Noach Mon, 12 Dec 2011 13:06:09 +0000 hourly 1 https://wordpress.org/?v=5.3.3 By: shlomi https://shlomi-noach.github.io/blog/mysql/information_schema-optimizations-still-crashing-my-servers/comment-page-1#comment-62649 Mon, 12 Dec 2011 08:40:13 +0000 https://shlomi-noach.github.io/blog/?p=4561#comment-62649 @Daniel,
As my memory serves me right, I’ve seen several bug reports on this in the past (about I_S in general, I mean).
I have not filed a bug report as yet.

]]> By: Daniël van Eeden https://shlomi-noach.github.io/blog/mysql/information_schema-optimizations-still-crashing-my-servers/comment-page-1#comment-62648 Mon, 12 Dec 2011 08:38:22 +0000 https://shlomi-noach.github.io/blog/?p=4561#comment-62648 The I_S can indeed be a bit dangerous. I’ve seen a number of installations on which the table_(open_)cache was set to the default and there were were about 4000 tables. To find out the amount of used data inside the ibdata1 file (no innodb_file_per_table) a query against I_S.tables was done and this gave serious issues with the production traffic/queries.

Did you file a bugreport for this issue?

]]>