Slide 1
Slide 1 text
WordPress
Performance Tuning
A Narrative
Slide 2
Slide 2 text
Gary Pendergast
@GaryPendergast
pento.net
Slide 3
Slide 3 text
THINK AHEAD
Slide 4
Slide 4 text
IN THE BEGINNING
Slide 5
Slide 5 text
HOSTING
Slide 6
Slide 6 text
No content
Slide 7
Slide 7 text
WP SUPER CACHE
google: wp super cache
Slide 8
Slide 8 text
No content
Slide 9
Slide 9 text
No content
Slide 10
Slide 10 text
No content
Slide 11
Slide 11 text
No content
Slide 12
Slide 12 text
UPDATE: It’s an
uncached WordPress
site, so, no surprise,
it’s crapped out.
“
Slide 13
Slide 13 text
INNODB
Slide 14
Slide 14 text
ALTER TABLE ENGINE=InnoDB;
wp_posts
Slide 15
Slide 15 text
ALTER TABLE ENGINE=InnoDB;
wp_postmeta
Slide 16
Slide 16 text
ALTER TABLE ENGINE=InnoDB;
wp_users
Slide 17
Slide 17 text
ALTER TABLE ENGINE=InnoDB;
............
Slide 18
Slide 18 text
GROWING PAINS
Slide 19
Slide 19 text
No content
Slide 20
Slide 20 text
No content
Slide 21
Slide 21 text
No content
Slide 22
Slide 22 text
innodb_buffer_pool_size
Slide 23
Slide 23 text
query_cache_size = 0
query_cache_type = 0
Slide 24
Slide 24 text
LIES
Slide 25
Slide 25 text
THINGS THAT ARE BAD
QUERY CACHE
Slide 26
Slide 26 text
THINGS THAT ARE GOOD
INNODB BUFFER POOL
Slide 27
Slide 27 text
OPCODE CACHE
Slide 28
Slide 28 text
Slide 29
Slide 29 text
Slide 30
Slide 30 text
Slide 31
Slide 31 text
Slide 32
Slide 32 text
APC
google: php apc
Slide 33
Slide 33 text
CDN
Slide 34
Slide 34 text
MULTI SERVER
Slide 35
Slide 35 text
MEMCACHED
Slide 36
Slide 36 text
OBJECT CACHE
http://wordpress.org/extend/plugins/memcached/
Slide 37
Slide 37 text
BATCACHE
google: batcache
Slide 38
Slide 38 text
THINK AHEAD
Slide 39
Slide 39 text
THINK AHEAD
... but not too far ahead
Slide 40
Slide 40 text
HYPERDB
google: hyperdb
Slide 41
Slide 41 text
$wpdb->add_database( array(
'host' => 'master.server',
'user' => 'wordpress',
'password' => 'lol1234',
'name' => 'wordpress'
) );
Slide 42
Slide 42 text
REPLICATION
Slide 43
Slide 43 text
MASTER
SLAVE
Slide 44
Slide 44 text
MASTER
SLAVE SLAVE
SLAVE
Slide 45
Slide 45 text
$wpdb->add_database( array(
'host' => 'slave1.server',
'user' => 'wordpress',
'password' => 'lol1234',
'name' => 'wordpress',
'write' => 0,
'read' => 1,
'dataset' => 'global',
'timeout' => 0.2
) );
Slide 46
Slide 46 text
MASTER
SLAVE SLAVE
SLAVE
MASTER
Slide 47
Slide 47 text
MASTER
SLAVE SLAVE
SLAVE
MASTER
Slide 48
Slide 48 text
REPLICATION
google: mysql replication
Slide 49
Slide 49 text
SHARDING
Slide 50
Slide 50 text
USE THE TOOLS
Slide 51
Slide 51 text
THINK AHEAD
Slide 52
Slide 52 text
THINK AHEAD
... but not too far ahead
Slide 53
Slide 53 text
automattic.com/work-with-us
QUESTIONS?
@GaryPendergast