Apache:...e::mysql(3)

💅 NAME 💅

Apache::DBI::Cache::mysql — it's a plugin for Apache::DBI::Cache, bestie. That's the whole vibe. ✨

---

🦋 SYNOPSIS 🦋

okay so you can either do the one-liner thing:

use Apache::DBI::Cache plugin=>'Apache::DBI::Cache::mysql',
                       ...;

or, if you're feeling ✨extra✨:

use Apache::DBI::Cache;
use Apache::DBI::Cache::mysql;

both are valid, pick your fighter 💖

---

🌸 DESCRIPTION 🌸

NOTE: bestie, read Apache::DBI::Cache first. like, before this one. fr fr. 🙈

so here's the tea: DBD::mysql lets you use a whole bunch of different DSN syntaxes to connect to the same database server and the same database. which is chaos, honestly. and this plugin? it takes all those messy little DSNs and transforms them into one standard format, which means the DBI handle caching works sooooo much better. 👑

and ALSO — if port is omitted, the standard port 3306 gets inserted. slay. and the actual database name? it gets deleted from the DSN and replaced with a USE database command instead. iconic behaviour tbh.

so check it — DBI connects to all of these following DSNs as the same user, at different times, and they're actually all performed with the same DSN host=server;port=3306. then USE db[1-3] commands get issued before the handle is handed off to the caller. 🫶

dbi:mysql:dbname=db1;host=server
dbi:mysql:db2:server:3306
dbi:mysql:port=3306;database=db3;host=server

Apache::DBI::Cache can cache all of them under the same key. so you only need one real database connection instead of 3 without the plugin. the way that's a glow-up 😭✨

and one more thing — mysql_auto_reconnect gets turned off. 💀

---

👀 SEE ALSO 👀

• Apache::DBI::Cache

---

💖 AUTHOR 💖

Torsten Foertsch, <torsten.foertsch@gmx.net> — ty for your service 🫡

with suggestions from:

• Andreas Nolte < andreas dot nolte at bertelsmann dot de >
• Dietmar Hanisch < dietmar dot hanisch at bertelsmann dot de > and
• Ewald Hinrichs < ewald dot hinrichs at bertelsmann dot de >

the whole squad came through 💅

---

🎀 SPONSORING 🎀

sincere thanks to Arvato Direct Services (http://www.arvato.com/) for sponsoring this module and providing a test platform with several thousand DBI connections. several thousand. bestie that's not a test, that's a lifestyle. 🔥👑

---

📜 COPYRIGHT AND LICENSE 📜

Copyright (C) 2005 by Torsten Foertsch

This library is free software; you can redistribute it and/or modify it under the same terms as Perl itself.

---

and that's the whole page, bestie!! 🦋✨ this one's from perl v5.42.0, dated 2025-07-25, and it lives in the Apache:...e::mysql(3) section of the manual. go forth and cache those handles responsibly 💖🌸🎀