If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

 
Go Back  dBforums > Database Server Software > MySQL > Help - Database getting to Big

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old 01-20-05, 19:12
tonyurso tonyurso is offline
Registered User
 
Join Date: Sep 2004
Posts: 4
Help - Database getting to Big

Hello,
I am running MySQL 4.0.15 for a mortgage lead website. The database is getting to large and is being bogged down by 7000 members logged in at once running queries.
What options are available?
I thought about running a slave database to hande the overflow.
Can someone point me in the right direction.
Reply With Quote
  #2 (permalink)  
Old 01-21-05, 03:07
codenode codenode is offline
Registered User
 
Join Date: Dec 2004
Posts: 26
Have you looked into replication or clustering? For replication I know that you can basically load balance SELECT queries between the slave servers. UPDATE, INSERT, etc. statements have to be issued to the master so it can propagate the changes to the slaves. So if your database is SELECT heavy replication might help.
Reply With Quote
  #3 (permalink)  
Old 01-21-05, 10:24
tonyurso tonyurso is offline
Registered User
 
Join Date: Sep 2004
Posts: 4
That is what I thought, can this be done on the same machine or do you need a separate server?
Reply With Quote
  #4 (permalink)  
Old 01-21-05, 10:57
ServerMetrics ServerMetrics is offline
Registered User
 
Join Date: May 2004
Posts: 45
It can be done on the same server, but my feeling is you will still have the same effect as now if you place the replicate on the same box/os. If your current bottlenecks are network and/or disk access you will probably encounter the same issue by placing the replicate on the same hardware.
__________________
Keith Brownlow
ServerMetrics DB Monitoring (www.servermetrics.com)
Reply With Quote
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On