Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 328
  • Last Modified:

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
0
intervision
Asked:
intervision
  • 4
  • 4
  • 2
  • +3
1 Solution
 
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
 
intervisionAuthor Commented:
~2000 tables and lots of records...
The OS is RH6.1
0
Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
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
 
JgouldCommented:
Question has been closed as per recommendation

JGould-EE Moderator
0

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

  • 4
  • 4
  • 2
  • +3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now