1Apache::DBI::Cache::mysUqsle(r3)Contributed Perl DocumenAtpaatcihoen::DBI::Cache::mysql(3)
2
3
4

NAME

6       Apache::DBI::Cache::mysql - a Apache::DBI::Cache plugin
7

SYNOPSIS

9         use Apache::DBI::Cache plugin=>'Apache::DBI::Cache::mysql',
10                                ...;
11        or
12
13         use Apache::DBI::Cache;
14         use Apache::DBI::Cache::mysql;
15

DESCRIPTION

17       NOTE: Read Apache::DBI::Cache before.
18
19       "DBD::mysql" allows many different DSN syntaxes for connecting to the
20       same database server and the same database. This plugin transforms them
21       to a standard format thus allowing better DBI handle caching. Further,
22       if "port" is omitted the standard port 3306 is inserted. The actual
23       database is deleted from the DSN and replaced by a "USE database"
24       command.
25
26       So, DBI connects to the following DSNs as the same user at different
27       times are actually performed with the same DSN "host=server;port=3306".
28       Subsequently "USE db[1-3]" commands are issued before passing the
29       handle to the caller.
30
31         dbi:mysql:dbname=db1;host=server
32         dbi:mysql:db2:server:3306
33         dbi:mysql:port=3306;database=db3;host=server
34
35       Apache::DBI::Cache can cache them all under the same key. So only one
36       real database connection is needed instead of 3 without the plugin.
37
38       Furthermore, "mysql_auto_reconnect" is turned off.
39

SEE ALSO

41       Apache::DBI::Cache
42

AUTHOR

44       Torsten Foertsch, <torsten.foertsch@gmx.net>
45
46       With suggestions from
47
48           Andreas Nolte < andreas dot nolte at bertelsmann dot de >
49
50           Dietmar Hanisch < dietmar dot hanisch at bertelsmann dot de > and
51
52           Ewald Hinrichs < ewald dot hinrichs at bertelsmann dot de >
53

SPONSORING

55       Sincere thanks to Arvato Direct Services (http://www.arvato.com/) for
56       sponsoring this module and providing a test platform with several
57       thousand DBI connections.
58
60       Copyright (C) 2005 by Torsten Foertsch
61
62       This library is free software; you can redistribute it and/or modify it
63       under the same terms as Perl itself.
64
65
66
67perl v5.36.0                      2023-01-19      Apache::DBI::Cache::mysql(3)
Impressum