mysql is extremely slow

Discussion in 'Server Operation' started by durjoy, Jun 8, 2007.

  1. durjoy

    durjoy New Member

    hi everyone . i have bought dedicated server with 256 MB ram i have run some static pages . speed is good . but when i have installed phpfox and run with my server's mysql . it has been taking ages to execute the query . however when i have used one of my sharing hosting 's mysql which alow remote connections my queer's are executing very fast . site running very smooth .

    now i have realized my server's mysql perfomance is extremely poor . even when 3/4 user is online its just take ages to load .

    is there any way to boost mysql perfomance .

    please advice
     
  2. sayfanet

    sayfanet New Member

    upgrade memory to 512mb at least.

    how much did you pay for that server?
     
  3. Ben

    Ben ISPConfig Developer ISPConfig Developer

    Depending on how complex the DB structure and the queries are, you need CPU performance as well as much RAM.
    But 256MB is definitly to less especially you have many differenz processes running (probably), that need memory (apache, postfix/sendmail, ftp, mysql...)

    You could also activate the slow log of mysql and then check (in case of select statemens) with
    explain select ...
    if keys and indexes are set correct...
     
  4. Ramoonus

    Ramoonus New Member

    what are your system specs?
    what is your config?
    how big is the database?
     
  5. durjoy

    durjoy New Member

    my server configurations

    space 40 GB .
    ram 256

    apache 2.2.2

    php 5.2.2

    mysql version 5.0.27

    ISP config

    and webmin

    plz suggest now what should i do to make mysql faster

    Thanks

    Niz
     
  6. falko

    falko Super Moderator ISPConfig Developer

  7. durjoy

    durjoy New Member

    thank you falko

    thank you falko . you are so kind . once again thanks for the link .

    I cant see any error . but query executing very slowly . is ther any command to check mysql log ?

    cheers

    Niz
     
  8. falko

    falko Super Moderator ISPConfig Developer

    You should check all logs in the /var/log directory.
    To open a log file, you can use a text editor such as vi, or use cat to display the entire contents at once (can be long!). You can also use tail. For example, to display the last 100 lines of /var/log/syslog, you'd do it as follows:
    Code:
    tail -n100 /var/log/syslog
     

Share This Page