有人能帮我解决问题吗。我有partion表( F_BUNDLCOL表示P5、6、7和8)。我不知道为什么当我选择数据从P5,7,8它非常快(只有0.26秒)
SELECT ri,rowid FROM creactor.F_BUNDLCOL WHERE part=5 AND status='0' and rownum<10
RI ROWID
---------- ---------------------------------------------------------------------------
227122 *BAXAClgCwQ
这是我的MySQL查询:
SELECT [columns] FROM article a
LEFT JOIN category_article ca ON a.id=ca.aid
LEFT JOIN category c1 ON c1.id=ca.cid
LEFT JOIN navigation n ON n.cid=c1.id
LEFT JOIN navigation nn ON nn.id=n.parent
LEFT JOIN category c2 ON nn.cid=c2.id
GROUP BY a
我无法在Ubuntu14.04中安装MySQL,因为它总是卡在:
apt-get install mysql-server-5.6
...
2014-12-19 20:15:06 0 [Warning] Using unique option prefix key_buffer instead of key_buffer_size is deprecated and will be removed in a future release. Please use the full name instead.
2014-12-19 20:15:06 0 [Warning] TIMESTAMP wi