max_heap_table_size = 512M
Is what I have in my my.cnf, and it works fine.
adam.
On 2014-08-27 03:04, Nick Pais wrote:
That's what I thought so too, which is why I decided to change the values by CLI and see if it works or not before restarting the darn thing.
I changed both values to a solid 96M, and still no dice. Showing variables show that the values are correct (both at 96M) and I still don't know what's wrong.
On Tue, Aug 26, 2014 at 10:57 PM, Eduardo Schoedler listas@esds.com.br wrote: No need to restart if you do in mysql "cli":
mysql>SET GLOBAL tmp_table_size=96*1024*1024;
But you need to write in my.cnf to persist the config.
-- Eduardo Schoedler Enviado via iPhone
Em 26/08/2014, às 22:54, Adam Armstrong adama@memetic.org escreveu:
And then restart MySQL.
On 2014-08-27 02:48, Nick Pais wrote: Fletcher, tmp_table_size is set to 96M from what I can tell... On Tue, Aug 26, 2014 at 10:37 PM, Fletcher Haynes fhaynes@willamette.edu wrote: 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 _______________________________________________ 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 _______________________________________________ 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