LinuxQuestions.org
Welcome to the most active Linux Forum on the web.
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 09-16-2013, 09:39 AM   #1
martinlangley
Member
 
Registered: Nov 2008
Posts: 69

Rep: Reputation: 0
Angry Mysql performance isssue


In the evening the database becomes very unresponsive and often it rejects new connections with 'Too many connections'. How would you analyze and solve this problem?
 
Old 09-16-2013, 10:10 AM   #2
TB0ne
LQ Guru
 
Registered: Jul 2003
Location: Birmingham, Alabama
Distribution: SuSE, RedHat, Slack,CentOS
Posts: 26,553

Rep: Reputation: 7946Reputation: 7946Reputation: 7946Reputation: 7946Reputation: 7946Reputation: 7946Reputation: 7946Reputation: 7946Reputation: 7946Reputation: 7946Reputation: 7946
Quote:
Originally Posted by martinlangley View Post
In the evening the database becomes very unresponsive and often it rejects new connections with 'Too many connections'. How would you analyze and solve this problem?
No idea, since you provide NO DETAILS at all. Version of MySQL? Linux? Number of users? How are they hitting the database? What have you done/tried??

And this also sounds very much like a verbatim homework question, like your other thread. Have you done ANY research on how to diagnose MySQL problems???
 
Old 09-16-2013, 11:12 AM   #3
carlosinfl
Senior Member
 
Registered: May 2004
Location: Orlando, FL
Distribution: Arch
Posts: 2,905

Rep: Reputation: 77
Please let us know some details about your configuration so we can better help you...

OS = ?
RAM = ?
VM or Physical = ?

How many users / applications are hitting your database in the 'evening' when you see this issue? Can you use 'ps' in command line and show us your processes running on the problem system?

Also let us know what version of MySQL you're using.
 
Old 09-16-2013, 12:38 PM   #4
gdr
Member
 
Registered: Jun 2013
Distribution: Mint KDE
Posts: 44

Rep: Reputation: Disabled
Start with raising the limit of connections, but if your database is slow now, it's going to be even slower - it just won't display connect errors anymore.

Code:
max_connections = 250
in my.cnf
 
Old 09-17-2013, 06:13 AM   #5
colucix
LQ Guru
 
Registered: Sep 2003
Location: Bologna
Distribution: CentOS 6.5 OpenSuSE 12.3
Posts: 10,509

Rep: Reputation: 1983Reputation: 1983Reputation: 1983Reputation: 1983Reputation: 1983Reputation: 1983Reputation: 1983Reputation: 1983Reputation: 1983Reputation: 1983Reputation: 1983
Per the LQ Rules, please do not post homework assignments verbatim. We're happy to assist if you have specific questions or have hit a stumbling point, however. Let us know what you've already tried and what references you have used (including class notes, books, and Google searches) and we'll do our best to help. Also, keep in mind that your instructor might also be an LQ member.
 
Old 09-17-2013, 06:24 AM   #6
TenTenths
Senior Member
 
Registered: Aug 2011
Location: Dublin
Distribution: Centos 5 / 6 / 7
Posts: 3,461

Rep: Reputation: 1552Reputation: 1552Reputation: 1552Reputation: 1552Reputation: 1552Reputation: 1552Reputation: 1552Reputation: 1552Reputation: 1552Reputation: 1552Reputation: 1552
Doing a little bit of (ironically) googling shows that this is more like a section from a Google e-mail interview questionaire.
 
Old 09-17-2013, 11:16 AM   #7
carlosinfl
Senior Member
 
Registered: May 2004
Location: Orlando, FL
Distribution: Arch
Posts: 2,905

Rep: Reputation: 77
Ah I'm guessing that's why the OP didn't respond w/ specifics. It's just a homework question or generic scenario it seems...
 
Old 09-17-2013, 11:48 PM   #8
ahmadmusfikin
LQ Newbie
 
Registered: Jul 2013
Posts: 2

Rep: Reputation: Disabled
you can add the specification of hardware RAM, Processor and hard drive, and maintenance the user connection
 
Old 09-18-2013, 08:57 AM   #9
TB0ne
LQ Guru
 
Registered: Jul 2003
Location: Birmingham, Alabama
Distribution: SuSE, RedHat, Slack,CentOS
Posts: 26,553

Rep: Reputation: 7946Reputation: 7946Reputation: 7946Reputation: 7946Reputation: 7946Reputation: 7946Reputation: 7946Reputation: 7946Reputation: 7946Reputation: 7946Reputation: 7946
Quote:
Originally Posted by ahmadmusfikin View Post
you can add the specification of hardware RAM, Processor and hard drive, and maintenance the user connection
Yes, they OP was asked all of that previously. See posts #2 and #3.
 
  


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
MySQL performance Sheridan Linux - Server 29 07-09-2010 06:30 AM
FreeBSD 7.3 Gnome Isssue? linuxunix *BSD 1 03-25-2010 04:01 PM
MySQL Performance Ammad Linux - General 5 07-25-2008 06:21 AM
isssue with pump kuertensun Linux - Networking 1 06-22-2005 04:14 PM
Monitor Configuration Isssue inescapeableus Linux - Hardware 2 11-01-2004 12:02 PM

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

All times are GMT -5. The time now is 07:17 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