SMF Support > Server Performance and Configuration

this is loosely smf related

<< < (3/5) > >>

texasman1979:
I'll definitely try that. Well see how that turns out.

I can upgrade to the latest version of ubuntu and see no reason it won't work just fine for what I'm doing with it. Do yall think that it might have a positive effect on my configurable settings?

I am investigating the use of nginx, but there are some limitations to that that Apache does by default. Such as url rewriting and such. I know that would cut down on RAM usage, but mysql still seems to be my biggest mem hog.

Ay advice or incite that yall might have would be greatly appreciated.

texasman1979:
Something else I'm curious about is that all the software I use can use sqlite. Does anyone know of a good free mysql to sqlite converter?

If I can move to nginx and sqlite I could use a 128 meg server easily. I'd still keep the 512 I got, but I would then have well more than enough RAM.

Thx

Yoshi:
Why would you want to switch to SQLite, a plain text database..?

texasman1979:
For memory if I can't get mysql working right. Course there is just switching to nginx, but inn my research, nginx has some very specific draw backs. Course Im not sure if those draw backs are specifically related to my specific web applications.

From your experience, is nginx good for smf, Wordpress, and drupal? And give those software full capabilities without messing with the cont files excessively?

青山 素子:

--- Quote from: texasman1979 on May 02, 2012, 09:32:40 AM ---I am investigating the use of nginx, but there are some limitations to that that Apache does by default. Such as url rewriting and such. I know that would cut down on RAM usage, but mysql still seems to be my biggest mem hog.

--- End quote ---

nginx supports rewrites just fine.

If you don't want to abandon Apache HTTPd, you could see about reducing modules being loaded and also moving PHP to use FastCGI (via mod_fcgid) or even FPM.



--- Quote from: texasman1979 on May 02, 2012, 09:40:50 AM ---Something else I'm curious about is that all the software I use can use sqlite. Does anyone know of a good free mysql to sqlite converter?

--- End quote ---

Just so you know, SQLite is much less capable than MySQL. It also doesn't scale as well due to how it is designed. I believe it stores all tables in a single file.

SMF's support of SQLite isn't bad, but some modifications may assume you're using MySQL and bypass the limits SMF puts in (by disabling certain checks in SMF) leading to issues with them if you convert.



--- Quote from: Yoshi2889 on May 02, 2012, 10:30:19 AM ---Why would you want to switch to SQLite, a plain text database..?

--- End quote ---

SQLite is not a plain-text or flat-file database.



--- Quote from: texasman1979 on May 02, 2012, 02:21:55 PM ---From your experience, is nginx good for smf, Wordpress, and drupal? And give those software full capabilities without messing with the cont files excessively?

--- End quote ---

Well, Wordpress isn't good with anything, IMO. ;)

In all seriousness, all those products should run under nginx.

Navigation

[0] Message Index

[#] Next page

[*] Previous page

Go to full version