MYSQL Optimization?

any info on how to reduce mysql’s cpu usage?

talking about a wordpress mysql database.

do you have wp-cache/supercache installed?

1. Cache
2. How much access do you have to the DB server.

query cache + basic mysql optimization.. check your buffers, mem size, etc.

High cpu could be caused by disk IO bottle necks.. run sysstat to see iops. (in sysstat package)

SCSI/SAS/SSD RAID array… RAID10 if you’re write heavy, RAID5/50 if you’re read heavy.

^ pretty much that.

most mysql performance issues are disk IO.

does WP index the sql tables by default? if not, i’d start there

It has to…

If it doesn’t. Fuck.

just depends on how much content i guess. for a small WP site it prob wouldn’t really matter

yes, and works to reduce overall cpu usage, but with each post mysql cpu usage goes up

full access to DB server, it’s on VPS

all that over my head
I still don’t know how to do command line operations, still using cpanel & whm
not sure how or if I can change RAID array. but it’s more read heavy than write

how do I check?

sounds like a bad plugin.

post your my.cnf file. (google it if you need help finding it)

[mysqld]
max_connections = 150
safe-show-database
skip-locking
key_buffer = 20M
max_allowed_packet = 2M
sort_buffer_size = 1M
net_buffer_length = 8K
read_buffer_size = 512K
read_rnd_buffer_size = 512K
myisam_sort_buffer_size = 8M
wait_timeout = 30
query_cache_size=8M
table_cache=64

[mysqldump]
quick
max_allowed_packet = 16M

[mysql]
no-auto-rehash

[isamchk]
key_buffer = 20M
sort_buffer_size = 20M
read_buffer = 2M
write_buffer = 2M

[myisamchk]
key_buffer = 20M
sort_buffer_size = 20M
read_buffer = 2M
write_buffer = 2M

What is M? If M is a megabyte, aren’t they massive packet sizes? A 16 meg packet?

that’s for database backup

has nothing to do with what I’m asking for