Thanks a lot guys !
//Mikael
From: observium [mailto:observium-bounces@observium.org] On Behalf Of Adam Armstrong Sent: den 19 februari 2016 15:37 To: observium@observium.org Subject: Re: [Observium] mysqld: The table 'ports_cbqos' is full - solved, probably
Yeah, the problem will have been temporarily "fixed" by wiping the table.
You indeed need to increase the MySQL heap size.
adam.
On 19/02/2016 14:36:33, Eduardo Schoedler <listas@esds.com.brmailto:listas@esds.com.br> wrote: Hi,
The 'ports_cbqos' is a memory table.
From Mysql manual: "The maximum size of MEMORY tables is limited by the max_heap_table_size system variable, which has a default value of 16MB." http://dev.mysql.com/doc/refman/5.6/en/memory-storage-engine.html
You have to raise your 'max_heap_table_size' parameter.
Regards,
2016-02-19 11:20 GMT-02:00 Fältman, Mikael :
Hi again.
Increased innodb_buffer_pool_size and restarted mysqld – solved the problem.
Buffer_pool_size has probably nothing to do with this issue but I was also getting warnings about
buffer pool is occupied by InnoDB: lock heaps or the adaptive hash index.
It is a good thing to sometimes keep a peek into /var/log/mysqld.log file (or where ever it is stored).
BR
Mikael
From: observium [mailto:observium-bounces@observium.org] On Behalf Of Fältman, Mikael Sent: den 18 februari 2016 10:27 To: Observium Network Observation System Subject: [Observium] mysqld: The table 'ports_cbqos' is full
Hello.
Running: Observium CE 0.16.1.7533 on RedHat 6.4
Keep getting this error msg in /var/log/mysqld.log
160218 10:21:28 [ERROR] /usr/libexec/mysqld: The table 'ports_cbqos' is full
What can I do to fix it ?
Disk space is available.
BR
Mikael
observium mailing list observium@observium.orgmailto:observium@observium.org http://postman.memetic.org/cgi-bin/mailman/listinfo/observium
-- Eduardo Schoedler _______________________________________________ observium mailing list observium@observium.orgmailto:observium@observium.org http://postman.memetic.org/cgi-bin/mailman/listinfo/observium