set okapi_syncbase = now()
where wp_oc in ('GC2P9MN')
5417 Query DELETE FROM gk_item_waypoint WHERE id= '8059'
5417 Query INSERT INTO gk_item_waypoint (id, wp)
VALUES ('8059', 'GC2P9MN')
ON DUPLICATE KEY UPDATE wp='GC2P9MN'
5417 Query INSERT INTO gk_item (`id`, `name`, `distancetravelled`, `latitude`, `longitude`, `stateid`)
VALUES ('8060', 'HARP_018 - woj szablik', '81', '', '','0')
ON DUPLICATE KEY UPDATE `name`='HARP_018 - woj szablik', `distancetravelled`='81',
`latitude`='', `longitude`='',
`stateid`='0'
5417 Query SELECT distinct wp FROM gk_item_waypoint
WHERE id='8060'
set okapi_syncbase = now()
where wp_oc in ('')
5417 Query DELETE FROM gk_item_waypoint WHERE id= '8063'
5417 Query INSERT INTO gk_item (`id`, `name`, `distancetravelled`, `latitude`, `longitude`, `stateid`)
VALUES ('8064', 'HARP_022 - woj kicarz', '4190', '', '','0')
ON DUPLICATE KEY UPDATE `name`='HARP_022 - woj kicarz', `distancetravelled`='4190',
`latitude`='', `longitude`='',
`stateid`='0'
5417 Query SELECT distinct wp FROM gk_item_waypoint
WHERE id='8064'
5416 Query update caches
set okapi_syncbase = now()
where wp_oc in ('')
5417 Query DELETE FROM gk_item_waypoint WHERE id= '8064'
5417 Query INSERT INTO gk_item (`id`, `name`, `distancetravelled`, `latitude`, `longitude`, `stateid`)
VALUES ('8065', 'HARP_023 - woj koguciarz', '2094', '50.33282', '18.92832','1')
ON DUPLICATE KEY UPDATE `name`='HARP_023 - woj koguciarz', `distancetravelled`='2094',
`latitude`='50.33282', `longitude`='18.92832',
`stateid`='1'
5417 Query SELECT distinct wp FROM gk_item_waypoint
WHERE id='8065'
5416 Query update caches
set okapi_syncbase = now()
where wp_oc in ('OP273B')
5417 Query DELETE FROM gk_item_waypoint WHERE id= '8065'
5417 Query INSERT INTO gk_item_waypoint (id, wp)
VALUES ('8065', 'OP273B')
ON DUPLICATE KEY UPDATE wp='OP273B'
5417 Query INSERT INTO gk_item (`id`, `name`, `distancetravelled`, `latitude`, `longitude`, `stateid`)
VALUES ('8066', 'HARP_024 - woj lukacz', '147', '', '','0')
ON DUPLICATE KEY UPDATE `name`='HARP_024 - woj lukacz', `distancetravelled`='147',
`latitude`='', `longitude`='',
`stateid`='0'
5417 Query SELECT distinct wp FROM gk_item_waypoint
WHERE id='8066'
The behaviour indicates a relation with a cron job, since these query storms seem to happen periodically.
These look like queries from updates from code and/or additional updates due to SQL triggers.
Anyway, they generate huge amounts of database modifications, hence the huge binary logs.
Also, looking at these queries, looks like data about geokrets unrelated to OCRO, which begs the question why are they processed on OCRO?
IMO OCRO should process OC <=> GeoKrety data only for geokrets located in OR caches, or at most geokrets located in Romania (geographically).
For now I disabled replication and binary logs, but it's only a temporary workaround and I am seeking a fix.
Thank you.
On OCRO I experienced several server outages due to exhaustion of disk space. Upon detailed investigation I discovered the following:
Apache log extract:
MySQL query log extract:
The behaviour indicates a relation with a cron job, since these query storms seem to happen periodically. These look like queries from updates from code and/or additional updates due to SQL triggers. Anyway, they generate huge amounts of database modifications, hence the huge binary logs.
Also, looking at these queries, looks like data about geokrets unrelated to OCRO, which begs the question why are they processed on OCRO?
IMO OCRO should process OC <=> GeoKrety data only for geokrets located in OR caches, or at most geokrets located in Romania (geographically).
For now I disabled replication and binary logs, but it's only a temporary workaround and I am seeking a fix. Thank you.