On Sun, 2012-05-06 at 14:09 +0000, Camaleón wrote: > On Sat, 05 May 2012 13:26:33 -0500, John W. Foster wrote: > > > I got this output from mysqltuner: > > Any advice is appreciated: The main issues is that this db server > > handles a Mediawiki database and when I upload files it takes way to > > long to do its job likewise when serving up the data to produce the > > webpages. > > Output: > > (...) > > > -------- > > Recommendations----------------------------------------------------- > > General recommendations: > > Run OPTIMIZE TABLE to defragment tables for better performance > > MySQL started within last 24 hours - recommendations may be > > inaccurate Enable the slow query log to troubleshoot bad queries > > When making adjustments, make tmp_table_size/max_heap_table_size > > equal Reduce your SELECT DISTINCT queries without LIMIT clauses > > Increase table_cache gradually to avoid file descriptor limits > > Variables to adjust: > > query_cache_size (> 16M) > > sort_buffer_size (> 1M) > > read_rnd_buffer_size (> 256K) > > tmp_table_size (> 20M) > > max_heap_table_size (> 20M) > > table_cache (> 128) > > innodb_buffer_pool_size (>= 764M) > > (...) > > It seems the script did a good job by telling you what's what you can > tweak. Have you made any of the recommended changes? actually I made all the suggested changes; My conundrum is that after I made them, the changes were not indicated as being sufficient. May be that the script does not do that; Example the original run of mysqltuner showed: tmp_table_size (> 16M) max_heap_table_size (> 16M)
I changed the values to; tmp_table_size (> 20M) max_heap_table_size (> 20M) If I am correctly understanding the values indicated it would seem that the 20M size is now insufficient. Is that correct? > > > Real memory > > 3.87 GB total, 2.13 GB used > > (...) > > > I know I need to add more memory & will do so: any other tips are > > appreciated. > > You have still not run out of memory but adding RAM is always of help :-) > > Greetings, > > -- > Camaleón > > -- To UNSUBSCRIBE, email to debian-user-requ...@lists.debian.org with a subject of "unsubscribe". Trouble? Contact listmas...@lists.debian.org Archive: http://lists.debian.org/1336355671.28659.7.ca...@beast.johnwfoster.com