Mysql Server Big databases - slow....

Hello,

I'm running a website with an mySQL server.
There is a really big database there,and the site working really slow because of that most of the time.

The site is on a dedicated server PIII 700 mhz with 256 ram , scasi hd.

What can be done ?

Thank you
intervisionAsked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
JgouldConnect With a Mentor Commented:
Question has been closed as per recommendation

JGould-EE Moderator
0
 
a.marshCommented:
What operating system are you running?

How "big" is "big"? What I mean is how many tables and how many records are in the database?

Are you using indexes? If not that would be the first way of speeding things up.

Ant
0
 
a.marshCommented:
Might be worth you taking a look at:

http://www.mysql.com/doc/M/y/MySQL_Optimization.html

Ant
0
Build your data science skills into a career

Are you ready to take your data science career to the next step, or break into data science? With Springboard’s Data Science Career Track, you’ll master data science topics, have personalized career guidance, weekly calls with a data science expert, and a job guarantee.

 
intervisionAuthor Commented:
~2000 tables and lots of records...
The OS is RH6.1
0
 
a.marshCommented:
Are you using indexes?

Ant
0
 
intervisionAuthor Commented:
yes. i do use indexes
0
 
a.marshCommented:
Is all that data really needed? Or could it be archived?

Ant
0
 
intervisionAuthor Commented:
all data needed :-)
0
 
calvinrsmithCommented:
you can try caching.  for example instead of querying the database for each request, possibly several times a second, only query the database every second and serve static pages that are less than a second old.
0
 
intervisionAuthor Commented:
how can i cach ?
0
 
calvinrsmithCommented:
In your program check the time since the last query if its too soon then serve static pages otherswise do the query.
Also make sure you account for race conditions as you don't want multiple people querying for the same page and having mysql running two queryies that will return similar results
0
 
deniscCommented:
if you do a lot of updates, updating indexes can be a powerful bottlneck
0
 
nico5038Commented:

No comment has been added lately, so it's time to clean up this TA.
I will leave a recommendation in the Cleanup topic area that this question is:
 - PAQ'd and pts removed
Please leave any comments here within the
next seven days.

PLEASE DO NOT ACCEPT THIS COMMENT AS AN ANSWER !

Nic;o)
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.