Tycoon Talk
Become a Big fish!
The number 1 forum for online business!
Post topics, ask questions, share your knowledge.
Tycoon Talk is part of Freelancer.com - find skilled workers online at a fraction of the cost.

The Database Forum


You are currently viewing our The Database Forum as a guest. Please register to participate.
Login



Reply
Need help with database overload possible
Old 11-04-2010, 08:58 PM Need help with database overload possible
ZoC
Skilled Talker

Posts: 68
Trades: 0
Hello there,
my website has a 20+ tables database, because one of the tables with 147221 records, my websites dies in 1-2 minutes after i start apache, is there any way to find out whats wrong with this table? every time website dies apache dies too i suppose overloaded or error table

hope someone can help me with this
thank you
ZoC is offline
Reply With Quote
View Public Profile
 
 
Register now for full access!
Old 11-04-2010, 09:42 PM Re: Need help with database overload possible
NullPointer's Avatar
Will Code for Food

Posts: 2,815
Name: Matt
Location: Irvine, CA
Trades: 0
Without seeing the structure of the table and the queries you are executing it would be hard to say. 147221 isn't that big of a database, but it is definitely large enough so that you need to start being more concerned about the efficiency of your queries.

1. What is the structure of the table?
2. What queries are you executing?
3. How often do you execute those queries?

Also, when you say 'my websites dies in 1-2 minutes after i start apache' does that mean it crashes without any requests being made? If so I don't think the problem is with your database. Does the sql server die as well or just apache?
__________________

Please login or register to view this content. Registration is FREE
|
Please login or register to view this content. Registration is FREE
|
Please login or register to view this content. Registration is FREE
|
Please login or register to view this content. Registration is FREE

Last edited by NullPointer; 11-04-2010 at 09:47 PM..
NullPointer is online now
Reply With Quote
View Public Profile Visit NullPointer's homepage!
 
Old 11-05-2010, 06:17 PM Re: Need help with database overload possible
cindyfowler's Avatar
Ultra Talker

Posts: 351
Trades: 0
It would be a problem of the structure of your entries.Call from the remote databases would aggravate your problem.
cindyfowler is offline
Reply With Quote
View Public Profile
 
Old 11-05-2010, 06:41 PM Re: Need help with database overload possible
NullPointer's Avatar
Will Code for Food

Posts: 2,815
Name: Matt
Location: Irvine, CA
Trades: 0
I take it this is the same issue you reported here:
http://www.webmaster-talk.com/php-fo...hp-script.html
__________________

Please login or register to view this content. Registration is FREE
|
Please login or register to view this content. Registration is FREE
|
Please login or register to view this content. Registration is FREE
|
Please login or register to view this content. Registration is FREE
NullPointer is online now
Reply With Quote
View Public Profile Visit NullPointer's homepage!
 
Reply     « Reply to Need help with database overload possible
 

Thread Tools Search this Thread
Search this Thread:

Advanced Search

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 On
HTML code is Off
Trackbacks are Off
Pingbacks are Off
Refbacks are Off





   
RSS Feed  Feeds: RSS   JS   XML
RSS Feed  Feeds for this forum: RSS   JS   XML



Page generated in 0.25488 seconds with 12 queries