05 2014 档案

MySQL exists的用法介绍
摘要：有一个查询如下：SELECT c.CustomerId, CompanyName FROM Customers c WHERE EXISTS( SELECT OrderID FROM Orders o WHERE o.CustomerID = cu.CustomerI... 阅读全文

posted @ 2014-05-25 21:18 Still water run deep 阅读(766) 评论(0) 推荐(0)

Don’t Assume – Per Session Buffers
摘要：MySQL has a number of global buffers, i.e. your SGA. There are also a number of per session/thread buffers that combined with other memory usage const... 阅读全文

posted @ 2014-05-15 02:29 Still water run deep 阅读(355) 评论(0) 推荐(0)

MySQL 5.5: InnoDB Change Buffering
摘要：To speed up bulk loading of data, InnoDB implements aninsert buffer, a special index in the InnoDB system tablespace that buffers modifications to sec... 阅读全文

posted @ 2014-05-13 16:21 Still water run deep 阅读(1064) 评论(0) 推荐(0)

导航