FUDforum
Fast Uncompromising Discussions. FUDforum will get your users talking.

Home » General » Database discussions » MySQL Tuning for FUDForum
Show: Today's Messages :: Polls :: Message Navigator
Return to the default flat view Create a new topic Submit Reply
MySQL Tuning for FUDForum [message #28224] Fri, 14 October 2005 05:02 Go to previous message
naudefj is currently offline  naudefj   South Africa
Messages: 3771
Registered: December 2004
Karma:
Senior Member
Administrator
Core Developer
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
[Message index]
 
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Previous Topic: Profile setting adjustments for mailing-list-only users
Next Topic: FUDForum charset problems
Goto Forum:
  

-=] Back to Top [=-
[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sun Nov 24 00:33:59 GMT 2024

Total time taken to generate the page: 0.06438 seconds