[Pgpool-hackers] patch "Caching query results in pgpool-II"

[Masanori Yamazaki]

I am sending new patch files.
I tested the program using temporary TABLE OID for test.
Bug is fixed.

The following are working.
- Manage TABLE OID
Set cache data on memcached. Key is MD5(username + query + databasename).
Write MD5 key in text file. File is named (tamporary)TABLE OID.
MD5 key is written every line in text file.
If table is updated(still using "check_ineligible_cache" function),
delete cache data on memcached using MD5 key in TABLE OID's file,
and remove this file related to updated table.

-- 
best regards
Masanori YAMAZAKI
email: m.yamazaki23 at gmail.com



2011/6/30 Tatsuo Ishii <ishii at sraoss.co.jp>

> >>> 3) What is this code doing? "con" is never
> >>>   used. memqcache_total_size's 3rd arg is "oid", while you are
> >>>   passing a file descriptor.
> >>>        /* save the received result to buf for each kind */
> >>>        if (pool_config->memory_cache_
> > enabled)
> >>>        {
> >>>                char* con;
> >>>                memqcache_register(kind, frontend, frontend->fd, p1,
> > len1);
> >>>        }
> > I corrected it. I think that "backend->info->key" is table oid.
> > Is it wrong?
>
> Wrong. See ConnectionInfo.
>
>        int                     key;    /* cancel key */
> --
> Tatsuo Ishii
> SRA OSS, Inc. Japan
> English: http://www.sraoss.co.jp/index_en.php
> Japanese: http://www.sraoss.co.jp
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://pgfoundry.org/pipermail/pgpool-hackers/attachments/20110718/ceb309bb/attachment-0001.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: memqcache_patch.tar.gz
Type: application/x-gzip
Size: 20917 bytes
Desc: not available
URL: <http://pgfoundry.org/pipermail/pgpool-hackers/attachments/20110718/ceb309bb/attachment-0001.bin>