On 7 Jan 2021, at 21:57, Edvinas Kairys via observium <observium@observium.org> wrote:

thanks anyway,

also, coul you advice what could be 'wrong' if im still after MariaDB update getting these:

[2021/01/07 21:50:35 +0000] discovery.php(671): Failed dbQuery (#1146 - Table 'observium.autodiscovery' doesn't exist), Query: SELECT `autodiscovery`.*, UNIX_TIMESTAMP(`last_checked`) AS `last_checked_unixtime` FROM `autodiscovery` WHERE `poller_id` = '0' AND `remote_hostname` = 'ntgnet02b.xxx.com' AND `remote_ip` = '10.3.2.3' AND (`remote_device_id` IS NULL OR `remote_device_id` != '348')
[2021/01/07 21:50:35 +0000] discovery.php(671): Failed dbQuery (#1146 - Table 'observium.autodiscovery' doesn't exist), Query: SELECT `autodiscovery`.*, UNIX_TIMESTAMP(`last_checked`) AS `last_checked_unixtime` FROM `autodiscovery` WHERE `poller_id` = '0' AND `remote_hostname` = 'ntgnet02b.xxx.com' AND `remote_ip` = '10.3.2.3'
[2021/01/07 21:50:35 +0000] discovery.php(671): Failed dbQuery (#1146 - Table 'observium.autodiscovery' doesn't exist), Query: SELECT `autodiscovery`.*, UNIX_TIMESTAMP(`last_checked`) AS `last_checked_unixtime` FROM `autodiscovery` WHERE `poller_id` = '0' AND `remote_hostname` = 'ntgnet02b.xxx.com' AND `remote_ip` = '10.3.2.3' AND (`remote_device_id` IS NULL OR `remote_device_id` != '348')

?

Thanks
On Thu, Jan 7, 2021 at 11:36 PM Adam Armstrong via observium <observium@observium.org> wrote:
In this case I have no idea. :)

Adam.

Sent from BlueMail
On 7 Jan 2021, at 21:06, Edvinas Kairys via observium <observium@observium.org> wrote:
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
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