The Community Forums

Interact with an entire community of cPanel & WHM users!
  1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

SQL Flood in my new server

Discussion in 'Database Discussions' started by Christleo, Dec 25, 2004.

  1. Christleo

    Christleo Well-Known Member

    Joined:
    Mar 13, 2003
    Messages:
    64
    Likes Received:
    0
    Trophy Points:
    6
    mysql 9954 0.3 4.3 315396 30992 pts/0 S 23:14 0:01 /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql --pid-file=/
    mysql 9955 0.0 4.3 315396 30992 pts/0 S 23:14 0:00 /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql --pid-file=/
    mysql 9956 0.0 4.3 315396 30992 pts/0 S 23:14 0:00 /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql --pid-file=/
    mysql 9957 0.0 4.3 315396 30992 pts/0 S 23:14 0:00 /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql --pid-file=/
    mysql 9958 0.0 4.3 315396 30992 pts/0 S 23:14 0:00 /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql --pid-file=/
    mysql 9959 0.0 4.3 315396 30992 pts/0 S 23:14 0:00 /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql --pid-file=/
    nobody 9960 2.3 1.3 16724 9476 ? S 23:14 0:13 /usr/local/apache/bin/httpd -DSSL
    mysql 9961 0.0 4.3 315396 30992 pts/0 S 23:14 0:00 /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql --pid-file=/
    mysql 9962 0.0 4.3 315396 30992 pts/0 S 23:14 0:00 /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql --pid-file=/
    mysql 9963 0.0 4.3 315396 30992 pts/0 S 23:14 0:00 /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql --pid-file=/
    mysql 9964 0.1 4.3 315396 30992 pts/0 S 23:14 0:00 /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql --pid-file=/
    mysql 9965 3.0 4.3 315396 30992 pts/0 S 23:14 0:16 /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql --pid-file=/
    mysql 9967 3.4 4.3 315396 30992 pts/0 S 23:14 0:18 /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql --pid-file=/
    nobody 9969 2.7 1.1 15528 8320 ? S 23:14 0:15 /usr/local/apache/bin/httpd -DSSL
    mysql 9972 3.1 4.3 315396 30992 pts/0 S 23:14 0:16 /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql --pid-file=/
    mysql 9974 2.5 4.3 315396 30992 pts/0 S 23:14 0:13 /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql --pid-file=/
    mysql 9977 2.5 4.3 315396 30992 pts/0 S 23:14 0:13 /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql --pid-file=/
    mysql 9978 2.6 4.3 315396 30992 pts/0 S 23:14 0:14 /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql --pid-file=/
    mysql 9988 3.4 4.3 315396 30992 pts/0 S 23:15 0:18 /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql --pid-file=/
    mysql 9989 2.4 4.3 315396 30992 pts/0 S 23:15 0:12 /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql --pid-file=/
    mysql 9995 2.8 4.3 315396 30992 pts/0 S 23:15 0:15 /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql --pid-file=/
    mysql 9997 2.4 4.3 315396 30992 pts/0 S 23:15 0:12 /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql --pid-file=/
    mysql 10015 1.8 4.3 315396 30992 pts/0 S 23:15 0:09 /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql --pid-file=/
    mysql 10016 2.4 4.3 315396 30992 pts/0 S 23:15 0:12 /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql --pid-file=/
    mysql 10017 2.4 4.3 315396 30992 pts/0 S 23:15 0:12 /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql --pid-file=/
    mysql 10019 3.1 4.3 315396 30992 pts/0 S 23:15 0:15 /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql --pid-file=/
    mysql 10020 3.7 4.3 315396 30992 pts/0 S 23:15 0:18 /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql --pid-file=/

    i am running it for a forum, about 10user active

    it show me a full page of mysqld running... and it's making my page load very slow! PLease advice....
     
  2. s_2_s

    s_2_s Well-Known Member

    Joined:
    Aug 9, 2004
    Messages:
    215
    Likes Received:
    0
    Trophy Points:
    16
    hello bro
    my friend had this problem before

    the magic fix was is to enable sql cashing so same sql queries will not be excuted everytime a user request it but will give him the cashed without re excuting
    it will help you
     
  3. EdRooney

    EdRooney BANNED

    Joined:
    Oct 21, 2004
    Messages:
    166
    Likes Received:
    0
    Trophy Points:
    0
    How do you enable mysql caching?
     
  4. CamronFry

    CamronFry BANNED

    Joined:
    Jan 1, 2005
    Messages:
    49
    Likes Received:
    0
    Trophy Points:
    0
    bump......
     
  5. GOT

    GOT Get Proactive!

    Joined:
    Apr 8, 2003
    Messages:
    900
    Likes Received:
    0
    Trophy Points:
    16
    Location:
    Norfolk, VA
    cPanel Access Level:
    DataCenter Provider
    You'll need to modify your /etc/my.cnf.

    If you have at least 512 MB ram, the easiest thing to do is this:

    mv /etc/my.cnf /etc/my.old
    cp /usr/share/mysql/my-huge.cnf /etc/my.cnf
    pico /etc/my.cnf

    Then find the line that says:

    log-bin

    and change it to

    #log-bin

    Then

    service mysql restart
     
Loading...

Share This Page