CLR Stored Procedure for Remove cache objects

2009-10-02 Thread Adi
All, I am using memcached on windows server 2003 and using Be.IT memcached client. How can i remove cache object when any direct database change occur, i want to invalidate / remove cache objects from memcached server, for this i am thinking about the CLR stored procedure. What if i write a

Re: CLR Stored Procedure for Remove cache objects

2009-10-02 Thread Henrik Schröder
In general, this is not the recommended usage of memcached. The best way is to have an object relational mapper that you handle all database access through and put your caching in that layer. That way you'll have cached objects or lists of objects above it, and you should be able to do all

Re: CLR Stored Procedure for Remove cache objects

2009-10-02 Thread Adi
I got your point, i don't want to cache the table rows. please explain object relational mapper? But In my scenario i have some utility like Microsoft ILM that synchronize user data from different system and i need to update or invalidate cache after the user info updated. for e.g. if the user

Re: CLR Stored Procedure for Remove cache objects

2009-10-02 Thread Dan Wierenga
-Original Message- From: memcached@googlegroups.com [mailto:memcac...@googlegroups.com] On Behalf Of Adi Sent: Friday, October 02, 2009 6:00 AM To: memcached Subject: Re: CLR Stored Procedure for Remove cache objects I got your point, i don't want to cache the table rows. please

memcached hangs suddenly and slows down

2009-10-02 Thread rch
I am using memcached in my production environment. It works fine 90% of the time. But suddenly, it slows down. when I try to connect via telnet the connect part is slow. How can I debug this? Also one more thing that is not clear is, stats shows the current connections more than 1024. I am

Re: CLR Stored Procedure for Remove cache objects

2009-10-02 Thread Kevin Amerson
You can also go with NHibernate and use NHibernate.Linq along with the NHibernate's memcached client that basically hooks in through configuration settings. On Fri, Oct 2, 2009 at 11:59 AM, Dan Wierenga dwiere...@gmail.com wrote: -Original Message- From: memcached@googlegroups.com

Re: memcached hangs suddenly and slows down

2009-10-02 Thread Ravi Chittari
Any one who can help on this? On Fri, Oct 2, 2009 at 8:43 AM, rch ravichitt...@gmail.com wrote: I am using memcached in my production environment. It works fine 90% of the time. But suddenly, it slows down. when I try to connect via telnet the connect part is slow. How can I debug this?

Re: memcached hangs suddenly and slows down

2009-10-02 Thread Edward M. Goldberg
Well I see that you are not getting lots of replies so I will step in. What I do is run a small CRON job that does a few Memcache actions like: Set key Get key Get status And watch the output for issues on each server. I use plain commands like: echo stats | nc localhost 11211 This way

Re: memcached hangs suddenly and slows down

2009-10-02 Thread Ravi Chittari
Thanks Edward. I do get an alarm when things are bad on the memcached. But the issue I want to figure out is, why and how it got itself into a bad state. Do you suggest turning on the debug logs? Out Of Memory errors. Time out on connect. No Connect. After a few week of looking at the issues, I

Re: memcached hangs suddenly and slows down

2009-10-02 Thread dormando
Hey, What version are you on? Is the machine it's on swapping? how much memory is free? cpu free? what's the general load on the box? What's the commandline you're using to start memcached? -Dormando On Fri, 2 Oct 2009, rch wrote: I am using memcached in my production environment. It

updating expires on read

2009-10-02 Thread Bill Moseley
I suspect asking this means my usage is wrong, but here goes. There's no way to touch a cached entry to update the expires time, correct? So, I have a pretty large item cached. It's mostly read only. It has an expires time, but every time it's read (or written) I want to extend the expires