 |
ANIME CHARACTERS DATABASE |
| Anime Characters Database |
|
☰
ACDB
Log In
|
| SMASH or PASS |
The visual search engine for animated characters. We index characters by eye color, hair color, hair length, age, gender, and animal ears.
| Characters | 140003 |
| Titles | 13564 |
| Members | 78028 |
| Quotes | 331747 |
| Voice Actors | 10092 |
Seventeen years ago today I registered animecharactersdatabase.com
Back then I already had liked running servers and watching anime for 10+ years. When I imagined something I could see myself doing and enjoying 10, 20+ years later, combining the two seemed like a sure bet. ACDB will continue to grow and evolve well into the future.
I'd like to take a moment to thank our moderators for the hard work they do, and all our contributors. We're closing in on 140,000 characters now!
In the 139,000's we have:
chanchanlee added 368
NatsumiSawada added 193
Juan_Elric added 177
Moon_Moon added 124
RinaK added 50
romhackd added 11
RamRol97 added 8
Ben6439 added 6
rpgguy999 added 6
Animemaster1 added 5
Kazuma00 added 1
TsundereChan added 1
NgKQ added 1
NoamRault added 1
DaddyRengoku added 1
mxtedangel added 1
~~~~
This week I've been exploring some more configuration possibilities within PHP FMP.
There have been cases where:
/var/log/messages
Apr 21 13:49:21 ns507285 kernel: sonewconn: pcb 0xfffff806a3f0f000: Listen queue overflow: 769 already in queue awaiting acceptance (8 occurrences)
This was happening when a large number of IP's at the same second, requested pages. Once all the php-fmp processes are busy, the Listen Queue starts to fill, and once that overflows 503 errors start happening.
I had been using:
pm = static
pm.max_children = 8
Which meant there was always 8 processes available to handle pages simultaneously. Beyond that they would queue until the queue limit was hit.
[23-Apr-2024 20:24:28] WARNING: [pool acdb] seems busy (you may need to increase pm.start_servers, or pm.min/max_spare_servers), spawning 8 children, there are 0 idle, and 13 total children
Now I'm trying:
pm = dynamic
pm.max_children = 64
pm.start_servers = 4
pm.min_spare_servers = 2
pm.max_spare_servers = 8
With this, under normal load there's always 8 servers up and ready to go. But under a traffic spike we can have up to 64 spawned to immediately accept requests.
As each one needs 2 mysql connections and the default max connections is 151, I can't safely go much higher without triggering MySQL errors.
For requests that can be handled near instantly, this works great. But in the event things slow down the server can still get a bit overwhelmed.
Thus I'm back to doing some profiling and optimizing. You'll see in the footer how long a page took to render. Ideally I'd love to keep the average below 100ms
There's still much I can do with query optimization. But some pages may need to be retired, or redesigned, if the site is to be able to handle 1000 connections per second.
--
Rei
Kawaii or NOT and Smash or Pass are quite popular! Or test your knowledge witch Series Quizzes.
Latest Family Tree Relations
1 hour(s) 6 minute(s) 41 second(s) ago
1 hour(s) 6 minute(s) 41 second(s) ago
1 hour(s) 6 minute(s) 41 second(s) ago
1 hour(s) 6 minute(s) 41 second(s) ago
1 hour(s) 6 minute(s) 41 second(s) ago
Quick Links for members.
Links
Add a Character 
A-Z Characters
Top 5 by Year
Latest
Tags
Lists
A-Z Series
Calendar
Who
News