Re: [Brahms-dev-l] Fw: ticket 12368 Flemming Videbaek Linux General

Oh.  But, the effect of the change is immediate.  You don't need to 
restart the daemon.  Anyhow, if it is fixed, that is good. :)

Hiro

Flemming Videbaek wrote:

> Hi Hiro,
>
> That is what I did; What I cannot do is to restart the deamon ? Anyhow 
> it is already done.
>
> Flemming
>
> --------------------------------------------
> Flemming Videbaek
> Physics Department Bldg 510-D
> Brookhaven National Laboratory
> Upton, NY11973
>
> phone: 631-344-4106
> cell:       631-681-1596
> fax:        631-344-1334
> e-mail: videbaek @ bnl.gov
> ----- Original Message ----- From: "Hironori Ito" <hito@rcf.rhic.bnl.gov>
> To: "Flemming Videbaek" <videbaek@bnl.gov>
> Cc: "devlist" <brahms-dev-l@lists.bnl.gov>
> Sent: Monday, June 12, 2006 9:31 AM
> Subject: Re: [Brahms-dev-l] Fw: ticket 12368 Flemming Videbaek Linux 
> General
>
>
>> Hello.  You can see/set the environmental variable in MySQL by set 
>> command
>>
>> for example, to see what the current value of max_connections, do
>>
>> show variables like 'max_connections';
>>
>> or, if you want to see all variables,
>>
>> show variables;
>>
>> Then, use "set" command to change the value.
>>
>> set max_connections=2000;
>>
>>
>> Hiro
>>
>>
>>
>> Flemming Videbaek wrote:
>>
>>> FYI
>>> I have submitted a  trouble ticket. Unfortunately we cannot do this 
>>> admin ourselves.
>>>  
>>> fv
>>> --------------------------------------------
>>> Flemming Videbaek
>>> Physics Department
>>> Bldg 510-D
>>> Brookhaven National Laboratory
>>> Upton, NY11973
>>>  
>>> phone: 631-344-4106
>>> cell:       631-681-1596
>>> fax:        631-344-1334
>>> e-mail: videbaek @ bnl.gov
>>> ----- Original Message -----
>>> *From:* Flemming Videbaek <mailto:videbaek@bnl.gov>
>>> *To:* hollowec@rcf.rhic.bnl.gov <mailto:hollowec@rcf.rhic.bnl.gov>
>>> *Cc:* garcia@rcf.rhic.bnl.gov <mailto:garcia@rcf.rhic.bnl.gov> ; 
>>> alexw@rcf.rhic.bnl.gov <mailto:alexw@rcf.rhic.bnl.gov> ; 
>>> smithj4@rcf.rhic.bnl.gov <mailto:smithj4@rcf.rhic.bnl.gov> ; 
>>> rind@rcf.rhic.bnl.gov <mailto:rind@rcf.rhic.bnl.gov> ; 
>>> awchan@rcf.rhic.bnl.gov <mailto:awchan@rcf.rhic.bnl.gov> ; 
>>> tomw@rcf.rhic.bnl.gov <mailto:tomw@rcf.rhic.bnl.gov> ; 
>>> videbaek@bnl.gov <mailto:videbaek@bnl.gov> ; hogue@rcf.rhic.bnl.gov 
>>> <mailto:hogue@rcf.rhic.bnl.gov> ; rpetkus@rcf.rhic.bnl.gov 
>>> <mailto:rpetkus@rcf.rhic.bnl.gov> ; operator@rcf.rhic.bnl.gov 
>>> <mailto:operator@rcf.rhic.bnl.gov>
>>> *Sent:* Sunday, June 11, 2006 3:38 PM
>>> *Subject:* CTS: ticket 12368 Flemming Videbaek Linux General
>>>
>>> Administrator
>>>
>>> RCF Call Tracking System
>>> *New* <https://www.rcf.bnl.gov/Auth/External/cts/cts_new.pl> *View* 
>>> <https://www.rcf.bnl.gov/Auth/External/cts/cts_view.pl> *Followup* 
>>> <https://www.rcf.bnl.gov/Auth/External/cts/cts_modify.pl> *Notify* 
>>> <https://www.rcf.bnl.gov/Auth/External/cts/cts_notify.pl> *Report* 
>>> <https://www.rcf.bnl.gov/Auth/External/cts/cts_report.pl> *Search* 
>>> <https://www.rcf.bnl.gov/Auth/External/cts/cts_search.pl> *Problem 
>>> Types* <https://www.rcf.bnl.gov/Auth/External/cts/cts_problem.pl> 
>>> *CForm* <https://www.rcf.bnl.gov/Auth/RCFInternal/cforms/cform.pl> 
>>> *About* 
>>> <https://www.rcf.bnl.gov/Auth/External/cts/cts_new.pl?source> *Help* 
>>> <https://www.rcf.bnl.gov/Auth/External/cts/cts_help.html>
>>>
>>> View problem ticket 12368, Original Submission View Full Ticket 
>>> <https://www.rcf.bnl.gov/Auth/External/cts/cts_view.pl?12368> 
>>> Followup 
>>> <https://www.rcf.bnl.gov/Auth/External/cts/cts_modify.pl?12368>
>>>
>>> Problem 12368, Original Ticket - *Open*, Priority: High
>>> Customer: Flemming Videbaek <MAILTO:videbaek@bnl.gov>, x4106, 
>>> Physics Department
>>> Submitted On: Sun, 11 Jun 2006 15:38:23 Submitted By: Flemming 
>>> Videbaek <MAILTO:videbaek@bnl.gov>, x4106
>>> Problem Type: Linux General Owner: Christopher Hollowell 
>>> <MAILTO:hollowec@bnl.gov>, x8031
>>> Summary: mysql on brahms-db0 low num max_connections
>>>
>>> Collaboration=Brahms
>>> It seems for not obvious reasons that the max_connections are back 
>>> to the default 100 (check it quering the db (show varaiables). It 
>>> also seems there is no default my.cnf that usual holds these 
>>> varaibels. I suspect but has no proof this happened after the move 
>>> of the db server.
>>> Could you please have the mac_connections set to 1000, and restart the
>>> daemons; our reconstruction of the new incoming data is suffering, 
>>> as well as old analysis
>>>  
>>>
>>> ------------------------------------------------------------------------ 
>>>
>>>
>>> _______________________________________________
>>> Brahms-dev-l mailing list
>>> Brahms-dev-l@lists.bnl.gov
>>> http://lists.bnl.gov/mailman/listinfo/brahms-dev-l
>>>  
>>>
>>

_______________________________________________
Brahms-dev-l mailing list
Brahms-dev-l@lists.bnl.gov
http://lists.bnl.gov/mailman/listinfo/brahms-dev-l