[geeklog-users] geeklog performance

Fri Dec 31 05:57:57 EST 2004

Hi,

I've looked at your site a couple of times over the last couple of days 
and from what I can see, your link is just slow, I don't think you'll 
speed it up a lot by changing anything related to PHP, MySQL or even 
Geeklog! Your network connection is slow.

 From Belgium:

traceroute to robinbowes.com (81.98.79.17), 30 hops max, 40 byte packets
  1  server.rocteur.cc (192.168.1.3)  13.393 ms  0.712 ms  0.624 ms
  2  d5766601.kabel.telenet.be (213.118.102.1)  24.805 ms  25.921 ms  
9.072 ms
  3  d5e0fae1.kabel.telenet.be (213.224.250.225)  52.331 ms  16.031 ms  
24.752 ms
  4  213.224.126.170 (213.224.126.170)  20.518 ms  14.392 ms  5.822 ms
  5  212.3.238.5 (212.3.238.5)  10.666 ms  26.303 ms  7.223 ms
  6  ae-0-16.mp2.brussels1.level3.net (212.3.239.82)  32.168 ms  75.68 
ms  9.976 ms
  7  ae1-0.bbr2.london1.level3.net (212.187.128.57)  30.179 ms  28.633 
ms  19.914 ms
  8  ge-3-0-0-0.gar2.london1.level3.net (4.68.128.126)  68.755 ms  
26.792 ms  18.897 ms
  9  195.50.91.70 (195.50.91.70)  10.93 ms  19.805 ms  16.446 ms
10  win-bb-b-so-500-0.inet.ntl.com (62.253.185.202)  24.976 ms  18.177 
ms  17.178 ms
11  bre-bb-a-so-100-0.inet.ntl.com (62.253.185.197)  25.073 ms  63.785 
ms  26.693 ms
12  herm-t2core-a-pos31.inet.ntl.com (62.253.187.18)  20.736 ms  26.754 
ms  47.562 ms
13  herm-t2cam1-a-ge-wan31.inet.ntl.com (80.3.33.6)  23.543 ms  50.513 
ms  31.777 ms
14  ubr02reig-ge10.inet.ntl.com (80.3.34.34)  33.135 ms  27.161 ms  
36.604 ms
15  * * *
16  * * *
17  * * *
18  * * *
19  * * *
20  * * *
21  * * *
22  * * *
23  * * *
24  * * *
25  * * *
26  * * *
27  * * *
28  * * *
29  * * *
30  * * *

 From Texas:

traceroute to robinbowes.com (81.98.79.17), 30 hops max, 38 byte packets
  1  ev1s-66-98-204-1.ev1servers.net (66.98.204.1)  0.261 ms  0.194 ms  
0.261 ms
  2  ivhou-207-218-245-14.ev1.net (207.218.245.14)  0.419 ms  0.313 ms *
  3  hstntx1wce2-gige5-0.wcg.net (65.77.93.53)  1.285 ms  1.189 ms  
0.986 ms
  4  hstntx1wcx3-pos9-2-oc48.wcg.net (65.77.93.214)  1.237 ms  1.206 ms *
  5  dllstx1wcx3-pos14-0-oc192.wcg.net (64.200.210.65)  6.127 ms  5.810 
ms  5.982 ms
  6  dllstx9lcx1-pos9-0.wcg.net (64.200.232.210)  5.977 ms  6.077 ms *
  7  so-2-2-0.edge1.Dallas1.Level3.net (4.68.127.21)  6.443 ms  6.253 ms 
  6.155 ms
  8  so-1-2-0.bbr2.Dallas1.Level3.net (209.244.15.165)  6.161 ms  6.271 
ms  6.303 ms
  9  ae-0-0.bbr2.Washington1.Level3.net (64.159.0.230)  49.233 ms  
48.996 ms  49.055 ms
10  as-0-0.bbr1.London2.Level3.net (4.68.128.101)  116.643 ms  115.730 
ms *
11  ge-3-0-0.gar1.London2.Level3.net (4.68.124.62)  115.976 ms  116.097 
ms  116.667 ms
12  195.50.91.130 (195.50.91.130)  117.500 ms  117.319 ms  118.413 ms
13  bre-bb-a-ae0-0.inet.ntl.com (213.105.172.86)  117.672 ms  117.926 
ms  118.106 ms
14  herm-t2core-a-pos31.inet.ntl.com (62.253.187.18)  117.971 ms  
118.069 ms  118.918 ms
15  herm-t2cam1-a-ge-wan31.inet.ntl.com (80.3.33.6)  118.317 ms  
118.018 ms  118.113 ms
16  ubr02reig-ge10.inet.ntl.com (80.3.34.34)  118.791 ms  119.000 ms  
119.583 ms
17  * * *
18  * * *
19  * * *
20  * * *

On 31 Dec 2004, at 01:23, Robin Bowes wrote:

> Tony Bibbs wrote:
>> Most of the load is, undoubtedly, on the database.  Do you have 
>> MySQL's query cache feature enabled and optimally configured?  I'd 
>> start there.
>
> Tony,
>
> I'm already using turck-mmcache but not cached queries.
>
> I turned on cached queries and didn't see any noticeable speed up. I 
> use the following settings in my.cnf:
>
> query_cache_type=1
> query_cache_size=20M
>
> It's definitely turned on:
>
> mysql> show variables like '%query_cache%';
> +------------------------------+----------+
> | Variable_name                | Value    |
> +------------------------------+----------+
> | have_query_cache             | YES      |
> | query_cache_limit            | 1048576  |
> | query_cache_min_res_unit     | 4096     |
> | query_cache_size             | 20971520 |
> | query_cache_type             | ON       |
> | query_cache_wlock_invalidate | OFF      |
> +------------------------------+----------+
> 6 rows in set (0.00 sec)
>
> If I load my home page a few times I see the following cache status:
>
> mysql> show status like 'Qcache%';
> +-------------------------+----------+
> | Variable_name           | Value    |
> +-------------------------+----------+
> | Qcache_free_blocks      | 2        |
> | Qcache_free_memory      | 20802176 |
> | Qcache_hits             | 495      |
> | Qcache_inserts          | 163      |
> | Qcache_lowmem_prunes    | 0        |
> | Qcache_not_cached       | 44       |
> | Qcache_queries_in_cache | 122      |
> | Qcache_total_blocks     | 289      |
> +-------------------------+----------+
> 8 rows in set (0.00 sec)
>
> So, I'm getting cache hits, but it doesn't seem to be making much 
> difference.
>
> Any further suggestions?
>
> R.
> -- 
> http://robinbowes.com
> _______________________________________________
> geeklog-users mailing list
> geeklog-users at lists.geeklog.net
> http://lists.geeklog.net/listinfo/geeklog-users
>