Re: MySQL seems to be running too slow; LONG
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
Reply to: