… | | REPORT_PORT | 5530 | 5610 | | PERFORMANCE_SCHEMA_MAX_FILE_INSTANCES | 10000 | 1556 | | SQL_MODE | | NO_ENGINE_SUBSTITUTION | | … by default in MySQL 5.6 Welcome to much faster information_schema queries! innodb_log_file_…such as using MySQL on NFS file system). innodb_data_file_path got a small …
Post: MySQL opening .frm even when table is in table definition cache
November 21, 2011 By 8 Comments
…_type(). In MySQL 5.1, for some reason yet unknown to humans, it lives in sql/sql_view.cc as mysql_frm_type(). What… called from several code paths in the server: DROP TABLE RENAME TABLE DROP VIEW open table filling INFORMATION_SCHEMA tables (I think it… of this bit of code is that MySQL may cause unnecessary disk IO for information it already has cached (often at least…
Post: Knowing what pt-online-schema-change will do
November 1, 2012 By 1 Comment
…-online-schema-change changes nothing but prints a lot of information …` = ? AND `score` <= ?) ) /*pt-online-schema-change 10451 copy nibble*/ SELECT /*!40001 SQL_NO_CACHE */ `guest…nearly all the same code paths that it will execute when … tool, problems with the MySQL server (privileges, etc.), or …
