Skip to content

Instantly share code, notes, and snippets.

@jywarren
Created May 30, 2014 15:43
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save jywarren/e82ccb5d4231b8669571 to your computer and use it in GitHub Desktop.
Save jywarren/e82ccb5d4231b8669571 to your computer and use it in GitHub Desktop.
measure of table sizes?
-- execute("ALTER TABLE content_field_bbox ENGINE = InnoDB")
-> 2.4616s
-- execute("ALTER TABLE content_field_image_gallery ENGINE = InnoDB")
-> 3.0838s
-- execute("ALTER TABLE content_field_main_image ENGINE = InnoDB")
-> 2.8453s
-- execute("ALTER TABLE content_field_map_editor ENGINE = InnoDB")
-> 0.4688s
-- execute("ALTER TABLE content_field_mappers ENGINE = InnoDB")
-> 0.4575s
-- execute("ALTER TABLE content_type_map ENGINE = InnoDB")
-> 1.5802s
-- execute("ALTER TABLE files ENGINE = InnoDB")
-> 1.1703s
-- execute("ALTER TABLE node ENGINE = InnoDB")
-> 2.5938s
-- execute("ALTER TABLE node_access ENGINE = InnoDB")
-> 1.5993s
-- execute("ALTER TABLE node_counter ENGINE = InnoDB")
-> 0.3368s
-- execute("ALTER TABLE node_revisions ENGINE = InnoDB")
-> 62.0373s
-- execute("ALTER TABLE profile_fields ENGINE = InnoDB")
-> 0.2144s
-- execute("ALTER TABLE profile_values ENGINE = InnoDB")
-> 103.6509s
-- execute("ALTER TABLE term_data ENGINE = InnoDB")
-> 1.4299s
-- execute("ALTER TABLE term_node ENGINE = InnoDB")
-> 0.6343s
-- execute("ALTER TABLE upload ENGINE = InnoDB")
-> 0.4594s
-- execute("ALTER TABLE url_alias ENGINE = InnoDB")
-> 253.0597s
-- execute("ALTER TABLE users ENGINE = InnoDB")
-> 290.7489s
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment