<强>
,,*
,,*
<强>
,类之前,*
<="刷:bash;工具栏:假"> mysql>, select t.table_id table_id,, t.name table_name,, i.page_no root_page_no 我得到information_schema.INNODB_SYS_INDEXES information_schema.INNODB_SYS_TABLES t where i.table_id =, t.table_id 以及i.name =,“主”, 以及t.name like “mytest/%”; + - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - + - - - - - - - - - - - - - - - - + | |,table_id table_name ,,,,,,, |, root_page_no | + - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - + - - - - - - - - - - - - - - - - + |,,,,,,,22,|,mytest/customer ,, |,,,,,,,,,,,, 3 | |,,,,,,,21,|,mytest/district ,, |,,,,,,,,,,,, 3 | |,,,,,,,,27日|,mytest/item ,,,,,, |,,,,,,,,,,,, 3 | |,,,,,,,24,|,mytest/new_orders |,,,,,,,,,,,, 3 | |,,,,,,,,26日|,mytest/order_line |,,,,,,,,,,,, 3 | |,,,,,,,25,|,mytest/orders ,,,, |,,,,,,,,,,,, 3 | |,,,,,,,28,|,mytest/stock ,,,,, |,,,,,,,,,,,, 3 | |,,,,,,,20,|,mytest/warehouse , |,,,,,,,,,,,, 3 | + - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - + - - - - - - - - - - - - - - - - + 8,rows set 拷贝;(0.04,sec)
,类之前,*
<="刷:sql;工具栏:假"> mysql>, select 计数(1),得到order_line; +----------+ |,计数(1)| +----------+ |,,6001615 | +----------+ 1,row set 拷贝;(9.03,sec)
,*
,,
InnoDB - - - - - - - - - -查询物联网B +树的高度
