Some Changes Aug 26, 2018 | Rei
Added two new Random links:

- Tag | for a Random Tag
- CV | or Character Voice, for a random voice actor/actress

Also shaved off a lot of pixels from the header, to hopefully reduce scrolling.

I'm working on replacing the Top Links with a show/hide menu table.

And exploring adding something of a Poker Dice game to the site. Where you'd play against characters. I have a proof of concept up but it'll take A LOT more code to make it playable.

There's also a new favorites tool to hopefully make it a little easier to explore your favorite characters and series, as well as rate and comment on them.

We're close to getting out of the Red financially. A thousand thanks to our brave Patreon supporters! While we're still a long ways off the $150/month needed to pay the bills, I have enough to cover this months server bill and next.
Server Performance Aug 15, 2018 | Rei
Finally, found a solution to intermittent server performance issues.

At all times, we have a lot of bots accessing ACDB. As far as Google Analytics is to be trusted, of our 500,000 - 1,000,000 daily page views, roughly 10% are from human sources. That other 90% is a legion of bots set upon us.

Our web server works a little weirdly in that for each connection, it allocates roughly 256 file descriptors. So it was giving me a useless error stating "out of fds" as it crashed. I set up trips and traps to monitor at a kernel level how many fds were actually in use as tracked by the OS, and it never went much beyond 3000. So how in the world could more than 5000 have been exceeded by the web server? It's that fractional reserve banking like counting, it is.

Even then, all I learned was another config value, one that turned a hard crash ( non-recoverable ) into a soft crash ( recoverable ).

Still, performance was shit. And it made no sense to be soft crashing over and over and over again.

So I turned my attention to the firewall. It's quite amazing how even after all these years, you can't have a firewall rule with two limit conditions.

You can
A) limit the connections per IP
B) limit the connections per rule
but not both.

I can not say a max of X IP's get Y connections each to a max of Z connections. Nope.

Made no diff anyways, more connections STILL came in than the server could handle. There was no 1-1 ratio here.

Thinking my only resource would be to hack the code myself to give me more info, I came across a better solution using mod_status. At one glance I understood the problem, the solution, and the action to take.

We're now severing 30 requests per second with 80% slack capacity.

Bring on the traffic !
Master Assignments Editor, Disqus Aug 14, 2018 | Rei
Made some improvements to our Master Assignments Editor.

There was a bit of an issue when dealing with primary assignments.

They are now highlighted in red, and rather than giving an error when clicked, they will direct you to a page where they can be properly edited.

Every character in the DB needs a primary assignment, one title I can use as a short cut to fetch publisher related data from. Ideally it should be wherever they first appeared in a franchise.

No character should ever be assigned directly to a franchise, as that would provide us the least amount of useful information about them.



What else ... well, we're going to try out Disqus yet again. I have it on character pages as the new comment system. To prevent it from lagging pages, you'll need to click Load Comments to use it.
Bookmark Icon Bookmark this Page

Sponsored with ♥

Sponsored with Jewels

Share on Facebook Share on Twitter Share on Google+ Share on Reddit Share on Tumblr
日本語 한국어 简化字 Français Deutsch Español Afrikaans English
Wilhelm van Astrea Wilhelm van Astrea | View More

This is for my wife, Theresia van Astrea.

All images are copyright of their respective owners.
Rendered in 20.9 ms. R-17-W-2-M-2286.2 KB Modified: Wed, 25 Jul 2018 01:48:41 -0400
Copyright © 2007-2019 Goral Software | Privacy Policy | Discord | Contact Us | Site Map | アニキャラベー | Help Wanted

Dark Theme