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
|