Linode Forum
Linode Community Forums
 FAQFAQ    SearchSearch    MembersMembers      Register Register 
 LoginLogin [ Anonymous ] 
Post new topic  Reply to topic
Author Message
PostPosted: Wed Mar 23, 2011 5:31 am 
Offline
Newbie

Joined: Wed Mar 23, 2011 5:25 am
Posts: 2
Hello all,

I've just amended the settings for my node as recommended here in the Troubleshooting Memory and Networking Issues guide
http://library.linode.com/troubleshooti ... networking

Now, not always, but quite frequently response and load times are quite slow.

I dont have massive sites, just a couple of them with traffic on one 5000 a day and the other 3000+.

Sites are running on wordpress and also use W3 Total Cache.

I suspect it could be due to MySQL Low-Memory Settings, but as I am not an expert in this area I am not sure.

Could you please help out? Maybe recommend higher settings for Apache or MySQL?

Thank you in advance.

Dmitri


Top
   
 Post subject:
PostPosted: Wed Mar 23, 2011 5:50 am 
Offline
Senior Member

Joined: Sat Mar 12, 2011 3:43 am
Posts: 76
Location: Russia
Quote:
key_buffer = 16K

Don't use it, or MySQL will scan full table on each query.
Set this value to RAM*25% (128M at Linode 512, for example).

Do you currently have memory issues? Just following that recommendations without reasons can raise more issues.
Quote:
table_cache = 4
sort_buffer = 64K

This settings can kill performance too.

Also you can read my comment about tuning here.


Top
   
 Post subject:
PostPosted: Wed Mar 23, 2011 6:36 am 
Offline
Newbie

Joined: Wed Mar 23, 2011 5:25 am
Posts: 2
Thanks for a quick reply. I will try as you sugegsted and post the outcome later.

All the best,

Dmitri


Top
   
Display posts from previous:  Sort by  
Post new topic  Reply to topic


Who is online

Users browsing this forum: No registered users and 1 guest


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum

Search for:
Jump to:  
RSS

Powered by phpBB® Forum Software © phpBB Group