mysqltuner.pl question

i installed this script a week ago, and keep getting these recommendations:
-------- Recommendations
-----------------------------------------------------
General recommendations:
MySQL started within last 24 hours - recommendations may be inaccurate
Be sure that tmp_table_size/max_heap_table_size are equal
Reduce your SELECT DISTINCT queries without LIMIT clauses
Variables to adjust:
tmp_table_size (> 64M)
max_heap_table_size (> 64M)



especially the part about tmp_table_size and max_heap_table_size is
confusing to me, esp. when seen the following:

/tmp # mysqladmin variables | grep table_size
| max_heap_table_size | 67108864 |
| tmp_table_size | 67108864 |
/tmp #

/tmp # mysqladmin version
mysqladmin Ver 8.41 Distrib 5.0.26, for suse-linux-gnu on x86_64
Copyright (C) 2000 MySQL AB & MySQL Finland AB & TCX DataKonsult AB
This software comes with ABSOLUTELY NO WARRANTY. This is free software,
and you are welcome to modify and redistribute it under the GPL license

Server version 5.0.26-Max-log
Protocol version 10
Connection Localhost via UNIX socket
UNIX socket /var/lib/mysql/mysql.sock
Uptime: 1 day 1 hour 41 min 0 sec

Threads: 1 Questions: 21445 Slow queries: 3701 Opens: 1214 Flush
tables: 3 Open tables: 598 Queries per second avg: 0.232

/tmp # cat /etc/my.cnf | grep table_size
tmp_table_size = 67108864
max_heap_table_size = 67109880

Can anyone give a hint on how to stop this recommentdation?
after this i will focus on the 'SELECT DISTINCT' part... ;-)

--
Luuk

Luuk schreef:
> i installed this script a week ago, and keep getting these recommendations:
> -------- Recommendations
> -----------------------------------------------------
> General recommendations:
> MySQL started within last 24 hours - recommendations may be inaccurate
> Be sure that tmp_table_size/max_heap_table_size are equal
> Reduce your SELECT DISTINCT queries without LIMIT clauses
> Variables to adjust:
> tmp_table_size (> 64M)
> max_heap_table_size (> 64M)
>
>
>
> especially the part about tmp_table_size and max_heap_table_size is
> confusing to me, esp. when seen the following:
>
> /tmp # mysqladmin variables | grep table_size
> | max_heap_table_size | 67108864 |
> | tmp_table_size | 67108864 |
> /tmp #
>
> /tmp # mysqladmin version
> mysqladmin Ver 8.41 Distrib 5.0.26, for suse-linux-gnu on x86_64
> Copyright (C) 2000 MySQL AB & MySQL Finland AB & TCX DataKonsult AB
> This software comes with ABSOLUTELY NO WARRANTY. This is free software,
> and you are welcome to modify and redistribute it under the GPL license
>
> Server version 5.0.26-Max-log
> Protocol version 10
> Connection Localhost via UNIX socket
> UNIX socket /var/lib/mysql/mysql.sock
> Uptime: 1 day 1 hour 41 min 0 sec
>
> Threads: 1 Questions: 21445 Slow queries: 3701 Opens: 1214 Flush
> tables: 3 Open tables: 598 Queries per second avg: 0.232
>
> /tmp # cat /etc/my.cnf | grep table_size
> tmp_table_size = 67108864
> max_heap_table_size = 67109880
>
> Can anyone give a hint on how to stop this recommentdation?
> after this i will focus on the 'SELECT DISTINCT' part... ;-)
>

o, btw, of course i have the latest version from:
http://rackerhacker.com/mysqltuner/

--
Luuk

Luuk wrote:
> Luuk schreef:
>> i installed this script a week ago, and keep getting these
>> recommendations:
>> -------- Recommendations
>> -----------------------------------------------------
>> General recommendations:
>> MySQL started within last 24 hours - recommendations may be
>> inaccurate
>> Be sure that tmp_table_size/max_heap_table_size are equal
>> Reduce your SELECT DISTINCT queries without LIMIT clauses
>> Variables to adjust:
>> tmp_table_size (> 64M)
>> max_heap_table_size (> 64M)
>>
>>
>>
>> especially the part about tmp_table_size and max_heap_table_size is
>> confusing to me, esp. when seen the following:
>>
>> /tmp # mysqladmin variables | grep table_size
>> | max_heap_table_size | 67108864 |
>> | tmp_table_size | 67108864 |
>> /tmp #
>>
>> /tmp # mysqladmin version
>> mysqladmin Ver 8.41 Distrib 5.0.26, for suse-linux-gnu on x86_64
>> Copyright (C) 2000 MySQL AB & MySQL Finland AB & TCX DataKonsult AB
>> This software comes with ABSOLUTELY NO WARRANTY. This is free software,
>> and you are welcome to modify and redistribute it under the GPL license
>>
>> Server version 5.0.26-Max-log
>> Protocol version 10
>> Connection Localhost via UNIX socket
>> UNIX socket /var/lib/mysql/mysql.sock
>> Uptime: 1 day 1 hour 41 min 0 sec
>>
>> Threads: 1 Questions: 21445 Slow queries: 3701 Opens: 1214 Flush
>> tables: 3 Open tables: 598 Queries per second avg: 0.232
>>
>> /tmp # cat /etc/my.cnf | grep table_size
>> tmp_table_size = 67108864
>> max_heap_table_size = 67109880
>>
>> Can anyone give a hint on how to stop this recommentdation?
>> after this i will focus on the 'SELECT DISTINCT' part... ;-)
>>
>
> o, btw, of course i have the latest version from:
> http://rackerhacker.com/mysqltuner/
>

Maybe talk to the people at rackhacker?

--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
jstucklex@attglobal.net
==================