Xxx fully sexy aunty - Invalidating query cache entries table mysql
When tuning My SQL servers, the first thing you usually want to pay attention to are buffer pools and caches.
Buffers and caches are used to improve performance by storing and retrieving frequently accessed data.
My setup: Site is planned to be used as a social network, expectation is that logged in members can add a variety of content types. Some views have exposed filter criteria, others are more "static" and perhaps candidates for views caching. My SQL Version 5.1.61 x86_64 Uptime = 2 days 15 hrs 34 min 33 sec Avg.
Focus is on serving user generated content to logged in members, limited exposure of content to anon web surfers. Centos 6 server running Apache/mysql 5.1x, PHP, etc. Seems to be using around half of that on any given day. qps = 53 Total Questions = 12312015 Threads Connected = 1 Server has been running for over 48hrs.
It should be safe to follow these recommendations To find out more information on how each of these runtime variables effects performance visit: info about My SQL's Enterprise Monitoring and Advisory Service SLOW QUERIES The slow query log is NOT enabled. You have 0 out of 12312036 that take longer than 10.000000 sec.