優(yōu)化mysql的limit offset的例子？在mysql中，limit通常用于分頁，并且經(jīng)常與ord:SQLgtselect * from us:select * from user_order_

優(yōu)化mysql的limit offset的例子？

在mysql中，limit通常用于分頁，并且經(jīng)常與ord:

SQLgtselect * from us:

select * from user_order_info內(nèi)部聯(lián)接(select pin from user _ order _ info limit 1000000，5) as lim using(pin)

SQLgtexplain select * from user _ order _ info限制1000000，5

- - - - - - - - - -

| id | select _ type | table | type | possible _ keys | key | key _ len | ref | rows | Extra |

- - - - - - - - - -

| 1 |簡單|用戶訂單信息|全部|空|空|空|空| 23131886 | |

- - - -- - - - - - -

集合中的1行(0.00秒)

SQLgtexplain擴(kuò)展select * from user_order_info內(nèi)部聯(lián)接(select pin from user _ order _ info limit 1000000，5) as lim using(pin)

- - - - - - - - - - -

| id | select _ typ

數(shù)據(jù)庫，分表后，怎么進(jìn)行分頁查詢？Mysql分庫分表方案？

可以先統(tǒng)計(jì)表數(shù)，然后根據(jù)頁數(shù)取數(shù)據(jù)或者使用中間件取數(shù)據(jù)。