Our Primary Goal

is to help you identify anime characters

1. Konata Search
2. Advanced Search
3. Quick Search
4. Who's This Character Board
5. Forum

Our Secondary Goal

is to build a meaningful database of characters and sources

1. Search
2. Charts
3. Popular
4. Images
5. Tags
6. Seasons
7. Watching

Our Third Goal

is to build a friendly and welcoming Anime Community

1. Guilds
2. Lounge
3. Forum
4. PM

Our Fourth Goal

is to listen to our members, and build the tools and features they want or need

To this end, you can find a near endless number of whacky side projects Rei has created

Admin Links 1000 Admin Area Alerts Ban Banned CB Char COTM Dash Dash 2 Emails email2uid email domains Franchises HP Inactive Login Fail Notes Pub Pub Changes Pub Image Profile Queue Rules Romaji Title Fix SQL Log Treasure Cheaters Wall of Shame Year Fix Admin Tools Adopted Series Caps Censor COS IP Block LAME Panic pid2cids SS Treasurer Trim UTMP zapavatar Cards Cards Copies Fixes Individual Merge New Official Packs Request Sale Stats Trade Charts Aliases Anime Getchu Games Release Dates Studios Character Add Clones Favorites Few Hated History Items Loved Last 100 Latest Main Character Names Notes No Profiles Relations Similar Status Traps Character of the Day Week Month Comments C Center Moderation CB Directories Characters Details Series Depreciated DVDs C Views Fav CP Groups HP Check Issues Known Acc No Matches No Matches Old Items Old News People DB P Views Voice Actors Worlds Episode Blogs Characters Forum Bookmarks Forum Guilds AP Images Guilds Help BBCode Guides Images Banners Logo Changes Promo Uploads Images Logs Deleted Images Deleted Characters Event Revision DB Changes Lists Series Characters Lists Type Lounge kline Lounge Main Lounge Living Room Lobby Channels History ML History Mini Avatar Avatar Members View Rank User CP PM Register Settings Saved Profiles Awards Epic Members Epic Ranks Password Reset Friends Ignored Login Logout ur data Rank / Title Ranks Mini Games whoami RPG ACDB Quiz VS Achievements Conquor Dice Exams Quiz Fortunes Exam Results Mobile Apps Mobile Character COTD Dialog Dialogs Guild Images Guild Latest Health Index Logout Lounge Test Photo Search Search Series Seasons Series Source Stats Tags Test Upload VA Watching Popular Characters Page Rank Fav Trends Most Fav Pop Series whatspopular Productivity Memos Ninbu To Do Anime Planner Watching Ratings Rate Search Advanced Predictive Find Trait Search Name Search Konata Search Live BIG Tiles Live Trait Visual Series Similar Add Favorites Notes Recommend Reviews Seasons Violence yearinfo yearanime Series Data Story / Info RSS Comments Change Log Characters Feeds Forum Lounge WTCB Comments WTCB Posts Site Info About Advertise Contact News Privacy Staff Supporters TOS whatshappening Stats Char XP Hair Color Favs Loli Member Neko Site Health Traffic Trait Stats Tags Multiple New Pub Cloud CP List List2 Moderation Tags Toggles antisocial Mobile Top Top Modders Log Mod Submit Rank Submitters Leader Boards Member View Rank Member Rank Searches Tools Image Lookup Treasure Get a License Licensed Hunters Stats Rich Members Unfinished Big VS Notify Queue Project Status Real/Official Diff Secure PM Code watching_dump watchingv7 Voice Actors CV VA Weird Colors Comptiq Template IP Tips Lots of Chests Projects Random Verbs Who Who Who XP Stats

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