In this case I have no idea. :)
Adam.
Sent from BlueMail
On 7 Jan 2021, 21:06, 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