Did you also set the tmp_table_size (I think that is the variable anyway) to 64M? MySQL, if I remember correctly, takes the minimum of the two.


On Tue, Aug 26, 2014 at 6:32 PM, Nick Pais <nick@nickserver.net> wrote:
Hi Adam,

I tried doing so as you mentioned, went from 16M to 64M but still no
dice. I tried running the MySQL commands manually from what the debug
output gave me (http://privatepaste.com/067e2e81d3) and still no dice:
http://privatepaste.com/22c53abbe8

I copied the max_heap_table_size from another install (the same value)
and it still doesn't work...

Any ideas? :/

On Fri, Aug 8, 2014 at 7:45 PM, Adam Armstrong <adama@memetic.org> wrote:
> Probably your MySQL heap size is too small.
>
> You need to allow more space to MySQL can make larger memory tables.
>
> adam.
>
>
> On 2014-08-08 19:17, Nick Pais wrote:
>>
>> Hogan,
>>
>> I'm talking about the current throughput, screenshots attached. Please
>> excuse my "fantastic" GIMPing skills :D
>>
>> Thanks!
>>
>>
>> Message: 2
>> Date: Fri, 8 Aug 2014 17:40:03 +0000
>> From: Hogan Whittall <whittalh@yahoo-inc.com>
>> To: Observium Network Observation System <observium@observium.org>
>> Subject: Re: [Observium] Weird database issue?
>> Message-ID: <6CDB9AE7-7909-401B-80E3-D404CDA371AC@yahoo-inc.com>
>> Content-Type: text/plain; charset="windows-1252"
>>
>> If you?re referring to the link speed (100Mb, 1Gb, etc) then that has
>> historically been a problem with permissions when snmpd tries to access
>> ethtool info.  You basically have 3 options:
>>
>> - Run snmpd as ?root? (Not recommended)
>> - Enable ETHTOOL_GSET in the kernel
>> - Add the link speed of each NIC to snmpd.conf (interface ethX 6 <speed in
>> bits/s>)
>>
>> I went with the third option and wrote a script to do this for me.  This
>> info is kept in the ?ports? table.
>>
>> Or are you talking about current throughput and not port speed?
>>
>> -Hogan
>>
>> _______________________________________________
>> observium mailing list
>> observium@observium.org
>> http://postman.memetic.org/cgi-bin/mailman/listinfo/observium
>
> _______________________________________________
> observium mailing list
> observium@observium.org
> http://postman.memetic.org/cgi-bin/mailman/listinfo/observium
_______________________________________________
observium mailing list
observium@observium.org
http://postman.memetic.org/cgi-bin/mailman/listinfo/observium



--
Fletcher Haynes <fhaynes@willamette.edu>
Systems Administrator/Network Services Consultant
Willamette Integrated Technology Services
Willamette University, Salem, OR
Phone: 503.370.6016