I tried to reproduce the error using Gear6's Brutis, but unfortunately
this time I'm getting too many connections error instead of event
queue error. It's hard to reproduce the exact environment when the
error occurred last week as our dev team has deployed new codes
including the fix for mysql que
> Hi there
>
> I am experimenting with using memcache for storing PHP sessions in a
> www cluster environment. But due to latency in network, I have noticed
> slight performance drop in application as opposed to just direct
> access.
>
> Has anyone played with changing MTU on their network card to
On 3-3-2010 10:10, simon wrote:
Hi there
I am experimenting with using memcache for storing PHP sessions in a
www cluster environment. But due to latency in network, I have noticed
slight performance drop in application as opposed to just direct
access.
Has anyone played with changing MTU on th
Hello everyone,
I would like to update some memcacheds from their current version
(1.2.3) to 1.4.4. They are mainly used by php client 1.3.9 at the
moment. Are there any known snares? I checked the release notes and
could not find any changes, that would alarm me. But I thought, maybe
somebody did
On Mar 3, 5:18 am, elSchrom wrote:
> Hello everyone,
>
> I would like to update some memcacheds from their current version
> (1.2.3) to 1.4.4. They are mainly used by php client 1.3.9 at the
> moment. Are there any known snares? I checked the release notes and
> could not find any changes, that w
Hello everyone, thanks a ton for all the replies. So let me give a
concrete example of something we do.
I recently just ran a report in SQL 2008 and found the top query as
far as total CPU time. The query basically pulls notifications for
users every minute they are logged in. The query is specifi
Justin:
I don't see this as a good candidate for memcached using a standard SQL
Server 2008. However, if you looked at this from the viewpoint of
StreamInsight on SQL Server 2008 R2, you could set up a ComplexProcessing
Query that would send something to the user when they get a notification --
b
I would disagree, this is a good example for using memcached. I've done a
similar thing in my env.
It appears to me that the requests for the data far out number the updates
to the data, which is great for a cache to handle.
Set up the key for memcached to be the query name with the query param
Justin:
Are you using parameters for user_id and viewed? If you switched to
parameters alone, you might gain a huge amount of SQL Server 2008 CPU time
back, by not recompiling the query every time you execute it. Just
retrieving the query from cache in SQL Server 2008 may help you.
Make it a st
What you have here is you are polling an event queue every minute, said
event being a notification. Maybe you would be better served actually using
an event queuing system. There are a number of them in the open source
world that fit this use case pretty well, including RabbitMQ and Resque. I
do
Once again, thanks for all the awesome replies. Let me add a few
things:
Most users have notifications pending, they just choose not to view
them, so the option of storing if a user has notifications won't help
us much as most users have them and we need to display them.
We are very heavy putting
if the lookup are always done using the same criteria (you mentioned userid =
@userid and viewed = @state), then just put an index on userid&viewed. i assume
that your server has a lots of memory, so sql server will cache most of the
data, and you'll have a very good (measured in msec) response
I'm guessing here but this is what it looks like to me. Most people have
notifications so the query to get notifications returns a boat load of data
(ok maybe a small boat), and there in lies the problem the constant
returning of data every time a notification check is made.
So how about this for
Justin:
I'm not sure you want to put the database update and memcached update into a
Trigger. Keep in mind that the trigger runs in the same transaction as the
original insert -- and the insert will not be completed until the Trigger
completes. Given that issue -- you may actually see your time
14 matches
Mail list logo