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
[image: image.png]
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
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
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
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
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 http://www.bluemail.me/r?b=16361 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
If your database structure was broken by the database server being too old, updating it won't fix the broken database structure.
The only way to do that is to manually check all of the tables, or to remove and recreate the database.
Adam.
Sent from BlueMail
On 7 Jan 2021, 21:57, 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 http://www.bluemail.me/r?b=16361 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
Hi,
main trouble that in old mysql/mariadb versions (ie mariadb 5.x), db was broken long ago..
On older versions, we have not checked the correctness of the database update for a long time. Than why now we notice about minimum required versions.
Anyway, if you use rolling train of observium, please update to latest revision and make db schema export as: cd /opt/observium svn up ./test_db.php -e > db.json
and send me file db.json (here only db structure, no any data). I will check how we can fix your db.
P.S. If after update you not found test_db.php file - than you used stable branch and need switch to rolling: https://docs.observium.org/updating/#switch-between-rolling-and-stable-train...
Edvinas Kairys via observium wrote on 08.01.2021 00:57:
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 http://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 http://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 http://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 mailto:observium@observium.org> wrote:
In this case I have no idea. :) Adam. Sent from BlueMail <http://www.bluemail.me/r?b=16361> On 7 Jan 2021, at 21:06, Edvinas Kairys via observium <observium@observium.org <mailto: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 <mailto: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 <mailto:observium-bounces@observium.org>> *On Behalf Of *Edvinas Kairys via observium *Sent:* 07 January 2021 15:13 *To:* Observium <observium@observium.org <mailto:observium@observium.org>> *Cc:* Edvinas Kairys <edvinas.email@gmail.com <mailto: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 <mailto:observium@observium.org> http://postman.memetic.org/cgi-bin/mailman/listinfo/observium ------------------------------------------------------------------------ observium mailing list observium@observium.org <mailto:observium@observium.org> http://postman.memetic.org/cgi-bin/mailman/listinfo/observium _______________________________________________ observium mailing list observium@observium.org <mailto: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
Or check out a separate instance of rolling and copy over the test script?
Adam.
Sent from BlueMail
On 14 Jan 2021, 20:38, at 20:38, Mike Stupalov via observium observium@observium.org wrote:
Hi,
main trouble that in old mysql/mariadb versions (ie mariadb 5.x), db was broken long ago..
On older versions, we have not checked the correctness of the database update for a long time. Than why now we notice about minimum required versions.
Anyway, if you use rolling train of observium, please update to latest revision and make db schema export as: cd /opt/observium svn up ./test_db.php -e > db.json
and send me file db.json (here only db structure, no any data). I will check how we can fix your db.
P.S. If after update you not found test_db.php file - than you used stable branch and need switch to rolling: https://docs.observium.org/updating/#switch-between-rolling-and-stable-train...
Edvinas Kairys via observium wrote on 08.01.2021 00:57:
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 mailto:observium@observium.org> wrote:
In this case I have no idea. :) Adam. Sent from BlueMail <http://www.bluemail.me/r?b=16361> On 7 Jan 2021, at 21:06, Edvinas Kairys via observium <observium@observium.org <mailto: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 <mailto: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 <mailto:observium-bounces@observium.org>> *On Behalf Of *Edvinas Kairys via observium *Sent:* 07 January 2021 15:13 *To:* Observium <observium@observium.org <mailto:observium@observium.org>> *Cc:* Edvinas Kairys <edvinas.email@gmail.com <mailto: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 <mailto:observium@observium.org>http://postman.memetic.org/cgi-bin/mailman/listinfo/observium
observium mailing list observium@observium.org <mailto:observium@observium.org> http://postman.memetic.org/cgi-bin/mailman/listinfo/observium _______________________________________________ observium mailing list observium@observium.org <mailto: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
-- Mike Stupalov Observium Limited, http://observium.org
observium mailing list observium@observium.org http://postman.memetic.org/cgi-bin/mailman/listinfo/observium
participants (3)
-
Adam Armstrong -
Edvinas Kairys -
Mike Stupalov