Re: MySQL seems to be running too slow; LONG

[Camaleón <noelamac@gmail.com>]

On Sun, 06 May 2012 20:54:31 -0500, John W. Foster wrote:

> On Sun, 2012-05-06 at 14:09 +0000, Camaleón wrote:

>> (...)
>> 
>> 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?

If you restarted MySQL service after making the suggested modifications 
(which are reflected on the new values) the script is telling you that 
the new values are still not enough.

Greetings,

-- 
Camaleón