I'm not sure what you are asking here? I assume you also mean 5.5.22 as your version of MySQL?
Are you asking why otrs has connections open to your database all the time? If so then that appears to be by design, OTRS runs as an application on top of Apache+mod_perl and so is always active in memory and maintains connections to the database. For example on my system it shows 10 connections open: mysql> show processlist; +-----+------+-------------------------------------+------+---------+-------+-------+------------------+ | Id | User | Host | db | Command | Time | State | Info | +-----+------+-------------------------------------+------+---------+-------+-------+------------------+ | 2 | otrs | web.lab.indigo-solutions.eu:56836 | otrs | Sleep | 4 | | NULL | | 5 | otrs | web.lab.indigo-solutions.eu:56839 | otrs | Sleep | 2418 | | NULL | | 27 | otrs | web.lab.indigo-solutions.eu:56867 | otrs | Sleep | 1807 | | NULL | | 31 | otrs | web.lab.indigo-solutions.eu:56872 | otrs | Sleep | 910 | | NULL | | 39 | otrs | web.lab.indigo-solutions.eu:56882 | otrs | Sleep | 304 | | NULL | | 83 | otrs | web.lab.indigo-solutions.eu:56940 | otrs | Sleep | 1207 | | NULL | | 85 | otrs | web.lab.indigo-solutions.eu:56942 | otrs | Sleep | 52471 | | NULL | | 102 | otrs | web.lab.indigo-solutions.eu:56964 | otrs | Sleep | 1510 | | NULL | | 128 | otrs | web.lab.indigo-solutions.eu:57000 | otrs | Sleep | 604 | | NULL | | 140 | otrs | web.lab.indigo-solutions.eu:57014 | otrs | Sleep | 2117 | | NULL | | 957 | root | ninja.lab.indigo-solutions.eu:40956 | NULL | Query | 0 | NULL | show processlist | +-----+------+-------------------------------------+------+---------+-------+-------+------------------+ 11 rows in set (0.00 sec) Steve On 26 March 2012 09:45, Luca Domenella <[email protected]> wrote: > Hi,**** > > ** ** > > i set mysql to log the queries... I see that when I go into admin panel or > sysconfig the application run a lot of queries on the system tables like > performace schema and so on…**** > > but I cant understand the meaning of that…**** > > ** ** > > it run all the time the same queries, looks like a loop or something like > this…**** > > ** ** > > is it a bug ?**** > > ** ** > > br,**** > > ** ** > > *Luca Domenella***** > > T: +39 0698962316 > E: [email protected]**** > > *bwin Italia* > Via Adolfo Ravà, 124 > 00142 Roma (RM)**** > > www.bwinparty.com**** > > **** > > This email and any attachments are confidential, and may be legally > privileged and protected by copyright. If you are not the intended > recipient dissemination or copying of this email is prohibited. If you have > received this in error, please notify the sender by replying by email and > then delete the email completely from your system. > > Any views or opinions are solely those of the sender. This communication > is not intended to form a binding contract unless expressly indicated to > the contrary and properly authorised. Any actions taken on the basis of > this email are at the recipient's own risk.**** > > ** ** > > *From:* [email protected] [mailto:[email protected]] *On Behalf > Of *Luca Domenella > *Sent:* lunedì 26 marzo 2012 10:24 > *To:* [email protected] > *Subject:* [otrs] strange block on orts application when going to > admin->sysconfig > *Importance:* High**** > > ** ** > > Hi,**** > > ** ** > > i found that if i with an administrative user to the admin section -> > sysconfig... the otrs application freeze the mysql database**** > > ** ** > > I actually use otrs 3.1.2 on a linux server and a mysql 5.22.20 on a linux > server (not the same as otrs)**** > > ** ** > > What I see on the mysql server is:**** > > ** ** > > mysql> show processlist;**** > > > +----+------+------------------+------+---------+------+-------+------------------+ > **** > > | Id | User | Host | db | Command | Time | State | > Info |**** > > > +----+------+------------------+------+---------+------+-------+------------------+ > **** > > | 3 | otrs | 10.20.1.63:14244 | otrs | Sleep | 92 | | > NULL |**** > > | 4 | otrs | 10.20.1.63:14245 | otrs | Sleep | 85 | | > NULL |**** > > | 5 | otrs | 10.20.1.63:14246 | otrs | Sleep | 68 | | > NULL |**** > > | 6 | otrs | 10.20.1.63:14247 | otrs | Sleep | 40 | | > NULL |**** > > | 7 | otrs | 10.20.1.63:14248 | otrs | Query | 0 | NULL | show > processlist |**** > > > +----+------+------------------+------+---------+------+-------+------------------+ > **** > > 5 rows in set (0.01 sec)**** > > ** ** > > mysql> show processlist;**** > > > +----+------+------------------+------+---------+------+-------+------------------+ > **** > > | Id | User | Host | db | Command | Time | State | > Info |**** > > > +----+------+------------------+------+---------+------+-------+------------------+ > **** > > | 3 | otrs | 10.20.1.63:14244 | otrs | Sleep | 93 | | > NULL |**** > > | 4 | otrs | 10.20.1.63:14245 | otrs | Sleep | 86 | | > NULL |**** > > | 5 | otrs | 10.20.1.63:14246 | otrs | Sleep | 69 | | > NULL |**** > > | 6 | otrs | 10.20.1.63:14247 | otrs | Sleep | 41 | | > NULL |**** > > | 7 | otrs | 10.20.1.63:14248 | otrs | Query | 0 | NULL | show > processlist |**** > > > +----+------+------------------+------+---------+------+-------+------------------+ > **** > > 5 rows in set (0.00 sec)**** > > ** ** > > mysql> show processlist;**** > > > +----+------+------------------+------+---------+------+-------+------------------+ > **** > > | Id | User | Host | db | Command | Time | State | > Info |**** > > > +----+------+------------------+------+---------+------+-------+------------------+ > **** > > | 3 | otrs | 10.20.1.63:14244 | otrs | Sleep | 94 | | > NULL |**** > > | 4 | otrs | 10.20.1.63:14245 | otrs | Sleep | 87 | | > NULL |**** > > | 5 | otrs | 10.20.1.63:14246 | otrs | Sleep | 70 | | > NULL |**** > > | 6 | otrs | 10.20.1.63:14247 | otrs | Sleep | 42 | | > NULL |**** > > | 7 | otrs | 10.20.1.63:14248 | otrs | Query | 0 | NULL | show > processlist |**** > > > +----+------+------------------+------+---------+------+-------+------------------+ > **** > > 5 rows in set (0.00 sec)**** > > ** ** > > mysql> show processlist;**** > > ** ** > > ** ** > > and nothing more… I need to wait a lot of time or restart mysql server… do > you know what can happen ?**** > > ** ** > > br,** > > *Luca Domenella***** > > T: +39 0698962316 > E: [email protected]**** > > *bwin Italia* > Via Adolfo Ravà, 124 > 00142 Roma (RM)**** > > www.bwinparty.com**** > > **** > > This email and any attachments are confidential, and may be legally > privileged and protected by copyright. If you are not the intended > recipient dissemination or copying of this email is prohibited. If you have > received this in error, please notify the sender by replying by email and > then delete the email completely from your system. > > Any views or opinions are solely those of the sender. This communication > is not intended to form a binding contract unless expressly indicated to > the contrary and properly authorised. Any actions taken on the basis of > this email are at the recipient's own risk.**** > > ** ** > > --------------------------------------------------------------------- > OTRS mailing list: otrs - Webpage: http://otrs.org/ > Archive: http://lists.otrs.org/pipermail/otrs > To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/otrs >
--------------------------------------------------------------------- OTRS mailing list: otrs - Webpage: http://otrs.org/ Archive: http://lists.otrs.org/pipermail/otrs To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/otrs
