#1  
Old 8th June 2007, 06:06
durjoy durjoy is offline
Junior Member
 
Join Date: Jun 2007
Posts: 27
Thanks: 4
Thanked 0 Times in 0 Posts
Default mysql is extremely slow

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
Reply With Quote
Sponsored Links
  #2  
Old 8th June 2007, 16:18
sayfanet sayfanet is offline
Junior Member
 
Join Date: Sep 2006
Posts: 2
Thanks: 0
Thanked 0 Times in 0 Posts
Default

upgrade memory to 512mb at least.

how much did you pay for that server?
Reply With Quote
  #3  
Old 8th June 2007, 16:42
Ben Ben is offline
Moderator
 
Join Date: Jul 2006
Posts: 1,029
Thanks: 7
Thanked 62 Times in 56 Posts
Default

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...
Reply With Quote
  #4  
Old 8th June 2007, 16:42
Ramoonus Ramoonus is offline
Junior Member
 
Join Date: May 2007
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
Default

what are your system specs?
what is your config?
how big is the database?
Reply With Quote
  #5  
Old 9th June 2007, 10:27
durjoy durjoy is offline
Junior Member
 
Join Date: Jun 2007
Posts: 27
Thanks: 4
Thanked 0 Times in 0 Posts
Default 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
Reply With Quote
  #6  
Old 9th June 2007, 11:17
falko falko is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lneburg, Germany
Posts: 41,701
Thanks: 1,900
Thanked 2,743 Times in 2,577 Posts
Default

Are there any MySQL-related errors in your logs?

Also take a look here: http://dev.mysql.com/doc/refman/5.0/...he-server.html
__________________
Falko
--
Download the ISPConfig 3 Manual! | Check out the ISPConfig 3 Billing Module!

FB: http://www.facebook.com/howtoforge

nginx-Webhosting: Timme Hosting | Follow me on:
Reply With Quote
  #7  
Old 9th June 2007, 11:20
durjoy durjoy is offline
Junior Member
 
Join Date: Jun 2007
Posts: 27
Thanks: 4
Thanked 0 Times in 0 Posts
Default 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
Reply With Quote
  #8  
Old 9th June 2007, 11:48
falko falko is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lneburg, Germany
Posts: 41,701
Thanks: 1,900
Thanked 2,743 Times in 2,577 Posts
 
Default

Quote:
Originally Posted by durjoy
I cant see any error . but query executing very slowly . is ther any command to check mysql log ?
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
__________________
Falko
--
Download the ISPConfig 3 Manual! | Check out the ISPConfig 3 Billing Module!

FB: http://www.facebook.com/howtoforge

nginx-Webhosting: Timme Hosting | Follow me on:
Reply With Quote
Reply

Bookmarks

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
mysql clustering problem : cannot create table in database prince.fer Server Operation 2 16th April 2007 17:03
Messed up ISPConfig-2.2.8 Upgrade Morons Installation/Configuration 4 29th November 2006 12:17
MySQL Cluster On FC5 : error while unpacking from engine asyadiqin HOWTO-Related Questions 7 28th October 2006 17:37
Mandriva 10.2 Perfect Setup Install Problems... ctroyp Installation/Configuration 12 30th December 2005 16:04


All times are GMT +2. The time now is 03:50.


Powered by vBulletin® Version 3.8.7
Copyright ©2000 - 2014, vBulletin Solutions, Inc.