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/

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.