Forum Activity for @soaringeagle

jrcore_cache gets very fragmented (and other db question)

Using Jamroom

i think i got it figured out

jrcore_cache gets very fragmented (and other db question)

Using Jamroom

redis-cli MONITOR says unable to connect to redis server connection refused
so it is installed
im guessing its just a difeent port

jrcore_cache gets very fragmented (and other db question)

Using Jamroom

getting Unable to retrieve stats from Redis Server
when trying to view server stats

jrcore_cache gets very fragmented (and other db question)

Using Jamroom

ok i remembered having to set up diferent ports for diferent sites

jrcore_cache gets very fragmented (and other db question)

Using Jamroom

theres no documentation on how to set it up

jrcore_cache gets very fragmented (and other db question)

Using Jamroom

just installed it (but got super sick) about to set it up

if you run adsense this tip might surprise you

Using Jamroom

adsense has added a new "user experience' adjustment that might surprise you in its effectiveness

basicly it increases user experience by reducing the member of ads shown, at the same time keeping 100% of your revenues (or more)

the sweet spot for me was... 40%!
so less then 1/2 of the times a page loads a ad is shown, this makes users enjoy the site more, but has no impact on income (negatively anyway)
i found that even in periods of reduced trafic, my income has gone up since making this change.

ads are always also the biggest contributer to a slow website. so 60% fewer ads means a faster site..in general ..better user experience
and ads are shown only when they are more like,y to be clicked

you can also try it out by going into adsense and creating a new experiment, choose user experience
drag the bar down to around where it says 100% revenues and set it to run x number of days

optionally you can set up multiple experiments with different % values (from 40-100% fill rates) let it run a month and check "automaticly use the winner"
that will try each value you set and see what ends up working best for you

i just tried running an experiment for 1st time recently, but had set my fill at 50% about a month back (whenever they added this feature)

i was really surprised to see that reducing the number of ads ..actually didn't reduce income but increase it

logically you'd think more ads = higher profits
but in reality happier visitors and better user experience.. and less annoyance with ads.. actually makes the fewer ads you display pay you a lil more while simultaneously making your users have a better experience on your site

try it a week and report back your experiences good or bad
updated by @soaringeagle: 05/21/18 09:56:22PM

jrcore_cache gets very fragmented (and other db question)

Using Jamroom


i noticed this has always been an issue but with the db being big it can be a big issue
jrcore_cache often is the only table fragmented if not the rest are a few k
but the cache table often has 800 megs of overhead and optimization can reduce the total db size by nearly 1/3


another db thing
what would cause sub par db performance results along with sub par disk results

note: with default my.cnf after fresh os install i got a 2,400+ rating
with cpu 0.1 db i think was 4.9 or 5.6 in that range and disk was 0.87-98

i added most of my prevoius optimisations from old server
but had issues when restarting mysql (mariadb) i would have a huge number of waiting for table lock messages in error log and the shutdown would timeout (continue to shutdown but not restart) shutdown took 5-10 minutes!
i added some innodb tweaks i found in searches meant to improve that (and it did to a decet degre)
but somewhere in there the db performance fropped to between 9.6 and 15.6
and disk performance dropped to 1.86-2.65 (approx estimations)
this leads me to think the db is using disk too much (there is 252 m of swap being used..im used to that always being zero)

not asking ya o tune it for me (mysqltuner only suggests increase join buffer but thats what it always says)
just wondering what you think might be the most important thing to look at that might be causing this

ps will be testing an outrageously expensive db optimizer as soon as i figure it out
just wondering in the meantime what might be the cause..if you had to guess
really feel like its an innodb setting

updated by @soaringeagle: 05/21/18 09:56:19PM

symbols in gallery/image name cause weird issues (urls)

Using Jamroom

ok i believe we're good will update if theres any other issued

so umm no expert at reading php..but was it coming from activity feed?
i saw mention of add item to activity up a ways
it seemed like the most logical place that would affect multiple modules

wow had an instant affect on cpu load it seems and the number of current connections dropped as well
updated by @soaringeagle: 02/17/18 06:53:12PM

symbols in gallery/image name cause weird issues (urls)

Using Jamroom

i see where i went wrong
2 opening comments
let me try again