Follow Marin Events


OS DB Log Analysis

GENERAL_LOG COUNTS of "replace into prims" table

GENERAL_LOG COUNTS of "insert into primitems" table

Theres also a variable general_log_file --- set to a filename in mysql/data
and in the space of 7 minutes since I set it to ON it created 7,000 lines 


I need to change a a bulb:-

SELECT COUNT(), SUBSTRING( argument, 1, 7), SUBSTRING_INDEX(SUBSTRING_INDEX(
SUBSTRING_INDEX( argument, "values", -1
),
"'", 4
),
"'", -1) AS arg
FROM mysql.general_log
WHERE SUBSTRING( argument, 1, 19) = "replace into prims "
GROUP BY arg
ORDER BY 1 DESC
 




SELECT COUNT(*), SUBSTRING( argument, 1, 7), SUBSTRING_INDEX(SUBSTRING_INDEX(argument, "values", -1), "'", 3) AS arg
FROM mysql.general_log
WHERE SUBSTRING( argument, 1, 21) = "insert into primitems"
GROUP BY arg
ORDER BY 1 DESC



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
),
"'", 4
),
"'", -1
)
AS arg
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 arg
ORDER BY 1 DESC

==========================================================

 a bunch of pretzels with a script called invisiprim changing texture on 5 sec timer within which is a 30 sec sleep !!


Fred Beckhusen 
Ugh. Thats gonna lag badly!

the 153 primitive in Winter is MY script to flicker candle light intensity every 1/2 sec 😞 ( I'm keepin it for now)

that's a reasonable thing to do. Events are supposed to be short. Maybe use a llFrand in the timer to set it to a value between 2 and 0.2, still flickers, average is 1.1, 5 x better
float randomFloat = 0.2 + llFrand(2.0);


The 330 Primitive in Dragon Fayre is
SteamPunk Broom
( dont know why yet)

and the 84 in Dragon fayre is Grandfather Clock
( 2 scripts:
        GetWallClock every half second
        GetWallClock every 0.2 sec !
both do rotations of pendulum + hands + chimes + ticks ---
Probably could all be done in one script . )


Fred Beckhusen 
Grandfather clock needs to have the second hand removed and the script set to 60 seconds. I've run into it before. Always one of the top scripts.


DREAMGRID & Opensim NOTES
 

   
Questions or problems regarding this web site should be directed to Info@marincounty.info  
Last modified: Thursday February 22, 2024.