[geeklog-users] geeklog performance

Tony Bibbs tony at tonybibbs.com
Tue Jan 4 10:08:39 EST 2005


The network connection has a measurable impact, however, the page 
creation times have nothing to do with networking.  So while you point 
out a good issue, the script execution is still an issue.

--Tony

MAC OS X at Rocteur.CC wrote:

> 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
>>
>
> _______________________________________________
> geeklog-users mailing list
> geeklog-users at lists.geeklog.net
> http://lists.geeklog.net/listinfo/geeklog-users





More information about the geeklog-users mailing list