Subscribe: FUDforum - RDF feed
http://fudforum.org/forum/rdf.php?mode=m&th=5726&basic=1
Added By: Feedage Forager Feedage Grade B rated
Language: English
Tags:
cache  fudforum  inserts  mysql show  mysql tuning  mysql  qcache free  qcache  queries  query cache  query  tuning fudforum  tuning 
Rate this Feed
Rate this feedRate this feedRate this feedRate this feedRate this feed
Rate this feed 1 starRate this feed 2 starRate this feed 3 starRate this feed 4 starRate this feed 5 star

Comments (0)

Feed Details and Statistics Feed Statistics
Preview: FUDforum - RDF feed

FUDforum - خوراک RDF



Fast Uncompromising Discussions. FUDforum will get your users talking.



 



MySQL Tuning for FUDForum

2005-10-14T05:02:15-00:00

Hi,

I've increased the MySQL query_cache_size parameter from 0 to 64K to see if I can improve FUDForum's performance.

mysql> show variables like '%query_cache%';
+------------------------------+----------+
| Variable_name                | Value    |
+------------------------------+----------+
| have_query_cache             | YES      |
| query_cache_limit            | 1048576  |
| query_cache_size             | 67108864 |
| query_cache_type             | ON       |
| query_cache_wlock_invalidate | OFF      |
+------------------------------+----------+
5 rows in set (0.00 sec)


However, looking at the stats (hits/inserts), it's not really helping.

mysql> show status like 'qc%';
+-------------------------+----------+
| Variable_name           | Value    |
+-------------------------+----------+
| Qcache_queries_in_cache | 4374     |
| Qcache_inserts          | 51522    |
| Qcache_hits             | 51411    |
| Qcache_lowmem_prunes    | 0        |
| Qcache_not_cached       | 433      |
| Qcache_free_memory      | 58983528 |
| Qcache_free_blocks      | 1342     |
| Qcache_total_blocks     | 10229    |
+-------------------------+----------+
8 rows in set (0.00 sec)


Any idea why this might be the case? Maybe I'm not interpreting the stats correctly?

Best regards.

Frank



Re: MySQL Tuning for FUDForum

2005-10-14T13:51:15-00:00

Seems to work, you has 51k cache hits.



Re: MySQL Tuning for FUDForum

2005-10-14T14:39:09-00:00

True, however, I didn't expect the high number of cache inserts. Is it because the forum doesn't use bind variables.

Best regards.

Frank





Re: MySQL Tuning for FUDForum

2005-10-14T14:42:02-00:00

The MySQL API (ext/mysql) does not support prepared statments, so caching would only work for identical queries or queries differing through LIMIT clauses.



Re: MySQL Tuning for FUDForum

2005-10-14T14:42:56-00:00

Actually that wouldn't help either since query caching relates to caching of QUERY RESULTS, so you can only cache identical operations.



Re: MySQL Tuning for FUDForum

2005-10-14T15:09:39-00:00

OK, I've mistakenly thought that SQL statements are cached to prevent re-parsing.

Thanks for the reply!

Frank