Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

Mysql Server Big databases - slow....

Posted on 2001-09-15
13
Medium Priority
?
321 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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
Get your Conversational Ransomware Defense e‑book

This e-book gives you an insight into the ransomware threat and reviews the fundamentals of top-notch ransomware preparedness and recovery. To help you protect yourself and your organization. The initial infection may be inevitable, so the best protection is to be fully prepared.

 
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
 

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

Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article shows the steps required to install WordPress on Azure. Web Apps, Mobile Apps, API Apps, or Functions, in Azure all these run in an App Service plan. WordPress is no exception and requires an App Service Plan and Database to install
In this article, I’ll look at how you can use a backup to start a secondary instance for MongoDB.
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…
This lesson discusses how to use a Mainform + Subforms in Microsoft Access to find and enter data for payments on orders. The sample data comes from a custom shop that builds and sells movable storage structures that are delivered to your property. …
Suggested Courses

604 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