• This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn more.

How fast does this load for you?

Deebs

Well-known member
#7
Seems very responsive. For those having performance problems remember that LiNX had a major fault this afternoon when they brought their new network online and you could be experiencing a knockon effect.
 

MagnusB

Well-known member
#8
76 requests ❘ 1.40MB transferred ❘ 12.07s (onload: 11.52s, DOMContentLoaded: 1.32s)

The thing slowing me down was twitter:
jot
r.twimg.com
GET
200
OK
image/gif
tweet_button.1337330192.html:1
Script
402B
43B
9.73s
9.73

When images is cached I get:
75 requests ❘ 121.45KB transferred ❘ 1.89s (onload: 1.56s, DOMContentLoaded: 1.06s)

That is with a 25/25 fiber connection.
 

Slavik

XenForo moderator
Staff member
#9
Why do I feel like im going to get sucked into completely re-writing my.cnf again?

This is it at the moment :D and whilst my server load has gone up a fraction of a %, to be honest the site feels quick as before... if not quicker


Code:
[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
user=mysql
# Disabling symbolic-links is recommended to prevent assorted security risks
symbolic-links=0
 
# Semisynchronous Replication
# http://dev.mysql.com/doc/refman/5.5/en/replication-semisync.html
# uncomment next line on MASTER
;plugin-load=rpl_semi_sync_master=semisync_master.so
# uncomment next line on SLAVE
;plugin-load=rpl_semi_sync_slave=semisync_slave.so
 
# Others options for Semisynchronous Replication
;rpl_semi_sync_master_enabled=1
;rpl_semi_sync_master_timeout=10
;rpl_semi_sync_slave_enabled=1
 
# http://dev.mysql.com/doc/refman/5.5/en/performance-schema.html
;performance_schema
 
 
[mysqld_safe]
log-error=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid
yup... thats its... entirely default...
 

Naatan

Well-known member
#11
Initial load felt a bit slow, but not unacceptably slow. I'd say about 5 seconds at most.

Subsequent loads are nice and speedy. Response time for main request (excluding assets) is around 500ms so that's quite decent.

I'm on the east coast fyi.
 

MGSteve

Well-known member
#14
Why do I feel like im going to get sucked into completely re-writing my.cnf again?

This is it at the moment :D and whilst my server load has gone up a fraction of a %, to be honest the site feels quick as before... if not quicker

yup... thats its... entirely default...
Have you used mysqltuner?

I found it invaluable for tweaking my install (note I'm still on vB, so its tuned towards myISAM at the moment.

>> MySQLTuner 1.2.0 - Major Hayden <major@mhtx.net>
>> Bug reports, feature requests, and downloads at http://mysqltuner.com/
>> Run with '--help' for additional options and output filtering

-------- General Statistics --------------------------------------------------
[--] Skipped version check for MySQLTuner script
[OK] Currently running supported MySQL version 5.0.77-log
[OK] Operating on 64-bit architecture

-------- Storage Engine Statistics -------------------------------------------
[--] Status: -Archive -BDB -Federated +InnoDB -ISAM -NDBCluster
[--] Data in MyISAM tables: 13G (Tables: 5533)
[--] Data in InnoDB tables: 3G (Tables: 145)
[--] Data in MEMORY tables: 2M (Tables: 15)
[!!] Total fragmented tables: 373

-------- Security Recommendations -------------------------------------------
[OK] All database users have passwords assigned

-------- Performance Metrics -------------------------------------------------
[--] Up for: 51d 10h 39m 9s (1B q [303.673 qps], 72M conn, TX: 20574B, RX: 311B)
[--] Reads / Writes: 77% / 23%
[--] Total buffers: 4.9G global + 1.5M per thread (2048 max threads)
[OK] Maximum possible memory usage: 7.9G (33% of installed RAM)
[OK] Slow queries: 0% (16K/1B)
[OK] Highest usage of available connections: 22% (462/2048)
[OK] Key buffer size / total MyISAM indexes: 512.0M/5.3G
[OK] Key buffer hit rate: 100.0% (251B cached / 23M reads)
[OK] Query cache efficiency: 64.6% (617M cached / 955M selects)
[!!] Query cache prunes per day: 571695
[OK] Sorts requiring temporary tables: 5% (8M temp sorts / 149M sorts)
[!!] Joins performed without indexes: 158904
[OK] Temporary tables created on disk: 5% (4M on disk / 94M total)
[OK] Thread cache hit rate: 99% (863 created / 72M connections)
[!!] Table cache hit rate: 14% (8K open / 59K opened)
[OK] Open file limit used: 31% (13K/43K)
[OK] Table locks acquired immediately: 99% (981M immediate / 983M locks)
[OK] InnoDB data size / buffer pool: 3.8G/4.0G

-------- Recommendations -----------------------------------------------------
General recommendations:
Run OPTIMIZE TABLE to defragment tables for better performance
Adjust your join queries to always utilize indexes
Increase table_cache gradually to avoid file descriptor limits
Variables to adjust:
query_cache_size (> 128M)
join_buffer_size (> 512.0K, or always use indexes with joins)
table_cache (> 20480)
 

Digital Doctor

Well-known member
#15
I felt it was reasonable ... but the page blanking seemed to make it feel longer.
slavik.p8ntballer.jpg

When using Xenforo.com the Tabs don't reload when I click Members. But they do on your site.
The blanking is what I didn't like.
 

Floren

Well-known member
#16
12.25 seconds to load that page first time, through a 10Mbit connection in Montreal Canada.
3.23 seconds, on page reload.

IMG_31052012_193010.png

I compared a setup I finished for a client with an army of forums on front page and SSL connection.
The load page is on average 1.40 seconds, very close to XenForo front page time load. His servers are located in Europe.
 

p4guru

Well-known member
#17
Messing around with some caches and reverting my.cnf back to default.

Can you guys let me know how quick this "feels" to load for you and how it feels to browse the site.

http://p8ntballer-forums.com/

Thankie.
11.15 seconds to load on 100Mbits connection from Australia - you have 1.4+ MB page size ! shave it down to 500KB in size and you'll improve your page load times dramatically. In comparison Floren's linked site https://www.thcfarmer.com/community/ loaded for me in 3.83 seconds and Xenforo.com front page 3.08 seconds and Xenforo forum home page 3.95 seconds

Load time is of course all relative to where visitor is located. Best 4 sites to test from different locations are

HTH
 

Slavik

XenForo moderator
Staff member
#18
Well I have just shrunk some of the files down, the page should now be aprox 1.1mb in size.

Anyone spot anything else I could do?
 

DBA

Well-known member
#19
Well I have just shrunk some of the files down, the page should now be aprox 1.1mb in size.

Anyone spot anything else I could do?
Have you enabled Keep Alive? Last I checked it wasn't on.

It's still taking a 20 MB connection ~3 seconds to load.
http://www.webpagetest.org/result/120602_FQ_9AD/1/performance_optimization/

Also check to make sure that your gzip and cache are setup right.

Personally the next thing I'd do would be to start creating image spirits. For example putting those 7 ad images into an image map would eliminate 6 requests. It also looks like majority of your site icons aren't in a spirit.