[dev] shares performance hit (was Re: disable shares)

[duck at obala.net]

Quoting "Didi Rieder" <adrieder at sbox.tugraz.at>:

>> Said that. You should get more from your server. 12 seconds to check
>> only 13k rows is definitely too much for a server you mentioned. I
>> have 13,465 rows in Kronolith shares and a query like that takes onl
>> 0.2254 sec! For Ansel Shares where I have 67.888 galleries in it,
>> takes only 1.9356 sec!
>
> The query was slow when our public computer rooms are getting filled
> by students and people/employees start to work.
> When I do it at later times when most of the users are already logged
> on, then it also takes ~0.08 sec. But I'll see what I can do for
> improving this.

This indicates that maybe shares queries are not all the problem if  
perform well after login. The can be a lot of small queries that are  
not visible in the log. Do you check the processes in real time? You  
can do it easily wit the mytop utility  
(http://jeremy.zawodny.com/mysql/mytop/).

How many mysql threads do you run?
What driver do you use for session and cache?
Do you pre-warm your cache?

Duck