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-lReceived on Mon Jun 12 09:32:03 2006
This archive was generated by hypermail 2.1.8 : Mon Jun 12 2006 - 09:32:15 EDT