GENERAL_LOG COUNTS of "insert into primitems" table

see also GENERAL_LOG COUNTS of "replace into prims" 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:-

DROP TEMPORARY TABLE mysql.temp_table ;

CREATE TEMPORARY TABLE mysql.temp_table (name_temp VARCHAR(255), itemID_temp char(36) );
/* ========================================================================== */
INSERT INTO mysql.temp_table

SELECT

SUBSTRING_INDEX(

SUBSTRING_INDEX(

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

"'", 2) ,

"'", -1),

SUBSTRING_INDEX( SUBSTRING_INDEX(argument, ", _binary '", -7),
"', _binary '", 1)

FROM mysql.general_log
WHERE SUBSTRING( argument, 1, 21) = "insert into primitems";
/* ========================================================================== */
SELECT COUNT(*), GroupPositionX, GroupPositionY, GroupPositionZ, regionName,

primitems.name AS "PrimItemName" , prims.Name AS primNAME, primitems.assetType

FROM mysql.temp_table , opensim.primitems , opensim.prims , robust.regions
WHERE opensim.primitems.itemID = mysql.temp_table.itemID_temp
AND primitems.primID = prims.UUID
AND regions.uuid = prims.RegionUUID
GROUP BY name_temp
ORDER BY 1 DESC

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

The general_log row:

event_time user_host thread_id server_id command_type argument
10/10/2022 5:38:39 PM opensimuser[opensimuser] @ localhost [127.0.0.1] 2089 0 Query insert into primitems
(invType, assetType, name, description, creationDate, nextPermissions, currentPermissions, basePermissions, everyonePermissions, groupPermissions, flags,
itemID,
primID,
assetID, parentFolderID, creatorID, ownerID, groupID, lastOwnerID)
values
(1, 1, 'Romancing the Stone 4', 'Romancing the Stone 4', 1660320509, 532480, 647168, 647168, 0, 0, 0,
_binary '2bda462d-70ed-4d15-9c61-5952833acace',
_binary 'ec3b8238-652c-4fce-8440-6fa49886b678',
_binary '2b4f06d6-85e4-4313-b49e-80a5c2c545c5', _binary 'ec3b8238-652c-4fce-8440-6fa49886b678', '580424ce-027a-4539-bdde-dc83bb6a14b9', _binary '580424ce-027a-4539-bdde-dc83bb6a14b9', _binary 'caa5cc3b-1e50-4a88-86fa-795cc37e6701', _binary '00000000-0000-0000-0000-000000000000')