Dedicated rackspace server, 16 core, and ssh / top gives below.
CPU% for mysql jumps between 50% and over 666%. Is this normal, is it just using available cpu as its there?
I've run tuning-primer.sh and increased some cache sizes as recommended and starting to monitor. Biggest issues reported there I felt were:
1. Of 516815 temp tables, 45% were created on disk - I've increased tmp_table_size to 256m from 16m
2. You have had 3989 queries where a join could not use an index properly (out of 4068156 in last 36 hours) - increased join_buffer_size to 4m
A lot of the basics have been done like attachments as files, no cache headers, update thread views only once an hour - but may change to once a night,
vb db is 17g
biggest tables
searchcore 5.9g
posts 4.4g
threads 2.8
I've 11m records in vb_attachmentviews ?? Can I empty that table.Or any others.
Also using memcached with vb.
In a 60 minute period typically 1600 - 2500 users.
Question.
I'd be happy to be given any pointers of aspects worth investigating. Site has been going for years!!! probably about 15 years
CPU% for mysql jumps between 50% and over 666%. Is this normal, is it just using available cpu as its there?
I've run tuning-primer.sh and increased some cache sizes as recommended and starting to monitor. Biggest issues reported there I felt were:
1. Of 516815 temp tables, 45% were created on disk - I've increased tmp_table_size to 256m from 16m
2. You have had 3989 queries where a join could not use an index properly (out of 4068156 in last 36 hours) - increased join_buffer_size to 4m
A lot of the basics have been done like attachments as files, no cache headers, update thread views only once an hour - but may change to once a night,
vb db is 17g
biggest tables
searchcore 5.9g
posts 4.4g
threads 2.8
I've 11m records in vb_attachmentviews ?? Can I empty that table.Or any others.
Also using memcached with vb.
In a 60 minute period typically 1600 - 2500 users.
Question.
I'd be happy to be given any pointers of aspects worth investigating. Site has been going for years!!! probably about 15 years
Comment