LinuxQuestions.org
Help answer threads with 0 replies.
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Server
User Name
Password
Linux - Server This forum is for the discussion of Linux Software used in a server related context.

Notices


Reply
  Search this Thread
Old 11-12-2009, 11:32 PM   #1
cheesewizz
Member
 
Registered: Aug 2004
Location: Philippines
Distribution: Centos
Posts: 221

Rep: Reputation: 15
Unhappy Invalid SQL : Too many Connections


Hello

Its my first time have this problem

Invalid SQL: SELECT message_id,content FROM egw_lang WHERE lang='en' AND app_name='home':
Too many connections


My server deisgned as a web server i installed some opensurce
I used apache, Mysql and PHP

Opensource:

1. OrangeHRM
2. DotProject
3. egroupware
4. WEB Timekeeping - inhouse development
5. MediaWiki


this past months ago i have no problems but as of today i monitored 4 times giving me Invalid SQL too many connections


Anyidea why i got this problem do i need to modify the configuration of PHP.ini, httpd.conf or the mysql configuration

please help me to fix i dont want to reinstall then will happen again.



thanks
 
Old 11-13-2009, 05:31 PM   #2
lewc
Member
 
Registered: Nov 2009
Distribution: Gentoo, Slackware or Debian
Posts: 60
Blog Entries: 1

Rep: Reputation: 18
content removed

Last edited by lewc; 11-27-2009 at 03:41 PM.
 
Old 11-13-2009, 06:10 PM   #3
cheesewizz
Member
 
Registered: Aug 2004
Location: Philippines
Distribution: Centos
Posts: 221

Original Poster
Rep: Reputation: 15
Quote:
Originally Posted by lewc View Post
Firstly you need to make sure your apps are not generating persistant connections to mySQL as when handled incorrectly these can lead to connections that lye idle, also you can edit your mysql config file /etc/mysql/my.cnf or mysql.cfg increasing the maximum number of connections.

NOTE : you may have to use gksu to open the file for editing, save and restart mysql or reboot


Hello LEWC


Thanks for your answer, It helps a lot for me
I found it and i set the maximum connection to 100.


Now im going to do is to observe if will happen again.



thank you and advance merry xmas.

Cheers
 
Old 11-14-2009, 03:04 AM   #4
lewc
Member
 
Registered: Nov 2009
Distribution: Gentoo, Slackware or Debian
Posts: 60
Blog Entries: 1

Rep: Reputation: 18
content removed

Last edited by lewc; 11-27-2009 at 03:41 PM.
 
  


Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off



Similar Threads
Thread Thread Starter Forum Replies Last Post
SQL update statement to SQL SERVER 2005 scheidel21 Programming 2 11-05-2009 06:30 PM
SQL noob question: can SQL effectively handle a 2D matrix? JoeyAdams Programming 2 03-17-2008 01:10 AM
LXer: Sql - stored procedures, views, and dynamic sql generation LXer Syndicated Linux News 0 08-17-2006 06:33 AM
SQL: old sql dump not loading into new db BrianK Linux - Software 1 07-25-2006 11:55 PM
Which SQL is suitable for EMbedded SQL on C? hk_michael Programming 4 01-10-2005 05:07 PM

LinuxQuestions.org > Forums > Linux Forums > Linux - Server

All times are GMT -5. The time now is 05:57 AM.

Main Menu
Advertisement
My LQ
Write for LQ
LinuxQuestions.org is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
Syndicate
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
Open Source Consulting | Domain Registration