select av.aq-psi.pq from ( select NVL(sum(bound_quantity),0) as aq from drop_ship_asin_availability where warehouse_id='GDEB' and asin='0718147707' and availability_type_cd ='IN' ) av, ( select NVL(sum(quantity),0) as pq from pending_shipment_items where warehouse_id='GDEB' and isbn='0718147707' ) psi
update inv_level_by_owner_physical set allocated_quantity=0 where inventory_level_by_owner_id in (8543605016, 9634213016); update inv_level_by_owner_physical set bound_quantity=0 where inventory_level_by_owner_id in (8543605016, 9634213016); update inv_level_by_location_physical set item_quantity=-61 where inventory_level_by_location_id in (12044015016); update inv_level_by_location_physical set available_quantity=-61 where inventory_level_by_location_id in (12044015016); update drop_ship_asin_availability set bound_quantity=0 where asin_availability_id in (3525379983, 3901789863); --- 11年9月16日，周五, [email protected] <[email protected]> 写道： 发件人: [email protected] <[email protected]> 主题: Abridged summary of [email protected] - 19 Messages in 3 Topics 收件人: "Abridged Recipients" <[email protected]> 日期: 2011年9月16日,周五,上午4:40 Today's Topic Summary Group: http://groups.google.com/group/memcached/topics How to change port memcache in XAMPP [2 Updates] Scaling Memcache to 10G [15 Updates] memory release problem of memcached_get [2 Updates] Topic: How to change port memcache in XAMPP Harry Saputra <[email protected]> Sep 14 06:38AM -0700 ^ How to change port memcache in XAMPP? by default is 11211. I want change it to 20202. thanks more... Paul Lindner <[email protected]> Sep 15 05:36PM -0700 ^ Something like this?: [Memcache] memcache.allow_failover = 1 memcache.max_failover_attempts=20 memcache.chunk_size =8192 memcache.default_port = 11211 just a guess... never used xampp more... Topic: Scaling Memcache to 10G Ripduman Sohan <[email protected]> Sep 15 03:54PM +0100 ^ Hi, I've been trying to opimise the performance of memcached (1.6) on 10G Ethernet and in doing so have created a series of patches that enable it to scale to link speed. Presently, memcache more... Ripduman Sohan <[email protected]> Sep 15 03:54PM +0100 ^ From: Ripduman Sohan <[email protected]> Signed-off-by: Ripduman Sohan <[email protected]> --- engines/default_engine/assoc.c | 2 -- 1 files changed, 0 insertions(+), more... Ripduman Sohan <[email protected]> Sep 15 03:54PM +0100 ^ From: Ripduman Sohan <[email protected]> It's cheaper and simpler to do a comparison based on a match with the (unique) memory address of the h_next item as opposed to doing a more... Ripduman Sohan <[email protected]> Sep 15 03:54PM +0100 ^ From: Ripduman Sohan <[email protected]> Changed default configuration behaviour so user has to explicitly ask for a debug build (--enable-debug configure parameter). more... Ripduman Sohan <[email protected]> Sep 15 03:54PM +0100 ^ From: Ripduman Sohan <[email protected]> Used the precomputed hash value as a primary indicator for optimising lookups and changes. We only do a memcmp() on lookup if item hash more... Ripduman Sohan <[email protected]> Sep 15 03:54PM +0100 ^ From: Ripduman Sohan <[email protected]> Basic idea - compute hash and store within item_hash, reduces computation overhead in subsequent operations. Also reduces the time more... Ripduman Sohan <[email protected]> Sep 15 03:54PM +0100 ^ From: Ripduman Sohan <[email protected]> This patch aims to allow multiple threads to make progress concurrently. It does this by modifying the code in 3 main ways: more... Ripduman Sohan <[email protected]> Sep 15 03:54PM +0100 ^ From: Ripduman Sohan <[email protected]> Changes: 1. Per bucket rwlock to increase parallelism. 2. cache_lock is now a rwlock, allowing safe expansion. Signed-off-by: Ripduman Sohan more... Ripduman Sohan <[email protected]> Sep 15 03:54PM +0100 ^ From: Ripduman Sohan <[email protected]> Changed from one itemlist lock to a lock for every LRU list with the aim of creating more opportunities for parallelism. Signed-off-by: more... Ripduman Sohan <[email protected]> Sep 15 03:54PM +0100 ^ From: Ripduman Sohan <[email protected]> The server goes into degraded mode when a hashtable expansion fails as every subsequent insert tries to trigger an expansion again. Changed more... Ripduman Sohan <[email protected]> Sep 15 03:54PM +0100 ^ From: Ripduman Sohan <[email protected]> Spinlocking keeps the thread active and spinning until it acquires the lock. Leads to slightly better performance in high-load situations as more... Ripduman Sohan <[email protected]> Sep 15 03:54PM +0100 ^ From: Ripduman Sohan <[email protected]> This improves the "item mutex" datastructure introduced in af3fcca940. To improve scalability, we now use an array of locks and the lower N more... dormando <[email protected]> Sep 15 11:08AM -0700 ^ > I have tried to keep the changes as self-contained and small as > possible and have tested them as extensively as I can, but I look > forward to your feedback and comments on the set. more... Ripduman Sohan <[email protected]> Sep 16 12:10AM +0100 ^ > changes from one to the other (if possible). > Thanks, > -Dormando Hi, Thanks for your feedback. I'll start to port the changes to a new engine as you've described. It is probable that more... dormando <[email protected]> Sep 15 04:20PM -0700 ^ > Hi, > Thanks for your feedback. I'll start to port the changes to a new engine as > you've described. It is probable that a significant portion of the gains are > realized even without storing the more... Topic: memory release problem of memcached_get Brian Aker <[email protected]> Sep 15 08:07AM -0700 ^ Hi! You should look at the manpage on memcached_get() to understand its behavior (and it does allocate memory and you are expected to deallocate it). more... "然 安" <[email protected]> Sep 13 09:38PM +0800 ^ Sorry, the client I used is libmemcached for C++. --- 11年9月13日，周二, BlueT - Matthew Lien <[email protected]> 写道： 发件人: BlueT - Matthew Lien <[email protected]> more...
