GENERAL_LOG COUNTS of "replace into prims" table

see also GENERAL_LOG COUNTS of "insert into primitems" table    An NPC playing the drums

After setting all my regions to RUNNING

With MYSQL Variable log_output = 'TABLE' ( need the single quote for a reserved word TABLE ) then general_log = ON for about 7 mins gave 26,000 rows in general_log

I ran this:-

SELECT COUNT(*), regionName,

SUBSTRING_INDEX(    
                SUBSTRING_INDEX(

  SUBSTRING_INDEX( argument, "values", -1

),

",", 17

),

",", -1
)

AS PosX,

SUBSTRING_INDEX(    
                SUBSTRING_INDEX(

  SUBSTRING_INDEX( argument, "values", -1

),

",", 18

),

",", -1
)

AS PosY,

SUBSTRING_INDEX(    
                SUBSTRING_INDEX(

  SUBSTRING_INDEX( argument, "values", -1

),

",", 19

),

",", -1
)

AS PosZ,

SUBSTRING_INDEX(SUBSTRING_INDEX(

SUBSTRING_INDEX( argument, "values", -1
),
"'", 4
),
"'", -1
)

AS primName
FROM mysql.general_log , robust.regions
WHERE SUBSTRING( argument, 1, 19) = "replace into prims "
AND regions.uuid = SUBSTRING_INDEX(SUBSTRING_INDEX(

SUBSTRING_INDEX( argument, "values", -1
),
"'", 14
),
"'", -1
)

GROUP BY primName, PosX, PosY
ORDER BY 1 DESC

--------------------------------------------------------------------------

The general_log row:

event_time user_host thread_id server_id command_type argument
10/9/2022 9:46:29 AM opensimuser[opensimuser] @ localhost [127.0.0.1] 1169 0
Query replace into prims
(UUID, CreationDate, Name, Text, Description, SitName, TouchName, ObjectFlags, OwnerMask, NextOwnerMask, GroupMask, EveryoneMask, BaseMask,
PositionX, PositionY, PositionZ,

GroupPositionX, GroupPositionY, GroupPositionZ,

 VelocityX, VelocityY, VelocityZ, AngularVelocityX, AngularVelocityY, AngularVelocityZ, AccelerationX, AccelerationY, AccelerationZ, standtargetx, standtargety, standtargetz, RotationX, RotationY, RotationZ, RotationW, SitTargetOffsetX, SitTargetOffsetY, SitTargetOffsetZ, SitTargetOrientW, SitTargetOrientX, SitTargetOrientY, SitTargetOrientZ,

RegionUUID, CreatorID, OwnerID, GroupID, LastOwnerID, RezzerID, SceneGroupID,
PayPrice, PayButton1, PayButton2, PayButton3, PayButton4, LoopedSound, LoopedSoundGain, TextureAnimation, CameraEyeOffsetX, CameraEyeOffsetY, CameraEyeOffsetZ, CameraAtOffsetX, CameraAtOffsetY, CameraAtOffsetZ, ForceMouselook, ScriptAccessPin, AllowedDrop, DieAtEdge, SalePrice, SaleType, ColorR, ColorG, ColorB, ColorA, ParticleSystem, ClickAction, Material, CollisionSound, CollisionSoundVolume, PassTouches, PassCollisions, LinkNumber, MediaURL, KeyframeMotion, AttachedPosX, AttachedPosY, AttachedPosZ, PhysicsShapeType, Density, GravityModifier, Friction, Restitution, Vehicle, PhysInertia, DynAttrs, RotationAxisLocks, sopanims, sitactrange, pseudocrc)

values

('e0f67fa1-eeda-47d0-a79f-52f3c8f41426', 1581953562, 'Roller Coaster', '', '', '', '', 64, 647168, 565248, 0, 0, 647168,
-0.162759, -0.274574, 0.452937,

70.2593, 113.024521, 24.2553825,

0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, -0.33196193, -0.206736937, 0.624342859, 0.6762079, 0, -0.265602, 0.20558, -0.707107, 0, 0, 0.707107,

'3ddc9c31-b81c-4291-bf31-fc6f61589855', '7227cd5d-d138-40e0-af94-9b57a59b46f7;http://hg.osgrid.org:80/;Spax Orion', '580424ce-027a-4539-bdde-dc83bb6a14b9', 'caa5cc3b-1e50-4a88-86fa-795cc37e6701', '580424ce-027a-4539-bdde-dc83bb6a14b9', '580424ce-027a-4539-bdde-dc83bb6a14b9', '1356e522-c54d-4dac-9862-38e2d7852e06',
-2, -2, -2, -2, -2, _binary '00000000-0000-0000-0000-000000000000', 0, _binary '', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 10, 0, 0, 0, 0, 255, _binary '', 1, 3, '00000000-0000-0000-0000-000000000000', 0, 0, 0, 13, '', _binary '', 0, 0, 0, 0, 1000, 1, 0.6, 0.5, '', '', NULL,0, NULL, 0, -797776216)