Solved

Mysql Server Big databases - slow....

Posted on 2001-09-15
13
287 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
Netscaler Common Configuration How To guides

If you use NetScaler you will want to see these guides. The NetScaler How To Guides show administrators how to get NetScaler up and configured by providing instructions for common scenarios and some not so common ones.

 
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

VMware Disaster Recovery and Data Protection

In this expert guide, you’ll learn about the components of a Modern Data Center. You will use cases for the value-added capabilities of Veeam®, including combining backup and replication for VMware disaster recovery and using replication for data center migration.

Question has a verified solution.

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

Using SQL Scripts we can save all the SQL queries as files that we use very frequently on our database later point of time. This is one of the feature present under SQL Workshop in Oracle Application Express.
Never store passwords in plain text or just their hash: it seems a no-brainier, but there are still plenty of people doing that. I present the why and how on this subject, offering my own real life solution that you can implement right away, bringin…
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…

803 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