Re: Really really slow select count(*)

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 




yeah, it already uses memcached with db save. Ânothing important in session anyway

the session table is not the issue

and I never clustered that one or ever will

thanks for the tip, also the other one about HOT


On Sun, Feb 6, 2011 at 8:19 PM, Pierre C <lists@xxxxxxxxxx> wrote:

I have clustered that table, its still unbelievably slow.

Did you actually delete the old entries before clustering it? Âif it's
still got 4G of old sessions or whatever in it, clustering ain't gonna
help.

Also, IMHO it is a lot better to store sessions in something like memcached, rather than imposing this rather large load on the main database...

PS : if your site has been down for 6 hours, you can TRUNCATE your sessions table...


[Postgresql General]     [Postgresql PHP]     [PHP Users]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Yosemite]

  Powered by Linux