Solved

Mysql Server Big databases - slow....

Posted on 2001-09-15
13
261 Views
Last Modified: 2006-11-17
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
Comment
Question by:intervision
  • 4
  • 4
  • 2
  • +3
13 Comments
 
LVL 15

Expert Comment

by:a.marsh
ID: 6485523
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
 
LVL 15

Expert Comment

by:a.marsh
ID: 6485525
Might be worth you taking a look at:

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

Ant
0
 

Author Comment

by:intervision
ID: 6485615
~2000 tables and lots of records...
The OS is RH6.1
0
 
LVL 15

Expert Comment

by:a.marsh
ID: 6485698
Are you using indexes?

Ant
0
 

Author Comment

by:intervision
ID: 6485756
yes. i do use indexes
0
 
LVL 15

Expert Comment

by:a.marsh
ID: 6485777
Is all that data really needed? Or could it be archived?

Ant
0
IT, Stop Being Called Into Every Meeting

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

 

Author Comment

by:intervision
ID: 6485799
all data needed :-)
0
 
LVL 1

Expert Comment

by:calvinrsmith
ID: 6500511
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
 

Author Comment

by:intervision
ID: 6500536
how can i cach ?
0
 
LVL 1

Expert Comment

by:calvinrsmith
ID: 6500542
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
 

Expert Comment

by:denisc
ID: 6614185
if you do a lot of updates, updating indexes can be a powerful bottlneck
0
 
LVL 54

Expert Comment

by:nico5038
ID: 7262045

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
 

Accepted Solution

by:
Jgould earned 0 total points
ID: 7292755
Question has been closed as per recommendation

JGould-EE Moderator
0

Featured Post

Enabling OSINT in Activity Based Intelligence

Activity based intelligence (ABI) requires access to all available sources of data. Recorded Future allows analysts to observe structured data on the open, deep, and dark web.

Join & Write a Comment

Introduction: Often, when running a query with joins, the results show up "duplicates", and often, those duplicates can be "eliminated" in the results using DISTINCT, for example. Using DISTINCT is simple: just add it after the SELECT keyword, an…
Shadow IT is coming out of the shadows as more businesses are choosing cloud-based applications. It is now a multi-cloud world for most organizations. Simultaneously, most businesses have yet to consolidate with one cloud provider or define an offic…
Video by: Steve
Using examples as well as descriptions, step through each of the common simple join types, explaining differences in syntax, differences in expected outputs and showing how the queries run along with the actual outputs based upon a simple set of dem…
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…

743 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

9 Experts available now in Live!

Get 1:1 Help Now