kid_drew

I'm stupid. One of the apps is a wordpress blog which was still configured to be at a subdirectory of my webroot. This is solved.

I'm just about to scream. This makes absolutely no sense to me. Hopefully someone else has some insight into this. I've set up virtual hosts plenty of times in apache/linux....no problems. I'm trying to do the same thing in Windows and I'm getting all kinds of problems. NameVirtualHost *:80 <VirtualHost *:80> ServerName www.example1.com DocumentRoot i:\webroot </VirtualHost> <VirtualHost *:80> ServerName www.example2.com DocumentRoot i:\webroot\example2 </VirtualHost> This is my config verbatim with the domains replaced with example1/example2. I get no error messages, but both www.example1.com and www.example2.com direct to the i:\webroot directory. Like I said....this makes absolutely no sense. Does anyone have any ideas?

After more research on my end, I'm convinced I need to do a rewrite and not a VirtualHost. Thanks for the reply texerasmo, but I'm not sure what to take out of what you wrote. I know how VirtualHosts are set up in terms of mapping multiple domain names to one box, but I specifically want this URL mapping: http://www.example.com/site1 should look for code in i:\webroot\drupal http://www.example.com/site2 should ALSO look for code in i:\webroot\drupal Neither of these apps have unique domain names. The URLs are exactly as I have typed them (with one domain replacing example.com of course). I could very well be wrong, but without a more specific example from you, I'm not convinced. -Drew

Hey everybody, So I'm trying to set up a WinXP multi-site drupal box, which allows you to create multiple sites using the same code base and different databases. I can get the databases set up correctly, but my problem is redirecting with .htaccess. I'm a PHP programmer, not a system admin, and I don't know all that much about mod_rewrite. Anyway, here's the situation. Webroot is located at i:\webroot and drupal is at i:\webroot\drupal. I need multiple subdirectories to pull the code from the i:\webroot\drupal webroot directory. So, to illustrate: http://www.example.com/app1 will pull from i:\webroot\drupal http://www.example.com/app2 will also pull from i:\webroot\drupal http://www.example.com/app3 is not a drupal app, so it will pull from i:\webroot\app3 as you would expect it to. Do I do that using mod_rewrite, VirtualHost, VirtualDocumentRoot? I'm a bit lost with all the options. Thanks -Drew

Hey guys, I have two large apps on physically separate mysql databases, and I want to combine the two servers into one to save money. The last time I tried this, the two apps competed for resources to the point that a half second query took 30 seconds. But on two separate servers, they aren't using anywhere near the capacity of one server. So I must be missing a setting or something that would allow two apps with completely disjoint queries to run on the same machine. It has to be some kind of a caching issue, I'm assuming. Can anyone give me any advice? Also, feel free to ask me any clarification questions. -Drew

CentOS I'm not sure about the processor, actually. I didn't set up the server. I know it's 64 bit, so greater than 4GB is possible.

We have a MySQL database backing up two applications getting well over 3M pageviews a day. Our database is getting hammered. The issue seems to be memory. Is 4GB reasonable for a site of this size?

Hey guys, I had a very active database and the disk ran out of space. Now, the database is down and giving me a 2002 error. The process isn't even showing up in the process list, and restarting it fails. I don't even know where to start. Can anyone give me any ideas?

I've never used INSERT DELAYED actually, so I'm not sure if I can afford it or not. As I understand it, MySQL will bundle a bunch of inserts together to throw in at one time. Seems that might actually speed things up.

A few million a day.

select * from trans where user_id=xxxxxx is very typical. Sometimes I query for the transaction type too. So select * from trans where user_id=xxxxxx and trans_type=xx.

Do you mean when I run them as root? Only select/where queries. select * from trans where....

Only inserts.

Hey everybody, I have a site that is pushing 1M users with ~2M pageviews per day. It's built on a form of artificial currency and involves a lot of transactions of this artificial currency. I log every monetary transaction into one table that, as you can imagine, is rather large (32M rows). I move old transactions daily into a non-live table to keep the size manageable, but here's my issue. I intentionally didn't build indexes in this table because it is only ever read from the MySQL monitor. It is only written to by users, so read does not need to be quick. The problem is that when I do need to read it (maybe twice a day) it takes FOREVER to query because it has to go through every row. So I'm wondering two things: 1. Should this table be InnoDB or MyISAM? 2. How much of a performance hit will I take if I build indexes on the table?

Hey guys, I'm trying to code up a simple game where the user passes from one page to the next through a series of links. How can I prevent a user from cheating by typing in the URL of a page that is not in the logical flow of the game? Some kind of cookie trick, I'm sure, but I can't seem to wrap my head around it. -Drew