Rechercher une page de manuel
Apache::DBI::Cache::mysql.3pm
Langue: en
Version: 2005-12-09 (fedora - 06/07/09)
Section: 3 (Bibliothèques de fonctions)
NAME
Apache::DBI::Cache::mysql - a Apache::DBI::Cache pluginSYNOPSIS
use Apache::DBI::Cache plugin=>'Apache::DBI::Cache::mysql', ...; or use Apache::DBI::Cache; use Apache::DBI::Cache::mysql;
DESCRIPTION
NOTE: Read Apache::DBI::Cache before."DBD::mysql" allows many different DSN syntaxes for connecting to the same database server and the same database. This plugin transforms them to a standard format thus allowing better DBI handle caching. Further, if "port" is omitted the standard port 3306 is inserted. The actual database is deleted from the DSN and replaced by a "USE database" command.
So, DBI connects to the following DSNs as the same user at different times are actually performed with the same DSN "host=server;port=3306". Subsequently "USE db[1-3]" commands are issued before passing the handle 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 them all under the same key. So only one real database connection is needed instead of 3 without the plugin.
Furthermore, "mysql_auto_reconnect" is turned off.
SEE ALSO
- Apache::DBI::Cache
AUTHOR
Torsten Foertsch, <torsten.foertsch@gmx.net>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 >
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.COPYRIGHT AND LICENSE
Copyright (C) 2005 by Torsten FoertschThis library is free software; you can redistribute it and/or modify it under the same terms as Perl itself.
Contenus ©2006-2024 Benjamin Poulain
Design ©2006-2024 Maxime Vantorre