LinuxQuestions.org
Visit Jeremy's Blog.
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-23-2009, 10:44 AM   #1
shii_va
LQ Newbie
 
Registered: Jul 2008
Posts: 24

Rep: Reputation: 17
Mysql Optimisation/fine tuning


Hello LQ masters,

i newly install mysql which is showing Too may connection and mysql load is increase please help

for your convinence there are some information.

having 4GB Ram
my.cnf

[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
user=mysql
# Default to using old password format for compatibility with mysql 3.x
# clients (those using the mysqlclient10 compatibility package).
old_passwords=1

[mysqld_safe]
log-error=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid


mysql -u root -p -e "show processlist"

+------+---------+-----------+-----------------+---------+------+---
| Id | User | Host | db | Command | Time | State | Info |
| 5623 | tenders | localhost | tendersinfo_com | Sleep | 121 | | NULL |
| 6225 | tenders | localhost | tendersinfo_com | Sleep | 126 | | NULL |
| 6271 | tenders | localhost | tendersinfo_com | Sleep | 156 | | NULL |
| 6458 | tenders | localhost | tendersinfo_com | Sleep | 197 | | NULL |
| 6468 | tenders | localhost | tendersinfo_com | Sleep | 105 | | NULL |
| 7484 | tenders | localhost | tendersinfo_com | Query | 4 | Sending data | select posting_id,country_name,short_desc,tender_sector,org_name,notice_type,tender_notice,country, |
| 7496 | tenders | localhost | NULL | Query | 0 | NULL | show processlist |


Do need your help/

Last edited by shii_va; 09-23-2009 at 10:56 AM.
 
Old 09-23-2009, 11:18 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 shii_va View Post
Hello LQ masters,

i newly install mysql which is showing Too may connection and mysql load is increase please help

for your convinence there are some information.

Do need your help/
Please try to write clearly, your question is hard to understand.

Did you try to Google for that error?? Lots of information on it. You might try to run the following:

- mysqladmin flush-hosts

and edit my.cnf and add or change the value ( max_connections by default is 100) to max_connections=500. Save my.cnf and restart mysql.

Also, without knowing how you're connecting to the database (via PHP? Shell client? Java program? ODBC????), or what the database structure is, or how many connections you're making before it dies, it's hard to give any decent answer.
 
  


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
Fine tuning monitor sunils1973 Linux - Hardware 1 08-19-2008 03:24 AM
Fine tuning my MTU cwwilson721 Linux - Networking 2 05-24-2006 10:40 AM
Fine-tuning samba TomalakBORG Linux - Networking 5 01-31-2006 11:34 PM
squid fine tuning help!!!! veeraabose Linux - Networking 3 03-07-2005 07:31 AM
FTP fine tuning eidolon532 Linux - Networking 1 04-15-2003 03:33 PM

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

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