thanks,

I see that just two tables are on MyISAM. And that ones are Wifi related which i think is not important, because the main devices is not associated with wifi

infra [root@observ001i tmp]# mysqlshow --status observium -p | grep -v InnoDB
Enter password:
Database: observium
+-------------------------------+--------+---------+------------+--------+----------------+-------------+-----------------+--------------+------------+----------------+---------------------+---------------------+---------------------+-------------------+----------+----------------+----------------------------------------------------------+------------------+-----------+
| Name                          | Engine | Version | Row_format | Rows   | Avg_row_length | Data_length | Max_data_length | Index_length | Data_free  | Auto_increment | Create_time         | Update_time         | Check_time          | Collation         | Checksum | Create_options | Comment                                                  | Max_index_length | Temporary |
+-------------------------------+--------+---------+------------+--------+----------------+-------------+-----------------+--------------+------------+----------------+---------------------+---------------------+---------------------+-------------------+----------+----------------+----------------------------------------------------------+------------------+-----------+
| wifi_accesspoints             | MyISAM | 10      | Dynamic    | 0      | 0              | 0           | 281474976710655 | 1024         | 0          | 1              | 2017-10-25 16:20:07 | 2017-10-25 16:20:07 |                     | utf8_unicode_ci   |          |                |                                                          | 1125899906841600 | N         |
| wifi_sessions                 | MyISAM | 10      | Dynamic    | 0      | 0              | 0           | 281474976710655 | 1024         | 0          | 1              | 2017-10-25 16:20:07 | 2017-10-25 16:20:07 | 2017-10-25 16:20:07 | utf8_unicode_ci   |          |                |                                                          | 1125899906841600 | N         |
+-------------------------------+--------+---------+------------+--------+----------------+-------------+-----------------+--------------+------------+----------------+---------------------+---------------------+---------------------+-------------------+----------+----------------+----------------------------------------------------------+------------------+-----------+


On Thu, Jan 7, 2021 at 7:01 PM Adam Armstrong via observium <observium@observium.org> wrote:

If you have any myisam tables, switch them to innodb.

 

I had this happen on a non-observium database at some point during an upgrade.

 

Adam.

 

From: observium <observium-bounces@observium.org> On Behalf Of Edvinas Kairys via observium
Sent: 07 January 2021 15:13
To: Observium <observium@observium.org>
Cc: Edvinas Kairys <edvinas.email@gmail.com>
Subject: [Observium] mysql poller times increased 2x after Maria DB upgrade from 5.x to 10.3

 

hello,

 

Mysql poller times increased 2x after Maria DB upgrade from 5.x to 10.3

 

 

I dont know if this is supposed to be or not ? dunno if i 'feel' any slowness, but i want to ask for your info.

 

Thanks for any input

 

_______________________________________________
observium mailing list
observium@observium.org
http://postman.memetic.org/cgi-bin/mailman/listinfo/observium