Re: [GENERAL] Memcached for Database server

2011-05-22 Thread Craig Ringer
On 20/05/11 17:33, Adarsh Sharma wrote: > Craig Ringer wrote: >> >> category_id Record_id fields >> 7821 {Village:adasrpur, SOI:media, Heading:CM dies >> > > Yes , but slight modification , I want Village, SOI Heading as column > names and adasrpur,media and CM dies their

Re: [GENERAL] Memcached for Database server

2011-05-20 Thread Craig Ringer
Please reply to the list, not directly to me. My reply follows. On 20/05/11 14:47, Adarsh Sharma wrote: > But Sometimes when I got stucked , I have no other option. Like I > stucked from the past 4 days to solve the attached problem. Sure. Sometimes you get stuck, and that's what mailing lists

Re: [GENERAL] Memcached for Database server

2011-05-19 Thread Craig Ringer
On 20/05/11 13:00, Adarsh Sharma wrote: > Thanks Craig, > > I spend some time on Memcahced and your explaination also helps. > I think it is used only for applications where load is very high & users > issue read only queries to the database. Er, yes. You can't really cache queries that write to

Re: [GENERAL] Memcached for Database server

2011-05-17 Thread satoshi . nagayasu
Hi, 2011/5/18 Tatsuo Ishii : >> How do you handle statements that rely on current_timestamp, random(), >> etc? What about if their reliance is via a function? Is that just an >> understood limitation of the cache, that it'll cache even queries that >> don't really make sense to cache? > > Probably

Re: [GENERAL] Memcached for Database server

2011-05-17 Thread Tatsuo Ishii
> How do you handle statements that rely on current_timestamp, random(), > etc? What about if their reliance is via a function? Is that just an > understood limitation of the cache, that it'll cache even queries that > don't really make sense to cache? Probably we should cache the result of a quer

Re: [GENERAL] Memcached for Database server

2011-05-17 Thread Cédric Villemain
2011/5/17 Craig Ringer : > On 05/17/2011 01:38 PM, Satoshi Nagayasu wrote: >> >> Hi, >> >> 2011/05/17 14:31, Adarsh Sharma wrote: >>> >>> Rick Genter wrote: On May 16, 2011, at 10:09 PM, Adarsh Sharma wrote: > Dear all, > > I need to research on Memcache in the next

Re: [GENERAL] Memcached for Database server

2011-05-17 Thread Craig Ringer
On 05/17/2011 01:31 PM, Adarsh Sharma wrote: At what stage we need memcached & what is the purpose of using it. You might not need it. Depends on the nature of your app, its performance requirements, how strict it is about always getting consistent & current data, and how much money you have

Re: [GENERAL] Memcached for Database server

2011-05-17 Thread Craig Ringer
On 05/17/2011 01:38 PM, Satoshi Nagayasu wrote: Hi, 2011/05/17 14:31, Adarsh Sharma wrote: Rick Genter wrote: On May 16, 2011, at 10:09 PM, Adarsh Sharma wrote: Dear all, I need to research on Memcache in the next few days. What I want to know is it worth to have memcahed enable in our My

Re: [GENERAL] Memcached for Database server

2011-05-16 Thread Rick Genter
On May 16, 2011, at 10:31 PM, Adarsh Sharma wrote: > Rick Genter wrote: >> >> On May 16, 2011, at 10:09 PM, Adarsh Sharma wrote: >> >> >>> Dear all, >>> >>> I need to research on Memcache in the next few days. >>> >>> What I want to know is it worth to have memcahed enable in our Mysql/ >

Re: [GENERAL] Memcached for Database server

2011-05-16 Thread Satoshi Nagayasu
Hi, 2011/05/17 14:31, Adarsh Sharma wrote: Rick Genter wrote: On May 16, 2011, at 10:09 PM, Adarsh Sharma wrote: Dear all, I need to research on Memcache in the next few days. What I want to know is it worth to have memcahed enable in our Mysql/ Postgres Production Servers. We have databa

Re: [GENERAL] Memcached for Database server

2011-05-16 Thread Adarsh Sharma
Rick Genter wrote: On May 16, 2011, at 10:09 PM, Adarsh Sharma wrote: Dear all, I need to research on Memcache in the next few days. What I want to know is it worth to have memcahed enable in our Mysql/ Postgres Production Servers. We have databases from 20 to 230 GB and it's not the OLTP

Re: [GENERAL] Memcached for Database server

2011-05-16 Thread Rick Genter
On May 16, 2011, at 10:09 PM, Adarsh Sharma wrote: > Dear all, > > I need to research on Memcache in the next few days. > > What I want to know is it worth to have memcahed enable in our Mysql/ > Postgres Production Servers. > We have databases from 20 to 230 GB and it's not the OLTP just a si

[GENERAL] Memcached for Database server

2011-05-16 Thread Adarsh Sharma
Dear all, I need to research on Memcache in the next few days. What I want to know is it worth to have memcahed enable in our Mysql/ Postgres Production Servers. We have databases from 20 to 230 GB and it's not the OLTP just a simple OLAP where data is fetched and stored in some meaningful for