Apache2 and virtualhosts and win - Anyone having problems???
Posted 10 February 2003 - 01:53 PM
The thread for my problems is here:
Any help or suggestions would be helpful.
Posted 10 February 2003 - 04:59 PM
i\'m not sure if it could be virtual hosting - i run 3 sites on a small linux box without issue.
- is apache set to create logs? are these getting big?
- do you have any settings on that may bog apache down, such as hostnamelookups, usecanonicalname, extendedstatus?
- is keepalive on?
- if you are not using .htaccess files make sure allowoverride none is in your default directory directive
- are you using the rewrite engine?
- is php ran as a module or cgi?
- at the time the server starts to hang, how many apache child processes are active?
Posted 11 February 2003 - 02:38 PM
Had a busy day yesterday and couldn\'t write back.
1) - Yes apache is set to log, the access logs are seperate for the sites that are hosted and the site in question had a log of 17mb!, I turned off the access log and kept the error log going, don\'t need acces logs at this point.
2) - do you have any settings on that may bog apache down, such as hostnamelookups, usecanonicalname, extendedstatus?
++ No none of those variables are set, never set them.
3) - keepalive is on - but just noticed when looking at the keepalive settings something i never noticed:
BrowserMatch \"Mozilla/2\" nokeepalive
BrowserMatch \"MSIE4.0b2;\" nokeepalive downgrade-1.0 force-response-1.0
I have no idea what these directives are but looks to me that if they are using explorer or netscape then the keepalive is off?
4) no rewrite engine.
5) php is ran as a module
6) not sure how to check the child processes on win2000, i have looked at the mem usage and at times it shows 3 apaches there, one really gobbling mem, but not all that bad, only 30 to 50 megs, well i don\'t know exactly what is bad.
Still tugging away at the problem and effigy thanks a ton for your insight, your couple of posts have taught me a lot. Hopefully I will get this figured before i go through the hassle of porting to postgre.
Posted 11 February 2003 - 05:33 PM
this is a very important area... it controls how much apache can handle. i do not know much about the windows MPM\'s but i suggest looking it and its directives up and experimenting.
the keep alive stuff is ok. those are always default... i guess the browsers do have the capability.
your mysql variables look fairly similar to mine and i have had not problems ( on linux ) ... how many tables are you using? how big are they? are they indexed with a primary key?
Posted 11 February 2003 - 07:13 PM
I did some research a week ago on the apache site regarding this directive and notice that there isn\'t much under this mpm as the others, but unsure as to whether the other directives would or could work under win2000, or what exactly they do.
The largest table is this:
Data 545,444 Bytes
Index 80,896 Bytes
Total 626,340 Bytes
Row length ø 132
Row size ø 152 Bytes
Next Autoindex 4,142
The next largest is half that size. There are 55 tables in the database. All the tables are indexed off of the id, only 3 have an index elsewhere. an example of the structure:
The \"sub\" tables are small and once i have an id, i usually select what i need from the other tables. The only \"sub\" table that i do full text search on, Other than a name field is the tbl_customer_address, where a customer is needed to be located for an address. I thought this design would be a better structure, mainly to get in, get a name and id and close that table down, then with the id, get into another table grab the stuff and then close that table, also it seems any more there are so many one-to-many relationships built on just the constant name. Not sure if that is great thinking or not.
Thanks again for your insight.
0 user(s) are reading this topic
0 members, 0 guests, 0 anonymous users