Results 1 to 12 of 12
  1. #1

    Mysql Load Problem

    Hello Sirs!

    I am having problem in my mysql, last year i shifted my server and by mistake i dumped database 2 times, that time i didn't care much but now when i am having more then 70000 members , database crashes very often, and every time i have to restart server then repair database.... site works fine for 3 to 4 hours then suddenly mysql load goes to 20 , 40 and then site stops responding ,i did a top and it showed me that its that is causing the load but as being newbie i don't know how to check which table is causing and how to resolve, please help me,and i have vbulletin 3.8.5 installed with xbt tracker....

    sorry for my bad English.....

  2. #2
    Join Date
    May 2008
    Location
    Sweden
    Posts
    152
    In the top, you will get the process id of the the mysql. From process id you can see the details of the db.
    Linux, C, Perl, Bash, PHP
    MySQL, PostgreSQL
    Postfix, Qmail
    Bind

  3. #3
    Try use APC cache or memcache, it will increase server performance.
    ╠══ Cool Wallpapers ══╡
    ║►►► Optimize your website

  4. #4
    sir i am completely newbie for this can u please pass me any guide to install or to setup

    APC cache or memcache

  5. #5
    Quote Originally Posted by helpyoulinux View Post
    In the top, you will get the process id of the the mysql. From process id you can see the details of the db.
    i do get the id of mysql but i dont know how to get to that table or coloumn with that id in order to delete that table or column can you please guide me?

    and pass me ur email id....please

  6. #6
    Join Date
    Jul 2005
    Posts
    489
    Quote Originally Posted by SHAN9211 View Post
    sir i am completely newbie for this can u please pass me any guide to install or to setup

    APC cache or memcache
    Try google search.
    http://www.google.co.in/#hl=en&sourc...5c7405d4a7e2c8

  7. Quote Originally Posted by SHAN9211 View Post
    i do get the id of mysql but i dont know how to get to that table or coloumn with that id in order to delete that table or column can you please guide me?

    and pass me ur email id....please
    Type
    Code:
    SHOW FULL PROCESSLIST
    When your having isues, it will give you a starting point.

  8. #8
    Join Date
    Aug 2007
    Posts
    352
    You need to turn on SLOW QUERY Logging and logging of queries not using indexes in my.cnf config file.

    You likely need to optimize your queries and use query cache in MySQL. Proper indexes need put in place.

    Test slow queries by prepending:
    EXPLAIN (the query)

    That will show you useful information on the query - which indexes (if any) are being used and help you to isolate some problems.

    As for the restarts and corruption, I believe you are using MyISAM. Convert your tables to InnoDB and the corruption *SHOULD* go away.

    When doing the repairs to tables you need to take down all front ends so you app isn't connecting to the database, otherwise this will create a big dogpile and cause more issues.

  9. #9
    THANKS Guyz, i am very great full , i will update you on results

  10. #10

  11. #11
    If you are total new to Server World, then I suggest to get some help. Either ask some friend to do it or hire somebody to do it for you.

  12. #12
    Quote Originally Posted by Gary4gar View Post
    If you are total new to Server World, then I suggest to get some help. Either ask some friend to do it or hire somebody to do it for you.
    can anyone please pass me his online contact for help, i think i am unable to solve the problem, i would be very great full

Similar Threads

  1. cpanel problem: cannot load mysql extension
    By phyto in forum Dedicated Server
    Replies: 0
    Last Post: 12-25-2004, 01:43 PM
  2. Mysql load data infile problem
    By awsolutions in forum Programming Discussion
    Replies: 7
    Last Post: 06-23-2004, 10:49 AM
  3. MySQL Load Problem (not enought)
    By Studio64 in forum Hosting Security and Technology
    Replies: 1
    Last Post: 05-25-2004, 06:53 AM
  4. mysql problem ... server load 20-50 help!
    By swijaya0101 in forum Dedicated Server
    Replies: 9
    Last Post: 05-09-2004, 08:32 PM
  5. Load Data Infile Problem (MySQL)
    By shaky21 in forum Hosting Security and Technology
    Replies: 1
    Last Post: 03-26-2004, 06:46 PM

Posting Permissions

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