tag:blogger.com,1999:blog-1135944569112521190.post3389560276937626522..comments2024-03-28T08:20:49.787+01:00Comments on Daniël's Database Blog: Fun with Performance SchemaDaniël van Eedenhttp://www.blogger.com/profile/14757324605223498151noreply@blogger.comBlogger1125tag:blogger.com,1999:blog-1135944569112521190.post-39998121953831830702012-08-25T12:45:30.302+02:002012-08-25T12:45:30.302+02:00The "wait/io/file/sql/file_parser" event...The "wait/io/file/sql/file_parser" event is an interesting one as well. It records the time spent reading view definitions from frm files (so you obviously have some views as well).<br /><br />And it happens every time a view is accessed in all current released versions. <br /><br />I happen to know this is fixed in 5.6.7 however. Now a TABLE_SHARE object is created (which has been extended to take the File_parser object as well), and it gets cached in the same way as a table. <br /><br />Yet another win for 5.6 :)Mark Leithhttps://www.blogger.com/profile/07526409233197705882noreply@blogger.com