Skip to content

Instantly share code, notes, and snippets.

@tadasuke

tadasuke/gist:3831636

Created October 4, 2012 05:26
Show Gist options
  • Save tadasuke/3831636 to your computer and use it in GitHub Desktop.
Save tadasuke/3831636 to your computer and use it in GitHub Desktop.
Download ZIP
MySQL パーティション関連
Raw
gistfile1.txt
パーティション確認
SHOW CREATE TABLE table_name;
どのパーティションが使われるか確認
EXPLAIN PARTITIONS SELECT * FROM table_name WHERE hoge = fuga;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment