1Apache::DBI::Cache::mysUqsle(r3)Contributed Perl DocumenAtpaatcihoen::DBI::Cache::mysql(3)
2
3
4
6 Apache::DBI::Cache::mysql - a Apache::DBI::Cache plugin
7
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
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
41 Apache::DBI::Cache
42
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
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.30.0 2019-07-26 Apache::DBI::Cache::mysql(3)