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? > 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/jo60n6$kir$8...@dough.gmane.org
