MYSQL分区表学习
mysql> select table_name ,partition_name ,table_rowsfrom information_schema.partitionswhere table_schema=database() and table_name='t_my_series';+-------------+----------------+------------+
| table_name| partition_name | table_rows |
+-------------+----------------+------------+
| t_my_series | p0 | 194181 |
| t_my_series | p1 | 195304 |
| t_my_series | p2 | 195561 |
| t_my_series | p3 | 195840 |
| t_my_series | p4 | 195846 |
| t_my_series | p5 | 194445 |
| t_my_series | p6 | 196426 |
| t_my_series | p7 | 196451 |
| t_my_series | p8 | 196977 |
| t_my_series | p9 | 196975 |
| t_my_series | p10 | 194458 |
| t_my_series | p11 | 197833 |
| t_my_series | p12 | 198110 |
| t_my_series | p13 | 195024 |
| t_my_series | p14 | 195307 |
| t_my_series | p15 | 194732 |
| t_my_series | p16 | 197543 |
| t_my_series | p17 | 198973 |
| t_my_series | p18 | 199816 |
| t_my_series | p19 | 200422 |
| t_my_series | p20 | 200435 |
| t_my_series | p21 | 200725 |
| t_my_series | p22 | 201361 |
| t_my_series | p23 | 201512 |
| t_my_series | p24 | 201809 |
| t_my_series | p25 | 202377 |
| t_my_series | p26 | 202075 |
| t_my_series | p27 | 202926 |
| t_my_series | p28 | 202640 |
| t_my_series | p29 | 203215 |
| t_my_series | p30 | 203496 |
| t_my_series | p31 | 203486 |
| t_my_series | p32 | 203782 |
| t_my_series | p33 | 204371 |
| t_my_series | p34 | 204619 |
| t_my_series | p35 | 204618 |
| t_my_series | p36 | 204928 |
| t_my_series | p37 | 205467 |
| t_my_series | p38 | 205763 |
| t_my_series | p39 | 206055 |
| t_my_series | p40 | 206332 |
| t_my_series | p41 | 206307 |
| t_my_series | p42 | 206622 |
| t_my_series | p43 | 206897 |
| t_my_series | p44 | 207187 |
| t_my_series | p45 | 207451 |
| t_my_series | p46 | 208014 |
| t_my_series | p47 | 208315 |
| t_my_series | p48 | 208584 |
| t_my_series | p49 | 209175 |
| t_my_series | p50 | 209158 |
| t_my_series | p51 | 209434 |
| t_my_series | p52 | 198400 |
| t_my_series | p53 | 199586 |
| t_my_series | p54 | 209758 |
| t_my_series | p55 | 210566 |
| t_my_series | p56 | 210297 |
| t_my_series | p57 | 210850 |
| t_my_series | p58 | 210851 |
| t_my_series | p59 | 211148 |
| t_my_series | p60 | 211130 |
| t_my_series | p61 | 211416 |
| t_my_series | p62 | 211695 |
| t_my_series | p63 | 211706 |
| t_my_series | p64 | 211973 |
| t_my_series | p65 | 211987 |
| t_my_series | p66 | 212269 |
| t_my_series | p67 | 205186 |
| t_my_series | p68 | 212832 |
| t_my_series | p69 | 212827 |
| t_my_series | p70 | 212543 |
| t_my_series | p71 | 213120 |
| t_my_series | p72 | 213119 |
| t_my_series | p73 | 213382 |
| t_my_series | p74 | 213382 |
| t_my_series | p75 | 213382 |
| t_my_series | p76 | 213382 |
| t_my_series | p77 | 213382 |
| t_my_series | p78 | 213382 |
| t_my_series | p79 | 213382 |
| t_my_series | p80 | 213382 |
| t_my_series | p81 | 213382 |
| t_my_series | p82 | 213382 |
| t_my_series | p83 | 213382 |
| t_my_series | p84 | 208028 |
| t_my_series | p85 | 213382 |
| t_my_series | p86 | 213382 |
| t_my_series | p87 | 213382 |
| t_my_series | p88 | 213382 |
| t_my_series | p89 | 213382 |
| t_my_series | p90 | 192443 |
| t_my_series | p91 | 192472 |
| t_my_series | p92 | 192733 |
| t_my_series | p93 | 193009 |
| t_my_series | p94 | 193040 |
| t_my_series | p95 | 193588 |
| t_my_series | p96 | 193600 |
| t_my_series | p97 | 193598 |
| t_my_series | p98 | 193886 |
| t_my_series | p99 | 194169 |
+-------------+----------------+------------+
页:
[1]