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

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?

It would be a problem of the structure of your entries.Call from the remote databases would aggravate your problem.

I take it this is the same issue you reported here:
http://www.webmaster-talk.com/php-fo...hp-script.html