• News
• New
• Index
• About

I've made a new tool to note missing characters in titles.



From the character listing on a title page, members can follow the Missing Character link. From here, you can add a character name and any useful info about them.

There's also a handy list of characters in the series, to check against any characters reported as missing. Members may edit and delete their own posts.

~~~

I've been learning a few new tricks to MySQL. One nagging problem has been approving characters can sometimes lag for 10 to 20 seconds. In that time, MySQL would be rebuilding 13 indexes on the characters table.

As some time ago I created a ＂built at midnight, cached table of characters＂, I figure it will be safer to have the indexes there for searching, and remove the search indexes from the main characters table.

This should speed up the insert, and then anything still depending on the indexes will need to be moved to the cached table.

~~~

There's also some nagging problems with MySQL since moving to PHP 8.x

I had a habit of not checking if user input was too long for the text field it was being stored in, since MySQL had the default behavior of silently dropping the portion that would not fit. Shaved off at least 3 lines of code not having to bother checking for that and giving an error. But PHP 8 changed the default behavior to crash the script.

--
Rei

Transcript - 379 new quotes

Unnamed Memory



The witch of Silence has cursed the royal family to never be able to bear children. Ready to change his fate, prince Oscar heads into the Azure tower.
In the azure tower, the Witch of the Moon has been sealed in after being cursed by a prince. For fifteen years, that has been her fate, but Prince Oscar is ready to change that.
Even though the tower is riddled with puzzles and traps, Oscar actually is ready and prepared to face them. With his unyielding resolve, he reaches the top of the tower.
Ready with tea, the witch Tinasha welcomes Oscar cheerfully. Afer a good chat, the prince explains his motives, and Tinasha makes it clear that what he has is something that can be overcomed, if the woman that bears the prince's child is strong enough to withstand the ＂curse＂.

Featuring Characters
Lazar | CV: Shuuichirou Umeda, 梅田修一朗, うめだ しゅういちろう | 68 lines
Litola | CV: Yuu Sasahara, 篠原侑, ささはら ゆう | 16 lines
Oscar | CV: Yoshiki Nakajima, 中島ヨシキ, なかじま よしき | 140 lines
The Wich of Silence | CV: Mie Sonozaki, 園崎未恵, そのざき みえ | 4 lines
Tinasha | CV: Atsumi Tanezaki, 種﨑敦美, たねざき あつみ | 149 lines

Try out our Quote Games!
Quote Trivia
Quotes to Learn Japanese Game
Quotes to Learn Japanese Game (Audio Version)
Quote Lists


Have you tried today's game ?
ACDB has a big collection of fun mini games for you to try out.
By playing our daily game selection, you can get many jewels and cards!
Not a member? Join us!


ACDB has gone social again!
Come by our X page and give us a shout-out, we post daily birthdays there. Follow our instagram to check the latest admin's recommendation and give us your opinion!
Follow us on X
Follow us on Instagram


Do you like ACDB and want to support us? Consider getting us a coffee

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

~*~*~*~*~*~*~*~*~*~*~*~*~*~

Though we post about birthdays everyday on social media, to so many characters, we wouldn't miss the most important one!

A big happy birthday to ACDB! My home and the home of many others that appreciate fun and camaraderie

-RinaK