Find the answer to your Linux question:
Results 1 to 3 of 3
since last 6months everything is working fine. suddenly this problem occured. site goes down regularly, need to restart the services of MySql. then everything goes fine. i just wanted to ...
Enjoy an ad free experience by logging in. Not a member yet? Register.
  1. #1
    Just Joined!
    Join Date
    Aug 2004
    Posts
    5

    Mysql Problem on linux server


    since last 6months everything is working fine.

    suddenly this problem occured.

    site goes down regularly, need to restart the services of MySql.

    then everything goes fine.

    i just wanted to know that is it the script error or problem in the linux server or the mysql.

    kindly help me in this regard, its really sucking me.

    ************************************************** ***********
    ERROR DISPLAYED ON SITE when the site is down............
    ************************************************** ***********
    connections in /home/fullhyd/public_html/scripts/config.inc.php3 on line 41

    Warning: session_start(): Cannot send session cookie - headers already sent by (output started at /home/fullhyd/public_html/scripts/config.inc.php3:41) in /home/fullhyd/public_html/scripts/config.inc.php3 on line 61

    Warning: session_start(): Cannot send session cache limiter - headers already sent (output started at /home/fullhyd/public_html/scripts/config.inc.php3:41) in /home/fullhyd/public_html/scripts/config.inc.php3 on line 61
    1044: Access denied for user: '@localhost' to database 'fullhyd_phpPolls'

    Warning: mysql_connect(): User fullhyd_kishore has already more than 'max_user_connections' active connections in /home/fullhyd/public_html/index.phtml on line 88
    There was some problem with connection
    ************************************************** **********

  2. #2
    Linux Guru
    Join Date
    Apr 2003
    Location
    London, UK
    Posts
    3,284
    If the site is busy then you need to increase the "max connections" in your my.cnf configuration file. The default is 100 clients can be connected at any one time. If your applications are using persistant connections you could turn these off.

    Im my copy of my.cnf, i've found this works well:

    Code:
    [mysqld]
    max_connections = 150
    interactive_timeout = 15
    log-slow-queries

  3. #3
    Just Joined!
    Join Date
    Aug 2004
    Posts
    5
    thanks a ton, for the help jason
    can i get your help on messenger, if yes please note my yahoomessenger
    ID : bhasi75@yahoo.com

    \raj

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •